Update of /cvsroot/monetdb/sql/src/test/BugDay_2005-11-09_2.8/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv1972/src/test/BugDay_2005-11-09_2.8/Tests
Modified Files:
ORDER_BY_evaluation_error.SF-1023658.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: ORDER_BY_evaluation_error.SF-1023658.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-11-09_2.8/Tests/ORDER_BY_evaluation_error.SF-1023658.stable.out,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -d -r1.10 -r1.11
--- ORDER_BY_evaluation_error.SF-1023658.stable.out 30 Dec 2008 19:19:06
-0000 1.10
+++ ORDER_BY_evaluation_error.SF-1023658.stable.out 27 Feb 2010 19:28:26
-0000 1.11
@@ -21,20 +21,22 @@
Over..
-# 12:29:32 >
-# 12:29:32 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=30086
-# 12:29:32 >
+# 19:37:26 >
+# 19:37:26 > mclient -lsql -ftest -i -e --host=alf --port=32764
+# 19:37:26 >
-% sys.keys, sys.keys, sys.keys, sys.keys, sys.keys,
sys.keys, sys.keycolumns, sys.keycolumns, sys.keycolumns, sys.keycolumns,
.tables, .tables, .tables, .tables, .tables,
.tables, .tables, .tables, sys.schemas, sys.schemas,
sys.schemas, sys.schemas # table_name
-% id, table_id, type, name, rkey, action, id, column, trunc,
nr, id, name, schema_id, query, type, system, commit_action,
temporary, id, name, authorization, owner # name
-% int, int, int, varchar, int, int, int, varchar,
int, int, int, varchar, int, varchar, smallint,
boolean, smallint, tinyint, int, varchar, int,
int # type
-% 1, 1, 1, 0, 1, 1, 1, 0, 1, 1,
1, 0, 1, 0, 1, 5, 1, 1, 1, 0,
1, 1 # length
-% sys.keys, sys.keys, sys.keys, sys.keys, sys.keys,
sys.keys, sys.keycolumns, sys.keycolumns, sys.keycolumns, sys.keycolumns,
.tables, .tables, .tables, .tables, .tables,
.tables, .tables, .tables, sys.schemas, sys.schemas,
sys.schemas, sys.schemas # table_name
-% id, table_id, type, name, rkey, action, id, column, trunc,
nr, id, name, schema_id, query, type, system, commit_action,
temporary, id, name, authorization, owner # name
-% int, int, int, varchar, int, int, int, varchar,
int, int, int, varchar, int, varchar, smallint,
boolean, smallint, tinyint, int, varchar, int,
int # type
-% 1, 1, 1, 0, 1, 1, 1, 0, 1, 1,
1, 0, 1, 0, 1, 5, 1, 1, 1, 0,
1, 1 # length
+#SELECT *
+% sys.keys, sys.keys, sys.keys, sys.keys, sys.keys,
sys.keys, sys.keycolumns, sys.keycolumns, sys.keycolumns, sys.keycolumns,
.tables, .tables, .tables, .tables, .tables,
.tables, .tables, .tables, .tables, sys.schemas,
sys.schemas, sys.schemas, sys.schemas # table_name
+% id, table_id, type, name, rkey, action, id, column, trunc,
nr, id, name, schema_id, query, type, system, commit_action,
readonly, temporary, id, name, authorization, owner # name
+% int, int, int, varchar, int, int, int, varchar,
int, int, int, varchar, int, varchar, smallint,
boolean, smallint, boolean, tinyint, int,
varchar, int, int # type
+% 1, 1, 1, 0, 1, 1, 1, 0, 1, 1,
1, 0, 1, 0, 1, 5, 1, 5, 1, 1,
0, 1, 1 # length
+#SELECT *
+% sys.keys, sys.keys, sys.keys, sys.keys, sys.keys,
sys.keys, sys.keycolumns, sys.keycolumns, sys.keycolumns, sys.keycolumns,
.tables, .tables, .tables, .tables, .tables,
.tables, .tables, .tables, .tables, sys.schemas,
sys.schemas, sys.schemas, sys.schemas # table_name
+% id, table_id, type, name, rkey, action, id, column, trunc,
nr, id, name, schema_id, query, type, system, commit_action,
readonly, temporary, id, name, authorization, owner # name
+% int, int, int, varchar, int, int, int, varchar,
int, int, int, varchar, int, varchar, smallint,
boolean, smallint, boolean, tinyint, int,
varchar, int, int # type
+% 1, 1, 1, 0, 1, 1, 1, 0, 1, 1,
1, 0, 1, 0, 1, 5, 1, 5, 1, 1,
0, 1, 1 # length
-# 12:29:33 >
-# 12:29:33 > Done.
-# 12:29:33 >
+# 19:37:26 >
+# 19:37:26 > Done.
+# 19:37:26 >
------------------------------------------------------------------------------
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
