Skip site navigation (1) Skip section navigation (2)

Bug #689: Bug at moving cursor on joined tables

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 (view raw or flat)
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


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-06-11 17:15:21
Subject: Re: Bug #689: Bug at moving cursor on joined tables
Previous:From: Lee KindnessDate: 2002-06-11 11:40:14
Subject: Re: Bug #640: ECPG: inserting float numbers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group