[MonetDB-users] SQL BLOB minor issue

Hi,

This is probably bad SQL-fu on my part, but you never know :-). I'm trying to insert a 0-byte blob into a table, but that doesn't work for me. The SQL code below fails on the second insert, the database complains about a bad blob syntax. Inserting an implicit NULL into a BLOB colum also fails (the 3th insert), even though inserting an explicit NULL (the fourth one) does succeed.

CREATE TABLE testtable ( id INTEGER data BLOB );

INSERT INTO testtable (id, data) VALUES (0, BLOB '00');

INSERT INTO testtable (id, data) VALUES (1, BLOB '');

INSERT INTO testtable (id) VALUES (2);

INSERT INTO testtable (id, data) VALUES (2, NULL);

Regards, Ronald