From: | pgsql-bugs(at)postgresql(dot)org |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Bug #689: Bug at moving cursor on joined tables |
Date: | 2002-06-11 16:33:31 |
Message-ID: | 20020611163331.1014D476550@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Robert Grabowski (robert(dot)grabowski(at)7bulls(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-06-11 17:15:21 | Re: Bug #689: Bug at moving cursor on joined tables |
Previous Message | Lee Kindness | 2002-06-11 11:40:14 | Re: Bug #640: ECPG: inserting float numbers |