Changeset: 1300bef5365c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/1300bef5365c
Modified Files:
sql/test/information-schema/Tests/columns.test
Branch: Dec2023
Log Message:
Extend columns.test with query that produced an error on an older version of
the information_schema.columns view (ref GH 7496)
diffs (16 lines):
diff --git a/sql/test/information-schema/Tests/columns.test
b/sql/test/information-schema/Tests/columns.test
--- a/sql/test/information-schema/Tests/columns.test
+++ b/sql/test/information-schema/Tests/columns.test
@@ -375,6 +375,12 @@ SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_
WHERE (IS_GENERATED) NOT IN ('NO', 'YES')
----
+query TTTI rowsort
+SELECT TABLE_NAME, COLUMN_NAME, "is_generated", length("is_generated") as
data_length
+ FROM "information_schema"."columns"
+ WHERE "is_generated" IS NOT NULL AND length("is_generated") > 2
+----
+
-- check IS_UPDATABLE allowed values
query TTTT rowsort
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, IS_UPDATABLE
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
