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 -- [email protected]
To unsubscribe send an email to [email protected]
