I thing this have relation to the bug I report a long, long time ago
(and never fixed) about SapDB returning wrong results when using "in"
operator with date/timestamp datatypes.
Richter
Thorsten Rosenkranz escreveu:
Hi
I get a wrong result "1" with the following statement:
select 1 from dual where '2005-11-23 11:34:04.985364'<subdate('2005-11-25
11:04:10.456231',40)
with "select subdate('2005-11-25 11:04:10.456231',40) from dual" I get the correct result
"2005-10-16 11:04:10.456231".
"select 1 from dual where '2005-11-23 11:34:04.985364'<'2005-10-16
11:04:10.456231'" is also correct and results to nothing.
I testet this statement in three db-versions:
sapdb 7.3.0 Build 029-000-087-696 works correct
maxdb 7.5.0 Build 030-121-100-791 and maxdb 7.6.0 Build 016-121-109-428 are
wrong
kind regards, Thorsten
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
