commit | 8581f0a3fe9a4f079cb4d36f02121ae22118714c | [log] [tgz] |
---|---|---|
author | Julian Hyde <jhyde@apache.org> | Wed Mar 31 13:37:04 2021 -0700 |
committer | Julian Hyde <jhyde@apache.org> | Fri Apr 02 18:45:11 2021 -0700 |
tree | 9b713e012eb7953f0a7f7b3e9c7b78675356f769 | |
parent | f30f407654e150679ede6e8d8d4344e6dc26b346 [diff] |
[CALCITE-4562] Improve simplification of "x IS TRUE" and "x LIKE '%'" Simplify "x LIKE '%'" to "x IS NOT NULL" in an unknown-as-false context, such as a WHERE clause. Simplify "x IS TRUE" to "x" if "x" is already NOT NULL; similarly "IS FALSE", "IS NOT TRUE", "IS NOT FALSE".
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.