Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv22582/src/test/BugTracker/Tests
Modified Files:
range_predicate.SF-1711242.sql
range_predicate.SF-1711242.stable.out
Log Message:
fixed optimizer bug, also fix order of joins which join more complex
columns.
Index: range_predicate.SF-1711242.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/range_predicate.SF-1711242.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- range_predicate.SF-1711242.stable.out 12 May 2007 22:22:49 -0000
1.1
+++ range_predicate.SF-1711242.stable.out 23 May 2007 23:00:25 -0000
1.2
@@ -34,8 +34,14 @@
% 1, 1, 1, 1, 32 # length
[ 1, 1, 1, 1, "foo" ]
[ 2, 0, 2, 1, "bar" ]
+% sys.c2 # table_name
+% pre # name
+% int # type
+% 1 # length
+[ 1 ]
+[ 2 ]
-# 00:17:03 >
-# 00:17:03 > Done.
-# 00:17:03 >
+# 00:55:05 >
+# 00:55:05 > Done.
+# 00:55:05 >
Index: range_predicate.SF-1711242.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/range_predicate.SF-1711242.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- range_predicate.SF-1711242.sql 12 May 2007 22:22:49 -0000 1.1
+++ range_predicate.SF-1711242.sql 23 May 2007 23:00:25 -0000 1.2
@@ -1,3 +1,5 @@
SELECT c0002.* FROM test1711251 AS c0002, test1711251 AS c0001 WHERE c0001.pre
+ c0001.size >= c0002.pre AND c0002.pre > c0001.pre AND c0001.prop =
'auctionG.xml';
SELECT c0002.* FROM test1711251 AS c0002, test1711251 AS c0001 WHERE c0002.pre
> c0001.pre AND c0001.prop = 'auctionG.xml';
+
+select distinct c2.pre from test1711251 as c2, test1711251 as c1 where c1.kind
= 6 and c1.prop = 'auctionG.xml' and c2.kind = 1 and c2.pre > c1.pre and c1.pre
+ c1.size >= c2.pre;
-------------------------------------------------------------------------
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
