Update of /cvsroot/monetdb/sql/src/test/bugs/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv1972/src/test/bugs/Tests
Modified Files:
innerjoin_multiple-bug-sf-943661.stable.out
select_orderby_alias-bug-sf-1024615.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: innerjoin_multiple-bug-sf-943661.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.stable.out,v
retrieving revision 1.16
retrieving revision 1.17
diff -u -d -r1.16 -r1.17
--- innerjoin_multiple-bug-sf-943661.stable.out 30 Dec 2008 19:19:06 -0000
1.16
+++ innerjoin_multiple-bug-sf-943661.stable.out 27 Feb 2010 19:28:34 -0000
1.17
@@ -28,7 +28,7 @@
% sys.schemas, .tables, .columns # table_name
% name, name, name # name
% varchar, varchar, varchar # type
-% 3, 10, 11 # length
+% 3, 10, 12 # length
[ "sys", "args", "func_id" ]
[ "sys", "args", "id" ]
[ "sys", "args", "name" ]
@@ -41,6 +41,7 @@
[ "sys", "columns", "name" ]
[ "sys", "columns", "null" ]
[ "sys", "columns", "number" ]
+[ "sys", "columns", "storage_type" ]
[ "sys", "columns", "table_id" ]
[ "sys", "columns", "type" ]
[ "sys", "columns", "type_digits" ]
@@ -93,7 +94,7 @@
% sys.s, .t, .c # table_name
% name, name, name # name
% varchar, varchar, varchar # type
-% 3, 10, 11 # length
+% 3, 10, 12 # length
[ "sys", "args", "func_id" ]
[ "sys", "args", "id" ]
[ "sys", "args", "name" ]
@@ -106,6 +107,7 @@
[ "sys", "columns", "name" ]
[ "sys", "columns", "null" ]
[ "sys", "columns", "number" ]
+[ "sys", "columns", "storage_type" ]
[ "sys", "columns", "table_id" ]
[ "sys", "columns", "type" ]
[ "sys", "columns", "type_digits" ]
Index: select_orderby_alias-bug-sf-1024615.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/select_orderby_alias-bug-sf-1024615.stable.out,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -d -r1.9 -r1.10
--- select_orderby_alias-bug-sf-1024615.stable.out 30 Dec 2008 19:19:06
-0000 1.9
+++ select_orderby_alias-bug-sf-1024615.stable.out 27 Feb 2010 19:28:35
-0000 1.10
@@ -21,18 +21,21 @@
Over..
-# 12:31:04 >
-# 12:31:04 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=30086
-# 12:31:04 >
+# 19:43:02 >
+# 19:43:02 > mclient -lsql -ftest -i -e --host=alf --port=32764
+# 19:43:02 >
-% 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 * FROM "sys"."keys" AS "keys", "sys"."keycolumns" AS
+% 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 * FROM "sys"."keys" AS "keys", "sys"."keycolumns" AS
+% 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 cast(null AS varchar(1)) AS "TABLE_CAT",
% ., sys.schemas, .tables, sys.keycolumns, sys.keys,
sys.keys # table_name
% TABLE_CAT, TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, KEY_SEQ,
PK_NAME # name
% varchar, varchar, varchar, varchar, int, varchar
# type
------------------------------------------------------------------------------
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
