Changeset: c35e4c08bbb5 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c35e4c08bbb5
Modified Files:
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.err
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.err.Windows
sql/test/BugConstraints/Tests/add_constraint_1643522.stable.err
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/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err
sql/test/BugTracker-2009/Tests/ambiguous_order_by.SF-2827916.stable.err
sql/test/BugTracker-2009/Tests/ambiguous_view.stable.err
sql/test/BugTracker-2009/Tests/assert_in_update.SF-2807336.stable.err
sql/test/BugTracker-2009/Tests/copy_into_error_off_by_one.SF-2833696.stable.err
sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.err
sql/test/BugTracker-2009/Tests/create_on_ro_db_crash.SF-2830238.stable.err
sql/test/BugTracker-2009/Tests/create_table_dup_name.SF-2879005.stable.err
sql/test/BugTracker-2009/Tests/drop-sequence-crash.SF-2854195.stable.err
sql/test/BugTracker-2009/Tests/except_error_wrong.SF-2808409.stable.err
sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.err
sql/test/BugTracker-2009/Tests/incomplete.SF.2536893.stable.err
sql/test/BugTracker-2009/Tests/insert_into_values_bug.SF-2807609.stable.err
sql/test/BugTracker-2009/Tests/limit_in_subquery.SF-2620437.stable.err
sql/test/BugTracker-2009/Tests/not_invalidtable_crash.SF-2927174.stable.err
sql/test/BugTracker-2009/Tests/overflow.SF-2853458.stable.err
sql/test/BugTracker-2009/Tests/overflow.SF-2853458.stable.err.Solaris
sql/test/BugTracker-2009/Tests/overflow.SF-2853458.stable.err.Windows
sql/test/BugTracker-2009/Tests/primekeyconstraint.SF-2783425.stable.err
sql/test/BugTracker-2009/Tests/rollback_bug.stable.err
sql/test/BugTracker-2009/Tests/rollback_mistake.SF-2814622.stable.err
sql/test/BugTracker-2009/Tests/segv_for_unknown_identifier_in_subquery.SF-2874045.stable.err
sql/test/BugTracker-2009/Tests/select_X_where_bla_EQ_whatever.SF-282597.stable.err
sql/test/BugTracker-2009/Tests/select_from_history.SF-2556566.stable.err
sql/test/BugTracker-2009/Tests/subquery_returns_table_crash.SF-2513620.stable.err
sql/test/BugTracker-2009/Tests/temp_table_fail_leaves_data.SF-2793286.stable.err
sql/test/BugTracker-2009/Tests/temporary_table_leftover.SF-2734713.stable.err
sql/test/BugTracker-2009/Tests/unique_constraint_on_char.SF-2873564.stable.err
sql/test/BugTracker-2009/Tests/wrong_error_message.SF-2637051.stable.err
sql/test/BugTracker-2010/Tests/TypeException_with_missing_function.Bug-2674.stable.err
sql/test/BugTracker-2010/Tests/call_function_without_warning.Bug-2752.stable.err
sql/test/BugTracker-2010/Tests/copy-into-too-long-string.Bug-2358.stable.err
sql/test/BugTracker-2010/Tests/crash_default_unlocked.Bug-2744.stable.err
sql/test/BugTracker-2010/Tests/crash_on_in_2.Bug-2604.stable.err
sql/test/BugTracker-2010/Tests/crashonschema.Bug-2547.stable.err
sql/test/BugTracker-2010/Tests/duplicate-key.Bug-2667.stable.err
sql/test/BugTracker-2010/Tests/error-truncated.Bug-2615.stable.err
sql/test/BugTracker-2010/Tests/error-truncated.Bug-2615.stable.err.Darwin
sql/test/BugTracker-2010/Tests/error-truncated.Bug-2615.stable.err.Windows
sql/test/BugTracker-2010/Tests/incomplete-utf8-sequence.Bug-2575.stable.err
sql/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.err
sql/test/BugTracker-2010/Tests/second_function_existing_signature.Bug-2611.stable.err
sql/test/BugTracker-2010/Tests/select_from_seq.Bug-2730.stable.err
sql/test/BugTracker-2010/Tests/select_star.Bug-2563.stable.err
sql/test/BugTracker-2010/Tests/sequence-restart-with-null.Bug-2648.stable.err
sql/test/BugTracker-2010/Tests/subselect.Bug-2537.stable.err
sql/test/BugTracker-2010/Tests/sum_on_date_crash.Bug-2643.stable.err
sql/test/BugTracker-2010/Tests/times-crash.Bug-2586.stable.err
sql/test/BugTracker-2010/Tests/wrong_error_message_dropping_view.Bug-2713.stable.err
sql/test/BugTracker-2012/Tests/create_function.Bug-3172.stable.err
sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err
sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090_nogeom.stable.err
sql/test/BugTracker-2012/Tests/table_function_with_column_subselects.Bug-3172.stable.err
sql/test/BugTracker-2013/Tests/binary_copy_into.Bug-3345.stable.err
sql/test/BugTracker-2013/Tests/psm_functions_and_accessrights.Bug-3300.stable.err
sql/test/BugTracker/Tests/bind_with_cast.SF-1720934.stable.err
sql/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err
sql/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err.Windows
sql/test/Dependencies/Tests/Dependencies.stable.err
sql/test/Tests/coalesce.stable.err.single
sql/test/Tests/setoptimizer.stable.err
sql/test/Triggers/Tests/recursive_triggers.stable.err
sql/test/mserver5-sql-readonly/Tests/mserver5-sql-readonly-table.stable.err
sql/test/ssqq/Tests/insert_queue.stable.err
Branch: default
Log Message:
Merge with Feb2013 branch.
diffs (truncated from 1126 to 300 lines):
diff --git
a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.err
b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.err
--- a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.err
+++ b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.err
@@ -30,16 +30,16 @@ stderr of test 'opt_sql_append` in direc
# 22:58:57 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=rome"
"--port=36275"
# 22:58:57 >
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-15953/.s.monetdb.31373
QUERY = explain copy into ttt from '\tmp/xyz';
ERROR = !COPY INTO: filename must have absolute path: \tmp/xyz
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-15953/.s.monetdb.31373
QUERY = explain copy into ttt from 'a:\tmp/xyz';
ERROR = !COPY INTO: filename must have absolute path: a:\tmp/xyz
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-15953/.s.monetdb.31373
QUERY = explain copy into ttt from '\tmp/xyz';
ERROR = !COPY INTO: filename must have absolute path: \tmp/xyz
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-15953/.s.monetdb.31373
QUERY = explain copy into ttt from 'Z:/tmp/xyz';
ERROR = !COPY INTO: filename must have absolute path: Z:/tmp/xyz
diff --git
a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.err.Windows
b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.err.Windows
---
a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.err.Windows
+++
b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.err.Windows
@@ -30,16 +30,16 @@ stderr of test 'opt_sql_append` in direc
# 22:58:57 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=rome"
"--port=36275"
# 22:58:57 >
-MAPI = monetdb@LAB03:34567
+MAPI = (monetdb) /var/tmp/mtest-15953/.s.monetdb.31373
QUERY = explain copy into ttt from '/tmp/xyz';
ERROR = !COPY INTO: filename must have absolute path: /tmp/xyz
-MAPI = monetdb@LAB03:34567
+MAPI = (monetdb) /var/tmp/mtest-15953/.s.monetdb.31373
QUERY = explain copy into ttt from '\tmp/xyz';
ERROR = !COPY INTO: filename must have absolute path: \tmp/xyz
-MAPI = monetdb@LAB03:34567
+MAPI = (monetdb) /var/tmp/mtest-15953/.s.monetdb.31373
QUERY = explain copy into ttt from '/tmp/xyz';
ERROR = !COPY INTO: filename must have absolute path: /tmp/xyz
-MAPI = monetdb@LAB03:34567
+MAPI = (monetdb) /var/tmp/mtest-15953/.s.monetdb.31373
QUERY = explain copy into ttt from '\tmp/xyz';
ERROR = !COPY INTO: filename must have absolute path: \tmp/xyz
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) /var/tmp/mtest-481/.s.monetdb.31323
+MAPI = monetdb@sofia:38972
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/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) /var/tmp/mtest-481/.s.monetdb.31323
+MAPI = monetdb@sofia:39182
QUERY = insert into t2 values(2,33);
ERROR = !INSERT INTO: FOREIGN KEY constraint 't2.t2_id_f_fkey' violated
-MAPI = (monetdb) /var/tmp/mtest-481/.s.monetdb.31323
+MAPI = monetdb@sofia:39182
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) /var/tmp/mtest-481/.s.monetdb.31323
+MAPI = monetdb@sofia:38972
QUERY = alter table t2 add constraint id_p primary key(id_f);
ERROR = !CONSTRAINT PRIMARY KEY: key 'id_p' already exists
-MAPI = (monetdb) /var/tmp/mtest-481/.s.monetdb.31323
+MAPI = monetdb@sofia:38972
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) /var/tmp/mtest-481/.s.monetdb.31323
+MAPI = monetdb@sofia:39182
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/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err
b/sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err
--- a/sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err
+++ b/sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err
@@ -82,7 +82,7 @@ stderr of test 'sql_command_kills_db.SF-
# 16:15:09 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=39774 -G
# 16:15:09 >
-MAPI = (monetdb) /var/tmp/mtest-17596/.s.monetdb.37297
+MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = insert into t1 values ((select id from tables));
ERROR = !cardinality violation (40>1)
diff --git
a/sql/test/BugTracker-2009/Tests/ambiguous_order_by.SF-2827916.stable.err
b/sql/test/BugTracker-2009/Tests/ambiguous_order_by.SF-2827916.stable.err
--- a/sql/test/BugTracker-2009/Tests/ambiguous_order_by.SF-2827916.stable.err
+++ b/sql/test/BugTracker-2009/Tests/ambiguous_order_by.SF-2827916.stable.err
@@ -69,7 +69,7 @@ stderr of test 'ambiguous_order_by.SF-28
# 16:29:59 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=38559
# 16:29:59 >
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = select args.id, types.id from args, types order by id limit 10;
ERROR = !SELECT: identifier 'id' ambiguous
diff --git a/sql/test/BugTracker-2009/Tests/ambiguous_view.stable.err
b/sql/test/BugTracker-2009/Tests/ambiguous_view.stable.err
--- a/sql/test/BugTracker-2009/Tests/ambiguous_view.stable.err
+++ b/sql/test/BugTracker-2009/Tests/ambiguous_view.stable.err
@@ -79,7 +79,7 @@ stderr of test 'ambiguous_view` in direc
# 20:07:37 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=38269
# 20:07:37 >
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = CREATE VIEW eur_kg_test AS
SELECT t_base.*
, 'EUR' AS DT_CURR
@@ -87,10 +87,10 @@ QUERY = CREATE VIEW eur_kg_test AS
FROM t_base
;
ERROR = !CREATE VIEW: duplicate column name dt_uom
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = select * from eur_kg_test;
ERROR = !SELECT: no such table 'eur_kg_test'
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = drop view eur_kg_test;
ERROR = !DROP VIEW: unknown view 'eur_kg_test'
diff --git
a/sql/test/BugTracker-2009/Tests/assert_in_update.SF-2807336.stable.err
b/sql/test/BugTracker-2009/Tests/assert_in_update.SF-2807336.stable.err
--- a/sql/test/BugTracker-2009/Tests/assert_in_update.SF-2807336.stable.err
+++ b/sql/test/BugTracker-2009/Tests/assert_in_update.SF-2807336.stable.err
@@ -69,7 +69,7 @@ stderr of test 'assert_in_update.SF-2807
# 10:38:04 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=36216
# 10:38:04 >
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = update anbi set kvk = (select kvk from kvk,anbi where lower(naam)
= lower(bedrijfsnaam) and lower(plaats) = lower(vestigingsplaats));
ERROR = !SELECT: identifier 'kvk' ambiguous
diff --git
a/sql/test/BugTracker-2009/Tests/copy_into_error_off_by_one.SF-2833696.stable.err
b/sql/test/BugTracker-2009/Tests/copy_into_error_off_by_one.SF-2833696.stable.err
---
a/sql/test/BugTracker-2009/Tests/copy_into_error_off_by_one.SF-2833696.stable.err
+++
b/sql/test/BugTracker-2009/Tests/copy_into_error_off_by_one.SF-2833696.stable.err
@@ -69,7 +69,7 @@ stderr of test 'copy_into_error_off_by_o
# 14:07:47 > mclient -lsql -umonetdb -Pmonetdb --host=rig --port=37202
# 14:07:47 >
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = COPY 2 RECORDS INTO number FROM stdin USING DELIMITERS '\n';
1
bla
diff --git
a/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.err
b/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.err
--- a/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.err
+++ b/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.err
@@ -76,10 +76,10 @@ stderr of test 'copy_multiple_files.SF-2
# 08:59:53 > mclient -lsql -i --host=alf --port=36694
# 08:59:53 >
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-10609/.s.monetdb.34310
QUERY = plan copy into cm_tmp from '\file1','\file2';
ERROR = !COPY INTO: filename must have absolute path: \file1
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-10609/.s.monetdb.34310
QUERY = plan copy into cm_tmp from 'a:\file1','Z:/file2';
ERROR = !COPY INTO: filename must have absolute path: a:\file1
diff --git
a/sql/test/BugTracker-2009/Tests/create_on_ro_db_crash.SF-2830238.stable.err
b/sql/test/BugTracker-2009/Tests/create_on_ro_db_crash.SF-2830238.stable.err
--- a/sql/test/BugTracker-2009/Tests/create_on_ro_db_crash.SF-2830238.stable.err
+++ b/sql/test/BugTracker-2009/Tests/create_on_ro_db_crash.SF-2830238.stable.err
@@ -5,7 +5,7 @@ stderr of test 'create_on_ro_db_crash.SF
# 21:37:20 > /usr/bin/python create_on_ro_db_crash.SF-2830238.py
create_on_ro_db_crash.SF-2830238
# 21:37:20 >
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = create table t2 (a int);
ERROR = !schema statements cannot be executed on a readonly database.
# builtin opt gdk_dbname = demo
diff --git
a/sql/test/BugTracker-2009/Tests/create_table_dup_name.SF-2879005.stable.err
b/sql/test/BugTracker-2009/Tests/create_table_dup_name.SF-2879005.stable.err
--- a/sql/test/BugTracker-2009/Tests/create_table_dup_name.SF-2879005.stable.err
+++ b/sql/test/BugTracker-2009/Tests/create_table_dup_name.SF-2879005.stable.err
@@ -76,7 +76,7 @@ stderr of test 'create_table_dup_name.SF
# 19:39:54 > mclient -lsql -i --host=alf --port=32337
# 19:39:54 >
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = CREATE TABLE ab AS SELECT * FROM a,b WITH DATA;
ERROR = !CREATE TABLE: duplicate column name name
diff --git
a/sql/test/BugTracker-2009/Tests/drop-sequence-crash.SF-2854195.stable.err
b/sql/test/BugTracker-2009/Tests/drop-sequence-crash.SF-2854195.stable.err
--- a/sql/test/BugTracker-2009/Tests/drop-sequence-crash.SF-2854195.stable.err
+++ b/sql/test/BugTracker-2009/Tests/drop-sequence-crash.SF-2854195.stable.err
@@ -73,7 +73,7 @@ stderr of test 'drop-sequence-crash.SF-2
# 14:55:13 > mclient -lsql -ftest -i -e --host=volund --port=33166
# 14:55:13 >
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = DROP SEQUENCE "seq_2184";
ERROR = !DROP SEQUENCE: no such sequence 'seq_2184'
diff --git
a/sql/test/BugTracker-2009/Tests/except_error_wrong.SF-2808409.stable.err
b/sql/test/BugTracker-2009/Tests/except_error_wrong.SF-2808409.stable.err
--- a/sql/test/BugTracker-2009/Tests/except_error_wrong.SF-2808409.stable.err
+++ b/sql/test/BugTracker-2009/Tests/except_error_wrong.SF-2808409.stable.err
@@ -69,7 +69,7 @@ stderr of test 'except_error_wrong.SF-28
# 17:04:37 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=34789
# 17:04:37 >
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = select naam, vestigingsplaats from anbi except select naam,
vestigingsplaats, beschikking from anbi, kvk where lower(naam) =
lower(bedrijfsnaam) and lower(plaats) = lower(vestigingsplaats);
ERROR = !EXCEPT: column counts (2 and 3) do not match
diff --git
a/sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.err
b/sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.err
--- a/sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.err
+++ b/sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.err
@@ -71,7 +71,7 @@ stderr of test 'explain_gives_crash.SF-2
# 22:45:54 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=35519
# 22:45:54 >
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = alter table blabla drop constraint dada;
ERROR = !ALTER TABLE: no such constraint 'dada'
diff --git a/sql/test/BugTracker-2009/Tests/incomplete.SF.2536893.stable.err
b/sql/test/BugTracker-2009/Tests/incomplete.SF.2536893.stable.err
--- a/sql/test/BugTracker-2009/Tests/incomplete.SF.2536893.stable.err
+++ b/sql/test/BugTracker-2009/Tests/incomplete.SF.2536893.stable.err
@@ -80,7 +80,7 @@ stderr of test 'incomplete.SF.2536893` i
# 19:21:49 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=31729
# 19:21:49 >
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = select a.b;
ERROR = !SELECT: no such column 'a.b'
diff --git
a/sql/test/BugTracker-2009/Tests/insert_into_values_bug.SF-2807609.stable.err
b/sql/test/BugTracker-2009/Tests/insert_into_values_bug.SF-2807609.stable.err
---
a/sql/test/BugTracker-2009/Tests/insert_into_values_bug.SF-2807609.stable.err
+++
b/sql/test/BugTracker-2009/Tests/insert_into_values_bug.SF-2807609.stable.err
@@ -69,10 +69,10 @@ stderr of test 'insert_into_values_bug.S
# 22:02:16 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=34561
# 22:02:16 >
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = insert into test (a) values (select 2);
ERROR = !syntax error, unexpected SELECT in: "insert into test (a) values
(select"
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = insert into test (a,b) values (select 2, 2);
ERROR = !syntax error, unexpected SELECT in: "insert into test (a,b) values
(select"
diff --git
a/sql/test/BugTracker-2009/Tests/limit_in_subquery.SF-2620437.stable.err
b/sql/test/BugTracker-2009/Tests/limit_in_subquery.SF-2620437.stable.err
--- a/sql/test/BugTracker-2009/Tests/limit_in_subquery.SF-2620437.stable.err
+++ b/sql/test/BugTracker-2009/Tests/limit_in_subquery.SF-2620437.stable.err
@@ -80,7 +80,7 @@ stderr of test 'limit_in_subquery.SF-262
# 20:35:13 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=32640
# 20:35:13 >
-MAPI = (monetdb) /var/tmp/mtest-5003/.s.monetdb.36177
+MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = select id from tables where id not in (select id from columns limit
10);
ERROR = !syntax error, unexpected LIMIT, expecting ')' or ',' in: "select id
from tables where id not in (select id from columns limit"
diff --git
a/sql/test/BugTracker-2009/Tests/not_invalidtable_crash.SF-2927174.stable.err
b/sql/test/BugTracker-2009/Tests/not_invalidtable_crash.SF-2927174.stable.err
---
a/sql/test/BugTracker-2009/Tests/not_invalidtable_crash.SF-2927174.stable.err
+++
b/sql/test/BugTracker-2009/Tests/not_invalidtable_crash.SF-2927174.stable.err
@@ -76,7 +76,7 @@ stderr of test 'not_invalidtable_crash.S
# 21:39:47 > mclient -lsql -i --host=alf --port=38367
# 21:39:47 >
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
