Bugs item #1841191, was opened at 2007-11-29 19:29
Message generated for change (Settings changed) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1841191&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: Core
Group: MonetDB5 5.2
>Status: Closed
Resolution: Fixed
Priority: 5
Private: No
Submitted By: mharrison (matt_harrison)
Assigned to: Niels Nes (nielsnes)
Summary: Timestamp column won't accept insert without time
Initial Comment:
If I create the following table
CREATE TABLE testdate (
id INTEGER NOT NULL,
adate DATE,
adatetime TIMESTAMP,
PRIMARY KEY (id)
)
I can't insert the following:
INSERT INTO testdate (id, adate, adatetime) VALUES (1, '2007-10-30',
'2007-10-30');
It gives the following error:
!SQLException:timestamp:conversion of string '2007-10-30' failed
One could argue that a timestamp is a superset of date, and thus should accept
date formatted input. (I believe mysql, postgres and oracle behave this way).
The databases should just add an implied 00:00:00.000000 for the time portion
of the timestamp value.
ps - the following works, which is sort of confusing too (what does the "0:0"
mean?)
INSERT INTO testdate (id, adate, adatetime) VALUES (2, '2007-10-30',
'2007-10-30 0:0');
----------------------------------------------------------------------
Comment By: Niels Nes (nielsnes)
Date: 2007-11-29 22:37
Message:
Logged In: YES
user_id=43556
Originator: NO
test added to
src/test/BugTracker/Tests/timestamp_default_time.SF-1841191.sql
Fixed this in the modules (mtime/monettime).
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1841191&group_id=56967
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
