MonetDB: Aug2024 - don't push down order by's on constants. Fixe...

[Niels Nes via checkin-list]

Changeset: 29577ef0a13f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/29577ef0a13f
Modified Files:
        sql/server/rel_optimize_others.c
Branch: Aug2024
Log Message:

don't push down order by's on constants. Fixes bug #7542


diffs (12 lines):

diff --git a/sql/server/rel_optimize_others.c b/sql/server/rel_optimize_others.c
--- a/sql/server/rel_optimize_others.c
+++ b/sql/server/rel_optimize_others.c
@@ -1381,6 +1381,8 @@ rel_push_topn_and_sample_down_(visitor *
                                if (pe)
                                        pe = rel_find_exp(l, pe);
                                if (pe) {
+                                       if (exp_is_atom(pe))
+                                               return rel;
                                        pe = exp_ref(v->sql, pe);
                                        if (asc)
                                                set_ascending(pe);
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org