Bugs item #2075104, was opened at 2008-08-26 06:07 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075104&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: MonetDB5 5.6 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Jane Chen (cjnn) Assigned to: Nobody/Anonymous (nobody) Summary: Can not insert a DOUBLE data into the INT type Initial Comment: OS: RedHat Linux AS 4 GCC: 3.4.6 1.setup: CREATE TABLE A (a INT); 2.execute: INSERT INTO A VALUES (.31416E+1); 3.result: !types double(51,0) (dbl) and int(32,0) (int) are not equal ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2008-08-26 12:05 Message: Logged In: YES user_id=43556 Originator: NO Not sure if why we would support this. It seems better to signal this user error then insert the down casted value. I'm not 100% sure about the SQL specs here but it sounds strange to me. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075104&group_id=56967 ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
