| From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
|---|---|
| To: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Bug(s) or not? |
| Date: | 2003-05-26 10:17:52 |
| Message-ID: | 3ED1E9D0.6080706@sigaev.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at)sigaev(dot)ru
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-05-26 11:29:25 | Re: Bug(s) or not? |
| Previous Message | Rajesh Kumar Mallah | 2003-05-26 09:24:13 | slow \d commands. |