Hi,
I have a simple SQL script which starts like this:
CREATE TABLE people (
pid integer NOT NULL PRIMARY KEY,
name varchar(40) NOT NULL DEFAULT '',
number varchar(15) NOT NULL UNIQUE DEFAULT '0',
email varchar(100) NOT NULL,
spid integer NOT NULL DEFAULT '0'
);
Afterwards, it inserts 251 People with ascending pids from 0 to 250. I
apply it to the MonetDB database either with MapiClient, or JDBCClient.
However, if I login with the JDBCClient and do a "select name,number
from people;" i only get 250 rows, not 251! But no error is reported.
Instead, a "select count(*) from people;" returns 251.
if i try the same with the MapiClient, everything works as expected.
the problem seems to be with other tables, too, but there the count of
returned rows another one, so I expect it has something to with a packet
limit, or something? is it a configuration thing or a bug? with 2.8.2
everything worked.
if executed from a java program, the statement returns the exception
"protocol violation: unexpected line in data block:"
