Update of /cvsroot/monetdb/sql/src/test
In directory sc8-pr-cvs16:/tmp/cvs-serv26146
Added Files:
compoundselect.sql
Log Message:
Added tst for bugreport [ 1711242 ] M5/SQL: wrong result for range predicate
--- NEW FILE: compoundselect.sql ---
-- [ 1711242 ] M5/SQL: wrong result for range predicate
create table test (pre integer not null primary key, size integer not
null, level smallint not null, kind smallint not null, prop char (32));
insert into test values(0, 2, 0, 6, 'auctionG.xml');
insert into test values(1, 1, 1, 1, 'foo');
insert into test values(2, 0, 2, 1, 'bar');
select * from test;
SELECT c0002.* FROM test AS c0002, test AS c0001 WHERE c0001.pre +
c0001.size >= c0002.pre AND c0002.pre > c0001.pre AND c0001.prop
='auctionG.xml';
-- This statement should return the foo and bar tuples -- but it doesn't.
-- Throwing away the first (non-effective) condition produces the expected
-- result:
SELECT c0002.* FROM test AS c0002, test AS c0001 WHERE c0002.pre >
c0001.pre AND c0001.prop = 'auctionG.xml';
drop table test;
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
