Bugs item #2075266, was opened at 2008-08-26 07:37
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075266&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 CVS Head
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Qian Qiao (drizzlerain)
Assigned to: Niels Nes (nielsnes)
Summary: SELECT EXTRACT is wrong
Initial Comment:
OS : RedHat Linux AS 4
GCC: 3.4.6
1.setup:
CREATE TABLE A (FIPS2 TIMESTAMP);
2.insert:
INSERT INTO A VALUES (
TIMESTAMP '1996-08-24 16:03:00.999999');
3.execute:
SELECT EXTRACT (SECOND FROM FIPS2)
* 1000000 - 999990 FROM A;
4.result:
+----------------------+
| sql_mul_second_fips2 |
+======================+
| -999990 |
+----------------------+
5.question:
The result is wrong.
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2009-08-06 21:26
Message:
will be close in next feature release
----------------------------------------------------------------------
Comment By: Stefan Manegold (stmane)
Date: 2009-02-15 20:43
Message:
test sql/src/test/BugTracker-2008/Tests/extract_bug.SF-2075266.* has been
disabled in the Feb2009 release branch as it won't be fixed, there.
----------------------------------------------------------------------
Comment By: Niels Nes (nielsnes)
Date: 2008-08-26 13:58
Message:
Logged In: YES
user_id=43556
Originator: NO
script added. extract_bug.SF-2075266.sql
The second(s) extract doesn't follow the specs here.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075266&group_id=56967
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
