[NO ISSUE][COMP] No subquery coercion in EXISTS clause
authorDmitry Lychagin <dmitry.lychagin@couchbase.com>
Fri, 19 Nov 2021 22:30:16 +0000 (14:30 -0800)
committerDmitry Lychagin <dmitry.lychagin@couchbase.com>
Mon, 22 Nov 2021 16:40:29 +0000 (16:40 +0000)
commit6dc0f84985fde15017d14b316db2ce2c590c3e15
tree85ae3e486cc6197d7c0fee643e13f177e7f7c9a3
parent7cdb65de50192b1fc551de9e25b08cc46f030982
[NO ISSUE][COMP] No subquery coercion in EXISTS clause

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

Details:
- In SQL-compat mode do not perform subquery coecrion
  if the subquery is in EXISTS or NOT EXISTS clause
- Add testscases

Change-Id: If4ae567fc449e5fa6bb040555325f429e8953256
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/14145
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>
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/sql-compat/subquery_coercion_08_misc/subquery_coercion_08_misc.1.query.sqlpp [moved from asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/sql-compat/subquery_coercion_07_from/subquery_coercion_07_from.4.query.sqlpp with 96% similarity]
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/sql-compat/subquery_coercion_08_misc/subquery_coercion_08_misc.2.query.sqlpp [new file with mode: 0644]
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/sql-compat/subquery_coercion_08_misc/subquery_coercion_08_misc.3.query.sqlpp [new file with mode: 0644]
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/sql-compat/subquery_coercion_08_misc/subquery_coercion_08_misc.4.query.sqlpp [new file with mode: 0644]
asterixdb/asterix-app/src/test/resources/runtimets/results/sql-compat/subquery_coercion_08_misc/subquery_coercion_08_misc.1.adm [moved from asterixdb/asterix-app/src/test/resources/runtimets/results/sql-compat/subquery_coercion_07_from/subquery_coercion_07_from.4.adm with 100% similarity]
asterixdb/asterix-app/src/test/resources/runtimets/results/sql-compat/subquery_coercion_08_misc/subquery_coercion_08_misc.2.adm [new file with mode: 0644]
asterixdb/asterix-app/src/test/resources/runtimets/results/sql-compat/subquery_coercion_08_misc/subquery_coercion_08_misc.3.adm [new file with mode: 0644]
asterixdb/asterix-app/src/test/resources/runtimets/results/sql-compat/subquery_coercion_08_misc/subquery_coercion_08_misc.4.adm [new file with mode: 0644]
asterixdb/asterix-app/src/test/resources/runtimets/testsuite_sqlpp.xml
asterixdb/asterix-lang-sqlpp/src/main/java/org/apache/asterix/lang/sqlpp/rewrites/visitor/SqlCompatRewriteVisitor.java