[ https://issues.apache.org/jira/browse/DERBY-7106?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Richard N. Hillegas closed DERBY-7106. -------------------------------------- > EOF ERROR WHEN FETCH FIRST ROW CALLED ON EMPTY TABLE. > ----------------------------------------------------- > > Key: DERBY-7106 > URL: https://issues.apache.org/jira/browse/DERBY-7106 > Project: Derby > Issue Type: Bug > Affects Versions: 10.14.2.0, 10.15.1.3 > Reporter: Ben CHARLTON > Priority: Minor > > Using the embedded client on Intellij 2020.3.2. But this is confirmed using > the AutoloadedDriver in the derby JAR as well. > > CREATE EMPTY TABLE > CREATE A SELECT QUERY THAT USES FETCH FIRST ROW. > [42X01][30000] Syntax error: Encountered "<EOF>" at line 1, column 99. > > The correct behaviour is returning an empty set. -- This message was sent by Atlassian Jira (v8.3.4#803005)