Changeset: d34df121728b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/d34df121728b
Modified Files:
sql/test/pg_regress/Tests/strings.test
Branch: reducedstack
Log Message:
approved output (inline with postgres giving result on null input (no cast
error))
diffs (24 lines):
diff --git a/sql/test/pg_regress/Tests/strings.test
b/sql/test/pg_regress/Tests/strings.test
--- a/sql/test/pg_regress/Tests/strings.test
+++ b/sql/test/pg_regress/Tests/strings.test
@@ -183,14 +183,18 @@ SELECT SUBSTRING('abcdefg' FROM 'a#"(b_d
statement error
SELECT SUBSTRING('abcdefg' FROM '#"(b_d)#"%' FOR '#') IS NULL AS "True"
-statement error
+query I
SELECT SUBSTRING('abcdefg' FROM '(b|c)' FOR NULL) IS NULL AS "True"
+----
+1
statement error
SELECT SUBSTRING(NULL FROM '(b|c)' FOR '#') IS NULL AS "True"
-statement error
+query I
SELECT SUBSTRING('abcdefg' FROM NULL FOR '#') IS NULL AS "True"
+----
+1
statement error
SELECT SUBSTRING('abcdefg' FROM 'c.e') AS "cde"
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
