[DERBY-6378] OFFSET/FETCH NEXT ignored when query is enclosed in parentheses

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.10.1.1
• Fix Version/s: 10.11.1.1
• Component/s: SQL
• Labels: derby_backport_reject_10_10
• Issue & fix info: Repro attached
• Bug behavior facts: Wrong query result
• Assignee: Dag H. Wanvik
• Reporter: Knut Anders Hatlen
• Created: 15/Oct/13 14:12
• Updated: 21/Jan/15 00:23
• Resolved: 05/Mar/14 13:49

Description

ij version 10.10
ij> connect 'jdbc:derby:memory:db;create=true';
ij> create table t(x int);
0 rows inserted/updated/deleted
ij> insert into t values 1,2,3;
3 rows inserted/updated/deleted
ij> select * from t offset 1 row fetch first 1 row only;
X
-----------
2

1 row selected
ij> (select * from t offset 1 row fetch first 1 row only);
X
-----------
1
2
3

3 rows selected

I would have expected that both of the queries had returned a single row.