Bugs item #2075075, was opened at 2008-08-26 05:52
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075075&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: None
Group: MonetDB5 5.6
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Jane Chen (cjnn)
Assigned to: Niels Nes (nielsnes)
Summary: The DEFAULT value is wrong
Initial Comment:
os: RedHat as 4
gcc: 3.4.6
1.setup:
CREATE TABLE A
(a NUMERIC(4,1) DEFAULT 98.6,
b NUMERIC(5) DEFAULT -55555);
2.insert:
INSERT INTO A(a) VALUES (99.0);
3.execute:
select * from A;
4.result:
+--------+-------+
| a |b |
+========+=======+
| 99.0 |null |
+--------+-------+
5.question:
The values of "b" should be "-55555".
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2008-09-09 12:41
Message:
- handling wasn't done correctly for 'default' values.
----------------------------------------------------------------------
Comment By: Niels Nes (nielsnes)
Date: 2008-08-26 11:58
Message:
Logged In: YES
user_id=43556
Originator: NO
Added a test to
src/test/BugTracker-2008/Tests/incorrect_default_value_inserted.SF-2075075.sql
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075075&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
