tree 6b83dce7752107af49bbd3acc281893df703b293
parent 3030acb653b41a52c97a842043e36739f1677554
author Dmitry Lychagin <dmitry.lychagin@couchbase.com> 1639618157 -0800
committer Dmitry Lychagin <dmitry.lychagin@couchbase.com> 1639694737 +0000

[ASTERIXDB-3000] Incorrect result in SQL-compat mode

- user model changes: no
- storage format changes: no
- interface changes: no

Details:
- Fix incorrect subquery coercion rewriting in SQL-compat
  mode if the subquery has an ORDER BY clause
- Add tests

Change-Id: Ia852f20864c2098221011dee4f2c738a52dc8368
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/14543
Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Reviewed-by: Dmitry Lychagin <dmitry.lychagin@couchbase.com>
Reviewed-by: Ali Alsuliman <ali.al.solaiman@gmail.com>