[DERBY-7106] EOF ERROR WHEN FETCH FIRST ROW CALLED ON EMPTY TABLE.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 10.14.2.0, 10.15.1.3
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Ben CHARLTON
• Created: 11/Mar/21 02:30
• Updated: 11/Mar/21 15:09
• Resolved: 11/Mar/21 15:09

Description

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.

Issue Links

• duplicates: DERBY-7105 CALLING "FETCH FIRST ROW" on an empty table will throw EOF SQL Exception