Hi!
Simple test suite for current CVS:
%initdb ...
%createdb q
%psql q
q=# select * from pg_class limit 1;
SELECT
q=# select * from pg_class limit 2;
server sent data ("D" message) without prior row description ("T" message)
SELECT
q=# select * from pg_class limit 3;
server sent data ("D" message) without prior row description ("T" message)
server sent data ("D" message) without prior row description ("T" message)
SELECT
Why can I select from pg_class? Other system tables are working properly...
And one more:
q=# create table q(i int);
CREATE TABLE
q=# insert into q values (1);
INSERT 17450 1
q=# insert into q values (2);
INSERT 17451 1
q=# select count(*) from q; count
------- 2
(1 row)
q=# select count(*) from q limit 1; count
------- 2
(1 row)
q=# select count(*) from q limit 1 offset 1; count
-------
(0 rows)
q=# select count(*) from q offset 1; count
-------
(0 rows)
q=# select count(*) from q offset 0; count
------- 2
(1 row)
I understand that it isn't correct query, but why pgsql do something strange
instead of say 'error'?
--
Teodor Sigaev E-mail: teodor@sigaev.ru