Changeset: 424b5bce1347 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=424b5bce1347
Modified Files:
        sql/test/BugConstraints/Tests/add_constraint_1643522.stable.err
        sql/test/BugConstraints/Tests/add_constraint_1643522.stable.out
        sql/test/BugConstraints/Tests/delete_primarykey_1643845.stable.err
        sql/test/BugConstraints/Tests/drop_column_1643542.stable.err
        sql/test/BugConstraints/Tests/update_primarykey_1643375.stable.err
        
sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851.stable.out
        sql/test/BugTracker-2009/Tests/All
        sql/test/BugTracker-2009/Tests/mclient-lsql-D.stable.out
        
sql/test/BugTracker-2009/Tests/name_clash_with_dump.SF-2780395.stable.out
        sql/test/BugTracker-2009/Tests/reorder.SF-2770608.sql
        sql/test/BugTracker-2009/Tests/table-leftovers.SF-2779462.sql
        sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out
        
sql/test/BugTracker-2011/Tests/interrupted-initialization.Bug-2875.stable.out
        
sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out
        sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err
        sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
        
sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-0.Bug-3063.stable.out
        
sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-1.Bug-3063.stable.out
        sql/test/BugTracker/Tests/multi-column-constraint.SF-1964587.stable.out
        sql/test/BugTracker/Tests/rank_over.SF-1691098.stable.out
        sql/test/BugTracker/Tests/with_only_once.SF-1720293.stable.out
        sql/test/Dependencies/Tests/Dependencies.stable.err
        sql/test/Dependencies/Tests/Dependencies.stable.out
        sql/test/Dependencies/Tests/dependency_loop.stable.out
        sql/test/DropCascade/Tests/drop_columns_cascade.stable.out
        sql/test/DropCascade/Tests/drop_pkey_cascade.stable.out
        sql/test/Dump/Tests/dump-empty.stable.out
        sql/test/Dump/Tests/dump.stable.out
        sql/test/Tests/keys.stable.out
        sql/test/Tests/setoptimizer.stable.err
        sql/test/Tests/setoptimizer.stable.out
        sql/test/Tests/systemfunctions.stable.out
        sql/test/UserDump/Tests/create.stable.out
        sql/test/bugs/Tests/groupby_having_charlength-bug-sf-943566.stable.out
        sql/test/bugs/Tests/insert_delete-bug-sf-904025.stable.out
        sql/test/bugs/Tests/simple_view.stable.out
        
sql/test/bugs/Tests/subselect_multiple_unionall_where_1=1-bug-sf-1005596.stable.out
        sql/test/concurrent/Tests/crash_on_concurrent_use.SF-1411926.stable.out
        sql/test/mapi/Tests/php_monetdb.stable.out
        sql/test/setoptimizer.sql
        sql/test/testdb/Tests/testdb-dump.stable.out
Branch: default
Log Message:

Approved and modified tests for the querylog change
They may require a double check at some point.


diffs (truncated from 935 to 300 lines):

diff --git a/sql/test/BugConstraints/Tests/add_constraint_1643522.stable.err 
b/sql/test/BugConstraints/Tests/add_constraint_1643522.stable.err
--- a/sql/test/BugConstraints/Tests/add_constraint_1643522.stable.err
+++ b/sql/test/BugConstraints/Tests/add_constraint_1643522.stable.err
@@ -12,7 +12,7 @@ stderr of test 'add_constraint_1643522` 
 # 12:55:03 >  Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb 
--host=localhost --port=33669  < add_constraint_1643522.sql
 # 12:55:03 >  
 
-MAPI  = monetdb@sofia:38972
+MAPI  = (monetdb) /var/tmp/mtest-481/.s.monetdb.31323
 QUERY = alter table t1 add constraint id_p primary key(id);
 ERROR = !CONSTRAINT PRIMARY KEY: key 'id_p' already exists
 
diff --git a/sql/test/BugConstraints/Tests/add_constraint_1643522.stable.out 
b/sql/test/BugConstraints/Tests/add_constraint_1643522.stable.out
--- a/sql/test/BugConstraints/Tests/add_constraint_1643522.stable.out
+++ b/sql/test/BugConstraints/Tests/add_constraint_1643522.stable.out
@@ -21,16 +21,12 @@ Ready.
 % sys.keys # table_name
 % name # name
 % varchar # type
-% 20 # length
-[ "queryhistory_id_pkey"       ]
-[ "callhistory_id_fkey"        ]
+% 4 # length
 [ "id_p"       ]
 % sys.keys # table_name
 % name # name
 % varchar # type
