Changeset: de4028931ba3 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/de4028931ba3
Added Files:
sql/test/BugTracker-2023/Tests/greatest-least-multi-arg-7391.test
Modified Files:
sql/test/BugTracker-2023/Tests/All
Branch: Dec2023
Log Message:
Add tests for request 7391
diffs (72 lines):
diff --git a/sql/test/BugTracker-2023/Tests/All
b/sql/test/BugTracker-2023/Tests/All
--- a/sql/test/BugTracker-2023/Tests/All
+++ b/sql/test/BugTracker-2023/Tests/All
@@ -10,6 +10,7 @@ rollback-alter-drop-col-crash-7385
view-on-alias-crash-7386
alter-inc-seq-crash-7387
misc-crashes-7390
+greatest-least-multi-arg-7391
union-query-7401
join-on-row_number-over-7403
between-crash-7413
diff --git a/sql/test/BugTracker-2023/Tests/greatest-least-multi-arg-7391.test
b/sql/test/BugTracker-2023/Tests/greatest-least-multi-arg-7391.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2023/Tests/greatest-least-multi-arg-7391.test
@@ -0,0 +1,56 @@
+query I
+SELECT greatest(3, 4, 2, 1);
+----
+4
+
+query I
+SELECT least(3, 4, 2, 1);
+----
+1
+
+query I
+SELECT greatest(3, 4, '0', '5');
+----
+5
+
+query I
+SELECT least(3, 4, 1, 2, '0', '5');
+----
+0
+
+query R
+SELECT greatest(3.321, 4.4321, '0.210', '5.54321', -6.54321);
+----
+5.543
+
+query R
+SELECT least(3.321, 4.4321, '0.210', '5.54321', -6.54321);
+----
+-6.543
+
+statement error conversion of string 'A' to type bte failed.
+SELECT greatest(3, 4, '0', '5', 'A', 'z');
+
+statement error conversion of string 'A' to type bte failed.
+SELECT least(3, 4, 1, 2, '0', '5', 'A', 'z');
+
+query T
+SELECT greatest('!', 3, 4, '0', '5', 'A', 'z');
+----
+z
+
+query T
+SELECT least('!', 3, 4, 1, 2, '0', '5', 'A', 'z');
+----
+!
+
+query T
+SELECT greatest('!', 'z3', 'z4', 'z0', 'z5', 'A', 'z');
+----
+z5
+
+query T
+SELECT least('!z3', '!z4', '!0', '!5', 'A', 'z');
+----
+!0
+
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
