This is an automated email from the ASF dual-hosted git repository.
github-actions[bot] pushed a change to branch site
in repository https://gitbox.apache.org/repos/asf/calcite.git
discard 45687effd8 [CALCITE-7561] Upgrade OWASP plugin from 6.1.6 to 12.2.2
discard 765dc70959 Document how PMC members add JIRA users to project roles
discard 8c75d8640e Bump nokogiri from 1.19.1 to 1.19.3 in /site
discard 8a542321ee Site: Update Ruben QL info
discard d5a5325c80 [CALCITE-7481] Support jdk24 in CI
discard d95a5a7e65 [CALCITE-7020] Upgrade gradle from 8.7 to 8.14.4
discard 8fa8bcd21a Bump addressable from 2.8.7 to 2.9.0 in /site
discard e78cf4c215 Site: Add Zhen Chen as PMC
discard 700ea9328c [CALCITE-7424] In Lint, support sort specifications
discard 9d556f67d1 Typo in index page
discard 6c0c476a5a Bump nokogiri from 1.18.9 to 1.19.1 in /site
discard 9d9da66964 [CALCITE-7410] TIMESTAMP type for TUMBLE and HOP is
hardwired to TIMESTAMP(3)
discard 0b4f4c2513 [CALCITE-7393] Support RelDataTypeDigest
discard 6c21b4da78 Site: Add Weihua Zhang as committer
discard 4cdf6794ef [CALCITE-7301] Add common test for SqlNode unparse after
deep copy and missing createCall in operators
discard 4a18e19f1e Site: Add Thomas Rebele as committer
discard 80c7aaa1ee [CALCITE-6942] Support decorrelated for sub-queries with
LIMIT 1 and OFFSET
discard dd5f723ff8 Change current PMC chair
discard 089fb4749e Add Feldera to 'powered by Calcite' page
discard 0c3a4a9cba Site: Change the Position of Yu Xu for Committer message
discard 61c2704cd7 Site: Add Yu Xu as committer
discard 7bda05fcda Site: Add Silun Dong as committer
discard e72312a559 Correct several misspellings
discard ff8e6e1599 Fix typos in some files
discard 1376885daa Site: Add announce 1.41.0 release
discard 789d2460f3 [CALCITE-7223] Release Calcite 1.41.0
add c838dd471c [CALCITE-7223] Release Calcite 1.41.0
add 63633ac9fb Site: Add announce 1.41.0 release
add 67e5bfcdc0 Prepare for next development iteration
add 8b5c17e51e [CALCITE-7258] RelBuilder.filter should throw if the
condition is not BOOLEAN
add 42ff295d6e [CALCITE-5223] AdjustProjectForCountAggregateRule throws
ArrayIndexOutOfBoundsException
add 82cdcc78db [CALCITE-7251] SEARCH and WINDOW operations should carry
source position information
add 18a8aed7a2 [CALCITE-7268] SqlToRelConverter throws exception if lambda
contains IN
add c18c045aab [CALCITE-7273] CoreRules.JOIN_REDUCE_EXPRESSIONS throws
when applied to an ASOF JOIN
add 253ed4639f [CALCITE-7261] `DiffRepository` generation xml does not
respect alphabetical order
add 14ad949490 Fix typos in some files
add eee63b24d1 [CALCITE-7276] SqlToRelConverter throws exception for
UPDATE if identifier expansion disabled
add 61a989ac47 [CALCITE-7256] Make the fields of SqlTableRef public
add 0f148c7256 [CALCITE-7266] Optimize the "well-known count bug"
correction
add 96c1b1f171 [CALCITE-7281] Deprecate NullPolicy.ANY in favor of
NullPolicy.SEMI_STRICT
add e8ac01cb89 [CALCITE-7290] Update json-path to 2.10.0
add 8412793191 [CALCITE-7291] Verify that the same exception is thrown for
the original and simplified expression in RexSimplify#verify
add 89da1b3a77 [CALCITE-7293] MAP constructor cannot handle VARIANT values
that need casts
add 7bebc878de [CALCITE-7292] Replace "case when true then deptno else
null end" with a non-simplifiable expression
add 05ea8e41ec [CALCITE-4947] Checkstyle fails on classes generated by
Intellij when using option "build and run [tests] using Intellij IDEA"
add 31a23f3809 [CALCITE-4947] Checkstyle fails on classes generated by
Intellij when using option "build and run [tests] using Intellij IDEA"
add 43e0d7581f [CALCITE-7145] RexSimplify should not simplify IS NULL(10/0)
add eb0534dac4 [CALCITE-6176] JOIN_SUB_QUERY_TO_CORRELATE rule incorrectly
handles EXISTS in LEFT JOIN ON clause
add 85a52797d8 Replace `replace` with `toLinux`
add 7e118bb05e [CALCITE-7265] Allow RelOptFixture.relFn to be used with
VolcanoPlanner
add 51965cfbcb [CALCITE-7295] RexSimplify should simplify a division with
a NULL argument
add 49fa3edbb9 [CALCITE-7287] In simplifyLike, the makeLiteral call does
not preserve the RelDataType
add 37a3ecc2c0 [CALCITE-5465] Rule of AGGREGATE_EXPAND_DISTINCT_AGGREGATES
produces an incorrect plan when sql has distinct agg-call with rollup
add a096c8fd32 [CALCITE-6963] SqlToRelConverter fails when subquery is in
join on clause
add 14d62816ff Add tests for [CALCITE-6985] to verify
AggregateMinMaxToLimitRule handles empty tables correctly
add 860ec68813 [CALCITE-7302] Infinite loop with
JoinPushTransitivePredicatesRule
add 3488a78e7c [CALCITE-7289] Select NULL subquery throwing exception
add abd7ca2594 [CALCITE-6681] NullPointerException in
ProjectCorrelateTransposeRule
add df3de965ac [CALCITE-7296] RexSimplify should not simplify IS
NULL(CAST(10/0 AS BIGINT))
add 04eececf8d [CALCITE-7087] SQLite does not support RIGHT/FULL JOIN
until version 3.39.0
add 18c9824191 [CALCITE-7309] Position is unparsed incorrectly for
ClickHouseSqlDialect
add e7472d454f [CALCITE-7312] Alias is not auto generated for LATERAL TABLE
add 541bae86cc Carry source position information through more code rewrites
add f2df771d86 [CALCITE-7207] Semi Join RelNode cannot be translated into
correct MySQL SQL
add 8f2d350670 [CALCITE-7305] Subqueries in ASOF JOIN MATCH_CONDITION
cause an assertion failure
add 3c85e06d90 [CALCITE-4525] Pull up predicate will lose some predicates
when project contains same RexInputRef
add f89d8862e1 [CALCITE-7303] Subqueries cannot be decorrelated if filter
condition have multi CorrelationId
add 32692447e8 [CALCITE-7254] Add rule for sharing trivially equivalent
RelNodes within Combine
add 935d676425 [CALCITE-7310] Support the syntax SELECT * EXCLUDE(columns)
add 02bfbee0dd [CALCITE-7317] SubQueryRemoveRule should skip NULL-safety
checks for IN subqueries when both the keys and the subquery columns are NOT
NULL
add 800e84d852 [CALCITE-7319] FILTER_INTO_JOIN rule loses correlation
variable context in HepPlanner
add 3b416debe7 [CALCITE-7297] The result is incorrect when the GROUP BY
key in a subquery is a RexFieldAccess
add aca1ed91e7 [CALCITE-7326] FILTER_CORRELATE rule loses correlation
variable context in HepPlanner
add e5682547cb [CALCITE-7319] FILTER_INTO_JOIN rule loses correlation
variable context in HepPlanner
add 6300c7964c [CALCITE-7321] FilesTableFunction throws
NumberFormatException on macOS with GNU stat installed
add 081e442020 [CALCITE-7325] Incorrect VARIANT signatures in
SqlItemOperator
add ca7be004f1 [CALCITE-7332] SELECT * EXCLUDE list should error when it
excludes all columns
add 585cbda527 [CALCITE-7330] AggregateCaseToFilterRule should not be
applied on aggregate functions that don't skip NULL inputs
add 8954e08912 Correct several misspellings
add 5cfe2a5e29 [CALCITE-7031] Implement the general decorrelation
algorithm (Neumann & Kemper)
add 20fae9a1b1 [CALCITE-7322] The POSITION function in MySQL is missing
the FROM clause
add b2b136dcd0 Site: Add Silun Dong as committer
add d00fe52b5f Site: Add Yu Xu as committer
add f19e854c39 Site: Change the Position of Yu Xu for Committer message
add 55aec64a33 [CALCITE-5347] Add 'SELECT ... BY', a syntax extension that
is shorthand for GROUP BY and ORDER BY
add 90c82303c7 [CALCITE-7323] Result of cast Number to Boolean is not
correct
add 19ef7f0b47 [CALCITE-7327] Support IS NOT DISTINCT FROM as equi
condition of hash join
add b12a9cefb6 [CALCITE-7335] RelToSqlConverter generate sql containing
Scala subqueries includes redundant parentheses
add dd1cd8693e [CALCITE-2152] SQL parser unable to parse SQL with nested
joins produced by RelToSqlConverter
add 1a4b00b77a [CALCITE-7311] Support the syntax ROW(*) to create a nested
ROW type with all columns
add 1d9f3823fc Add Feldera to 'powered by Calcite' page
add 28ace851e0 Minor optimizations to the document
add 25b043397a [CALCITE-7307] A new added dependency conflicts with Java
9+ and JPMS
add f26c333d6c Change current PMC chair
add 6db44aa583 [CALCITE-3128] Joining two tables producing only NULLs will
return 0 rows
add e4b2baa8b4 [CALCITE-7338] Window hints are not propagated to window
rel nodes
add 5c6456d1f7 [CALCITE-2274] Filter predicates aren't inferred while
using dynamic star in subquery
add 3eac1f7d56 [CALCITE-7272] Subqueries cannot be decorrelated if have
set op
add ae42f777f0 [CALCITE-4813] ANY_VALUE assumes that arguments should be
comparable
add 1e92bbe799 [CALCITE-6942] Support decorrelated for sub-queries with
LIMIT 1 and OFFSET
add fabf648bb7 [CALCITE-7339] Most classes in SqlDdlNodes use an incorrect
SqlCallFactory
add fcb86f0753 [CALCITE-7257] Subqueries cannot be decorrelated if join
condition contains RexFieldAccess
add 02c176a556 [CALCITE-7345] Quidem test support for Field Trimmer
add b9e9e9d958 [CALCITE-7342] Quidem test support for
TopDownGeneralDecorrelator
add c274aacdfd [CALCITE-7346] Prevent overflow in metadata row-count when
LIMIT/OFFSET literal exceeds Long range
add 6ba1b536a6 [CALCITE-7274] RexFieldAccess has wrong index when use trim
unused fields
add 74bbf474d6 Move ExpandDisjunctionForJoinInputsRule test from
planner.iq to hep.iq
add 3d143325fd [CALCITE-7349] Upgrade the types of FETCH and OFFSET in
SORT to BigDecimal
add 92cfb30175 [CALCITE-5733] Simplify "a = ARRAY[1,2] AND a = ARRAY[2,3]"
to "false"
add 6e86c227ed [CALCITE-7350] Missing allowEmptyOutputFromRewrite
parameter in TopDownGeneralDecorrelator.unnestInternal
add fe73166a17 [CALCITE-7352] Incorrect SqlLibrary enum value used in
ClickHouse SQL test
add 533a61520b Site: Add Thomas Rebele as committer
add 17f2f973df [CALCITE-6066] Add HYPOT function (enabled in Spark library)
add 45e41e8db6 [CALCITE-7348] Remove redundant extraction correlation
variables when Trim Project Fields
add 951c02de62 [CALCITE-7337] Add age function (enabled in PostgreSQL
library)
add 63a9f477b0 [CALCITE-7351] Make getMaxNumericScale() and
getMaxNumericPrecision() final
add 799433a1df [CALCITE-5093] Quantified comparison operators (e.g. ANY)
should support ARRAY arguments
add 1204f4231a [CALCITE-7355] RelToSqlConverter throws exception when the
join condition contains a correlated subquery
add ab6a397c91 [CALCITE-7301] Add common test for SqlNode unparse after
deep copy and missing createCall in operators
add c0d5a08328 [CALCITE-7336] RelFieldTrimmer generates an incorrect plan
when handling correlated sub-query within Filter or Join condition
add c3d49bd4f8 [CALCITE-7357] Introduce the implementation of rex operator
IS DISTINCT FROM
add 2a6ce48a97 [CALCITE-7196] Create an optimization pass which can
convert some cases of Correlate + Unnest to Unnest
add c8387a6e7d [CALCITE-7363] Improve error message for ASOF JOIN
add 506950a3eb [CALCITE-7358] Casts involving MAP and ROW types cause
compile-time exceptions
add 6423188a5a [CALCITE-7366] RexLiteral.valueMatchesType throws for a MAP
type
add e1732c4cc4 [CALCITE-7367] NULLS FIRST throws ClassCastException when
sorting arrays
add 05399a86be [CALCITE-6829] MSSQL dialect incorrectly translates of
SELECT TRUE
add 1efc2bdd77 [CALCITE-7365] RelMdRowCount ignores estimateRowCount()
overrides in SingleRel's subclasses
add cb359a82bb Update copyright NOTICE year to 2026
add 77d561fe5e [CALCITE-7315] Support LEFT_MARK type for hash join in
enumerable convention
add 4ae896d4a5 [CALCITE-7369] ProjectToWindowRule loses column alias when
optimizing OVER window queries
add 0eaadfad91 Opened some iq files in CoreQuidemTest2
add 9f575b39a0 [CALCITE-7370] Trailing dot is not removed when normalizing
timestamp strings
add 43e7fbf0ee [CALCITE-5597] SELECT DISTINCT query with ORDER BY column
will get error result
add 3e8a082445 [CALCITE-7372] TopDownGeneralDecorrelator will throw an
error when the JOIN condition has correlation
add 6548b0e6f7 [CALCITE-7375] ProjectWindowTransposeRule does not
correctly adjust column indices in window bounds
add fd72200178 [CALCITE-7377] Validator should reject a DESCRIPTOR in a
table function when it is not an identifier
add 5e309f24c4 [CALCITE-7331] Support the alias form SELECT * EXCEPT() for
SELECT * EXCLUDE()
add 17af1848df [CALCITE-7374] NULLS LAST throws ClassCastException when
sorting arrays
add 583e73f1a3 [CALCITE-7373] FILTER_INTO_JOIN should not push Filter into
a join when the Filter contains non-deterministic function
add 79de3a64bf [CALCITE-7359] Incorrect result for array comparison with
ANY operator
add 05347685da [CALCITE-7381] Parameters modified by !set must be restored
to their default values in Quidem test
add d0c72d1965 [CALCITE-5787] The RelMdInputFieldsUsed is introduced to
track the usage of input fields
add 6de626697a [CALCITE-7378] Potential incorrect column attribution in
RelToSqlConverter due to implicit table alias handling
add ae47b72804 [CALCITE-7356] The MARK JOIN generated by
TopDownGeneralDecorrelator needs to be adapted to RelFieldTrimmer
add 270ba649cf [CALCITE-7382] The TopDownGeneralDecorrelator returns an
error result when a subquery contains a LIMIT 1
add f6271b79c2 Make SqlValidatorImpl#maybeCast protected to allow using it
by child classes
add 3dc7feae24 [CALCITE-5740] Support for AggToSemiJoinRule
add 84e35bafd4 [CALCITE-7389] PruneJoinSingleValue rule causes type
mismatch in EXISTS
add 7c9a58c3a7 [CALCITE-7279] ClickHouse dialect should wrap nested JOINs
with explicit column aliases
add ea08b43db6 [CALCITE-7391] FILTER_REDUCE_EXPRESSIONS crashes on
expression where 123 in (SELECT NULL FROM emps)
add 507ee67f03 Opened misc and scalar iq files in CoreQuidemTest2
add 6fab1a1b64 [CALCITE-7388] Redis Adapter operand config should not
support empty string
add f451b2af9c [CALCITE-7379] LHS correlated variables are shadowed by
nullable RHS outputs in LEFT JOIN
add f33c6a23b8 Add debug log for query plan after decorrelation completion
add c251de4eca [CALCITE-7395] ProjectMergeRule incorrectly merges PROJECTs
with correlation variables
add 4bdd19a4c1 [CALCITE-7396] PruneEmptyRules does not support LEFT_MARK
JOIN
add 8a286c5076 [CALCITE-5578] RelOptRulesTest testAggregateCaseToFilter
optimized plan not semantically equivalent to the original one after conversion
add 41774e2b2f [CALCITE-7397] Error in simplifying join condition when
creating LEFT MARK JOIN
add b24f476127 [CALCITE-7320] AggregateProjectMergeRule throws
AssertionError when Project maps multiple grouping keys to the same field
add 88fe7d2c3f [CALCITE-7398] Incorrect int cast in VariantNonNull#cast
for BIGINT
add 5a3526cb4b [CALCITE-7385] Support LEFT_MARK type for nested loop join
in enumerable convention
add 47fdf61a02 [CALCITE-7394] Nested sub-query with multiple levels of
correlation returns incorrect results
add 077d355ec3 [CALCITE-7400] PruneJoinSingleValue rule causes type
mismatch in IN
add 4253102ac6 [CALCITE-5787] The RelMdInputFieldsUsed is introduced to
track the usage of input fields
add 15d79dbbbb [CALCITE-4765] Complex correlated EXISTS sub-queries used
as scalar subqueries can return wrong results
add 2029412cdc [CALCITE-7401] Multi-level correlated subqueries cause an
out-of-range error in the TopDownGeneralDecorrelator
add 96e318b6fa [CALCITE-7403] Missing ENUMERABLE Convention for
LogicalConditionalCorrelate
add 4e959ef261 Included the `some` iq files in CoreQuidemTest2
add bf0eae04cb [CALCITE-7402] Two-level nested correlated subquery causes
TopDownGeneralDecorrelator type mismatch during translation
add 383315bf50 [CALCITE-7406] Add abs function (enabled in Mongodb library)
add 5543694274 [CALCITE-7404] Incorrect Field Alias in MongoDB project
Stage
add 7be1fc59b4 [CALCITE-7409] MERGE JOIN condition cannot contain IS NOT
DISTINCT FROM
add 3b5fcf50d9 Test case for [CALCITE-6452] Scalar sub-query that uses IS
NOT DISTINCT FROM returns incorrect result
add 67ae43bfb2 Site: Add Weihua Zhang as committer
add 894136fad0 [CALCITE-7412] Redis test failed on higher versions of macOS
add 869fe15f36 [CALCITE-7411] When a SCALAR_QUERY in PROJECT contains
correlated variables execution fails using TopDownGeneralDecorrelator
add 8925773e9b [CALCITE-7408] URL_ENCODE/URL_DECODE is unparsed
incorrectly for ClickHouseSqlDialect
add 8ee4c00f3a [CALCITE-7057] NPE when decorrelating query containing
nested correlated subqueries
add 4c041cb95f [CALCITE-7414] Incorrect mapping of CorDef after
decorrelating a Join in TopDownGeneralDecorrelator
add 8e7e84cc92 Included the sub-query.iq in CoreQuidemTest2
add 4385bbb262 Included cases for [CALCITE-2359]
add dd34021fbc [CALCITE-7413] Add Concat and Substring function (enabled
in Mongodb library)
add df31d6f2e7 [CALCITE-7347] UNKNOWN type inferred for array element type
add 75d35f3b90 [CALCITE-7415] CalciteCatalogReader.lookupOperatorOverloads
keeps original function identifier casing instead of resolved schema-path casing
add a44373782f [CALCITE-7368] The validator accepts CAST(INT TO BINARY),
but the runtime does not implement them
add e810d8becb [CALCITE-7418] SqlOverlapsOperator does not reject some
illegal comparisons (e.g., TIME vs DATE)
add f181e079da [CALCITE-7416] Add firedRulesCache for HepPlanner
add 69a7a06025 [CALCITE-5390] RelDecorrelator throws NullPointerException
add a90b2da1ce [CALCITE-7393] Support RelDataTypeDigest
add e7e3925cf1 [CALCITE-7410] TIMESTAMP type for TUMBLE and HOP is
hardwired to TIMESTAMP(3)
add 6626bcc16e [CALCITE-5832] CyclicMetadataException thrown in complex
JOIN
add 87dcba9f0e [CALCITE-7386] An error occurred while using
TopDownGeneralDecorrelator to process the aggregate(col) filter
add 63f5a69a83 [CALCITE-7423] Setop subquery without correlated variables
triggers NullPointerException during decorrelation
add b907876715 Bump nokogiri from 1.18.9 to 1.19.1 in /site
add 245f2f8c2a Included cases for [CALCITE-6828]
add 47fea32286 Typo in index page
add 80e717ab2e [CALCITE-7424] In Lint, support sort specifications
add 7654dd8216 [CALCITE-7362] Add rule to transform WHERE clauses into
filtered aggregates
add 607126846b [CALCITE-7343] RelToSqlConverter generate wrong sql when
scalar correlated sub-query in Project
add d59c7f3493 [CALCITE-7427] Query with "ORDER BY NULL" throws
"NoSuchMethodException: compareNullsLast"
add 2f2ae4681f [CALCITE-7429] Query with MINUS fails with "Unable to
implement EnumerableMinus(all=[false])"
add af286b5493 [CALCITE-7425] Correct the logical inverse of
SqlBetweenOperator
add b04f744f7f [CALCITE-5132] Scalar IN subquery returns UNKNOWN instead
of FALSE when key is partially NULL
add 66c496a6a0 [CALCITE-7434] Error in new decorrelation algorithm caused
by FilterJoinRule omitting variablesSet
add 341e8d5490 [CALCITE-7392] Unable to implement EnumerableCollect for
SQL queries containing UNNEST
add 09a149942f [CALCITE-7386] An error occurred while using
TopDownGeneralDecorrelator to process the aggregate(col) filter
add c628e6876b [CALCITE-7433] Invalid unparse for cast to map type in Spark
add a56cecf09d [CALCITE-7417] Add a large plan benchmark for HepPlanner
add 18454caf1d [CALCITE-7435] WINDOW functions should allow ORDER BY
fields of type INTERVAL
add 8a873607a9 [CALCITE-7426] Add a PR submission template to Calcite
add 288d490f12 Test case for [CALCITE-3366] RelDecorrelator supports Union
add 5dffb84be1 Site: Add Zhen Chen as PMC
add af6367d61e [CALCITE-7441] AggregateFilterToFilteredAggregateRule fails
when WHERE condition is nullable
add 174a79b03e [CALCITE-7259] Drop commons-lang3 dependency
add bbd083fd6b [CALCITE-7432] NumberFormatException when convert `NaN`
literal to sql
add ea7fb17053 [CALCITE-7318] Execution fails when the JOIN ON condition
contains references to columns from both the left and right sides
add 7f99701eba [CALCITE-7447] RelRoot.project() adds Project for DDL nodes
add 05e410ff3e [CALCITE-7428] Support regexp function change regexp
operator for Hive library
add 93c792fb19 [CALCITE-7450] ValuesReduceRule incorrectly drops tuples
when filter condition is irreducible
add f1f9a2b1e3 [CALCITE-7422] Support large plan optimization mode for
HepPlanner
add 9350097148 [CALCITE-6646] Support timestamp data type in Arrow adapter
add f768501a91 [CALCITE-7450] Refactor ValuesReduceRuleTest inside
RelOptRulesTest (addendum)
add 2886ce17f6 [CALCITE-7316] The POSITION function in SQLite is missing
the FROM clause
add 28ddefd12d [CALCITE-7431] RelTraitSet#getTrait seems to mishandle
RelCompositeTrait
add 04a7832751 [CALCITE-7187] Java UDF byte arrays cannot be mapped to
VARBINARY
add ac81f758da [CALCITE-6300] Function MAP_VALUES/MAP_KEYS gives exception
when mapVauleType and mapKeyType not equals map Biggest mapKeytype or
mapValueType
add 1aacc43efd [CALCITE-6636] Support CNF condition of Arrow ArrowAdapter
add 8813b5784f [CALCITE-7458] Upgrade Jackson to 2.18.6 due to CVE
add 8cc86b38a0 [CALCITE-7456] Enable the TRY_CAST function to support the
MSSQL dialect
add a51df251a4 Add test cases for SetOpToFilterRule to verify that PROJECT
containing non-deterministic expressions and subqueries are not merged
add b52a6b262c [CALCITE-7461] Add @Strict to ByteArrayFunction and
ByteArrayLengthFunction
add cde0fe572c [CALCITE-6968] SqlUpdate#getOperandList omits sourceSelect
operand
add 3f541a68c7 Bump addressable from 2.8.7 to 2.9.0 in /site
add 99c8d5911d [CALCITE-4645] In Elasticsearch adapter, a range predicate
should be translated to a range query
add 5bf40d5dc6 [CALCITE-7466] Unparse of `MATCH_RECOGNIZE` produces
duplicate aliases
add 27a9d05fd7 [CALCITE-7470] Unparse of `DEFINE` in `MATCH_RECOGNIZE`
leads to incorrect SQL
add 37448dc565 [CALCITE-7467] `MATCH_RECOGNIZE` does not support aliases
for tableRef
add 0a39568b16 [CALCITE-4868] Elasticsearch adapter fails if GROUP BY is
followed by ORDER BY
add e5192ec21d [CALCITE-6298] Support UNION in Arrow adapter
add 9264745616 [CALCITE-7020] Upgrade gradle from 8.7 to 8.14.4
add 925f490bf8 [CALCITE-7471] Alias is not auto generated for
`MATCH_RECOGNIZE`
add dc77792fef [CALCITE-7468] The SPLIT_PART implementation is incorrect
for regex patterns
add 0ce0c5ae2f Test case for [CALCITE-5161] NPE when inserting a null
value into a decimal column
add 88b91847b3 Test case for [CALCITE-5124] LIMIT won't work when GROUP BY
two or more columns in Elasticsearch Adapter
add c46978659b [CALCITE-7442] Correlated variable has wrong index inside
subquery
add 7c0dfef966 [CALCITE-7443] Incorrect simplification for large interval
add 422952453a [CALCITE-7472] Arrow adapter should support LIKE operator
push down
add 8adab488e7 [CALCITE-7474] `LAST` in `MATCH_RECOGNIZE` might return
wrong result
add a27257eb06 [CALCITE-7480] Unparse of `MATCH_RECOGNIZE` with `PARTITION
BY` or `ORDER BY` produces invalid SQL
add c44ab8b4be [CALCITE-7481] Support jdk24 in CI
add 95eecd87cb [CALCITE-7473] Better IntelliJ and VSCode .gitignore
add 5be90f8cf5 [CALCITE-7477] Push schema pattern filter into sub-schema
map lookup to avoid loading all schemas
add 82e5ae7072 [CALCITE-7482] Wrong variablesSet used when rewriting
subquery in JOIN ON clause
add 8a7ee97f61 [CALCITE-7483] RelToSqlConverter generates SELECT * despite
supportGenerateSelectStar
add 02d8003f94 [CALCITE-6757] Elasticsearch adapter returns wrong result
when aggregating sub-query with aggregation
add 915c769d8b [CALCITE-7465] Make `MATCH_RECOGNIZE` tolerant to `FINAL`
and `RUNNING` non function `MEASURES`
add bda5286d5a [CALCITE-7486] Operators in `MATCH_RECOGNIZE` don't support
`SqlLiterals`
add 265059f552 Test cases for [CALCITE-6299] Support JOIN in Arrow adapter
add 0344850d54 [CALCITE-7479] Remove redundant aggregate group keys with FD
add 752d5b457f [CALCITE-7208] Allow downstream projects implement `CREATE
OR ALTER`
add 3505dba4cd [CALCITE-7484] Add a rule to eliminate redundant aggregates
functions over GROUP BY keys
add ad273f029b [CALCITE-7491] Literals of type TIMESTAMP WITH TIME ZONE
cause crashes
add b008df9a71 [CALCITE-7360] The meaning of negation for unsigned numbers
is not defined
add e00c69300e [CALCITE-7490] PruneEmptyRules is ineffective for window
statements
add fa951db4b9 [CALCITE-7497] Enable Lambda supports constant folding
add d7f64f7d46 [CALCITE-7437] Type coercion for quantifier operators is
incomplete
add 97fd524d17 [CALCITE-7498] The parser rejects the example hints from
the documentation
add e8e0dd5414 [CALCITE-7501] Assertion error in alias expansion for LEFT
JOIN USING
add b2e1ab3e46 [CALCITE-7499] `COALESCE` with args of different types
might be incorrectly simplified
add adb417483e [CALCITE-7502] RelToSqlConverter creates invalid sql when
converting nested window contains SqlCaseWhen
add cf4ffc1fdf [CALCITE-6291] Support converting ArrowTable to Queryable
add ad02464e87 Site: Update Ruben QL info
add 5e54cfb74a Bump nokogiri from 1.19.1 to 1.19.3 in /site
add 740a0bc4c2 [CALCITE-7506] RelWriterImpl does not output hints
add b4a9b28799 [CALCITE-7503] Hint validation does not have access to
source position
add c7c3f316b6 [CALCITE-7448] Add support for ':' variant path access
syntax
add fcb07463d0 [CALCITE-7485] FIRST_VALUE/LAST_VALUE should only be
defined for window aggregates
add 111030383c [CALCITE-7504] The Hypergraph code does not use lazy logging
add a83681020b [CALCITE-7507] NPE in ReleaseExtension.<init> when building
from sources
add c2cbd8912d Test cases for [CALCITE-4232] Elasticsearch IN Query is not
supported
add 85b042ca23 [CALCITE-7521] Upgrade Calcite to Avatica 1.28.0
add 03d333693e [CALCITE-7475] Babel parser allows postfix access after
PostgreSQL-style :: infix cast
add e0bc26c344 [CALCITE-7522] Allow EXTRACT(interval FROM tz) to operate
on TIMESTAMP WITH TIME ZONE
add 5b2a14494d [CALCITE-7524] JdbcSchema throws exception for DECIMAL
columns with precision 0 in JDBC metadata
add c4fd54c522 Document how PMC members add JIRA users to project roles
add 3774ade072 [CALCITE-7526] Incorrect TIMESTAMP WITH TIME ZONE produces
wrong error message
add f707ef4b7e [CALCITE-7527] SqlParserUtil.parseTimestampTzLiteral does
not validate timezone
add d6a551886c [CALCITE-7530] `FOR SYSTEM_TIME AS OF` on CTE causes NPE
while validation
add 89fb4ab4bd Addendum to [CALCITE-7475]: correction for unparse method
add 142bbe22bc [CALCITE-7523] Support the syntax SELECT * REPLACE(expr as
column)
add 2fe48c7cf2 Improve [CALCITE-7424] In Lint, support sort specifications
add 69774d0c93 [CALCITE-7457] VALUES and SELECT produce different
validation results for the same expression
add 118edc9e94 [CALCITE-4460] Support custom delimiter when parsing CSV
tables
add 32ef284f88 [CALCITE-7496] OS-adapter usability
add a8345ae8ea [CALCITE-7533] Parser rejects parenthesized query as the
body of a WITH clause
add 3816664396 [CALCITE-7531] Add to `BasicSqlType` constructor accepting
precision, scale and nullability
add b056e45696 [CALCITE-7537] Invalid Postgres SQL generated for
right-deep comma join trees
add c1d9f50bf6 [CALCITE-7085] JOIN USING with unqualified common column
fails in a conformance where allowQualifyingCommonColumn is false (e.g. Oracle,
Presto)
add 16c2b1c346 [CALCITE-7538] `SqlValidatorImpl` should reject
`MATCH_RECOGNIZE` with duplicate `MEASURE` alias
add 0d4c0a2b21 [CALCITE-7514] MultiJoinOptimizeBushyRule throws
AssertionError when a join condition references 3 or more factors
add 068c03dfcc [CALCITE-7492] Support expression that has a constant value
within the group involving only GROUP BY keys as aggregate arguments
add 5855cfa14d [CALCITE-7532] Model usability
add c1550dedec [CALCITE-7561] Upgrade OWASP plugin from 6.1.6 to 12.2.2
This update added new revisions after undoing existing revisions.
That is to say, some revisions that were in the old version of the
branch are not in the new version. This situation occurs
when a user --force pushes a change and generates a repository
containing something like this:
* -- * -- B -- O -- O -- O (45687effd8)
\
N -- N -- N refs/heads/site (c1550dedec)
You should already have received notification emails for all of the O
revisions, and so the following emails describe only the N revisions
from the common base, B.
Any revisions marked "omit" are not gone; other references still
refer to them. Any revisions marked "discard" are gone forever.
No new revisions were added by this update.
Summary of changes:
.github/pull_request_template.md | 43 +
.gitignore | 24 +-
.ratignore | 2 +-
NOTICE | 2 +-
arrow/build.gradle.kts | 1 -
.../adapter/arrow/AbstractArrowEnumerator.java | 45 +-
.../calcite/adapter/arrow/ArrowEnumerable.java | 12 +-
.../adapter/arrow/ArrowFieldTypeFactory.java | 21 +
.../apache/calcite/adapter/arrow/ArrowFilter.java | 2 +-
.../adapter/arrow/ArrowFilterEnumerator.java | 8 +-
.../adapter/arrow/ArrowProjectEnumerator.java | 6 +-
.../org/apache/calcite/adapter/arrow/ArrowRel.java | 15 +-
.../apache/calcite/adapter/arrow/ArrowRules.java | 8 +-
.../apache/calcite/adapter/arrow/ArrowSchema.java | 21 +-
.../apache/calcite/adapter/arrow/ArrowTable.java | 156 +-
.../adapter/arrow/ArrowToEnumerableConverter.java | 20 +-
.../calcite/adapter/arrow/ArrowTranslator.java | 90 +-
.../calcite/adapter/arrow/ConditionToken.java | 97 +
.../adapter/arrow/ArrowAdapterDataTypesTest.java | 96 +-
.../calcite/adapter/arrow/ArrowAdapterTest.java | 442 ++-
.../calcite/adapter/arrow/ArrowDataTest.java | 82 +
babel/src/main/codegen/config.fmpp | 4 +-
babel/src/main/codegen/includes/parserImpls.ftl | 23 +-
.../org/apache/calcite/test/BabelParserTest.java | 153 +-
.../org/apache/calcite/test/BabelQuidemTest.java | 3 +
.../java/org/apache/calcite/test/BabelTest.java | 362 +-
babel/src/test/resources/sql/big-query.iq | 52 +-
babel/src/test/resources/sql/postgresql.iq | 37 +-
babel/src/test/resources/sql/select.iq | 225 ++
babel/src/test/resources/sql/spark.iq | 17 +
bom/build.gradle.kts | 1 -
build.gradle.kts | 57 +
.../apache/calcite/test/CassandraExtension.java | 4 +-
core/build.gradle.kts | 1 -
core/src/main/codegen/default_config.fmpp | 1 +
core/src/main/codegen/templates/Parser.jj | 364 +-
.../calcite/adapter/enumerable/EnumUtils.java | 81 +-
.../adapter/enumerable/EnumerableCollect.java | 14 +-
.../adapter/enumerable/EnumerableCombine.java | 167 +
...leUnionRule.java => EnumerableCombineRule.java} | 25 +-
...te.java => EnumerableConditionalCorrelate.java} | 109 +-
...ava => EnumerableConditionalCorrelateRule.java} | 27 +-
.../adapter/enumerable/EnumerableHashJoin.java | 112 +-
.../adapter/enumerable/EnumerableIntersect.java | 4 -
.../adapter/enumerable/EnumerableMergeJoin.java | 10 +
.../enumerable/EnumerableMergeJoinRule.java | 13 +-
.../adapter/enumerable/EnumerableMergeUnion.java | 23 +-
.../enumerable/EnumerableMergeUnionRule.java | 4 +-
.../adapter/enumerable/EnumerableMinus.java | 4 -
.../enumerable/EnumerableNestedLoopJoin.java | 39 +
.../adapter/enumerable/EnumerableRules.java | 14 +
.../calcite/adapter/enumerable/MatchUtils.java | 19 +-
.../calcite/adapter/enumerable/NullPolicy.java | 4 +-
.../calcite/adapter/enumerable/PhysType.java | 9 +
.../calcite/adapter/enumerable/PhysTypeImpl.java | 58 +
.../calcite/adapter/enumerable/RexImpTable.java | 144 +-
.../adapter/enumerable/RexToLixTranslator.java | 39 +-
.../apache/calcite/adapter/jdbc/JdbcSchema.java | 9 +-
.../calcite/config/CalciteConnectionConfig.java | 3 +
.../config/CalciteConnectionConfigImpl.java | 5 +
.../calcite/config/CalciteConnectionProperty.java | 3 +
.../calcite/config/CalciteSystemProperty.java | 26 +
.../org/apache/calcite/jdbc/CalciteMetaImpl.java | 32 +-
.../org/apache/calcite/model/ClassNameFilter.java | 185 +
.../org/apache/calcite/model/ModelHandler.java | 43 +-
.../apache/calcite/plan/AbstractRelOptPlanner.java | 41 +-
.../java/org/apache/calcite/plan/RelOptRules.java | 1 +
.../java/org/apache/calcite/plan/RelOptUtil.java | 133 +-
.../java/org/apache/calcite/plan/RelTraitSet.java | 74 +-
.../org/apache/calcite/plan/SpoolRelOptTable.java | 145 +
.../main/java/org/apache/calcite/plan/Strong.java | 1 +
.../org/apache/calcite/plan/hep/HepPlanner.java | 318 +-
.../apache/calcite/plan/hep/HepVertexIterator.java | 92 +
.../calcite/prepare/CalciteCatalogReader.java | 66 +-
.../apache/calcite/prepare/CalcitePrepareImpl.java | 10 +
.../org/apache/calcite/prepare/PlannerImpl.java | 28 +-
.../java/org/apache/calcite/prepare/Prepare.java | 17 +-
.../main/java/org/apache/calcite/rel/RelRoot.java | 5 +-
.../java/org/apache/calcite/rel/core/Combine.java | 42 +-
.../calcite/rel/core/ConditionalCorrelate.java | 86 +
.../org/apache/calcite/rel/core/Correlate.java | 6 +
.../java/org/apache/calcite/rel/core/Filter.java | 14 +
.../java/org/apache/calcite/rel/core/Join.java | 30 +-
.../java/org/apache/calcite/rel/core/JoinInfo.java | 36 +-
.../org/apache/calcite/rel/core/JoinRelType.java | 32 +-
.../org/apache/calcite/rel/core/RelFactories.java | 49 +
.../java/org/apache/calcite/rel/core/Window.java | 26 +-
.../apache/calcite/rel/externalize/RelJson.java | 16 +-
.../calcite/rel/externalize/RelWriterImpl.java | 8 +
.../java/org/apache/calcite/rel/hint/RelHint.java | 32 +-
.../rel/logical/LogicalConditionalCorrelate.java | 90 +
.../apache/calcite/rel/logical/LogicalWindow.java | 36 +-
.../calcite/rel/logical/ToLogicalConverter.java | 4 +-
.../calcite/rel/metadata/BuiltInMetadata.java | 30 +
.../rel/metadata/DefaultRelMetadataProvider.java | 1 +
.../rel/metadata/RelMdColumnUniqueness.java | 8 +-
.../calcite/rel/metadata/RelMdInputFieldsUsed.java | 180 +
.../calcite/rel/metadata/RelMdMaxRowCount.java | 14 +-
.../calcite/rel/metadata/RelMdMinRowCount.java | 14 +-
.../calcite/rel/metadata/RelMdPredicates.java | 93 +-
.../apache/calcite/rel/metadata/RelMdRowCount.java | 18 +-
.../org/apache/calcite/rel/metadata/RelMdSize.java | 18 +-
.../org/apache/calcite/rel/metadata/RelMdUtil.java | 40 +-
.../calcite/rel/metadata/RelMetadataQuery.java | 17 +
.../apache/calcite/rel/mutable/MutableRels.java | 2 +-
.../calcite/rel/rel2sql/RelToSqlConverter.java | 181 +-
.../apache/calcite/rel/rel2sql/SqlImplementor.java | 185 +-
.../rel/rules/AggregateCaseToFilterRule.java | 3 +-
.../AggregateExpandDistinctAggregatesRule.java | 375 +-
.../AggregateFilterToFilteredAggregateRule.java | 109 +
.../rel/rules/AggregateProjectMergeRule.java | 8 +
.../AggregateReduceFunctionsOnGroupKeysRule.java | 290 ++
.../rules/AggregateRemoveDuplicateKeysRule.java | 181 +
.../apache/calcite/rel/rules/CalcRelSplitter.java | 112 +-
.../rel/rules/CombineSimpleEquivalenceRule.java | 212 ++
.../org/apache/calcite/rel/rules/CoreRules.java | 51 +-
.../java/org/apache/calcite/rel/rules/DpHyp.java | 34 +-
.../calcite/rel/rules/FilterCorrelateRule.java | 17 +-
.../apache/calcite/rel/rules/FilterJoinRule.java | 27 +-
.../rel/rules/FilterProjectTransposeRule.java | 14 +-
.../calcite/rel/rules/LoptOptimizeJoinRule.java | 2 +-
.../calcite/rel/rules/LoptSemiJoinOptimizer.java | 2 +-
.../rel/rules/MarkToSemiOrAntiJoinRule.java | 143 +
.../rel/rules/MultiJoinOptimizeBushyRule.java | 40 +-
.../apache/calcite/rel/rules/ProjectMergeRule.java | 7 +
.../calcite/rel/rules/ProjectToWindowRule.java | 13 +-
.../rel/rules/ProjectWindowTransposeRule.java | 15 +-
.../apache/calcite/rel/rules/PruneEmptyRules.java | 35 +-
.../calcite/rel/rules/ReduceExpressionsRule.java | 25 +-
.../org/apache/calcite/rel/rules/SemiJoinRule.java | 80 +-
.../rel/rules/SingleValuesOptimizationRules.java | 73 +-
.../calcite/rel/rules/SortJoinTransposeRule.java | 10 +-
.../calcite/rel/rules/SortRemoveRedundantRule.java | 5 +-
.../calcite/rel/rules/SubQueryRemoveRule.java | 418 ++-
.../calcite/rel/rules/UnnestDecorrelateRule.java | 182 +
.../apache/calcite/rel/rules/ValuesReduceRule.java | 14 +-
.../apache/calcite/rel/type/RelDataTypeSystem.java | 52 +-
.../calcite/rel/type/RelDataTypeSystemImpl.java | 17 +-
.../java/org/apache/calcite/rex/RexAnalyzer.java | 4 +
.../java/org/apache/calcite/rex/RexBuilder.java | 35 +-
.../main/java/org/apache/calcite/rex/RexCall.java | 2 +-
.../java/org/apache/calcite/rex/RexCopier.java | 2 +-
.../java/org/apache/calcite/rex/RexLiteral.java | 26 +-
.../main/java/org/apache/calcite/rex/RexOver.java | 34 +-
.../java/org/apache/calcite/rex/RexShuttle.java | 9 +-
.../java/org/apache/calcite/rex/RexSimplify.java | 307 +-
.../main/java/org/apache/calcite/rex/RexUtil.java | 138 +-
.../apache/calcite/runtime/CalciteResource.java | 35 +-
.../calcite/runtime/CompressionFunctions.java | 4 +-
.../java/org/apache/calcite/runtime/FlatLists.java | 13 +
.../org/apache/calcite/runtime/SqlFunctions.java | 522 ++-
.../org/apache/calcite/runtime/XmlFunctions.java | 7 +-
.../calcite/runtime/variant/VariantNonNull.java | 2 +-
.../org/apache/calcite/sql/SqlAggFunction.java | 27 +
.../java/org/apache/calcite/sql/SqlByRewriter.java | 83 +
.../java/org/apache/calcite/sql/SqlCollation.java | 23 +
.../java/org/apache/calcite/sql/SqlDialect.java | 18 +
.../main/java/org/apache/calcite/sql/SqlHint.java | 4 +-
.../main/java/org/apache/calcite/sql/SqlJoin.java | 5 +-
.../main/java/org/apache/calcite/sql/SqlKind.java | 3 +
.../java/org/apache/calcite/sql/SqlLambda.java | 7 +
.../java/org/apache/calcite/sql/SqlSelect.java | 10 +
.../sql/{SqlTableRef.java => SqlStarExclude.java} | 63 +-
.../sql/{SqlTableRef.java => SqlStarReplace.java} | 63 +-
.../java/org/apache/calcite/sql/SqlTableRef.java | 11 +-
.../java/org/apache/calcite/sql/SqlUpdate.java | 8 +-
.../main/java/org/apache/calcite/sql/SqlUtil.java | 46 +-
.../org/apache/calcite/sql/SqlValuesOperator.java | 8 +
.../apache/calcite/sql/SqlWindowTableFunction.java | 11 +-
.../java/org/apache/calcite/sql/SqlWriter.java | 9 +
.../sql/advise/SqlAdvisorGetHintsFunction.java | 2 +-
.../sql/advise/SqlAdvisorGetHintsFunction2.java | 2 +-
.../calcite/sql/ddl/SqlAttributeDefinition.java | 24 +-
.../apache/calcite/sql/ddl/SqlCheckConstraint.java | 14 +-
.../calcite/sql/ddl/SqlColumnDeclaration.java | 32 +-
.../calcite/sql/ddl/SqlCreateForeignSchema.java | 21 +-
.../apache/calcite/sql/ddl/SqlCreateFunction.java | 25 +-
.../calcite/sql/ddl/SqlCreateMaterializedView.java | 20 +-
.../apache/calcite/sql/ddl/SqlCreateSchema.java | 19 +-
.../org/apache/calcite/sql/ddl/SqlCreateTable.java | 7 +-
.../apache/calcite/sql/ddl/SqlCreateTableLike.java | 23 +-
.../org/apache/calcite/sql/ddl/SqlCreateType.java | 17 +-
.../org/apache/calcite/sql/ddl/SqlCreateView.java | 6 +-
.../apache/calcite/sql/ddl/SqlDropFunction.java | 16 +-
.../calcite/sql/ddl/SqlDropMaterializedView.java | 17 +-
.../org/apache/calcite/sql/ddl/SqlDropObject.java | 5 +-
.../org/apache/calcite/sql/ddl/SqlDropSchema.java | 19 +-
.../org/apache/calcite/sql/ddl/SqlDropTable.java | 16 +-
.../org/apache/calcite/sql/ddl/SqlDropType.java | 16 +-
.../org/apache/calcite/sql/ddl/SqlDropView.java | 16 +-
.../apache/calcite/sql/ddl/SqlKeyConstraint.java | 25 +-
.../apache/calcite/sql/ddl/SqlTruncateTable.java | 27 +-
.../calcite/sql/dialect/ClickHouseSqlDialect.java | 84 +-
.../calcite/sql/dialect/DuckDBSqlDialect.java | 4 -
.../apache/calcite/sql/dialect/HiveSqlDialect.java | 3 +
.../calcite/sql/dialect/MssqlSqlDialect.java | 25 +-
.../calcite/sql/dialect/MysqlSqlDialect.java | 12 +-
.../calcite/sql/dialect/PhoenixSqlDialect.java | 4 -
.../calcite/sql/dialect/PrestoSqlDialect.java | 4 -
.../calcite/sql/dialect/RedshiftSqlDialect.java | 8 -
.../calcite/sql/dialect/SparkSqlDialect.java | 3 +
.../calcite/sql/dialect/SqliteSqlDialect.java | 77 +-
.../apache/calcite/sql/fun/SqlBetweenOperator.java | 11 +-
.../apache/calcite/sql/fun/SqlCastOperator.java | 10 +
.../apache/calcite/sql/fun/SqlColonOperator.java | 123 +
.../apache/calcite/sql/fun/SqlExtractFunction.java | 6 +
.../apache/calcite/sql/fun/SqlItemOperator.java | 22 +-
.../calcite/sql/fun/SqlLibraryOperators.java | 38 +-
.../calcite/sql/fun/SqlOverlapsOperator.java | 58 +-
.../calcite/sql/fun/SqlQuantifyOperator.java | 9 +-
.../calcite/sql/fun/SqlStdOperatorTable.java | 21 +-
.../apache/calcite/sql/parser/SqlParserUtil.java | 33 +-
.../apache/calcite/sql/pretty/SqlPrettyWriter.java | 8 +
.../org/apache/calcite/sql/type/BasicSqlType.java | 14 +
.../org/apache/calcite/sql/type/OperandTypes.java | 127 +-
.../calcite/sql/type/SqlTypeCoercionRule.java | 8 +-
.../calcite/sql/type/SqlTypeFactoryImpl.java | 2 +-
.../org/apache/calcite/sql/type/SqlTypeFamily.java | 4 +
.../org/apache/calcite/sql/type/SqlTypeUtil.java | 33 +-
.../calcite/sql/validate/IdentifierNamespace.java | 1 +
.../calcite/sql/validate/MatchRecognizeScope.java | 15 +-
.../apache/calcite/sql/validate/SelectScope.java | 11 +
.../sql/validate/SqlAbstractConformance.java | 4 +
.../calcite/sql/validate/SqlConformance.java | 12 +
.../calcite/sql/validate/SqlConformanceEnum.java | 4 +
.../sql/validate/SqlDelegatingConformance.java | 4 +
.../apache/calcite/sql/validate/SqlValidator.java | 6 +
.../calcite/sql/validate/SqlValidatorImpl.java | 522 ++-
.../calcite/sql/validate/SqlValidatorUtil.java | 36 +
.../sql/validate/implicit/TypeCoercionImpl.java | 131 +-
.../apache/calcite/sql2rel/ConvertToChecked.java | 56 +-
.../apache/calcite/sql2rel/RelDecorrelator.java | 749 +++-
.../apache/calcite/sql2rel/RelFieldTrimmer.java | 105 +-
.../calcite/sql2rel/SqlNodeToRexConverterImpl.java | 3 +-
.../apache/calcite/sql2rel/SqlToRelConverter.java | 263 +-
.../calcite/sql2rel/StandardConvertletTable.java | 140 +-
.../sql2rel/TopDownGeneralDecorrelator.java | 1209 +++++++
.../java/org/apache/calcite/tools/Programs.java | 31 +-
.../java/org/apache/calcite/tools/RelBuilder.java | 89 +-
.../src/main/java/org/apache/calcite/util/Bug.java | 22 -
.../org/apache/calcite/util/BuiltInMethod.java | 33 +-
.../apache/calcite/util/RelToSqlConverterUtil.java | 33 +
.../org/apache/calcite/util/TimestampString.java | 4 +
.../calcite/util/TimestampWithTimeZoneString.java | 4 +-
.../main/java/org/apache/calcite/util/Util.java | 101 +
.../calcite/util/format/FormatElementEnum.java | 15 +-
.../calcite/runtime/CalciteResource.properties | 13 +-
.../org/apache/calcite/model/ModelHandlerTest.java | 144 +
.../java/org/apache/calcite/plan/RelTraitTest.java | 35 +
.../calcite/plan/volcano/VolcanoPlannerTest.java | 18 +-
.../prepare/LookupOperatorOverloadsTest.java | 158 +
.../java/org/apache/calcite/rel/RelRootTest.java | 50 +
.../calcite/rel/externalize/RelJsonTest.java | 45 +
.../rel/logical/ToLogicalConverterTest.java | 8 +-
.../rel/rel2sql/RelToSqlConverterStructsTest.java | 3 +-
.../calcite/rel/rel2sql/RelToSqlConverterTest.java | 1127 +++++-
.../org/apache/calcite/rex/RexBuilderTest.java | 4 +
.../apache/calcite/rex/RexProgramBuilderBase.java | 7 +
.../org/apache/calcite/rex/RexProgramTest.java | 355 +-
.../apache/calcite/sql/SqlCallOperandsTest.java | 141 +
.../calcite/sql/parser/SqlParserUtilTest.java | 51 +
.../apache/calcite/sql/test/SqlAdvisorTest.java | 2 +
.../calcite/sql/type/RelDataTypeSystemTest.java | 20 +-
.../calcite/sql/type/SqlTypeFactoryTest.java | 3 +-
.../calcite/sql2rel/RelDecorrelatorTest.java | 1930 ++++++++++-
.../calcite/sql2rel/RelFieldTrimmerTest.java | 132 +-
...AggregateFilterToFilteredAggregateRuleTest.java | 126 +
...ggregateReduceFunctionsOnGroupKeysRuleTest.java | 155 +
.../test/AggregateRemoveDuplicateKeysRuleTest.java | 87 +
.../calcite/test/CombineRelOptRulesTest.java | 509 +++
.../org/apache/calcite/test/CoreQuidemTest.java | 56 +-
.../org/apache/calcite/test/CoreQuidemTest2.java | 30 +-
.../org/apache/calcite/test/HepPlannerTest.java | 123 +-
.../org/apache/calcite/test/JdbcAdapterTest.java | 213 +-
.../apache/calcite/test/JdbcSchemaSqlTypeTest.java | 74 +
.../java/org/apache/calcite/test/JdbcTest.java | 15 +-
.../java/org/apache/calcite/test/LintTest.java | 65 +-
.../org/apache/calcite/test/RelBuilderTest.java | 14 +
.../org/apache/calcite/test/RelMetadataTest.java | 228 +-
.../org/apache/calcite/test/RelOptRulesTest.java | 1036 +++++-
.../org/apache/calcite/test/SqlFunctionsTest.java | 44 +-
.../apache/calcite/test/SqlHintsConverterTest.java | 115 +-
.../apache/calcite/test/SqlToRelConverterTest.java | 194 +-
.../org/apache/calcite/test/SqlValidatorTest.java | 562 ++-
.../test/java/org/apache/calcite/test/UdfTest.java | 35 +
.../test/enumerable/EnumerableCalcTest.java | 22 +
.../test/enumerable/EnumerableCombineTest.java | 167 +
.../test/enumerable/EnumerableCorrelateTest.java | 172 +
.../test/enumerable/EnumerableHashJoinTest.java | 272 ++
.../test/enumerable/EnumerableJoinTest.java | 146 +
.../org/apache/calcite/tools/FrameworksTest.java | 10 -
.../java/org/apache/calcite/tools/PlannerTest.java | 30 +
.../java/org/apache/calcite/util/UtilTest.java | 51 +
.../AggregateFilterToFilteredAggregateRuleTest.xml | 192 +
...AggregateReduceFunctionsOnGroupKeysRuleTest.xml | 324 ++
.../test/AggregateRemoveDuplicateKeysRuleTest.xml | 94 +
.../apache/calcite/test/CombineRelOptRulesTest.xml | 371 ++
.../org/apache/calcite/test/RelOptRulesTest.xml | 2312 ++++++++++++-
.../apache/calcite/test/SqlHintsConverterTest.xml | 16 +
.../apache/calcite/test/SqlToRelConverterTest.xml | 377 +-
core/src/test/resources/sql/agg.iq | 144 +-
core/src/test/resources/sql/blank.iq | 246 +-
core/src/test/resources/sql/cast.iq | 39 +-
core/src/test/resources/sql/conditions.iq | 17 +
core/src/test/resources/sql/hep.iq | 117 +
core/src/test/resources/sql/join.iq | 133 +
core/src/test/resources/sql/lateral.iq | 2 -
core/src/test/resources/sql/match.iq | 16 +
core/src/test/resources/sql/measure-paper.iq | 55 +
core/src/test/resources/sql/misc.iq | 236 +-
core/src/test/resources/sql/new-decorr.iq | 474 +++
core/src/test/resources/sql/operator.iq | 4 +-
core/src/test/resources/sql/planner.iq | 219 +-
core/src/test/resources/sql/scalar.iq | 179 +-
core/src/test/resources/sql/set-op.iq | 99 +-
core/src/test/resources/sql/some.iq | 69 +-
core/src/test/resources/sql/sort.iq | 111 +
core/src/test/resources/sql/struct.iq | 39 +
core/src/test/resources/sql/sub-query.iq | 3649 ++++++++++++++++----
core/src/test/resources/sql/unsigned.iq | 5 +
core/src/test/resources/sql/winagg.iq | 26 +-
druid/build.gradle.kts | 1 -
.../apache/calcite/adapter/druid/DruidRules.java | 36 +-
.../org/apache/calcite/test/DruidAdapter2IT.java | 2 +
.../org/apache/calcite/test/DruidAdapterIT.java | 2 +
.../adapter/elasticsearch/ElasticsearchRules.java | 36 +
.../adapter/elasticsearch/ElasticsearchTable.java | 6 +-
.../adapter/elasticsearch/PredicateAnalyzer.java | 81 +-
.../elasticsearch/AggregationAndSortTest.java | 174 +-
.../elasticsearch/ElasticSearchAdapterTest.java | 3 -
.../calcite/adapter/csv/CsvFilterableTable.java | 2 +-
.../calcite/adapter/csv/CsvScannableTable.java | 2 +-
.../adapter/csv/CsvStreamScannableTable.java | 2 +-
.../org/apache/calcite/adapter/csv/CsvTable.java | 4 +-
.../calcite/adapter/csv/CsvTranslatableTable.java | 3 +-
file/build.gradle.kts | 1 -
.../apache/calcite/adapter/file/CsvEnumerator.java | 82 +-
.../calcite/adapter/file/CsvStreamReader.java | 6 +-
.../org/apache/calcite/adapter/file/CsvTable.java | 11 +-
.../calcite/adapter/file/CsvTableFactory.java | 15 +-
.../calcite/adapter/file/CsvTranslatableTable.java | 10 +-
.../apache/calcite/adapter/file/FileSchema.java | 5 +-
.../calcite/adapter/file/FileAdapterTest.java | 85 +
...ith-custom-table.json => custom-separator.json} | 12 +-
.../test/resources/sales-csv/PIPE_DELIMITED.csv | 5 +
geode/build.gradle.kts | 1 -
.../calcite/adapter/geode/util/GeodeUtils.java | 7 +-
gradle.properties | 13 +-
innodb/build.gradle.kts | 1 -
.../calcite/adapter/innodb/InnodbSchema.java | 4 +-
.../adapter/innodb/InnodbSchemaFactory.java | 4 +-
.../adapter/innodb/InnodbAdapterDataTypesTest.java | 54 +-
.../apache/calcite/linq4j/DefaultEnumerable.java | 33 +
.../apache/calcite/linq4j/EnumerableDefaults.java | 514 ++-
.../apache/calcite/linq4j/ExtendedEnumerable.java | 66 +
.../java/org/apache/calcite/linq4j/JoinType.java | 27 +-
.../apache/calcite/linq4j/function/Functions.java | 145 +-
.../{Function2.java => NullablePredicate2.java} | 7 +-
.../calcite/adapter/mongodb/MongoProject.java | 4 +-
.../apache/calcite/adapter/mongodb/MongoRules.java | 3 +
.../calcite/adapter/mongodb/MongoAdapterTest.java | 177 +
.../java/org/apache/calcite/piglet/Handler.java | 6 +-
.../org/apache/calcite/piglet/PigRelOpVisitor.java | 7 +-
.../java/org/apache/calcite/test/PigRelExTest.java | 11 +-
.../java/org/apache/calcite/test/PigRelOpTest.java | 4 +-
.../java/org/apache/calcite/test/PigletTest.java | 2 +-
.../calcite/adapter/os/FilesTableFunction.java | 102 +-
.../apache/calcite/adapter/os/OsAdapterTest.java | 34 +-
.../org/apache/calcite/adapter/tpch/TpchTest.java | 297 ++
redis/build.gradle.kts | 2 +-
.../calcite/adapter/redis/RedisDataProcess.java | 6 +-
.../calcite/adapter/redis/RedisEnumerator.java | 9 +-
.../calcite/adapter/redis/RedisJedisManager.java | 3 +-
.../apache/calcite/adapter/redis/RedisSchema.java | 70 +-
.../src/main/java/redis/embedded/util/JarUtil.java | 50 +
.../java/redis/embedded/util}/package-info.java | 4 +-
.../adapter/redis/RedisAdapterConfigCaseBase.java | 200 ++
.../calcite/adapter/redis/RedisCaseBase.java | 7 +-
.../apache/calcite/server/ServerDdlExecutor.java | 9 +-
.../org/apache/calcite/test/ServerParserTest.java | 101 +
server/src/test/resources/sql/type.iq | 51 +
site/_docs/algebra.md | 35 +-
site/_docs/file_adapter.md | 20 +
site/_docs/materialized_views.md | 88 +-
site/_docs/reference.md | 59 +-
.../org/apache/calcite/test/SparkAdapterTest.java | 8 +-
testkit/build.gradle.kts | 1 -
.../apache/calcite/sql/parser/SqlParserTest.java | 190 +
.../org/apache/calcite/test/CalciteAssert.java | 15 +-
.../org/apache/calcite/test/DiffRepository.java | 8 +-
.../org/apache/calcite/test/MockDdlExecutor.java | 2 +
.../java/org/apache/calcite/test/QuidemTest.java | 149 +-
.../org/apache/calcite/test/RelOptFixture.java | 41 +-
.../java/org/apache/calcite/test/RelSupplier.java | 6 +
.../org/apache/calcite/test/SqlOperatorTest.java | 396 ++-
.../main/java/org/apache/calcite/util/Smalls.java | 18 +
.../test/DiffRepositoryGeneratedFileTest.java | 78 +
.../java/org/apache/calcite/test/FixtureTest.java | 2 +-
...est.xml => DiffRepositoryGeneratedFileTest.xml} | 9 +-
.../calcite/benchmarks/LargePlanBenchmark.java | 583 ++++
400 files changed, 33533 insertions(+), 3947 deletions(-)
create mode 100644 .github/pull_request_template.md
create mode 100644
arrow/src/main/java/org/apache/calcite/adapter/arrow/ConditionToken.java
create mode 100644
core/src/main/java/org/apache/calcite/adapter/enumerable/EnumerableCombine.java
copy
core/src/main/java/org/apache/calcite/adapter/enumerable/{EnumerableUnionRule.java
=> EnumerableCombineRule.java} (65%)
copy
core/src/main/java/org/apache/calcite/adapter/enumerable/{EnumerableCorrelate.java
=> EnumerableConditionalCorrelate.java} (62%)
copy
core/src/main/java/org/apache/calcite/adapter/enumerable/{EnumerableCorrelateRule.java
=> EnumerableConditionalCorrelateRule.java} (62%)
create mode 100644
core/src/main/java/org/apache/calcite/model/ClassNameFilter.java
create mode 100644
core/src/main/java/org/apache/calcite/plan/SpoolRelOptTable.java
create mode 100644
core/src/main/java/org/apache/calcite/plan/hep/HepVertexIterator.java
create mode 100644
core/src/main/java/org/apache/calcite/rel/core/ConditionalCorrelate.java
create mode 100644
core/src/main/java/org/apache/calcite/rel/logical/LogicalConditionalCorrelate.java
create mode 100644
core/src/main/java/org/apache/calcite/rel/metadata/RelMdInputFieldsUsed.java
create mode 100644
core/src/main/java/org/apache/calcite/rel/rules/AggregateFilterToFilteredAggregateRule.java
create mode 100644
core/src/main/java/org/apache/calcite/rel/rules/AggregateReduceFunctionsOnGroupKeysRule.java
create mode 100644
core/src/main/java/org/apache/calcite/rel/rules/AggregateRemoveDuplicateKeysRule.java
create mode 100644
core/src/main/java/org/apache/calcite/rel/rules/CombineSimpleEquivalenceRule.java
create mode 100644
core/src/main/java/org/apache/calcite/rel/rules/MarkToSemiOrAntiJoinRule.java
create mode 100644
core/src/main/java/org/apache/calcite/rel/rules/UnnestDecorrelateRule.java
create mode 100644 core/src/main/java/org/apache/calcite/sql/SqlByRewriter.java
copy core/src/main/java/org/apache/calcite/sql/{SqlTableRef.java =>
SqlStarExclude.java} (51%)
copy core/src/main/java/org/apache/calcite/sql/{SqlTableRef.java =>
SqlStarReplace.java} (51%)
create mode 100644
core/src/main/java/org/apache/calcite/sql/fun/SqlColonOperator.java
create mode 100644
core/src/main/java/org/apache/calcite/sql2rel/TopDownGeneralDecorrelator.java
create mode 100644
core/src/test/java/org/apache/calcite/test/AggregateFilterToFilteredAggregateRuleTest.java
create mode 100644
core/src/test/java/org/apache/calcite/test/AggregateReduceFunctionsOnGroupKeysRuleTest.java
create mode 100644
core/src/test/java/org/apache/calcite/test/AggregateRemoveDuplicateKeysRuleTest.java
create mode 100644
core/src/test/java/org/apache/calcite/test/CombineRelOptRulesTest.java
copy plus/src/test/java/org/apache/calcite/chinook/EndToEndTest.java =>
core/src/test/java/org/apache/calcite/test/CoreQuidemTest2.java (57%)
create mode 100644
core/src/test/java/org/apache/calcite/test/JdbcSchemaSqlTypeTest.java
create mode 100644
core/src/test/java/org/apache/calcite/test/enumerable/EnumerableCombineTest.java
create mode 100644
core/src/test/resources/org/apache/calcite/test/AggregateFilterToFilteredAggregateRuleTest.xml
create mode 100644
core/src/test/resources/org/apache/calcite/test/AggregateReduceFunctionsOnGroupKeysRuleTest.xml
create mode 100644
core/src/test/resources/org/apache/calcite/test/AggregateRemoveDuplicateKeysRuleTest.xml
create mode 100644
core/src/test/resources/org/apache/calcite/test/CombineRelOptRulesTest.xml
create mode 100644 core/src/test/resources/sql/new-decorr.iq
copy file/src/test/resources/{model-with-custom-table.json =>
custom-separator.json} (84%)
create mode 100644 file/src/test/resources/sales-csv/PIPE_DELIMITED.csv
copy linq4j/src/main/java/org/apache/calcite/linq4j/function/{Function2.java
=> NullablePredicate2.java} (81%)
create mode 100644 redis/src/main/java/redis/embedded/util/JarUtil.java
copy {core/src/main/java/org/apache/calcite/sql/type =>
redis/src/main/java/redis/embedded/util}/package-info.java (92%)
create mode 100644
redis/src/test/java/org/apache/calcite/adapter/redis/RedisAdapterConfigCaseBase.java
create mode 100644
testkit/src/test/java/org/apache/calcite/test/DiffRepositoryGeneratedFileTest.java
copy
testkit/src/test/resources/org/apache/calcite/test/{DiffRepositoryOutOfOrderTest.xml
=> DiffRepositoryGeneratedFileTest.xml} (83%)
create mode 100644
ubenchmark/src/jmh/java/org/apache/calcite/benchmarks/LargePlanBenchmark.java