MonetDB: Jan2022 - make sure values lists are compared order aware

[Niels Nes]

Changeset: df71ef7420eb for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/df71ef7420eb
Added Files:
        sql/test/BugTracker-2022/Tests/values.Bug-7336.test
Modified Files:
        sql/server/rel_exp.c
        sql/test/BugTracker-2022/Tests/All
Branch: Jan2022
Log Message:

make sure values lists are compared order aware


diffs (37 lines):

diff --git a/sql/server/rel_exp.c b/sql/server/rel_exp.c
--- a/sql/server/rel_exp.c
+++ b/sql/server/rel_exp.c
@@ -1376,7 +1376,7 @@ exp_match_exp( sql_exp *e1, sql_exp *e2)
                case e_atom:
                        if (e1->l && e2->l && !atom_cmp(e1->l, e2->l))
                                return 1;
-                       if (e1->f && e2->f && exp_match_list(e1->f, e2->f))
+                       if (e1->f && e2->f && exps_equal(e1->f, e2->f))
                                return 1;
                        if (e1->r && e2->r && e1->flag == e2->flag && 
!subtype_cmp(&e1->tpe, &e2->tpe)) {
                                sql_var_name *v1 = (sql_var_name*) e1->r, *v2 = 
(sql_var_name*) e2->r;
diff --git a/sql/test/BugTracker-2022/Tests/All 
b/sql/test/BugTracker-2022/Tests/All
--- a/sql/test/BugTracker-2022/Tests/All
+++ b/sql/test/BugTracker-2022/Tests/All
@@ -8,3 +8,4 @@ pkey-restart.Bug-7263
 delete-update.Bug-7267
 having-clauses.Bug-7278
 temp-table-create-index-drop-issue
+values.Bug-7336
diff --git a/sql/test/BugTracker-2022/Tests/values.Bug-7336.test 
b/sql/test/BugTracker-2022/Tests/values.Bug-7336.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2022/Tests/values.Bug-7336.test
@@ -0,0 +1,12 @@
+query IIR nosort
+select a,b,c
+from (values (10, 20, 0.5), 
+             (20, 10, 0.5)
+) as (a,b,c)
+----
+10
+20
+0.500
+20
+10
+0.500
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org