[jira] [Commented] (IGNITE-16632) Calcite engine. Add calcite dependencies to TC build

2022-02-28 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16632?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17498846#comment-17498846 ] Aleksey Plekhanov commented on IGNITE-16632: [~vveider], currently, I've faced with this

[jira] [Commented] (IGNITE-16632) Calcite engine. Add calcite dependencies to TC build

2022-02-28 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16632?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17498839#comment-17498839 ] Aleksey Plekhanov commented on IGNITE-16632: [~vveider], build config

[jira] [Created] (IGNITE-16632) Calcite engine. Add calcite dependencies to TC build

2022-02-28 Thread Aleksey Plekhanov (Jira)
Aleksey Plekhanov created IGNITE-16632: -- Summary: Calcite engine. Add calcite dependencies to TC build Key: IGNITE-16632 URL: https://issues.apache.org/jira/browse/IGNITE-16632 Project: Ignite

[jira] [Commented] (IGNITE-16632) Calcite engine. Add calcite dependencies to TC build

2022-02-28 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16632?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17498819#comment-17498819 ] Aleksey Plekhanov commented on IGNITE-16632: [~vveider], can you please change the

[jira] [Updated] (IGNITE-14195) SQL Calcite: ease of use of new Calcite engine

2022-02-21 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-14195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-14195: --- Labels: calcite calcite3-required (was: calcite2-required calcite3-required) >

[jira] [Commented] (IGNITE-14195) SQL Calcite: ease of use of new Calcite engine

2022-02-21 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-14195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17495923#comment-17495923 ] Aleksey Plekhanov commented on IGNITE-14195: [~ivandasch], thanks for the review! Merged to

[jira] [Commented] (IGNITE-16580) Calcite. Merge returns unexpected results.

2022-02-20 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17495353#comment-17495353 ] Aleksey Plekhanov commented on IGNITE-16580: [~zstan], I've checked the query and it

[jira] [Assigned] (IGNITE-16580) Calcite. Merge returns unexpected results.

2022-02-20 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov reassigned IGNITE-16580: -- Assignee: Aleksey Plekhanov > Calcite. Merge returns unexpected results. >

[jira] [Commented] (IGNITE-16493) Calcite engine. Decorrelation after subquery rewrite

2022-02-17 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17494024#comment-17494024 ] Aleksey Plekhanov commented on IGNITE-16493: Looks like there are some problems in

[jira] [Resolved] (IGNITE-15993) Calcite engine. Wrong result for single-value aggregation from empty source

2022-02-16 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15993?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov resolved IGNITE-15993. Resolution: Fixed > Calcite engine. Wrong result for single-value aggregation

[jira] [Updated] (IGNITE-15993) Calcite engine. Wrong result for single-value aggregation from empty source

2022-02-16 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15993?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-15993: --- Labels: calcite3-required (was: calcite2-required calcite3-required) > Calcite

[jira] [Commented] (IGNITE-15993) Calcite engine. Wrong result for single-value aggregation from empty source

2022-02-16 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17493660#comment-17493660 ] Aleksey Plekhanov commented on IGNITE-15993: [~vladsz83], thanks for the review! Merged to

[jira] [Commented] (IGNITE-16396) Calcite engine. Allow hash output distribution for aggregations

2022-02-16 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17493342#comment-17493342 ] Aleksey Plekhanov commented on IGNITE-16396: [~zstan], [~tledkov-gridgain], [~korlov], can

[jira] [Commented] (IGNITE-15584) Calcite. Failed to parse query with IN and simple subquery.

2022-02-15 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15584?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17492516#comment-17492516 ] Aleksey Plekhanov commented on IGNITE-15584: [~zstan], [~ivandasch] it's not in a standard

[jira] [Resolved] (IGNITE-13035) Calcite integration. Support fallback on indexes rebuild

2022-02-14 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-13035?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov resolved IGNITE-13035. Resolution: Duplicate Resolved by IGNITE-16111 > Calcite integration. Support

[jira] [Updated] (IGNITE-13035) Calcite integration. Support fallback on indexes rebuild

2022-02-14 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-13035?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-13035: --- Labels: calcite (was: ) > Calcite integration. Support fallback on indexes

[jira] [Updated] (IGNITE-13035) Calcite integration. Support fallback on indexes rebuild

2022-02-14 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-13035?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-13035: --- Labels: (was: calcite2-required calcite3-required) > Calcite integration.

