Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv15984/src/test/BugTracker/Tests
Modified Files:
crash_on_fkey_update2.SF-1703497.stable.err.Five
select_id_not_in_another_select.SF-1737777.stable.err.Algebra
set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out
Log Message:
added support for sql/xml namespaces
fixed bug in algebra version for handling exist/not exists in exists/not exists
with correlation
added optimizer steps for algebra version to rewrite semi/anti joins followed
by joins on the same (referenced) relation into a single semijoin
push selects through semi/anti joins
approved tests
U select_id_not_in_another_select.SF-1737777.stable.err.Algebra
Index: select_id_not_in_another_select.SF-1737777.stable.err.Algebra
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/select_id_not_in_another_select.SF-1737777.stable.err.Algebra,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- select_id_not_in_another_select.SF-1737777.stable.err.Algebra 28 Jan
2008 16:25:55 -0000 1.1
+++ select_id_not_in_another_select.SF-1737777.stable.err.Algebra 28 Oct
2008 20:05:04 -0000 1.2
@@ -12,9 +12,9 @@
# 09:42:27 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=koala --port=32420
# 09:42:27 >
-MAPI = [EMAIL PROTECTED]:34235
-QUERY = select objID1 from "Match" where objID1 not in (select objID1 from
-ERROR = !SELECT: identifier 'objid1' unknown
+# 20:11:36 >
+# 20:11:36 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=35925 -G
+# 20:11:36 >
# 09:42:28 >
U set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out
Index: set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out 7 Sep 2008
20:31:36 -0000 1.6
+++ set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out 28 Oct 2008
20:05:04 -0000 1.7
@@ -35,7 +35,7 @@
% name, fullname, default_schema # name
% varchar, varchar, int # type
% 9, 10, 4 # length
-[ "skyserver", "sky server", 1059 ]
+[ "skyserver", "sky server", 1061 ]
# 16:28:05 >
# 16:28:05 > Done.
U crash_on_fkey_update2.SF-1703497.stable.err.Five
Index: crash_on_fkey_update2.SF-1703497.stable.err.Five
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/crash_on_fkey_update2.SF-1703497.stable.err.Five,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- crash_on_fkey_update2.SF-1703497.stable.err.Five 8 Feb 2008 22:49:38
-0000 1.2
+++ crash_on_fkey_update2.SF-1703497.stable.err.Five 28 Oct 2008 20:05:04
-0000 1.3
@@ -10,19 +10,19 @@
# 22:42:12 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=33006
# 22:42:12 >
-MAPI = [EMAIL PROTECTED]:36456
+MAPI = [EMAIL PROTECTED]:35914
QUERY = update t2 set id = 10 where id =3;
ERROR = !SQLException:assert:UPDATE: FOREIGN KEY constraint 't2.t2_id_fkey'
violated
-MAPI = [EMAIL PROTECTED]:36456
+MAPI = [EMAIL PROTECTED]:35914
QUERY = drop table t2;
ERROR = !current transaction is aborted (please ROLLBACK)
-MAPI = [EMAIL PROTECTED]:36456
+MAPI = [EMAIL PROTECTED]:35914
QUERY = drop table t1;
ERROR = !current transaction is aborted (please ROLLBACK)
-MAPI = [EMAIL PROTECTED]:36456
+MAPI = [EMAIL PROTECTED]:35914
QUERY = COMMIT;
-ERROR = !COMMIT: failed
- !ERROR: COMMIT: transaction is aborted, will ROLLBACK instead
+ERROR = !ERROR: COMMIT: transaction is aborted, will ROLLBACK instead
+ !COMMIT: failed
# 22:42:12 >
# 22:42:12 > Done.
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
