On 11-02-2008 16:57:03 -0500, McKennirey.Matthew wrote:
The error is reported by SQL clients (Squirrel SQL, OpenOffice, etc) when issuing
SELECT * FROM "dpa"."collection_info";
The previous log file was the output when the above query was passed by the client.
Indeed, the last query was TD 1202760166418: write final block: 35 bytes TX 1202760166418: sselect * from dpa.collection_info; RD 1202760166420: read final block: 4693 bytes RX 1202760166421: &1 8 37 14 37
No idea, I think I found your issue though: (removed lots of data to make it readable)
RX 1202760166421: &1 8 37 14 37 % # table_name % # name % # type % # length [ 1 [ 2 [ 3 [ 4 [ 5 [ 6 [ 7 [ 8 [ 9 [ 10 [ 11 [ 12 [ 13 [ 14 [ 15 [ 16
RD 1202760166421: inserting prompt
16 != (14 or 37) so JDBC gets confused by getting more rows than it expects. It could be clearer here in the error message, but I'm not sure where it ends up here, it might complain about seeing the prompt after reading line 15 and 16, in which case the error message is correct.
Niels, any idea on how this can happen (sending more rows than the header says)?
I have no idea. What is the query which gives this problematic output.
Niels
PS. This is a BUG.
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users