[jira] [Updated] (IGNITE-16111) Calcite engine. Fallback to table scan if index is absent on some nodes

2022-02-14 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16111: --- Labels: calcite calcite3-required (was: calcite2-required calcite3-required) >

[jira] [Commented] (IGNITE-14916) Calcite. RuntimeHashIndex scan must filter result by predicate

2022-02-14 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-14916?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17492134#comment-17492134 ] Aleksey Plekhanov commented on IGNITE-14916: [~tledkov-gridgain] LGTM. > Calcite.

[jira] [Updated] (IGNITE-16511) Calcite engine. Move system properties constants to IgniteSystemProperties class

2022-02-11 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16511?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16511: --- Labels: calcite calcite3-required (was: calcite calcite2-required

[jira] [Commented] (IGNITE-14916) Calcite. RuntimeHashIndex scan must filter result by predicate

2022-02-11 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-14916?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17490749#comment-17490749 ] Aleksey Plekhanov commented on IGNITE-14916: [~tledkov-gridgain] pull request is not

[jira] [Assigned] (IGNITE-16511) Calcite engine. Move system properties constants to IgniteSystemProperties class

2022-02-10 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16511?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov reassigned IGNITE-16511: -- Assignee: Aleksey Plekhanov > Calcite engine. Move system properties

[jira] [Commented] (IGNITE-14916) Calcite. FilterSpoolMergeToHashIndexSpoolRule need to be applicable only if all conditions are covered.

2022-02-10 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-14916?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17490213#comment-17490213 ] Aleksey Plekhanov commented on IGNITE-14916: Reproducer for the problem: {code:java} /** */

[jira] [Updated] (IGNITE-16505) Calcite engine. Move row count approximation from ignite-indexing

2022-02-09 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16505: --- Labels: calcite calcite3-required (was: calcite calcite2-required

[jira] [Commented] (IGNITE-16505) Calcite engine. Move row count approximation from ignite-indexing

2022-02-09 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17490011#comment-17490011 ] Aleksey Plekhanov commented on IGNITE-16505: [~zstan], thanks for the review! Merged to

[jira] [Created] (IGNITE-16511) Calcite engine. Move system properties constants to IgniteSystemProperties class

2022-02-09 Thread Aleksey Plekhanov (Jira)
Aleksey Plekhanov created IGNITE-16511: -- Summary: Calcite engine. Move system properties constants to IgniteSystemProperties class Key: IGNITE-16511 URL: https://issues.apache.org/jira/browse/IGNITE-16511

[jira] [Created] (IGNITE-16510) Calcite engine. Support "keep binary" flag

2022-02-09 Thread Aleksey Plekhanov (Jira)
Aleksey Plekhanov created IGNITE-16510: -- Summary: Calcite engine. Support "keep binary" flag Key: IGNITE-16510 URL: https://issues.apache.org/jira/browse/IGNITE-16510 Project: Ignite

[jira] [Created] (IGNITE-16509) Calcite engine. Support OTHER data type

2022-02-09 Thread Aleksey Plekhanov (Jira)
Aleksey Plekhanov created IGNITE-16509: -- Summary: Calcite engine. Support OTHER data type Key: IGNITE-16509 URL: https://issues.apache.org/jira/browse/IGNITE-16509 Project: Ignite Issue

[jira] [Created] (IGNITE-16507) Calcite engine. Redundant sort node when rewriting index scan on index rebuild

2022-02-09 Thread Aleksey Plekhanov (Jira)
Aleksey Plekhanov created IGNITE-16507: -- Summary: Calcite engine. Redundant sort node when rewriting index scan on index rebuild Key: IGNITE-16507 URL: https://issues.apache.org/jira/browse/IGNITE-16507

[jira] [Created] (IGNITE-16505) Calcite engine. Move row count approximation from ignite-indexing

2022-02-08 Thread Aleksey Plekhanov (Jira)
Aleksey Plekhanov created IGNITE-16505: -- Summary: Calcite engine. Move row count approximation from ignite-indexing Key: IGNITE-16505 URL: https://issues.apache.org/jira/browse/IGNITE-16505

[jira] [Commented] (IGNITE-16191) Calcite engine. Unexpected result of COUNT with multiple parameters

2022-02-08 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16191?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17488848#comment-17488848 ] Aleksey Plekhanov commented on IGNITE-16191: [~Berkov], hmm, looks like you are right,

[jira] [Updated] (IGNITE-16397) Calcite engine. Failed to insert to table with two or more columns in primary keys

2022-02-08 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16397: --- Labels: calcite calcite3-required (was: calcite2-required calcite3-required) >

[jira] [Commented] (IGNITE-16397) Calcite engine. Failed to insert to table with two or more columns in primary keys

2022-02-08 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16397?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17488739#comment-17488739 ] Aleksey Plekhanov commented on IGNITE-16397: [~ivandasch], thanks for the review! Merged to

[jira] [Updated] (IGNITE-16119) Caclite engine. Refactor IgniteBuiltInMethod and IgniteMethod classes

2022-02-08 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16119?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16119: --- Labels: calcite3-required (was: calcite2-required calcite3-required) > Caclite

[jira] [Commented] (IGNITE-16119) Caclite engine. Refactor IgniteBuiltInMethod and IgniteMethod classes

2022-02-08 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16119?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17488734#comment-17488734 ] Aleksey Plekhanov commented on IGNITE-16119: [~ivandasch], thanks for the review! Merged to

[jira] [Updated] (IGNITE-16119) Caclite engine. Refactor IgniteBuiltInMethod and IgniteMethod classes

2022-02-08 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16119?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16119: --- Labels: calcite calcite3-required (was: calcite3-required) > Caclite engine.

[jira] [Updated] (IGNITE-16493) Calcite engine. Decorrelation after subquery rewrite

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16493: --- Description: Currently decorrelation is performed in {{SqlToRelConverter}}, but

[jira] [Created] (IGNITE-16493) Calcite engine. Decorrelation after subquery rewrite

2022-02-07 Thread Aleksey Plekhanov (Jira)
Aleksey Plekhanov created IGNITE-16493: -- Summary: Calcite engine. Decorrelation after subquery rewrite Key: IGNITE-16493 URL: https://issues.apache.org/jira/browse/IGNITE-16493 Project: Ignite

[jira] [Assigned] (IGNITE-16397) Calcite engine. Failed to insert to table with two or more columns in primary keys

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov reassigned IGNITE-16397: -- Assignee: Aleksey Plekhanov > Calcite engine. Failed to insert to table

[jira] [Assigned] (IGNITE-16119) Caclite engine. Refactor IgniteBuiltInMethod and IgniteMethod classes

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16119?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov reassigned IGNITE-16119: -- Assignee: Aleksey Plekhanov > Caclite engine. Refactor IgniteBuiltInMethod

[jira] [Updated] (IGNITE-16161) Memory leak in BaseQueryContext

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16161: --- Labels: calcite3-required ignite-3 (was: calcite2-required calcite3-required

[jira] [Comment Edited] (IGNITE-16414) Calcite engine. Sorted index spool produces wrong collation

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17488105#comment-17488105 ] Aleksey Plekhanov edited comment on IGNITE-16414 at 2/7/22, 1:26 PM:

[jira] [Updated] (IGNITE-16414) Calcite engine. Sorted index spool produces wrong collation

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16414: --- Labels: calcite3-required (was: calcite2-required calcite3-required) > Calcite

[jira] [Commented] (IGNITE-16414) Calcite engine. Sorted index spool produces wrong collation

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17488105#comment-17488105 ] Aleksey Plekhanov commented on IGNITE-16414: [~zstan] thanks for the review! Merged to

[jira] [Updated] (IGNITE-16191) Calcite engine. Unexpected result of COUNT with multiple parameters

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16191: --- Labels: calcite3-required (was: calcite2-required calcite3-required) > Calcite

[jira] [Updated] (IGNITE-16299) Calcite. Statement with explain can`t be parsed.

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16299: --- Labels: calcite ignite-3 (was: calcite calcite2-required calcite3-required

[jira] [Updated] (IGNITE-13971) Merge Calcite SQL engine to Ignite 3.0

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-13971?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-13971: --- Labels: calcite ignite-3 (was: ignite-3) > Merge Calcite SQL engine to Ignite 3.0

[jira] [Updated] (IGNITE-13971) Merge Calcite SQL engine to Ignite 3.0

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-13971?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-13971: --- Labels: ignite-3 (was: calcite2-required calcite3-required ignite-3) > Merge

[jira] [Updated] (IGNITE-13797) Calcite bug. CREATE TABLE with WHERE SELECT 1;

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-13797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-13797: --- Labels: calcite (was: calcite calcite2-required calcite3-required) > Calcite bug.

[jira] [Updated] (IGNITE-14531) Calcite improvements. Support DISTINCT for aggregates call at the execution

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-14531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-14531: --- Labels: calcite (was: calcite2-required calcite3-required) > Calcite

[jira] [Updated] (IGNITE-14537) Calcite engine. Nested arbitrary queries hangs on optimizing

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-14537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-14537: --- Labels: calcite (was: calcite2-required calcite3-required) > Calcite engine.

[jira] [Updated] (IGNITE-14681) Calcite engine. Extend return type of sum() aggregate function

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-14681?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-14681: --- Labels: calcite3-required ignite-3 (was: calcite2-required calcite3-required

[jira] [Updated] (IGNITE-14862) Calcite improvements. Collect all metadata information

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-14862?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-14862: --- Labels: calcite sql (was: calcite2-required calcite3-required sql) > Calcite

[jira] [Updated] (IGNITE-14713) Calcite. Explain failed for subquery expression.

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-14713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-14713: --- Labels: calcite (was: calcite calcite2-required calcite3-required) > Calcite.

[jira] [Updated] (IGNITE-14866) Calcite. Check SQL function works

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-14866?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-14866: --- Labels: calcite3-required (was: calcite2-required calcite3-required) > Calcite.

[jira] [Updated] (IGNITE-14953) Calcite. Sort out test scripts 'function'

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-14953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-14953: --- Labels: calcite3-required (was: calcite2-required calcite3-required) > Calcite.

[jira] [Updated] (IGNITE-15323) Calcite engine. Query lifecycle refactoting

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-15323: --- Labels: calcite (was: calcite2-required calcite3-required) > Calcite engine.

[jira] [Updated] (IGNITE-15110) Calcite bug. Function CHAR_LENGTH works incorrect with UNICODE

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-15110: --- Labels: calcite (was: calcite2-required calcite3-required) > Calcite bug.

[jira] [Updated] (IGNITE-15539) Calcite. Unexpected resultset from aggregate query.

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-15539: --- Labels: calcite (was: calcite2-required calcite3-required ignite-3) > Calcite.

[jira] [Updated] (IGNITE-15540) Calcite engine. Support for QUANTILE, MEDIAN aggregate functions.

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-15540: --- Labels: calcite (was: calcite2-required calcite3-required ignite-3) > Calcite

[jira] [Updated] (IGNITE-15808) Calcite engine. Failed to join table with itself with 'USING' clause

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-15808: --- Labels: calcite (was: calcite calcite2-required calcite3-required) > Calcite

[jira] [Updated] (IGNITE-16130) Calcite. Natural join returns empty resultset.

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16130: --- Labels: calcite (was: calcite calcite2-required calcite3-required ignite-3) >

[jira] [Updated] (IGNITE-16142) Calcite. Append additional JOIN and ORDER BY functionality covering tests.

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16142?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16142: --- Labels: calcite calcite3-required ignite-3 (was: calcite calcite2-required

[jira] [Updated] (IGNITE-16460) Calcite. Fix Calcite TC test suite.

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16460: --- Labels: calcite (was: calcite2-required) > Calcite. Fix Calcite TC test suite. >

[jira] [Commented] (IGNITE-15993) Calcite engine. Wrong result for single-value aggregation from empty source

2022-02-07 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17488037#comment-17488037 ] Aleksey Plekhanov commented on IGNITE-15993: Calcite version was updated, I've uncommented

[jira] [Commented] (IGNITE-16414) Calcite engine. Sorted index spool produces wrong collation

2022-02-04 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17487071#comment-17487071 ] Aleksey Plekhanov commented on IGNITE-16414: [~zstan], [~tledkov-gridgain], [~ivandasch],

[jira] [Commented] (IGNITE-16443) Calcite engine. Incorrect nulls in search row processing by hash/sorted spools

2022-02-04 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17487066#comment-17487066 ] Aleksey Plekhanov commented on IGNITE-16443: [~ivandasch], [~tledkov-gridgain], thanks for

[jira] [Updated] (IGNITE-16443) Calcite engine. Incorrect nulls in search row processing by hash/sorted spools

2022-02-04 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16443: --- Labels: calcite3-required (was: calcite2-required calcite3-required) > Calcite

[jira] [Commented] (IGNITE-16443) Calcite engine. Incorrect nulls in search row processing by hash/sorted spools

2022-02-03 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17486276#comment-17486276 ] Aleksey Plekhanov commented on IGNITE-16443: [~zstan], [~ivandasch], [~tledkov-gridgain],

[jira] [Commented] (IGNITE-16315) Calcite engine. Query start request contains a lot of data

2022-02-02 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17486267#comment-17486267 ] Aleksey Plekhanov commented on IGNITE-16315: [~zstan], thanks for the review! Merged to

[jira] [Updated] (IGNITE-16315) Calcite engine. Query start request contains a lot of data

2022-02-02 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16315: --- Labels: calcite3-required (was: calcite2-required calcite3-required) > Calcite

[jira] [Updated] (IGNITE-16354) Calcite engine. Memory leak in RelOptCluster during mapping

2022-02-02 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16354?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16354: --- Labels: calcite3-required (was: calcite2-required calcite3-required) > Calcite

[jira] [Updated] (IGNITE-16443) Calcite engine. Incorrect nulls in search row processing by hash/sorted spools

2022-02-02 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16443: --- Description: Currently, the sorted spool comparator treats nulls in the search row

[jira] [Updated] (IGNITE-16443) Calcite engine. Incorrect nulls in search row processing by hash/sorted spools

2022-02-02 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16443: --- Description: Currently, the sorted spool comparator treats nulls in the search row

[jira] [Created] (IGNITE-16443) Calcite engine. Incorrect nulls in search row processing by hash/sorted spools

2022-02-02 Thread Aleksey Plekhanov (Jira)
Aleksey Plekhanov created IGNITE-16443: -- Summary: Calcite engine. Incorrect nulls in search row processing by hash/sorted spools Key: IGNITE-16443 URL: https://issues.apache.org/jira/browse/IGNITE-16443

[jira] [Commented] (IGNITE-16264) [PageMemoryImpl] PageRestore does not mark the restored page as dirty.

2022-01-31 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17485078#comment-17485078 ] Aleksey Plekhanov commented on IGNITE-16264: [~xtern] looks good to me. > [PageMemoryImpl]

[jira] [Commented] (IGNITE-16191) Calcite engine. Unexpected result of COUNT with multiple parameters

2022-01-31 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16191?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17484741#comment-17484741 ] Aleksey Plekhanov commented on IGNITE-16191: Yes, it's not an SQL standard, but Calcite

[jira] [Commented] (IGNITE-16430) Calcite engine. Sorted index spool with sorting can't be planned

2022-01-31 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16430?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17484663#comment-17484663 ] Aleksey Plekhanov commented on IGNITE-16430: [~tledkov-gridgain], unfortunately, it will

[jira] [Updated] (IGNITE-16430) Calcite engine. Sorted index spool with sorting can't be planned

2022-01-30 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16430: --- Summary: Calcite engine. Sorted index spool with sorting can't be planned (was:

[jira] [Updated] (IGNITE-16430) Calcite engine. Sorted index spool with sorting can be planned

2022-01-30 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16430: --- Labels: calcite2-required calcite3-required (was: ) > Calcite engine. Sorted

[jira] [Updated] (IGNITE-16430) Calcite engine. Sorted index spool with sorting can be planned

2022-01-30 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16430: --- Description: Currently, we have code in {{FilterSpoolMergeToSortedIndexSpoolRule}}

[jira] [Updated] (IGNITE-16430) Calcite engine. Sorted index spool with sorting can be planned

2022-01-30 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16430: --- Description: Currently, we have code in {{FilterSpoolMergeToSortedIndexSpoolRule}}

[jira] [Updated] (IGNITE-16430) Calcite engine. Sorted index spool with sorting can be planned

2022-01-30 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16430: --- Description: Currently, we have code in {{FilterSpoolMergeToSortedIndexSpoolRule}}

[jira] [Created] (IGNITE-16430) Calcite engine. Sorted index spool with sorting can be planned

2022-01-30 Thread Aleksey Plekhanov (Jira)
Aleksey Plekhanov created IGNITE-16430: -- Summary: Calcite engine. Sorted index spool with sorting can be planned Key: IGNITE-16430 URL: https://issues.apache.org/jira/browse/IGNITE-16430

[jira] [Updated] (IGNITE-16414) Calcite engine. Sorted index spool produces wrong collation

2022-01-26 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16414: --- Labels: calcite2-required calcite3-required (was: ) > Calcite engine. Sorted

[jira] [Created] (IGNITE-16414) Calcite engine. Sorted index spool produces wrong collation

2022-01-26 Thread Aleksey Plekhanov (Jira)
Aleksey Plekhanov created IGNITE-16414: -- Summary: Calcite engine. Sorted index spool produces wrong collation Key: IGNITE-16414 URL: https://issues.apache.org/jira/browse/IGNITE-16414 Project:

[jira] [Updated] (IGNITE-16397) Calcite engine. Failed to insert to table with two or more columns in primary keys

2022-01-26 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16397: --- Labels: calcite2-required calcite3-required (was: ) > Calcite engine. Failed to

[jira] [Created] (IGNITE-16397) Calcite engine. Failed to insert to table with two or more columns in primary keys

2022-01-26 Thread Aleksey Plekhanov (Jira)
Aleksey Plekhanov created IGNITE-16397: -- Summary: Calcite engine. Failed to insert to table with two or more columns in primary keys Key: IGNITE-16397 URL: https://issues.apache.org/jira/browse/IGNITE-16397

[jira] [Updated] (IGNITE-16396) Calcite engine. Allow hash output distribution for aggregations

2022-01-26 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16396: --- Labels: calcite2-required calcite3-required (was: ) > Calcite engine. Allow hash

[jira] [Updated] (IGNITE-16395) Calcite engine. Implement correct copy-on-write on schema objects change

2022-01-26 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16395: --- Labels: calcite2-required calcite3-required (was: ) > Calcite engine. Implement

[jira] [Updated] (IGNITE-16396) Calcite engine. Allow hash output distribution for aggregations

2022-01-26 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16396: --- Description: Currently, we allow only single output distribution for aggregates,

[jira] [Created] (IGNITE-16396) Calcite engine. Allow hash output distribution for aggregations

2022-01-26 Thread Aleksey Plekhanov (Jira)
Aleksey Plekhanov created IGNITE-16396: -- Summary: Calcite engine. Allow hash output distribution for aggregations Key: IGNITE-16396 URL: https://issues.apache.org/jira/browse/IGNITE-16396

[jira] [Created] (IGNITE-16395) Calcite engine. Implement correct copy-on-write on schema objects change

2022-01-26 Thread Aleksey Plekhanov (Jira)
Aleksey Plekhanov created IGNITE-16395: -- Summary: Calcite engine. Implement correct copy-on-write on schema objects change Key: IGNITE-16395 URL: https://issues.apache.org/jira/browse/IGNITE-16395

[jira] [Commented] (IGNITE-16277) Query failed with assertion

2022-01-24 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17481132#comment-17481132 ] Aleksey Plekhanov commented on IGNITE-16277: Backported to ignite-2 (merged to sql-calcite

[jira] [Updated] (IGNITE-16277) Query failed with assertion

2022-01-24 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16277: --- Labels: calcite ignite-3 (was: calcite calcite2-required ignite-3) > Query failed

[jira] [Updated] (IGNITE-15566) Calcite. Join with correlated subqueries returns wrong result.

2022-01-24 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15566?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-15566: --- Labels: calcite calcite3-required ignite-3 (was: calcite calcite2-required

[jira] [Commented] (IGNITE-15566) Calcite. Join with correlated subqueries returns wrong result.

2022-01-24 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17481116#comment-17481116 ] Aleksey Plekhanov commented on IGNITE-15566: [~zstan], [~korlov] thanks for the review!

[jira] [Updated] (IGNITE-16217) Calcite engine. Upgrade Apache Calcite dependency to 1.29.0

2022-01-24 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aleksey Plekhanov updated IGNITE-16217: --- Labels: calcite3-required (was: calcite2-required calcite3-required) > Calcite

[jira] [Commented] (IGNITE-16217) Calcite engine. Upgrade Apache Calcite dependency to 1.29.0

2022-01-24 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16217?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17481102#comment-17481102 ] Aleksey Plekhanov commented on IGNITE-16217: [~korlov], I've fixed your comment. Thanks for

[jira] [Commented] (IGNITE-16333) Calcite. IgniteProject need to be initialized with single distribution.

2022-01-24 Thread Aleksey Plekhanov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-16333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17480911#comment-17480911 ] Aleksey Plekhanov commented on IGNITE-16333: [~zstan] LGTM > Calcite. IgniteProject need

<    2   3   4   5   6   7   8   9   10   11   >