# \[IGN-6957\]NamedQuery Bug in 8.1.23 **URL:** \ **Category:** Ignition\ **Created:** [December 20, 2022, 1:11pm UTC](https://forum.inductiveautomation.com/t/ign-6957-namedquery-bug-in-8-1-23/67827 "2022-12-20T13:11:30Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![roland.scheuer](https://avatars.discourse-cdn.com/v4/letter/r/c57346/32.png) [@roland.scheuer](https://forum.inductiveautomation.com/u/roland.scheuer)\ **Post date:** [December 20, 2022, 1:11pm UTC](https://forum.inductiveautomation.com/t/ign-6957-namedquery-bug-in-8-1-23/67827/1 "2022-12-20T13:11:30Z")
Hi, im facing a problem with NamedQueries in Ignition 8.1.23 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/c/1c801eb13bcffd47570b022629cadc0fdb50fef1.png) Same query works with 8.1.22 and 8.1.17 and same DB as a NamedQuery. Same query works on 8.1.23 in DBQueryBrowser and also in Scripting, seems problem in NamedQueries. Br, Roland ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [December 20, 2022, 2:06pm UTC](https://forum.inductiveautomation.com/t/ign-6957-namedquery-bug-in-8-1-23/67827/2 "2022-12-20T14:06:54Z")
Show your named query authoring tab. ---
**Author:** ![roland.scheuer](https://avatars.discourse-cdn.com/v4/letter/r/c57346/32.png) [@roland.scheuer](https://forum.inductiveautomation.com/u/roland.scheuer)\ **Post date:** [December 20, 2022, 2:13pm UTC](https://forum.inductiveautomation.com/t/ign-6957-namedquery-bug-in-8-1-23/67827/3 "2022-12-20T14:13:51Z")
sorry 🙂 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/0/c06ec69285824521b7bf05d3d84598c126bdaeea.png) I think the "--" is recognized as a comment ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [December 20, 2022, 2:16pm UTC](https://forum.inductiveautomation.com/t/ign-6957-namedquery-bug-in-8-1-23/67827/4 "2022-12-20T14:16:34Z")
I suggest reporting this to support. Likely a real bug related to recent attempts to make the NQ parser ignore parameters embedded in comments. Supporting that in general to accommodate the few JDBC drivers that allow them seems counter-productive to me. 🤷‍♂️ ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [December 22, 2022, 5:19pm UTC](https://forum.inductiveautomation.com/t/ign-6957-namedquery-bug-in-8-1-23/67827/5 "2022-12-22T17:19:34Z")
Yikes. Yeah, this is just an oversight. We'll get this fixed pretty quickly, I imagine. ---
**Author:** ![Christopher\_Snyder](https://avatars.discourse-cdn.com/v4/letter/c/e480ec/32.png) [@Christopher\_Snyder](https://forum.inductiveautomation.com/u/Christopher_Snyder)\ **Post date:** [April 3, 2023, 1:24pm UTC](https://forum.inductiveautomation.com/t/ign-6957-namedquery-bug-in-8-1-23/67827/6 "2023-04-03T13:24:14Z")
Any updates to this issue? We are running into the same bug. ---
**Author:** ![roland.scheuer](https://avatars.discourse-cdn.com/v4/letter/r/c57346/32.png) [@roland.scheuer](https://forum.inductiveautomation.com/u/roland.scheuer)\ **Post date:** [October 27, 2023, 1:59pm UTC](https://forum.inductiveautomation.com/t/ign-6957-namedquery-bug-in-8-1-23/67827/7 "2023-10-27T13:59:28Z")
i recently updated my gateway to current version and it works. Im not sure when but i read it also in one of the release notes. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [October 27, 2023, 2:07pm UTC](https://forum.inductiveautomation.com/t/ign-6957-namedquery-bug-in-8-1-23/67827/8 "2023-10-27T14:07:02Z")
> [@roland.scheuer](#): > > to current version If you are broken on the current version, you must have deployed on one of the versions were IA **attempted** to handle comments. Delete all SQL comments from your NQs and try again. (SQL comments are part of SQL scripts, which are not supported by vanilla JDBC, and only work at all in certain JDBC drivers.) ---
**Author:** ![roland.scheuer](https://avatars.discourse-cdn.com/v4/letter/r/c57346/32.png) [@roland.scheuer](https://forum.inductiveautomation.com/u/roland.scheuer)\ **Post date:** [October 27, 2023, 2:09pm UTC](https://forum.inductiveautomation.com/t/ign-6957-namedquery-bug-in-8-1-23/67827/9 "2023-10-27T14:09:34Z")
sorry... i meant it works!