Changeset: 2de28b09b51d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2de28b09b51d
Modified Files:
sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-distinct-coalesce.Bug-6431.stable.err
sql/test/BugTracker-2017/Tests/sqllitelogistest_case.Bug-6335.stable.err
sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.stable.err
sql/test/BugTracker-2017/Tests/udf_crash_subquery_scalar_paramters.Bug-6399.stable.err
sql/test/pg_regress/Tests/strings.stable.err
sql/test/pg_regress/Tests/strings.stable.err.int128
Branch: default
Log Message:
Added some missing CODE = SQLSTATE in stable.err outputs
diffs (78 lines):
diff --git
a/sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-distinct-coalesce.Bug-6431.stable.err
b/sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-distinct-coalesce.Bug-6431.stable.err
---
a/sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-distinct-coalesce.Bug-6431.stable.err
+++
b/sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-distinct-coalesce.Bug-6431.stable.err
@@ -30,6 +30,7 @@ stderr of test 'sqlitelogictest-aggregat
MAPI = (monetdb) /var/tmp/mtest-26937/.s.monetdb.35713
QUERY = SELECT DISTINCT + ( - col2 ) AS col0 FROM tab2 AS cor0 WHERE NOT ( - 1
* col2 ) <> ( 37 ) GROUP BY col2 HAVING ( col2 ) IN ( COALESCE ( + ( + COALESCE
( - 64, COUNT ( * ) + ( col0 ) * 12 ) ), + COUNT ( * ), COUNT ( * ) / 97 ) );
ERROR = !SELECT: no such aggregate 'sql_add'
+CODE = 42000
# 12:05:34 >
# 12:05:34 > "Done."
diff --git
a/sql/test/BugTracker-2017/Tests/sqllitelogistest_case.Bug-6335.stable.err
b/sql/test/BugTracker-2017/Tests/sqllitelogistest_case.Bug-6335.stable.err
--- a/sql/test/BugTracker-2017/Tests/sqllitelogistest_case.Bug-6335.stable.err
+++ b/sql/test/BugTracker-2017/Tests/sqllitelogistest_case.Bug-6335.stable.err
@@ -34,6 +34,7 @@ QUERY = SELECT DISTINCT 8 * + + CASE + N
+ 40 THEN NULL END * 7 THEN NULL WHEN - 8 THEN SUM ( + 62 ) * 44 WHEN
- ( - ( + ( 6 ) ) ) THEN + 91 + + 38 ELSE NULL END
END, + 57 ) WHEN - CAST ( NULL AS INTEGER ) THEN ( 46 ) ELSE NULL END
* - 77;
ERROR = !overflow in conversion of -616 to bte.
+CODE = 22003
# 19:21:49 >
# 19:21:49 > "Done."
diff --git
a/sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.stable.err
b/sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.stable.err
--- a/sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.stable.err
+++ b/sql/test/BugTracker-2017/Tests/table_returning_with.Bug-6444.stable.err
@@ -36,9 +36,11 @@ QUERY = CREATE TABLE results_table AS (
SELECT * FROM test_function(test_table_tmp.x, test_table_tmp.y,
test_table_tmp.z)
);
ERROR = !SELECT: no such column 'test_table_tmp.x'
+CODE = 42S22
MAPI = (monetdb) /var/tmp/mtest-83731/.s.monetdb.39208
QUERY = SELECT * FROM results_table;
ERROR = !current transaction is aborted (please ROLLBACK)
+CODE = 25005
# 15:36:01 >
# 15:36:01 > "Done."
diff --git
a/sql/test/BugTracker-2017/Tests/udf_crash_subquery_scalar_paramters.Bug-6399.stable.err
b/sql/test/BugTracker-2017/Tests/udf_crash_subquery_scalar_paramters.Bug-6399.stable.err
---
a/sql/test/BugTracker-2017/Tests/udf_crash_subquery_scalar_paramters.Bug-6399.stable.err
+++
b/sql/test/BugTracker-2017/Tests/udf_crash_subquery_scalar_paramters.Bug-6399.stable.err
@@ -34,12 +34,15 @@ stderr of test 'udf_crash_subquery_scala
MAPI = (monetdb) /var/tmp/mtest-41450/.s.monetdb.30991
QUERY = select * from crash2((select idx from data), 2);
ERROR = !SELECT: 'crash2' requires a single sub query
+CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-41450/.s.monetdb.30991
QUERY = select * from crash2(1, (select idx from data));
ERROR = !SELECT: 'crash2' requires a single sub query
+CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-41450/.s.monetdb.30991
QUERY = select * from crash3((select idx from data), 2, 3);
ERROR = !SELECT: 'crash3' requires a single sub query
+CODE = 42000
# 18:08:38 >
# 18:08:38 > "Done."
diff --git a/sql/test/pg_regress/Tests/strings.stable.err
b/sql/test/pg_regress/Tests/strings.stable.err
--- a/sql/test/pg_regress/Tests/strings.stable.err
+++ b/sql/test/pg_regress/Tests/strings.stable.err
@@ -92,6 +92,7 @@ CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = select split_part('joeuser@mydatabase','@',0) AS "an error";
ERROR = !field position must be greater than zero
+CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-27483/.s.monetdb.35395
QUERY = select to_hex(256*256*256 - 1) AS "ffffff";
ERROR = !SELECT: no such unary operator 'to_hex(int)'
diff --git a/sql/test/pg_regress/Tests/strings.stable.err.int128
b/sql/test/pg_regress/Tests/strings.stable.err.int128
--- a/sql/test/pg_regress/Tests/strings.stable.err.int128
+++ b/sql/test/pg_regress/Tests/strings.stable.err.int128
@@ -92,6 +92,7 @@ CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = select split_part('joeuser@mydatabase','@',0) AS "an error";
ERROR = !field position must be greater than zero
+CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-1493/.s.monetdb.37430
QUERY = select to_hex(256*256*256 - 1) AS "ffffff";
ERROR = !SELECT: no such unary operator 'to_hex(int)'
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
