Bugs item #2678502, was opened at 2009-03-10 12:44
Message generated for change (Tracker Item Submitted) made by Item Submitter
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: Open
Resolution: None
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
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2678502&group_id=56967
------------------------------------------------------------------------------
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
