calcite
calcite copied to clipboard
apache
Apache Calcite
This feature is mainly about expanding ProjectJoinRemoveRule to support inner join remove by the foreign-unique constraint in the catalog. The main steps are as follows: 1. Analyse the column used...
Exploring what would have to change in ReltoSqlConverterTest in order to simplify SqlImplementor->Context->orderField. Current findings Tests that seem to be caused by bugs - testConvertWindowToSql Put in fix for egregious...
We can get constraints by RelOptTable#getReferentialConstraints method, but maybe can't get appropriate constraints at top relNode. Foreign keys metadata is very useful in many optimize scenes. Such as it can...
# What is the purpose of the change https://issues.apache.org/jira/browse/CALCITE-5840 The SqlFunctions#soundexMySQL rewrite the mysql's c++ soundex implementation. pls see: https://github.com/mysql/mysql-server/blob/ea1efa9822d81044b726aab20c857d5e1b7e046a/sql/item_strfunc.cc#L2054 # Brief change log Add a new mysql soundex implementation...
Updates the SnowflakeSQLDialect to fix the unparse implementation for SQL Literals. In Snowflake the qualifier is not a keyword and is instead included as part of the string literal that...
Sorting is an expensive operation, however. Therefore, it is imperative that sorting is optimized to avoid unnecessary sort field. Add SortRemoveRedundantRule, it removes redundant sort fields if they are functionally...