Robert Grabowski (robert.grabowski@7bulls.com) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Bug at moving cursor on joined tables
Long Description
I have problems with moving cursors on joined tables. On Simple tables all is ok... See example code...
Sample Code
test=# create table t1 (id integer, name text);
CREATE
test=# create table t2 (id integer, name text);
CREATE
test=# insert into t1 values (1, 'a');
INSERT 3670086 1
test=# insert into t1 values (2, 'b');
INSERT 3670087 1
test=# insert into t1 values (3, 'd');
INSERT 3670088 1
test=# insert into t2 values (1, 'x');
INSERT 3670089 1
test=# insert into t2 values (2, 'y');
INSERT 3670090 1
test=# insert into t2 values (3, 'z');
INSERT 3670091 1
test=# begin;
BEGIN
test=# declare c cursor for select t1.id, t1.name, t2.name from t1 join t2 using (id);
DECLARE
test=# fetch all from c;
id | name | name
----+------+------
1 | a | x
2 | b | y
3 | d | z
(3 rows)
test=# move backward all in c;
MOVE 0
test=# fetch all from c;
id | name | name
----+------+------
(0 rows)
test=# rollback;
ROLLBACK
test=# begin;
BEGIN
test=# declare c cursor for select t1.id, t1.name from t1;
DECLARE
test=# fetch all from c;
id | name
----+------
1 | a
2 | b
3 | d
(3 rows)
test=# move backward all in c;
MOVE 3
test=# fetch all from c;
id | name
----+------
1 | a
2 | b
3 | d
(3 rows)
test=#
No file was uploaded with this report