Changeset: 1b576e306467 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/1b576e306467
Modified Files:
sql/test/odbc-escape-sequences/Tests/literals.test
sql/test/odbc-escape-sequences/Tests/time-date-interval-functions.test
Branch: Jun2023
Log Message:
On power8 platform on testweb the SQL parser gives different error message.
diffs (44 lines):
diff --git a/sql/test/odbc-escape-sequences/Tests/literals.test
b/sql/test/odbc-escape-sequences/Tests/literals.test
--- a/sql/test/odbc-escape-sequences/Tests/literals.test
+++ b/sql/test/odbc-escape-sequences/Tests/literals.test
@@ -103,15 +103,15 @@ 6:45:04
6:45:04
# also test invalid interval qualifiers
-statement error 42000!syntax error in: "select {interval '7' week"
+statement error 42000!syntax error...
select {interval '7' week}
-statement error 42000!syntax error in: "select {interval '8' quarter"
+statement error 42000!syntax error...
select {interval '8' quarter}
-statement error 42000!syntax error in: "select {interval '9' decade"
+statement error 42000!syntax error...
select {interval '9' decade}
-statement error 42000!syntax error in: "select {interval '1' century"
+statement error 42000!syntax error...
select {interval '1' century}
diff --git
a/sql/test/odbc-escape-sequences/Tests/time-date-interval-functions.test
b/sql/test/odbc-escape-sequences/Tests/time-date-interval-functions.test
--- a/sql/test/odbc-escape-sequences/Tests/time-date-interval-functions.test
+++ b/sql/test/odbc-escape-sequences/Tests/time-date-interval-functions.test
@@ -31,7 +31,7 @@ select { fn CURRENT_TIME() } >= {t'00:00
1
# test CURRENT_TIME( time-precision )
-statement error 42000!syntax error in: "select { fn current_time(6"
+statement error 42000!syntax error...
select { fn current_time(6) } >= {t'00:00:00.000000001'}
# ----
# 1
@@ -57,7 +57,7 @@ select { fn CURRENT_TIMESTAMP() } > {ts'
1
# test CURRENT_TIMESTAMP( timestamp-precision )
-statement error 42000!syntax error in: "select { fn current_timestamp(9"
+statement error 42000!syntax error...
select { fn current_timestamp(9) } >= {ts'2002-01-02 00:00:00.000000001'}
# ----
# 1
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