-% 20 # length
-[ "queryhistory_id_pkey"       ]
-[ "callhistory_id_fkey"        ]
+% 0 # length
 
 # 11:09:09 >  
 # 11:09:09 >  Done.
diff --git a/sql/test/BugConstraints/Tests/delete_primarykey_1643845.stable.err 
b/sql/test/BugConstraints/Tests/delete_primarykey_1643845.stable.err
--- a/sql/test/BugConstraints/Tests/delete_primarykey_1643845.stable.err
+++ b/sql/test/BugConstraints/Tests/delete_primarykey_1643845.stable.err
@@ -12,10 +12,10 @@ stderr of test 'delete_primarykey_164384
 # 12:55:04 >  Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb 
--host=localhost --port=33669  < delete_primarykey_1643845.sql
 # 12:55:04 >  
 
-MAPI  = monetdb@sofia:39182
+MAPI  = (monetdb) /var/tmp/mtest-481/.s.monetdb.31323
 QUERY = insert into t2 values(2,33);
 ERROR = !INSERT INTO: FOREIGN KEY constraint 't2.t2_id_f_fkey' violated
-MAPI  = monetdb@sofia:39182
+MAPI  = (monetdb) /var/tmp/mtest-481/.s.monetdb.31323
 QUERY = delete from t1 where id = 1;
 ERROR = !DELETE: FOREIGN KEY constraint 't2.t2_id_f_fkey' violated
 
diff --git a/sql/test/BugConstraints/Tests/drop_column_1643542.stable.err 
b/sql/test/BugConstraints/Tests/drop_column_1643542.stable.err
--- a/sql/test/BugConstraints/Tests/drop_column_1643542.stable.err
+++ b/sql/test/BugConstraints/Tests/drop_column_1643542.stable.err
@@ -12,10 +12,10 @@ stderr of test 'drop_column_1643542` in 
 # 12:57:28 >  Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb 
--host=localhost --port=31322  < drop_column_1643542.sql
 # 12:57:28 >  
 
-MAPI  = monetdb@sofia:38972
+MAPI  = (monetdb) /var/tmp/mtest-481/.s.monetdb.31323
 QUERY = alter table t2 add constraint id_p primary key(id_f);
 ERROR = !CONSTRAINT PRIMARY KEY: key 'id_p' already exists
-MAPI  = monetdb@sofia:38972
+MAPI  = (monetdb) /var/tmp/mtest-481/.s.monetdb.31323
 QUERY = alter table t1 drop id;
 ERROR = !ALTER TABLE: cannot drop column 'id': there are database objects 
which depend on it
 
diff --git a/sql/test/BugConstraints/Tests/update_primarykey_1643375.stable.err 
b/sql/test/BugConstraints/Tests/update_primarykey_1643375.stable.err
--- a/sql/test/BugConstraints/Tests/update_primarykey_1643375.stable.err
+++ b/sql/test/BugConstraints/Tests/update_primarykey_1643375.stable.err
@@ -12,7 +12,7 @@ stderr of test 'update_primarykey_164337
 # 12:55:04 >  Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb 
--host=localhost --port=33669  < update_primarykey_1643375.sql
 # 12:55:04 >  
 
-MAPI  = monetdb@sofia:39182
+MAPI  = (monetdb) /var/tmp/mtest-481/.s.monetdb.31323
 QUERY = update t1 set id = 0 where id =1;
 ERROR = !UPDATE: FOREIGN KEY constraint 't2.t2_id_f_fkey' violated
 
diff --git 
a/sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851.stable.out 
b/sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851.stable.out
--- a/sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851.stable.out
+++ b/sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851.stable.out
@@ -113,6 +113,12 @@ Ready.
 # 14:58:14 >  
 
 START TRANSACTION;
