Bugs item #1613902, was opened at 2006-12-12 12:08
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1613902&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL 2.14
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Ronald Oussoren (ronaldoussoren)
Assigned to: Niels Nes (nielsnes)
Summary: SQL BLOB edgecases
Initial Comment:
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);
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2007-01-15 20:49
Message:
Logged In: YES
user_id=43556
Originator: NO
The BLOB with empty string, we concider an incorrect value, ie use NULL
instead.
Added a test for this, the others now work correctly
See src/test/BugTracker/Tests/blob_corner_cases.SF-1613902
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1613902&group_id=56967
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Monetdb-bugs mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
