Google Git
Sign in
apache / calcite / d7b3c83e06e4a63e5cb97c6f93b66795556d53db
commitd7b3c83e06e4a63e5cb97c6f93b66795556d53db[log] [tgz]
authorStamatis Zampetakis <zabetak@gmail.com>Thu Mar 11 11:38:52 2021 +0100
committerStamatis Zampetakis <zabetak@gmail.com>Thu Apr 29 15:31:59 2021 +0200
tree58218d8ef7d6ef4417dfe580d4a4a0d8ecaa6fab
parent8c2228eaf8ccc05ae58778276e760092557f78cc [diff]
[CALCITE-4560] Wrong plan when decorrelating EXISTS subquery with COALESCE in the predicate

1. Add plan transformations before starting the core RelDecorrelator logic
to bring the plan into an equivalent but more convenient form that can be
decorrelated into more efficient and correct plans.

2. Based on the changes above many plans with subqueries become more
efficient since the value generator is no longer necessary and it is dropped.

3. Add test cases in SqlToRelConverter, subquery.iq reproducing the
problem (bad plan/query results) and update existing tests based on the
changes.

Close apache/calcite#2406
11 files changed
tree: 58218d8ef7d6ef4417dfe580d4a4a0d8ecaa6fab
  1. .github/
  2. .idea/
  3. babel/
  4. bom/
  5. buildSrc/
  6. cassandra/
  7. core/
  8. druid/
  9. elasticsearch/
  10. example/
  11. file/
  12. geode/
  13. gradle/
  14. innodb/
  15. kafka/
  16. linq4j/
  17. mongodb/
  18. pig/
  19. piglet/
  20. plus/
  21. redis/
  22. release/
  23. server/
  24. site/
  25. spark/
  26. splunk/
  27. src/
  28. ubenchmark/
  29. .asf.yaml
  30. .editorconfig
  31. .gitattributes
  32. .gitignore
  33. .ratignore
  34. .travis.yml
  35. appveyor.yml
  36. build.gradle.kts
  37. gradle.properties
  38. gradlew
  39. gradlew.bat
  40. LICENSE
  41. NOTICE
  42. README
  43. README.md
  44. settings.gradle.kts
  45. sqlline
  46. sqlline.bat
  47. sqlsh
  48. sqlsh.bat
README.md

Maven Central Travis Build Status CI Status AppVeyor Build Status

Apache Calcite

Apache Calcite is a dynamic data management framework.

It contains many of the pieces that comprise a typical database management system but omits the storage primitives. It provides an industry standard SQL parser and validator, a customisable optimizer with pluggable rules and cost functions, logical and physical algebraic operators, various transformation algorithms from SQL to algebra (and the opposite), and many adapters for executing SQL queries over Cassandra, Druid, Elasticsearch, MongoDB, Kafka, and others, with minimal configuration.

For more details, see the home page.