Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv1972/src/test/BugTracker/Tests
Modified Files:
cardinality_violation.SF-1240701.stable.err
like_exp.SF-1613949.stable.out
set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out
Log Message:
A sequence of group new and derives is now closed with a group.done (does
the last step ie a group.new or derive).
This makes the code in merge table a bit cleaner (more could be done later)
sql.bind and append/update/delete now have an extra (first) argument,
making them safe to use in the dataflow (ie solved using variable dependencies)
(BREAKS octopus !)
Implemented read only tables. Use
ALTER TABLE x SET READ ONLY;
(cannot be reverted currently)
fixed bug in limit/offset handling, now we have 64 bit wrd instead of int.
The new read only required schema changes, ie backup/restore your db.
We therefor claimed some more oid's for internal functions.
Index: cardinality_violation.SF-1240701.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err,v
retrieving revision 1.33
retrieving revision 1.34
diff -u -d -r1.33 -r1.34
--- cardinality_violation.SF-1240701.stable.err 21 Dec 2009 11:05:54 -0000
1.33
+++ cardinality_violation.SF-1240701.stable.err 27 Feb 2010 19:28:26 -0000
1.34
@@ -80,12 +80,12 @@
# 21:00:43 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=38808
# 21:00:43 >
-MAPI = mone...@localhost:38198
+MAPI = mone...@alf:32764
QUERY = select * from env() as env where name = ( select 'prefix' from env()
as env );
ERROR = !SQLException:zero_or_one:cardinality violation (53>1)
-MAPI = mone...@localhost:38198
+MAPI = mone...@alf:32764
QUERY = select * from columns where name = (select columns.name from _tables,
columns where _tables.id = columns.table_id);
-ERROR = !SQLException:zero_or_one:cardinality violation (164>1)
+ERROR = !SQLException:zero_or_one:cardinality violation (170>1)
# 21:00:43 >
# 21:00:43 > Done.
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.12
retrieving revision 1.13
diff -u -d -r1.12 -r1.13
--- set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out 29 Jan 2009
23:52:36 -0000 1.12
+++ set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out 27 Feb 2010
19:28:26 -0000 1.13
@@ -35,7 +35,7 @@
% name, fullname, default_schema # name
% varchar, varchar, int # type
% 9, 10, 4 # length
-[ "skyserver", "sky server", 1061 ]
+[ "skyserver", "sky server", 2000 ]
# 16:28:05 >
# 16:28:05 > Done.
Index: like_exp.SF-1613949.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/like_exp.SF-1613949.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- like_exp.SF-1613949.stable.out 30 Dec 2008 19:19:06 -0000 1.4
+++ like_exp.SF-1613949.stable.out 27 Feb 2010 19:28:26 -0000 1.5
@@ -21,16 +21,17 @@
Over..
-# 21:38:42 >
-# 21:38:42 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=33867 < like_exp.SF-1613949.sql
-# 21:38:42 >
+# 19:37:54 >
+# 19:37:54 > mclient -lsql -ftest -i -e --host=alf --port=32764
+# 19:37:54 >
-% .tables, .tables, .tables, .tables, .tables,
.tables, .tables, .tables # table_name
-% id, name, schema_id, query, type, system, commit_action,
temporary # name
-% int, varchar, int, varchar, smallint, boolean,
smallint, tinyint # type
-% 1, 0, 1, 0, 1, 5, 1, 1 # length
+#select * from tables where name LIKE ('hel%');
+% .tables, .tables, .tables, .tables, .tables,
.tables, .tables, .tables, .tables # table_name
+% id, name, schema_id, query, type, system, commit_action,
readonly, temporary # name
+% int, varchar, int, varchar, smallint, boolean,
smallint, boolean, tinyint # type
+% 1, 0, 1, 0, 1, 5, 1, 5, 1 # length
-# 21:38:42 >
-# 21:38:42 > Done.
-# 21:38:42 >
+# 19:37:54 >
+# 19:37:54 > Done.
+# 19:37:54 >
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
