Details
-
Bug
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
10.14.2.0
-
None
-
None
-
Windows 10
Intellij 2020.3.2
-
Normal
Description
Steps to produce
Create derby database
`CREATE DATABASE APP`
Create empty table
create table APP.PRISM_ID_MAP ( MATERIAL VARCHAR(63) not null, STATE VARCHAR(255) not null, BLOCK_ID INTEGER default AUTOINCREMENT: start 1 increment 1 generated always as identity, BLOCK_SUBID INTEGER default 0 not null, primary key (MATERIAL, STATE), unique (BLOCK_ID, BLOCK_SUBID) )
Run a simple query
SELECT block_id, block_subid FROM APP.prism_id_map WHERE PRISM_ID_MAP.MATERIAL = 'dirt'
Confirm Empty Set
SELECT block_id, block_subid FROM APP.prism_id_map WHERE PRISM_ID_MAP.MATERIAL = 'dirt' FETCH FIRST ROW
[42X01][30000] Syntax error: Encountered "<EOF>" at line *, column *.
This was performed using the Intellij inbuilt database schema manager.
Attachments
Issue Links
- is duplicated by
-
DERBY-7106 EOF ERROR WHEN FETCH FIRST ROW CALLED ON EMPTY TABLE.
- Closed