Changeset: d629075ad985 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/d629075ad985
Added Files:
sql/test/BugTracker-2024/Tests/greatest-as-colname-7444.test
Modified Files:
sql/test/BugTracker-2024/Tests/All
Branch: Dec2023
Log Message:
Add test for GH issue 7444.
diffs (62 lines):
diff --git a/sql/test/BugTracker-2024/Tests/All
b/sql/test/BugTracker-2024/Tests/All
--- a/sql/test/BugTracker-2024/Tests/All
+++ b/sql/test/BugTracker-2024/Tests/All
@@ -5,3 +5,4 @@ where-case-null-issue-7429
create-index-query-issue-7430
alloc-overflow-7432
gc-col-crash-7440
+greatest-as-colname-7444
diff --git a/sql/test/BugTracker-2024/Tests/greatest-as-colname-7444.test
b/sql/test/BugTracker-2024/Tests/greatest-as-colname-7444.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2024/Tests/greatest-as-colname-7444.test
@@ -0,0 +1,49 @@
+statement error 42000!syntax error, unexpected GREATEST, expecting FOREIGN or
PRIMARY or UNIQUE in: "create table t7444a(greatest"
+create table t7444a(greatest int)
+
+statement error 42000!syntax error, unexpected FROM, expecting '(' in: "select
greatest from"
+select greatest from t7444a
+
+statement ok
+create table t7444b("greatest" int)
+
+query I
+select "greatest" from t7444b
+----
+
+-- check if GREATEST or greatest is a (reserved) keyword
+query T
+select keyword from sys.keywords where keyword ilike 'GREATEST'
+----
+
+statement ok
+drop table if exists t7444a
+
+statement ok
+drop table if exists t7444b
+
+
+-- also check it for: least
+statement error 42000!syntax error, unexpected LEAST, expecting FOREIGN or
PRIMARY or UNIQUE in: "create table t7444c(least"
+create table t7444c(least int)
+
+statement error 42000!syntax error, unexpected FROM, expecting '(' in: "select
least from"
+select least from t7444c
+
+statement ok
+create table t7444d("least" int)
+
+query I
+select "least" from t7444d
+----
+
+-- check if LEAST or least is a (reserved) keyword
+query T
+select keyword from sys.keywords where keyword ilike 'LEAST'
+----
+
+statement ok
+drop table if exists t7444c
+
+statement ok
+drop table if exists t7444d
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
