Bugs item #2678502, was opened at 2009-03-10 12:44
Message generated for change (Comment added) made by stmane
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2678502&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: Jens Oehlschlägel (jens_oehl)
Assigned to: Niels Nes (nielsnes)
Summary: Scary: (not)equal evaluated wrong
Initial Comment:
sql>-- aparently correct
0 tuples
sql>SELECT a, b
more>FROM (select 1 AS a, 'x' AS b) sub
more>WHERE b='x'
more>;
+---+---+
| a | b |
+===+===+
| 1 | x |
+---+---+
1 tuple
sql>
0 tuples
sql>-- WRONG
0 tuples
sql>SELECT a, b
more>FROM (select 1 AS a, 'x' AS b) sub
more>WHERE b<>'x'
more>;
+---+---+
| a | b |
+===+===+
| 1 | x |
+---+---+
1 tuple
sql>
0 tuples
sql>-- WRONG
0 tuples
sql>SELECT a, b
more>FROM (select 1 AS a, 'x' AS b) sub
more>WHERE b = 'y'
more>;
+---+---+
| a | b |
+===+===+
| 1 | x |
+---+---+
1 tuple
sql>
0 tuples
sql>
0 tuples
sql>-- correct
0 tuples
sql>SELECT a, b
more>FROM (select 1 AS a, 'x' AS b) sub
more>WHERE NOT b='x'
more>;
0 tuples
sql>
0 tuples
sql>-- correct
0 tuples
sql>SELECT a, b
more>FROM (select 1 AS a, 'x' AS b) sub
more>WHERE NOT b<>'x'
more>;
+---+---+
| a | b |
+===+===+
| 1 | x |
+---+---+
1 tuple
sql>
0 tuples
sql>-- correct
0 tuples
sql>SELECT a, b
more>FROM (select 1 AS a, 'x' AS b) sub
more>WHERE NOT b = 'y'
more>;
+---+---+
| a | b |
+===+===+
| 1 | x |
+---+---+
1 tuple
sql>
0 tuples
sql>
0 tuples
sql>-- correct
0 tuples
sql>SELECT a, b
more>FROM (select 1 AS a, 'x' AS b) sub
more>WHERE b IN ('x')
more>;
+---+---+
| a | b |
+===+===+
| 1 | x |
+---+---+
1 tuple
sql>
0 tuples
sql>-- correct
0 tuples
sql>SELECT a, b
more>FROM (select 1 AS a, 'x' AS b) sub
more>WHERE b IN ('y')
more>;
0 tuples
sql>
0 tuples
sql>
0 tuples
sql>-- correct
0 tuples
sql>SELECT a, b
more>FROM (select 1 AS a, 'x' AS b) sub
more>WHERE NOT b IN ('x')
more>;
0 tuples
sql>
0 tuples
sql>-- correct
0 tuples
sql>SELECT a, b
more>FROM (select 1 AS a, 'x' AS b) sub
more>WHERE NOT b IN ('y')
more>;
+---+---+
| a | b |
+===+===+
| 1 | x |
+---+---+
1 tuple
MonetDB server v5.10.1 (32-bit), based on kernel v1.28.1 (32-bit oids)
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
Visit http://monetdb.cwi.nl/ for further information
Configured for prefix: C:\Documents and Settings\sjoerd\My
Documents\src\stable\vs32\NT32
Libraries:
libpcre: 7.7 2008-05-07
libxml2: 2.6.32
Compiled by: sjo...@gans
Compilation: cl -GF -W3 -WX -wd4273 -wd4102 -MD -nologo -Ox
Linking : cl -GF -W3 -WX -wd4273 -wd4102 -MD -nologo -Ox
----------------------------------------------------------------------
>Comment By: Stefan Manegold (stmane)
Date: 2009-03-13 17:50
Message:
Fixed by Niels in Feb2009 CVS branch.
Test added by Niels in
sql/src/test/BugTracker-2009/Tests/not_equal.SF-2678502.sql
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2678502&group_id=56967
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
