# Query problems in 7.9.6 **URL:** \ **Category:** Ignition\ **Created:** [April 21, 2021, 11:46pm UTC](https://forum.inductiveautomation.com/t/query-problems-in-7-9-6/45896 "2021-04-21T23:46:07Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Brian](https://avatars.discourse-cdn.com/v4/letter/b/97f17d/32.png) [@Brian](https://forum.inductiveautomation.com/u/Brian)\ **Post date:** [April 21, 2021, 11:46pm UTC](https://forum.inductiveautomation.com/t/query-problems-in-7-9-6/45896/1 "2021-04-21T23:46:07Z")
I’m having trouble with a SQL query that doesn’t work in the Ignition database query browser, but works directly in the database. I’m using Postgresql, 9.6.13. The query is: ```auto with linedates as ( select generate_series('2021-04-05'::date, '2021-04-09'::date, '1 day'::interval) as linedate ) select linedates.linedate, count(evl.id) FROM linedates left join employee_vacation_log evl on vacationdate = linedates.linedate group by 1 order by linedates.linedate ``` The error that I’m getting from the database query browser is: ```auto com.inductiveautomation.ignition.client.gateway_interface.GatewayException: SQL error for "with linedates as ( select generate_series('2021-04-05'::date, '2021-04-09'::date, '1 day'::interval) as linedate ) select linedates.linedate, count(evl.id) FROM linedates left join employee_vacation_log evl on vacationdate = linedates.linedate group by 1 order by linedates.linedate": A result was returned when none was expected. at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:341) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:315) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:268) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.runUpdateQuery(GatewayInterface.java:576) at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.runUpdateQuery(GatewayInterface.java:560) at com.inductiveautomation.ignition.designer.querybrowser.QueryBrowser$6.run(QueryBrowser.java:501) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: A result was returned when none was expected. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:307) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at com.inductiveautomation.ignition.gateway.datasource.DelegatingStatement.executeUpdate(DelegatingStatement.java:80) at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRStatement.executeUpdate(SRConnectionWrapper.java:857) at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.RunUpdateQuery.runUpdateQuery(RunUpdateQuery.java:35) at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.AbstractUpdateQuery.run(AbstractUpdateQuery.java:37) at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.AbstractDBAction.invoke(AbstractDBAction.java:77) at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:405) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:85) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:837) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1160) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1092) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134) at org.eclipse.jetty.server.Server.handle(Server.java:518) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:308) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:244) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95) at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93) at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceAndRun(ExecuteProduceConsume.java:246) at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:156) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:654) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:572) at java.lang.Thread.run(Thread.java:748) Ignition v7.9.6 (b2018012914) Java: Oracle Corporation 1.8.0_201 ``` Running the query in pgAdmin gives the query results as expected. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/d/7dcb248dac1e115cdfe7e469478d9b19ceed6d81.png) Is this a bug? Or some other limit that I’m running into? JBDC driver limitation? ---
**Author:** ![Brian](https://avatars.discourse-cdn.com/v4/letter/b/97f17d/32.png) [@Brian](https://forum.inductiveautomation.com/u/Brian)\ **Post date:** [April 21, 2021, 11:52pm UTC](https://forum.inductiveautomation.com/t/query-problems-in-7-9-6/45896/2 "2021-04-21T23:52:43Z")
Huh, just occurred to me to try it in the script console, and it works there. ```auto query = "with linedates as (select generate_series('2021-04-05'::date, '2021-04-09'::date, '1 day'::interval) as linedate) select linedates.linedate, count(evl.id) FROM linedates left join employee_vacation_log evl on vacationdate = linedates.linedate group by 1 order by linedates.linedate" args = [] db = "postgres" system.db.runPrepQuery(query, args, db) ``` Result: ```auto Jython 2.5.3 (v2.5.3:3d2dbae23c52+, Nov 17 2012, 11:51:23) [Java HotSpot(TM) 64-Bit Server VM (Oracle Corporation)] on java1.8.0_201 >>> >>> ``` ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [April 21, 2021, 11:59pm UTC](https://forum.inductiveautomation.com/t/query-problems-in-7-9-6/45896/3 "2021-04-21T23:59:59Z")
I think this is because the query browser is dumb and since your query doesn’t literally begin with “SELECT” it isn’t expecting results. ---
**Author:** ![Brian](https://avatars.discourse-cdn.com/v4/letter/b/97f17d/32.png) [@Brian](https://forum.inductiveautomation.com/u/Brian)\ **Post date:** [April 22, 2021, 12:01am UTC](https://forum.inductiveautomation.com/t/query-problems-in-7-9-6/45896/4 "2021-04-22T00:01:46Z")
Ok. It seems to be working where it counts (scripting and property bindings), so no big deal 🙂