commit | 5b8ce9c477dcf6ea4848b14982a11bd2e6ebe556 | [log] [tgz] |
---|---|---|
author | NobiGo <nobigogle@gmail.com> | Sat Sep 25 23:05:54 2021 +0800 |
committer | Julian Hyde <jhyde@apache.org> | Thu Sep 30 14:24:34 2021 -0500 |
tree | b15b3a73847a15509eedff6ef151500ab4b5f830 | |
parent | d6a2d69d33c466f7cb7d164f3db4e54771d31371 [diff] |
[CALCITE-4805] Calcite should convert a small IN-list as if the user had written OR, even if the IN-list contains NULL Since [CALCITE-373], Calcite has converted "x IN (1, 2)" to "x = 1 OR x = 2" but it still converts "x IN (1, NULL)" to "x IN (VALUES 1, NULL)". Now that some bugs have been fixed, there's no longer any reason to treat lists with NULL any differently. Close apache/calcite#2545
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.