Bugs item #2075133, was opened at 2008-08-26 06:22 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075133&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: Niels Nes (nielsnes) Summary: Don't limit the disable DATE Initial Comment: OS: RedHat Linux AS 4 GCC: 3.4.6 1.setup: CREATE TABLE A (a DATE); 2.execute: INSERT INTO A VALUES ( DATE '9999-01-01' + INTERVAL '1-00' YEAR TO MONTH); 3.result: select * from A; +------------+ | a | +============+ | 10000-01-0 | : 1 | +------------+ 4.question: "10000-01-01" is not a correct DATE. ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2008-08-26 12:11 Message: Logged In: YES user_id=43556 Originator: NO Added test add year_overflow_bug.SF-2075133.sql . The sql specs indeed specify a DATE literal as YYYY-MM-DD. ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2008-08-26 06:51 Message: Logged In: YES user_id=572415 Originator: NO Why is "10000-01-01" not a correct DATE? (Admittedly, we cannoth predict whether or planet, let alone our civilization, will still exist, then, but the date itself looks perfectly correct to me...) Or does the SQL standard limit its calender to 4-digit years, or so? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075133&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
