[
https://issues.apache.org/jira/browse/DERBY-7106?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Richard N. Hillegas resolved DERBY-7106.
----------------------------------------
Resolution: Duplicate
> 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)
