Changeset: 530433da0280 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=530433da0280
Modified Files:
sql/test/ADT2006/Tests/sander.stable.err
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/BugDay_2005-10-06_2.8/Tests/double_commit.SF-916584.stable.err
sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.err
sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.out
sql/test/BugDay_2005-10-06_2.9.3/Tests/div_by_zero.SF-987304.stable.err
sql/test/BugDay_2005-10-06_2.9.3/Tests/having.SF-922614.stable.err
sql/test/BugDay_2005-10-06_2.9.3/Tests/inserts_with_defaults.SF-921977.stable.err
sql/test/BugDay_2005-10-06_2.9.3/Tests/view_on_deleted_table.SF-938583.stable.err
sql/test/BugDay_2005-11-09_2.8/Tests/overflow_checking.SF-1089334.stable.err
sql/test/BugDay_2005-11-09_2.8/Tests/updating_views.SF-1023645.stable.err
sql/test/BugDay_2005-11-09_2.9.3/Tests/hang_on_copy_into.SF-1100504.stable.err
sql/test/BugDay_2005-11-09_2.9.3/Tests/having_clause_quirks.SF-947601.stable.err
sql/test/BugDay_2005-11-09_2.9.3/Tests/integer_overflow.SF-1048671.stable.err
sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.err
sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.out
sql/test/BugDay_2005-12-19_2.9.3/Tests/bogus_prepare.SF-1377079.stable.err
sql/test/BugDay_2005-12-19_2.9.3/Tests/prepare-where.SF-1238867.1238959.1238965.1240124.stable.err
sql/test/BugDay_2005-12-19_2.9.3/Tests/subselect_cardinality.SF-1240701.1242164.stable.err
sql/test/BugTracker-2008/Tests/alter_add_constraint_should_check_existing_data.SF-2075241.stable.err
sql/test/BugTracker-2008/Tests/copy-format.SF-2468513.stable.err
sql/test/BugTracker-2008/Tests/count_with_order_by_and_limit_crashes.SF-2229936.stable.err
sql/test/BugTracker-2008/Tests/insert_into_unique_column.SF-2075180.stable.err
sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err
sql/test/BugTracker-2008/Tests/string_length_not_checked.SF-2075078.stable.err
sql/test/BugTracker-2008/Tests/too_many_nested_operators.SF-2102167.stable.err
sql/test/BugTracker-2008/Tests/varchar.SF-2471371.stable.err
sql/test/BugTracker-2009/Tests/ambiguous_order_by.SF-2827916.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/drop-sequence-crash.SF-2854195.stable.err
sql/test/BugTracker-2009/Tests/except_error_wrong.SF-2808409.stable.err
sql/test/BugTracker-2009/Tests/except_error_wrong.SF-2808409.stable.out
sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.err
sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.out
sql/test/BugTracker-2009/Tests/overflow.SF-2853458.stable.err
sql/test/BugTracker-2009/Tests/primekeyconstraint.SF-2783425.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/subquery_returns_table_crash.SF-2513620.stable.err
sql/test/BugTracker-2009/Tests/use_order_column_first.SF-2686008.stable.err
sql/test/BugTracker-2009/Tests/wrong_error_message.SF-2637051.stable.err
sql/test/BugTracker-2010/Tests/ORDER_BY_over_UNION_EXCEPT_INTERSECT.Bug-2606.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/constants-optimizer.Bug-2317.stable.err
sql/test/BugTracker-2010/Tests/copy-into-too-long-string.Bug-2358.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/incomplete-utf8-sequence.Bug-2575.stable.err
sql/test/BugTracker-2010/Tests/new-readonly-db.Bug-2695.stable.err
sql/test/BugTracker-2010/Tests/second_function_existing_signature.Bug-2611.stable.err
sql/test/BugTracker-2010/Tests/select_star.Bug-2563.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-2011/Tests/UNIQUE_Constraint_reference.Bug-2835.stable.err
sql/test/BugTracker-2011/Tests/alter-table-set-read-only.bug-2906.stable.err
sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.err
sql/test/BugTracker-2011/Tests/multicolumn_constraints.Bug-2849.stable.err
sql/test/BugTracker-2012/Tests/create_function.Bug-3172.stable.err
sql/test/BugTracker-2012/Tests/foreign_key.Bug-3114.stable.err
sql/test/BugTracker-2012/Tests/interval_timestamp.Bug-3002.stable.err
sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.err.int128
sql/test/BugTracker-2012/Tests/nested-select-crash.Bug-3009.stable.err
sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err
sql/test/BugTracker-2012/Tests/simple_select.Bug-2988.stable.err
sql/test/BugTracker-2012/Tests/table_function_with_column_subselects.Bug-3172.stable.err
sql/test/BugTracker-2012/Tests/table_returning_func_returns_too_many_columns.Bug-3077.stable.err
sql/test/BugTracker-2012/Tests/timestamp_minus_date.Bug-2977.stable.err
sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.stable.err
sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.stable.out.int128
sql/test/BugTracker-2013/Tests/binary_copy_into.Bug-3345.stable.err
sql/test/BugTracker-2013/Tests/cannot_use_columns_after_groupby.Bug-3340.stable.err
sql/test/BugTracker-2013/Tests/duplicate_column_name.Bug-3349.stable.err
sql/test/BugTracker-2013/Tests/env_errors.Bug-3370.stable.err
sql/test/BugTracker-2013/Tests/env_errors.Bug-3370.stable.out
sql/test/BugTracker-2013/Tests/incorrect_subquery_delete.Bug-3315.stable.err
sql/test/BugTracker-2013/Tests/psm_functions_and_accessrights.Bug-3300.stable.err
sql/test/BugTracker-2013/Tests/timestamp.Bug-3401.stable.err
sql/test/BugTracker-2013/Tests/update_on_declared_table.Bug-3318.stable.err
sql/test/BugTracker-2014/Tests/current_timestamp.Bug-3427.stable.err
sql/test/BugTracker-2014/Tests/duplicate_primary_keys.Bug-3474.stable.err
sql/test/BugTracker-2014/Tests/in_incorrect_multi.Bug-3462.stable.err
sql/test/BugTracker-2014/Tests/integer-cast.Bug-3424.stable.err
sql/test/BugTracker-2014/Tests/nested_common_table_exp.Bug-3417.stable.err
sql/test/BugTracker-2014/Tests/non_groupby_column.Bug-3524.stable.err
sql/test/BugTracker-2014/Tests/order_by_incorrect_error.Bug-3630.stable.err
sql/test/BugTracker-2014/Tests/queueError.Bug-3604.stable.err
sql/test/BugTracker-2015/Tests/adddrop_unknown_table.Bug-3718.stable.err
sql/test/BugTracker-2015/Tests/backslash_predecing_separator.Bug-3775.stable.err
sql/test/BugTracker-2015/Tests/float-space-parse.Bug-3691.stable.err
sql/test/BugTracker-2015/Tests/inf-nan-handling.Bug-3696.stable.err
sql/test/BugTracker-2015/Tests/inf-nan-handling.Bug-3696.stable.out
sql/test/BugTracker-2015/Tests/insert_into_merge_table_crash.Bug-3703.stable.err
sql/test/BugTracker-2015/Tests/local-remotetable-crash.Bug-3754.stable.err
sql/test/BugTracker-2015/Tests/name_conflict.Bug-3650.stable.err
sql/test/BugTracker-2015/Tests/negative_oid_crash.Bug-3667.stable.err
sql/test/BugTracker-2015/Tests/readonly.Bug-3709.stable.err
sql/test/BugTracker-2015/Tests/ukey_check_unaligned.Bug-3669.stable.err
sql/test/BugTracker-2015/Tests/ukey_check_unaligned.Bug-3669.stable.out
sql/test/BugTracker-2016/Tests/RELEASE_SAVEPOINT_after_UPDATE_crash.Bug-4010.stable.err
sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.err
sql/test/BugTracker-2016/Tests/foreign_key.Bug-3938.stable.err
sql/test/BugTracker-2016/Tests/incorrect_column_name_in_OR_condition_of_LEFT-JOIN_crashes_mserver.Bug-3909.stable.err
sql/test/BugTracker-2016/Tests/invalidcolumns.Bug-3968.stable.err
sql/test/BugTracker-2016/Tests/isaUUID_function.Bug-3997.stable.err
sql/test/BugTracker-2016/Tests/stream_table_crash.Bug-3952.stable.err
sql/test/BugTracker-2016/Tests/timestamp_with_tz_fromstr.Bug-4019.stable.err
sql/test/BugTracker-2017/Tests/cast_boolean_to_string.Bug-6110.stable.err
sql/test/BugTracker-2017/Tests/crash_in_in_handling.Bug-6260.stable.err
sql/test/BugTracker-2017/Tests/drop_not_null_on_pkey.Bug-6189.stable.err
sql/test/BugTracker-2017/Tests/incorrect_error.Bug-6141.stable.err
sql/test/BugTracker-2017/Tests/lateral.Bug-6310.stable.err
sql/test/BugTracker-2017/Tests/oidx-on-strings.Bug-6202.stable.err
sql/test/BugTracker-2017/Tests/prepare.Bug-6133.stable.err
sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6219.stable.err
sql/test/BugTracker-2017/Tests/too-large-decimals.Bug-6192.stable.err
sql/test/BugTracker-2017/Tests/union_func_crash.Bug-6196.stable.err
sql/test/BugTracker-2017/Tests/unknown_col_in_order_by.Bug-3535.stable.err
sql/test/BugTracker/Tests/alter_table_add_fkey.SF-1737668.stable.err
sql/test/BugTracker/Tests/alter_table_set_not_null.SF-1997030.stable.err
sql/test/BugTracker/Tests/ambiguous_join.SF-1580565.stable.err
sql/test/BugTracker/Tests/auto_increment.SF-1834820.stable.err
sql/test/BugTracker/Tests/between_having_problem.SF-1959391.stable.err
sql/test/BugTracker/Tests/between_with_column.SF-1959410.stable.err
sql/test/BugTracker/Tests/coalesce_equal_coalesce.SF-1907905.stable.err
sql/test/BugTracker/Tests/copy_decimal.SF-1582957.stable.err
sql/test/BugTracker/Tests/copy_overflow_null_bug.SF-1842550.stable.err
sql/test/BugTracker/Tests/crash_on_fkey_update.SF-1703497.stable.err
sql/test/BugTracker/Tests/drop_system_tables.SF-1550768.stable.err
sql/test/BugTracker/Tests/groupby_orderby_nonselected.SF-1723863.stable.err
sql/test/BugTracker/Tests/insert_date.SF-1838785.stable.err
sql/test/BugTracker/Tests/insert_values.SF-1578838.stable.err
sql/test/BugTracker/Tests/multivalue_insert.SF-1509864.stable.err
sql/test/BugTracker/Tests/number_null_first_row.SF-1833286.stable.err
sql/test/BugTracker/Tests/reset_session_vars.SF-1505987.stable.err
sql/test/BugTracker/Tests/set_a_new_user_password.SF-1844050.stable.err
sql/test/BugTracker/Tests/set_operation_coersions.SF-1543216.stable.err
sql/test/BugTracker/Tests/string2int_conversion.SF-1356068.stable.err
sql/test/BugTracker/Tests/table_dependency_inside_union.SF-1884382.stable.err
sql/test/BugTracker/Tests/temporary_tables.SF-1715669.stable.err
sql/test/BugTracker/Tests/update_fkey_with_value_not_in_the_pkey.SF-1734143.stable.err
sql/test/BugTracker/Tests/update_pkey_bug.SF-1733712.stable.err
sql/test/BugTracker/Tests/variables.SF-1508160.stable.err
sql/test/BugTracker/Tests/view_creation_using_func.SF-1714814.stable.err
sql/test/LSST/Tests/dbQuery036.stable.err
sql/test/Tests/50ways.stable.err
sql/test/Tests/decimal.stable.err
sql/test/Tests/default.stable.err
sql/test/Tests/function_syntax.stable.err
sql/test/Tests/marcin2.stable.err
sql/test/Tests/marcin3.stable.err
sql/test/Tests/null.stable.err
sql/test/Tests/procedure_syntax.stable.err
sql/test/Tests/setoptimizer.stable.err
sql/test/Update_Delete_action/Tests/delete_restrict.stable.err
sql/test/Update_Delete_action/Tests/delete_set_default.stable.err
sql/test/Update_Delete_action/Tests/delete_set_null.stable.err
sql/test/Update_Delete_action/Tests/update_delete_set_null.stable.err
sql/test/Update_Delete_action/Tests/update_restrict.stable.err
sql/test/Update_Delete_action/Tests/update_set_default.stable.err
sql/test/Update_Delete_action/Tests/update_set_default_crash.stable.err
sql/test/Update_Delete_action/Tests/update_set_null.stable.err
Branch: malerrors
Log Message:
Temporary commit
diffs (truncated from 3369 to 300 lines):
diff --git a/sql/test/ADT2006/Tests/sander.stable.err
b/sql/test/ADT2006/Tests/sander.stable.err
--- a/sql/test/ADT2006/Tests/sander.stable.err
+++ b/sql/test/ADT2006/Tests/sander.stable.err
@@ -15,13 +15,13 @@ QUERY = insert into suspect (name, pictu
victim_name) values ("Dr. Thomas Neill Cream ",
"http://blabla/toolong";, "did commit murders, but by
poisoning", "");
-ERROR = !SELECT: identifier 'Dr. Thomas Neill Cream ' unknown
-MAPI = (monetdb) /var/tmp/mtest-27483/.s.monetdb.35395
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !SELECT: identifier 'Dr.
Thomas Neill Cream ' unknown
+MAPI = (monetdb) /var/tmp/mtest-5920/.s.monetdb.34392
QUERY = insert into suspect (name, picture_uri, notes,
victim_name) values ("Sander Borsboom", "lives
centuries later, so not much chance", "blah.jpg",
"noone (yet :D)");
-ERROR = !SELECT: identifier 'Sander Borsboom' unknown
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !SELECT: identifier 'Sander
Borsboom' unknown
# 11:28:19 >
# 11:28:19 > Done.
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
@@ -14,7 +14,8 @@ stderr of test 'add_constraint_1643522`
MAPI = monetdb@sofia:38972
QUERY = alter table t1 add constraint id_p primary key(id);
-ERROR = !CONSTRAINT PRIMARY KEY: key 'id_p' already exists
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !42000!CONSTRAINT PRIMARY
KEY: key 'id_p' already exists
+
# 12:55:04 >
# 12:55:04 > 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
@@ -14,10 +14,11 @@ stderr of test 'delete_primarykey_164384
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@sofia:39182
+ERROR = !SQLException:assert:SQLSTATE M0M29 !INSERT INTO: FOREIGN KEY
constraint 't2.t2_id_f_fkey' violated
+MAPI = (monetdb) /var/tmp/mtest-29803/.s.monetdb.33854
QUERY = delete from t1 where id = 1;
-ERROR = !DELETE: FOREIGN KEY constraint 't2.t2_id_f_fkey' violated
+ERROR = !SQLException:assert:SQLSTATE M0M29 !DELETE: FOREIGN KEY constraint
't2.t2_id_f_fkey' violated
+
# 12:55:04 >
# 12:55:04 > Done.
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
@@ -14,10 +14,11 @@ stderr of test 'drop_column_1643542` in
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@sofia:38972
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !42000!CONSTRAINT PRIMARY
KEY: key 'id_p' already exists
+MAPI = (monetdb) /var/tmp/mtest-29803/.s.monetdb.33854
QUERY = alter table t1 drop id;
-ERROR = !ALTER TABLE: cannot drop column 'id': there are database objects
which depend on it
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !2BM37!ALTER TABLE: cannot
drop column 'id': there are database objects which depend on it
+
# 12:57:28 >
# 12:57:28 > Done.
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
@@ -14,7 +14,8 @@ stderr of test 'update_primarykey_164337
MAPI = monetdb@sofia:39182
QUERY = update t1 set id = 0 where id =1;
-ERROR = !UPDATE: FOREIGN KEY constraint 't2.t2_id_f_fkey' violated
+ERROR = !SQLException:assert:SQLSTATE M0M29 !UPDATE: FOREIGN KEY constraint
't2.t2_id_f_fkey' violated
+
# 12:55:05 >
# 12:55:05 > Done.
diff --git
a/sql/test/BugDay_2005-10-06_2.8/Tests/double_commit.SF-916584.stable.err
b/sql/test/BugDay_2005-10-06_2.8/Tests/double_commit.SF-916584.stable.err
--- a/sql/test/BugDay_2005-10-06_2.8/Tests/double_commit.SF-916584.stable.err
+++ b/sql/test/BugDay_2005-10-06_2.8/Tests/double_commit.SF-916584.stable.err
@@ -12,7 +12,7 @@ stderr of test 'double_commit.SF-916584`
MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = COMMIT;
-ERROR = !COMMIT: not allowed in auto commit mode
+ERROR = !SQLException:sql.trans:2DM30!COMMIT: not allowed in auto commit mode
# 14:14:57 >
# 14:14:57 > Done.
diff --git
a/sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.err
b/sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.err
--- a/sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.err
+++ b/sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.err
@@ -81,10 +81,10 @@ stderr of test 'mixed_type.SF-917372` in
MAPI = (monetdb) /var/tmp/mtest-10022/.s.monetdb.31381
QUERY = select 'a'+1;
-ERROR = !daytime (a) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-10022/.s.monetdb.31381
+ERROR = !SQLException:daytime:SQLSTATE 22007 !Daytime (a) has incorrect format
+MAPI = (monetdb) /var/tmp/mtest-5920/.s.monetdb.34392
QUERY = select 1-'a';
-ERROR = !conversion of string 'a' to type bte failed.
+ERROR = !MALException:calc.bte:22018!conversion of string 'a' to type bte
failed.
# 19:21:06 >
# 19:21:06 > Done.
diff --git
a/sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.out
b/sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.out
--- a/sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.out
+++ b/sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.out
@@ -25,8 +25,8 @@ Ready.
# 11:50:16 >
#select true+1;
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
% tinyint # type
% 1 # length
[ 2 ]
diff --git
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/div_by_zero.SF-987304.stable.err
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/div_by_zero.SF-987304.stable.err
--- a/sql/test/BugDay_2005-10-06_2.9.3/Tests/div_by_zero.SF-987304.stable.err
+++ b/sql/test/BugDay_2005-10-06_2.9.3/Tests/div_by_zero.SF-987304.stable.err
@@ -81,10 +81,10 @@ stderr of test 'div_by_zero.SF-987304` i
MAPI = (monetdb) /var/tmp/mtest-27483/.s.monetdb.35395
QUERY = select 1/0;
-ERROR = !division by zero.
-MAPI = (monetdb) /var/tmp/mtest-27483/.s.monetdb.35395
+ERROR = !MALException:calc./:22012!division by zero.
+MAPI = (monetdb) /var/tmp/mtest-5920/.s.monetdb.34392
QUERY = select x/y from a;
-ERROR = !division by zero.
+ERROR = !MALException:batcalc./:22012!division by zero.
# 19:22:52 >
# 19:22:52 > Done.
diff --git a/sql/test/BugDay_2005-10-06_2.9.3/Tests/having.SF-922614.stable.err
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/having.SF-922614.stable.err
--- a/sql/test/BugDay_2005-10-06_2.9.3/Tests/having.SF-922614.stable.err
+++ b/sql/test/BugDay_2005-10-06_2.9.3/Tests/having.SF-922614.stable.err
@@ -12,7 +12,7 @@ stderr of test 'having.SF-922614` in dir
MAPI = (monetdb) /var/tmp/mtest-27483/.s.monetdb.35395
QUERY = select * from t10 having i= max(i);
-ERROR = !SELECT: cannot use non GROUP BY column 'i' in query results without
an aggregate function
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !SELECT: cannot use non GROUP
BY column 'i' in query results without an aggregate function
# 16:54:28 >
# 16:54:28 > Done.
diff --git
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/inserts_with_defaults.SF-921977.stable.err
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/inserts_with_defaults.SF-921977.stable.err
---
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/inserts_with_defaults.SF-921977.stable.err
+++
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/inserts_with_defaults.SF-921977.stable.err
@@ -12,10 +12,10 @@ stderr of test 'inserts_with_defaults.SF
MAPI = (monetdb) /var/tmp/mtest-27483/.s.monetdb.35395
QUERY = INSERT INTO null_1 (id) VALUES(1);
-ERROR = !INSERT INTO: NOT NULL constraint violated for column null_1.text1
-MAPI = (monetdb) /var/tmp/mtest-27483/.s.monetdb.35395
+ERROR = !SQLException:assert:SQLSTATE M0M29 !INSERT INTO: NOT NULL constraint
violated for column null_1.text1
+MAPI = (monetdb) /var/tmp/mtest-5920/.s.monetdb.34392
QUERY = INSERT INTO null_1 (text1) VALUES('test');
-ERROR = !INSERT INTO: NOT NULL constraint violated for column null_1.id
+ERROR = !SQLException:assert:SQLSTATE M0M29 !INSERT INTO: NOT NULL constraint
violated for column null_1.id
# 14:29:04 >
# 14:29:04 > Done.
diff --git
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/view_on_deleted_table.SF-938583.stable.err
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/view_on_deleted_table.SF-938583.stable.err
---
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/view_on_deleted_table.SF-938583.stable.err
+++
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/view_on_deleted_table.SF-938583.stable.err
@@ -32,7 +32,7 @@ stderr of test 'view_on_deleted_table.SF
MAPI = (monetdb) /var/tmp/mtest-27483/.s.monetdb.35395
QUERY = drop table t_vdt;
-ERROR = !DROP TABLE: unable to drop table t_vdt (there are database objects
which depend on it)
+ERROR = !SQLSTATE 42000 !DROP TABLE: unable to drop table t_vdt (there are
database objects which depend on it)
# 15:38:06 >
# 15:38:06 > Done.
diff --git
a/sql/test/BugDay_2005-11-09_2.8/Tests/overflow_checking.SF-1089334.stable.err
b/sql/test/BugDay_2005-11-09_2.8/Tests/overflow_checking.SF-1089334.stable.err
---
a/sql/test/BugDay_2005-11-09_2.8/Tests/overflow_checking.SF-1089334.stable.err
+++
b/sql/test/BugDay_2005-11-09_2.8/Tests/overflow_checking.SF-1089334.stable.err
@@ -14,7 +14,7 @@ MAPI = monetdb@sofia:39182
QUERY = INSERT INTO rawtriples VALUES(1001, 1,
'100168990', 2, 'glossaryEntry', 0, '',
-5342185907394955428, NULL, 'adorning with mosaic', true);
-ERROR = !too many digits (19 > 10)
+ERROR = !SQLException:lng_2_lng:SQLSTATE 22003 !Too many digits (19 > 10)
# 13:12:25 >
# 13:12:25 > Done.
diff --git
a/sql/test/BugDay_2005-11-09_2.8/Tests/updating_views.SF-1023645.stable.err
b/sql/test/BugDay_2005-11-09_2.8/Tests/updating_views.SF-1023645.stable.err
--- a/sql/test/BugDay_2005-11-09_2.8/Tests/updating_views.SF-1023645.stable.err
+++ b/sql/test/BugDay_2005-11-09_2.8/Tests/updating_views.SF-1023645.stable.err
@@ -12,7 +12,7 @@ stderr of test 'updating_views.SF-102364
MAPI = monetdb@sofia:39182
QUERY = insert into v1023645 values (1);
-ERROR = !INSERT INTO: cannot insert into view 'v1023645'
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !INSERT INTO: cannot insert
into view 'v1023645'
# 10:01:13 >
diff --git
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/hang_on_copy_into.SF-1100504.stable.err
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/hang_on_copy_into.SF-1100504.stable.err
---
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/hang_on_copy_into.SF-1100504.stable.err
+++
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/hang_on_copy_into.SF-1100504.stable.err
@@ -88,7 +88,7 @@ QUERY = COPY 1 RECORDS INTO "news" FROM
allemaal nogal lang duurt, maar in principe is het nog
maar een uurtje of 6 werk om het goed te krijgen. Zoals
je kan zien heb ik bij de voicemails al wat leuke
-ERROR = !Failed to import table 'news', incomplete record at end of file
+ERROR = !SQLException:importTable:SQLSTATE 42000 !Failed to import table
'news', incomplete record at end of file
# 23:26:36 >
# 23:26:36 > Done.
diff --git
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/having_clause_quirks.SF-947601.stable.err
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/having_clause_quirks.SF-947601.stable.err
---
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/having_clause_quirks.SF-947601.stable.err
+++
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/having_clause_quirks.SF-947601.stable.err
@@ -12,7 +12,7 @@ stderr of test 'having_clause_quirks.SF-
MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = select name from t947601 having 1=1;
-ERROR = !SELECT: cannot use non GROUP BY column 'name' in query results
without an aggregate function
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !SELECT: cannot use non GROUP
BY column 'name' in query results without an aggregate function
# 11:57:00 >
# 11:57:00 > Done.
diff --git
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/integer_overflow.SF-1048671.stable.err
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/integer_overflow.SF-1048671.stable.err
---
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/integer_overflow.SF-1048671.stable.err
+++
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/integer_overflow.SF-1048671.stable.err
@@ -81,7 +81,7 @@ stderr of test 'integer_overflow.SF-1048
MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = insert into test1048671 values (9876543210);
-ERROR = !overflow in conversion of 9876543210 to int.
+ERROR = !MALException:calc.int:22003!overflow in conversion of 9876543210 to
int.
# 19:27:23 >
# 19:27:23 > Done.
diff --git
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.err
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.err
---
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.err
+++
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.err
@@ -12,7 +12,7 @@ stderr of test 'interval_on_time_stamp.S
MAPI = (monetdb) /var/tmp/mtest-23209/.s.monetdb.33225
QUERY = select interval '2:74' hour to minute;
-ERROR = !Overflow detected in minutes (74)
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !Overflow detected in minutes
(74)
# 19:58:14 >
# 19:58:14 > Done.
diff --git
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.out
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.out
---
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.out
+++
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.out
@@ -24,50 +24,50 @@ Ready.
# 11:50:55 >
#select date '1997-07-31' + interval '1' month;
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
% date # type
% 10 # length
[ 1997-08-31 ]
#select date '1997-10-31' + interval '1' month;
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
% date # type
% 10 # length
[ 1997-12-01 ]
#select timestamp '1997-07-15 19:00:00' + interval '9' hour;
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
% timestamp # type
% 26 # length
[ 1997-07-16 04:00:00.000000 ]
#select time '19:00:00' + interval '9' hour;
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
% time # type
% 15 # length
[ 04:00:00.000000 ]
#select date '1997-07-31' + interval '1' hour;
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
% date # type
% 10 # length
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