+CREATE SCHEMA "querylog" AUTHORIZATION "monetdb";
+SET SCHEMA "querylog";
+create view querylog.history as
+select qd.*, ql."start",ql."stop", ql.arguments, ql.tuples, ql.run, ql.ship, 
ql.cpu, ql.space, ql.io 
+from querylog.catalog() qd, querylog.calls() ql
+where qd.id = ql.id and qd.owner = user;
 SET SCHEMA "sys";
 CREATE TABLE "sys"."allnewtriples" (
        "id" INTEGER NOT NULL,
diff --git a/sql/test/BugTracker-2009/Tests/All 
b/sql/test/BugTracker-2009/Tests/All
--- a/sql/test/BugTracker-2009/Tests/All
+++ b/sql/test/BugTracker-2009/Tests/All
@@ -28,7 +28,7 @@ update-crash
 correlated-selection-bug
 segfault_when_quitting_debugger.SF-2538837
 row_number_bug.SF-2546109
-set_history_and_drop_table.SF-2607045
+#set_history_and_drop_table.SF-2607045  not relevant anymore
 TypeException_having_count_distinct.SF-2494227
 insert_into_done_by_procedure.SF-2607293
 decimal_needs_truncation.SF-2605686
diff --git a/sql/test/BugTracker-2009/Tests/mclient-lsql-D.stable.out 
b/sql/test/BugTracker-2009/Tests/mclient-lsql-D.stable.out
--- a/sql/test/BugTracker-2009/Tests/mclient-lsql-D.stable.out
+++ b/sql/test/BugTracker-2009/Tests/mclient-lsql-D.stable.out
@@ -30,6 +30,12 @@ Ready.
 # 21:51:00 >  
 
 START TRANSACTION;
+CREATE SCHEMA "querylog" AUTHORIZATION "monetdb";
+SET SCHEMA "querylog";
+create view querylog.history as
+select qd.*, ql."start",ql."stop", ql.arguments, ql.tuples, ql.run, ql.ship, 
ql.cpu, ql.space, ql.io 
+from querylog.catalog() qd, querylog.calls() ql
+where qd.id = ql.id and qd.owner = user;
 SET SCHEMA "sys";
 CREATE TABLE "sys"."table_a" (
        "table_a_id" INTEGER       NOT NULL,
diff --git 
a/sql/test/BugTracker-2009/Tests/name_clash_with_dump.SF-2780395.stable.out 
b/sql/test/BugTracker-2009/Tests/name_clash_with_dump.SF-2780395.stable.out
--- a/sql/test/BugTracker-2009/Tests/name_clash_with_dump.SF-2780395.stable.out
+++ b/sql/test/BugTracker-2009/Tests/name_clash_with_dump.SF-2780395.stable.out
@@ -25,6 +25,12 @@ Ready.
 # 18:43:34 >  
 
 START TRANSACTION;
+CREATE SCHEMA "querylog" AUTHORIZATION "monetdb";
+SET SCHEMA "querylog";
+create view querylog.history as
+select qd.*, ql."start",ql."stop", ql.arguments, ql.tuples, ql.run, ql.ship, 
ql.cpu, ql.space, ql.io 
+from querylog.catalog() qd, querylog.calls() ql
+where qd.id = ql.id and qd.owner = user;
 SET SCHEMA "sys";
 CREATE TABLE "sys"."tf" (
        "a" INTEGER
diff --git a/sql/test/BugTracker-2009/Tests/reorder.SF-2770608.sql 
b/sql/test/BugTracker-2009/Tests/reorder.SF-2770608.sql
--- a/sql/test/BugTracker-2009/Tests/reorder.SF-2770608.sql
+++ b/sql/test/BugTracker-2009/Tests/reorder.SF-2770608.sql
@@ -42,7 +42,7 @@ 5125  "url"   "url"   0       0       0       13      2000
 5187   "inet"  "inet"  0       0       0       13      2000
 
 -- query causes problems in specific pipeline
-set 
optimizer='optimizer.inline();optimizer.remap();optimizer.evaluate();optimizer.costModel();optimizer.coercions();optimizer.emptySet();optimizer.mitosis();optimizer.aliases();optimizer.mergetable();optimizer.deadcode();optimizer.constants();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.dataflow();optimizer.history();optimizer.multiplex();optimizer.garbageCollector();';
+set 
optimizer='optimizer.inline();optimizer.remap();optimizer.evaluate();optimizer.costModel();optimizer.coercions();optimizer.emptySet();optimizer.mitosis();optimizer.aliases();optimizer.mergetable();optimizer.deadcode();optimizer.constants();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.garbageCollector();';
 select * from t2770608 t1, t2770608 t2 where t1.id = t2.id;
 
 -- clean up
diff --git a/sql/test/BugTracker-2009/Tests/table-leftovers.SF-2779462.sql 
b/sql/test/BugTracker-2009/Tests/table-leftovers.SF-2779462.sql
--- a/sql/test/BugTracker-2009/Tests/table-leftovers.SF-2779462.sql
+++ b/sql/test/BugTracker-2009/Tests/table-leftovers.SF-2779462.sql
@@ -1,6 +1,6 @@
 start transaction;
 
-set 
optimizer='optimizer.inline();optimizer.remap();optimizer.evaluate();optimizer.costModel();optimizer.coercions();optimizer.emptySet();optimizer.aliases();optimizer.mergetable();optimizer.deadcode();optimizer.constants();optimizer.commonTerms();optimizer.reorder();optimizer.joinPath();optimizer.deadcode();optimizer.recycle();optimizer.reduce();optimizer.dataflow();optimizer.history();optimizer.multiplex();optimizer.garbageCollector();';
+set 
optimizer='optimizer.inline();optimizer.remap();optimizer.evaluate();optimizer.costModel();optimizer.coercions();optimizer.emptySet();optimizer.aliases();optimizer.mergetable();optimizer.deadcode();optimizer.constants();optimizer.commonTerms();optimizer.reorder();optimizer.joinPath();optimizer.deadcode();optimizer.recycle();optimizer.reduce();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.garbageCollector();';
 
 CREATE TABLE y (x int);
 INSERT INTO y VALUES (10);
diff --git 
a/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out 
b/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out
--- a/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out
+++ b/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out
@@ -29,19 +29,19 @@ Ready.
 % L1 # name
 % wrd # type
 % 2 # length
-[ 32   ]
+[ 30   ]
 #select count(distinct name) from tables;
 % .tables # table_name
 % L1 # name
 % wrd # type
 % 2 # length
-[ 26   ]
+[ 24   ]
 #select count(name) , count(distinct name) from tables;
 % .tables,     .tables # table_name
 % L1,  L2 # name
 % wrd, wrd # type
 % 2,   2 # length
-[ 32,  26      ]
+[ 30,  24      ]
 
 # 10:05:42 >  
 # 10:05:42 >  Done.
diff --git 
a/sql/test/BugTracker-2011/Tests/interrupted-initialization.Bug-2875.stable.out 
b/sql/test/BugTracker-2011/Tests/interrupted-initialization.Bug-2875.stable.out
--- 
a/sql/test/BugTracker-2011/Tests/interrupted-initialization.Bug-2875.stable.out
+++ 
b/sql/test/BugTracker-2011/Tests/interrupted-initialization.Bug-2875.stable.out
@@ -17,6 +17,13 @@ stdout of test 'interrupted-initializati
 # MonetDB/GIS module loaded
 # MonetDB/SQL module loaded
 START TRANSACTION;
+CREATE SCHEMA "querylog" AUTHORIZATION "monetdb";
+SET SCHEMA "querylog";
+create view querylog.history as
+select qd.*, ql."start",ql."stop", ql.arguments, ql.tuples, ql.run, ql.ship, 
ql.cpu, ql.space, ql.io 
+from querylog.catalog() qd, querylog.calls() ql
+where qd.id = ql.id and qd.owner = user;
+SET SCHEMA "sys";
 COMMIT;
 # MonetDB 5 server v11.5.8
 # This is an unreleased version
diff --git 
a/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out
 
b/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out
--- 
a/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out
+++ 
b/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out
@@ -28,13 +28,13 @@ Ready.
 % L2,  L1 # name
 % tinyint,     wrd # type
 % 1,   2 # length
-[ 1,   33      ]
+[ 1,   31      ]
 #SELECT (SELECT count(*) FROM tables), 1;
 % .tables,     . # table_name
 % L1,  single_value # name
 % wrd, tinyint # type
 % 2,   1 # length
-[ 33,  1       ]
+[ 31,  1       ]
 
 # 21:48:51 >  
 # 21:48:51 >  "Done."
diff --git 
a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err 
b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err
--- a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err
+++ b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err
@@ -30,7 +30,7 @@ stderr of test 'predicate_select.Bug-309
 # 18:53:13 >  "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=niels" 
"--port=32323"
 # 18:53:13 >  
 
-MAPI  = (monetdb) /var/tmp/mtest-16462/.s.monetdb.36324
+MAPI  = (monetdb) /var/tmp/mtest-950/.s.monetdb.37058
 QUERY = select * from tables where name;
 ERROR = !conversion of string 'r' to type bit failed.
 
diff --git 
a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out 
b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
--- a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
+++ b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
@@ -54,13 +54,11 @@ Ready.
 [ 5104,        "user_role",    2000,   NULL,   0,      true,   0,      false,  
0       ]
 [ 5107,        "auths",        2000,   NULL,   0,      true,   0,      false,  
0       ]
 [ 5111,        "privileges",   2000,   NULL,   0,      true,   0,      false,  
0       ]
-[ 5264,        "queryhistory", 2000,   NULL,   0,      true,   0,      false,  
0       ]
-[ 5278,        "callhistory",  2000,   NULL,   0,      true,   0,      false,  
0       ]
-[ 5295,        "querylog",     2000,   "create view sys.querylog as\nselect 
qd.*, ql.ctime, ql.arguments, ql.exec, ql.result, ql.foot, ql.memory, 
ql.tuples, ql.inblock, ql.oublock from queryhistory qd, callhistory ql\nwhere 
qd.id = ql.id;",       1,      true,   0,      false,  0       ]
-[ 6036,        "storagemodelinput",    2000,   NULL,   0,      true,   0,      
false,  0       ]
-[ 6077,        "tablestoragemodel",    2000,   "-- A summary of the table 
storage requirement is is available as a table view.\n-- The auxillary column 
denotes the maximum space if all non-sorted columns\n-- would be augmented with 
a hash (rare situation)\ncreate view sys.tablestoragemodel\nas select 
\"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as 
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(indices) as 
indices,\n\tsum(case when sorted = false then 8 * count else 0 end) as 
auxillary\nfrom sys.storagemodel() group by \"schema\",\"table\";",      1,     
 true,   0,      false,  0       ]
-[ 6099,        "systemfunctions",      2000,   NULL,   0,      true,   0,      
false,  0       ]
-[ 6208,        "r",    2000,   NULL,   0,      false,  0,      false,  0       
]
+[ 5296,        "history",      5255,   "create view querylog.history 
as\nselect qd.*, ql.\"start\",ql.\"stop\", ql.arguments, ql.tuples, ql.run, 
ql.ship, ql.cpu, ql.space, ql.io \nfrom querylog.catalog() qd, querylog.calls() 
ql\nwhere qd.id = ql.id and qd.owner = user;",        1,      false,  0,      
false,  0       ]
+[ 6026,        "storagemodelinput",    2000,   NULL,   0,      true,   0,      
false,  0       ]
+[ 6067,        "tablestoragemodel",    2000,   "-- A summary of the table 
storage requirement is is available as a table view.\n-- The auxillary column 
denotes the maximum space if all non-sorted columns\n-- would be augmented with 
a hash (rare situation)\ncreate view sys.tablestoragemodel\nas select 
\"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as 
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(indices) as 
indices,\n\tsum(case when sorted = false then 8 * count else 0 end) as 
auxillary\nfrom sys.storagemodel() group by \"schema\",\"table\";",      1,     
 true,   0,      false,  0       ]
+[ 6089,        "systemfunctions",      2000,   NULL,   0,      true,   0,      
false,  0       ]
+[ 6198,        "r",    2000,   NULL,   0,      false,  0,      false,  0       
]
 
 # 18:53:13 >  
 # 18:53:13 >  "Done."
diff --git 
a/sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-0.Bug-3063.stable.out
 
b/sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-0.Bug-3063.stable.out
--- 
a/sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-0.Bug-3063.stable.out
+++ 
b/sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-0.Bug-3063.stable.out
@@ -31,9 +31,10 @@ Ready.
 % .ftf # table_name
 % sch # name
 % varchar # type
-% 3 # length
+% 8 # length
 [ "sys"        ]
 [ "tmp"        ]
+[ "querylog"   ]
 [ "ft" ]
 
 # 15:58:57 >  
diff --git 
a/sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-1.Bug-3063.stable.out
 
b/sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-1.Bug-3063.stable.out
--- 
a/sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-1.Bug-3063.stable.out
+++ 
b/sql/test/BugTracker-2012/Tests/table_functions_fail_after_restart-1.Bug-3063.stable.out
@@ -27,9 +27,10 @@ Ready.
 % .ftf # table_name
 % sch # name
 % varchar # type
-% 3 # length
+% 8 # length
 [ "sys"        ]
 [ "tmp"        ]
+[ "querylog"   ]
 [ "ft" ]
 #drop function ft.func;
 #drop schema ft;
diff --git 
a/sql/test/BugTracker/Tests/multi-column-constraint.SF-1964587.stable.out 
b/sql/test/BugTracker/Tests/multi-column-constraint.SF-1964587.stable.out
--- a/sql/test/BugTracker/Tests/multi-column-constraint.SF-1964587.stable.out
+++ b/sql/test/BugTracker/Tests/multi-column-constraint.SF-1964587.stable.out
@@ -26,6 +26,12 @@ Ready.
 # 16:17:36 >  
 
 START TRANSACTION;
+CREATE SCHEMA "querylog" AUTHORIZATION "monetdb";
+SET SCHEMA "querylog";
+create view querylog.history as
+select qd.*, ql."start",ql."stop", ql.arguments, ql.tuples, ql.run, ql.ship, 
ql.cpu, ql.space, ql.io 
+from querylog.catalog() qd, querylog.calls() ql
+where qd.id = ql.id and qd.owner = user;
_______________________________________________
checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list

Reply via email to