[jira] [Created] (IGNITE-19503) Sql. UUID. Some expressions and statements with types from incompatible families are not rejected.

2023-05-17 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created IGNITE-19503: - Summary: Sql. UUID. Some expressions and statements with types from incompatible families are not rejected. Key: IGNITE-19503 URL: https://issues.apache.org/jira/browse/

[jira] [Commented] (IGNITE-19307) Sql. Set operations: Conversion to relational algebra failed to preserve datatypes.

2023-05-17 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17723421#comment-17723421 ] Maksim Zhuravkov commented on IGNITE-19307: --- This is issue is by caused by ht

[jira] [Comment Edited] (IGNITE-19307) Sql. Set operations: Conversion to relational algebra failed to preserve datatypes.

2023-05-17 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17723421#comment-17723421 ] Maksim Zhuravkov edited comment on IGNITE-19307 at 5/17/23 11:41 AM:

[jira] [Updated] (IGNITE-19503) Sql. UUID. Some expressions and statements with types from incompatible families are not rejected.

2023-05-17 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19503: -- Description: Type compatibility checks for UUID in some expression/statement are not

[jira] [Updated] (IGNITE-19503) Sql. UUID. Some expressions and statements with types from incompatible families are not rejected.

2023-05-17 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19503: -- Description: Type compatibility checks for UUID in some expression/statement are not

[jira] [Updated] (IGNITE-19503) Sql. UUID. Some expressions and statements with types from incompatible families are not rejected.

2023-05-17 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19503: -- Description: Type compatibility checks for UUID in some expression/statement are not

[jira] [Updated] (IGNITE-19503) Sql. UUID. Some expressions and statements with types from incompatible families are not rejected.

2023-05-17 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19503: -- Description: Type compatibility checks for UUID in some expression/statement are not

[jira] [Updated] (IGNITE-19503) Sql. UUID. Some expressions and statements with types from incompatible families are not rejected.

2023-05-18 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19503: -- Description: Type compatibility checks for UUID in some expression/statement are not

[jira] [Assigned] (IGNITE-19493) Sql. Query flow refactoring.

2023-05-18 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-19493: - Assignee: Maksim Zhuravkov > Sql. Query flow refactoring. > --

[jira] [Assigned] (IGNITE-19496) Sql. Implement SqlSchemaManager on top of CatalogService

2023-05-18 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-19496: - Assignee: Maksim Zhuravkov > Sql. Implement SqlSchemaManager on top of Catalog

[jira] [Assigned] (IGNITE-18443) Sql. Provide extend commands and handlers for distributed zones operation

2023-05-24 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-18443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-18443: - Assignee: Maksim Zhuravkov > Sql. Provide extend commands and handlers for dis

[jira] [Assigned] (IGNITE-19261) Replace parser tests for create/alter zones query by the tests for ddl converter

2023-05-29 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-19261: - Assignee: Maksim Zhuravkov > Replace parser tests for create/alter zones query

[jira] [Commented] (IGNITE-19481) Sql. Inconsistent behaviour of DML operations introduced by implicit type casts.

2023-05-30 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727537#comment-17727537 ] Maksim Zhuravkov commented on IGNITE-19481: --- Vanilla calcite (the latest main

[jira] [Comment Edited] (IGNITE-19481) Sql. Inconsistent behaviour of DML operations introduced by implicit type casts.

2023-05-30 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727537#comment-17727537 ] Maksim Zhuravkov edited comment on IGNITE-19481 at 5/30/23 2:16 PM: -

[jira] [Updated] (IGNITE-19474) Sql. ExecutionServiceImplTest testCursorIsClosedAfterAllDataRead is flaky

2023-05-30 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19474: -- Description: The test failed at {code:java} assertTrue(waitForCondition(

[jira] [Commented] (IGNITE-17374) Sql. Unable to insert default value to VARBINARY column

2023-05-31 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-17374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727919#comment-17727919 ] Maksim Zhuravkov commented on IGNITE-17374: --- The issue is no longer reproduci

[jira] [Assigned] (IGNITE-17374) Sql. Unable to insert default value to VARBINARY column

2023-05-31 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-17374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-17374: - Assignee: Maksim Zhuravkov > Sql. Unable to insert default value to VARBINARY

[jira] [Assigned] (IGNITE-18365) Sql. class java.lang.Integer cannot be cast to class java.lang.String

2023-05-31 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-18365?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-18365: - Assignee: Maksim Zhuravkov > Sql. class java.lang.Integer cannot be cast to cl

[jira] [Assigned] (IGNITE-18965) Sql. CREATE TABLE fails when a column with DEFAULT constraint NULL is present.

2023-05-31 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-18965?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-18965: - Assignee: Maksim Zhuravkov > Sql. CREATE TABLE fails when a column with DEFAUL

[jira] [Assigned] (IGNITE-19587) Sql. Remove execution-related part from IgniteTable

2023-05-31 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19587?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-19587: - Assignee: Maksim Zhuravkov > Sql. Remove execution-related part from IgniteTab

[jira] [Updated] (IGNITE-19474) Sql. ExecutionServiceImplTest testCursorIsClosedAfterAllDataRead is flaky

2023-06-12 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19474: -- Description: The test failed at {code:java} assertTrue(waitForCondition(

[jira] [Created] (IGNITE-19721) Sql. TypeCoercion. Move type validation checks to SqlValidator.

2023-06-13 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created IGNITE-19721: - Summary: Sql. TypeCoercion. Move type validation checks to SqlValidator. Key: IGNITE-19721 URL: https://issues.apache.org/jira/browse/IGNITE-19721 Project:

[jira] [Updated] (IGNITE-19721) Sql. TypeCoercion. Move type validation checks to SqlValidator.

2023-06-13 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19721: -- Description: https://issues.apache.org/jira/browse/IGNITE-18831 Introduced additional

[jira] [Updated] (IGNITE-19721) Sql. TypeCoercion. Move type validation checks to SqlValidator.

2023-06-13 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19721: -- Description: https://issues.apache.org/jira/browse/IGNITE-18831 [Sql. Dynamic paramet

[jira] [Updated] (IGNITE-19721) Sql. TypeCoercion. Move type validation checks to SqlValidator.

2023-06-13 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19721: -- Description: https://issues.apache.org/jira/browse/IGNITE-18831 introduced additional

[jira] [Updated] (IGNITE-19721) Sql. TypeCoercion. Move type validation checks to SqlValidator.

2023-06-13 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19721: -- Description: https://issues.apache.org/jira/browse/IGNITE-18831 introduced additional

[jira] [Created] (IGNITE-19726) Sql. Migrate index operations to ScanableTable.

2023-06-13 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created IGNITE-19726: - Summary: Sql. Migrate index operations to ScanableTable. Key: IGNITE-19726 URL: https://issues.apache.org/jira/browse/IGNITE-19726 Project: Ignite

[jira] [Updated] (IGNITE-19726) Sql. Migrate index operations to ScanableTable.

2023-06-13 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19726: -- Description: When https://issues.apache.org/jira/browse/IGNITE-19587 is complete, it

[jira] [Updated] (IGNITE-19726) Sql. Migrate index operations to ScanableTable.

2023-06-13 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19726: -- Description: When https://issues.apache.org/jira/browse/IGNITE-19587 is complete, it

[jira] [Updated] (IGNITE-19726) Sql. Migrate index operations to ScanableTable.

2023-06-13 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19726: -- Description: When https://issues.apache.org/jira/browse/IGNITE-19587 is complete, it

[jira] [Updated] (IGNITE-19726) Sql. Migrate index operations to ScanableTable.

2023-06-13 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19726: -- Epic Link: IGNITE-19502 > Sql. Migrate index operations to ScanableTable. > -

[jira] [Updated] (IGNITE-19726) Sql. Migrate index operations to ScanableTable.

2023-06-13 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19726: -- Description: When https://issues.apache.org/jira/browse/IGNITE-19587 is complete, it

[jira] [Updated] (IGNITE-19587) Sql. Remove execution-related part from IgniteTable

2023-06-13 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19587?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19587: -- Priority: Minor (was: Major) > Sql. Remove execution-related part from IgniteTable

[jira] [Updated] (IGNITE-19587) Sql. Remove execution-related part from IgniteTable

2023-06-13 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19587?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19587: -- Priority: Major (was: Minor) > Sql. Remove execution-related part from IgniteTable

[jira] [Assigned] (IGNITE-19615) Index is not used while performing SELECT over an indexed column

2023-06-14 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-19615: - Assignee: Maksim Zhuravkov > Index is not used while performing SELECT over an

[jira] [Assigned] (IGNITE-18663) Sql. DATE Literals are not validated correctly.

2023-06-19 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-18663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-18663: - Assignee: Maksim Zhuravkov > Sql. DATE Literals are not validated correctly. >

[jira] [Assigned] (IGNITE-19353) Sql. Incorrect type conversion for dynamic parameters - CAST operation ignores type precision.

2023-06-19 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-19353: - Assignee: Maksim Zhuravkov > Sql. Incorrect type conversion for dynamic parame

[jira] [Assigned] (IGNITE-18663) Sql. DATE Literals are not validated correctly.

2023-06-19 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-18663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-18663: - Assignee: (was: Maksim Zhuravkov) > Sql. DATE Literals are not validated c

[jira] [Created] (IGNITE-19822) Sql. CAST(literal AS decimal_type) is reduced to literal when type(lateral).scale != decimal_type.scale

2023-06-23 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created IGNITE-19822: - Summary: Sql. CAST(literal AS decimal_type) is reduced to literal when type(lateral).scale != decimal_type.scale Key: IGNITE-19822 URL: https://issues.apache.org/jira/br

[jira] [Updated] (IGNITE-19822) Sql. CAST(literal AS decimal_type) is reduced to literal when type(lateral).scale != decimal_type.scale

2023-06-23 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19822: -- Description: RexSimplify/RexBuilder ignores type.scale when it considers whether to r

[jira] [Updated] (IGNITE-19858) Sql. RelJson serialization/deserialization mismatch for statements that include large numbers

2023-06-27 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19858: -- Description: {code:java} SELECT * FROM test2 WHERE C2 > 34028234663852886

[jira] [Updated] (IGNITE-19858) Sql. RelJson serialization/deserialization mismatch for statements that include very large numbers.

2023-06-27 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19858: -- Summary: Sql. RelJson serialization/deserialization mismatch for statements that incl

[jira] [Created] (IGNITE-19858) Sql. RelJson serialization/deserialization mismatch for statements that include large numbers

2023-06-27 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created IGNITE-19858: - Summary: Sql. RelJson serialization/deserialization mismatch for statements that include large numbers Key: IGNITE-19858 URL: https://issues.apache.org/jira/browse/IGNIT

[jira] [Updated] (IGNITE-19858) Sql. RelJson serialization/deserialization mismatch for statements that include large numbers.

2023-06-27 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19858: -- Summary: Sql. RelJson serialization/deserialization mismatch for statements that incl

[jira] [Updated] (IGNITE-19858) Sql. RelJson serialization/deserialization mismatch for statements that include very large numbers.

2023-06-27 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19858: -- Description: {code:java} SELECT C2 > 3402823466385288601::REAL FR

[jira] [Assigned] (IGNITE-19862) Revise error codes for SQL module

2023-06-28 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19862?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-19862: - Assignee: Maksim Zhuravkov > Revise error codes for SQL module > -

[jira] [Updated] (IGNITE-19881) Sql. Queries that access columns of type REAL may require explicit casts in order to pick an index.

2023-06-29 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19881: -- Labels: ignite-3 (was: ) > Sql. Queries that access columns of type REAL may require

[jira] [Created] (IGNITE-19881) Sql. Queries that access columns of type REAL may require explicit casts in order to pick an index.

2023-06-29 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created IGNITE-19881: - Summary: Sql. Queries that access columns of type REAL may require explicit casts in order to pick an index. Key: IGNITE-19881 URL: https://issues.apache.org/jira/browse

[jira] [Updated] (IGNITE-19881) Sql. Queries that access columns of type REAL may require adding an explicit cast in order to pick an index.

2023-06-29 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19881: -- Summary: Sql. Queries that access columns of type REAL may require adding an explicit

[jira] [Updated] (IGNITE-19881) Sql. Queries that access columns of type REAL may require explicit casts in order to pick an index.

2023-06-29 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19881: -- Description: When a column is compared with a non-integer numeric literal, index is n

[jira] [Updated] (IGNITE-19881) Sql. Queries that access columns of type REAL may require adding an explicit cast in order to pick an index.

2023-06-29 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19881: -- Description: When REAL column is compared with non-integer numeric literal, index is

[jira] [Updated] (IGNITE-19882) Sql. Queries that access columns of type DECIMAL do not pick index, when compared with INT/BIGINT.

2023-06-29 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19882: -- Priority: Minor (was: Major) > Sql. Queries that access columns of type DECIMAL do n

[jira] [Created] (IGNITE-19882) Sql. Queries that access columns of type DECIMAL do not pick index, when compared with INT/BIGINT.

2023-06-29 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created IGNITE-19882: - Summary: Sql. Queries that access columns of type DECIMAL do not pick index, when compared with INT/BIGINT. Key: IGNITE-19882 URL: https://issues.apache.org/jira/browse/

[jira] [Created] (IGNITE-19890) Sql. VARCHAR. SUBSTRING function call with length greater than INT, triggers java.lang.NoSuchMethodException

2023-06-29 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created IGNITE-19890: - Summary: Sql. VARCHAR. SUBSTRING function call with length greater than INT, triggers java.lang.NoSuchMethodException Key: IGNITE-19890 URL: https://issues.apache.org/ji

[jira] [Updated] (IGNITE-19890) Sql. VARCHAR. SUBSTRING function call with length greater than INT, triggers java.lang.NoSuchMethodException

2023-06-29 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19890: -- Description: The following query results in java.lang.NoSuchMethodException: org.ap

[jira] [Updated] (IGNITE-19890) Sql. VARCHAR. SUBSTRING function call with length greater than INT, triggers java.lang.NoSuchMethodException

2023-06-29 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19890: -- Description: The following query results in java.lang.NoSuchMethodException: org.ap

[jira] [Commented] (IGNITE-19890) Sql. VARCHAR. SUBSTRING function call with length greater than INT, triggers java.lang.NoSuchMethodException

2023-06-30 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738932#comment-17738932 ] Maksim Zhuravkov commented on IGNITE-19890: --- It won't because SqlTypeFamily.I

[jira] [Created] (IGNITE-19893) Sql. Add plan checks to BaseIndexDataTypeTest

2023-06-30 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created IGNITE-19893: - Summary: Sql. Add plan checks to BaseIndexDataTypeTest Key: IGNITE-19893 URL: https://issues.apache.org/jira/browse/IGNITE-19893 Project: Ignite Is

[jira] [Assigned] (IGNITE-19893) Sql. Add plan checks to BaseIndexDataTypeTest

2023-06-30 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-19893: - Assignee: Maksim Zhuravkov > Sql. Add plan checks to BaseIndexDataTypeTest > -

[jira] [Updated] (IGNITE-19917) Sql. Index scans/lookups should not result in physical scans/looks when search conditions can not be satisfied.

2023-07-05 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19917: -- Description: The following query issues redundant requests to perform index lookups:

[jira] [Created] (IGNITE-19917) Sql. Index scans/lookups should not result in physical scans/looks when search conditions can not be satisfied.

2023-07-05 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created IGNITE-19917: - Summary: Sql. Index scans/lookups should not result in physical scans/looks when search conditions can not be satisfied. Key: IGNITE-19917 URL: https://issues.apache.org

[jira] [Updated] (IGNITE-19917) Sql. Index scans/lookups should not result in physical scans/looks when search conditions can not be satisfied.

2023-07-05 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19917: -- Description: The following query issues redundant requests to perform index lookups:

[jira] [Assigned] (IGNITE-19785) Sql. Rework execution of 2-phase aggregates

2023-07-05 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19785?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-19785: - Assignee: Maksim Zhuravkov > Sql. Rework execution of 2-phase aggregates > ---

[jira] [Created] (IGNITE-19931) Sql. Varbinary. Index is not selected for key = '1'::VARBINARY

2023-07-07 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created IGNITE-19931: - Summary: Sql. Varbinary. Index is not selected for key = '1'::VARBINARY Key: IGNITE-19931 URL: https://issues.apache.org/jira/browse/IGNITE-19931 Project: I

[jira] [Updated] (IGNITE-19931) Sql. Varbinary. Index is not selected for key = '1'::VARBINARY

2023-07-07 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19931: -- Description: Index is not selected for the following query: {code:java} @Test public

[jira] [Updated] (IGNITE-19931) Sql. Varbinary. Index is not selected for key = '1'::VARBINARY

2023-07-07 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19931: -- Description: Index is not selected for the following query: {code:java} @Test public

[jira] [Updated] (IGNITE-19931) Sql. Varbinary. Index is not selected for key = '1'::VARBINARY

2023-07-07 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19931: -- Description: Index is not selected for the following query: {code:java} @Test public

[jira] [Updated] (IGNITE-19931) Sql. Varbinary. Index is not selected for key = '1'::VARBINARY

2023-07-07 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19931: -- Description: Index is not selected for the following query: {code:java} @Test public

[jira] [Updated] (IGNITE-19931) Sql. Varbinary. Index is not selected for key = '1'::VARBINARY

2023-07-07 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19931: -- Description: Index is not selected for the following query: {code:java} @Test public

[jira] [Commented] (IGNITE-19497) Sql. Switch to SqlSchemaManager implementation on top of CatalogService

2023-07-10 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17741529#comment-17741529 ] Maksim Zhuravkov commented on IGNITE-19497: --- CatalogSqlSchemaManager uses Ign

[jira] [Created] (IGNITE-19947) Sql. Fix CAST(n AS DECIMAL(precision, scale) behaviour for scale > precision.

2023-07-11 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created IGNITE-19947: - Summary: Sql. Fix CAST(n AS DECIMAL(precision, scale) behaviour for scale > precision. Key: IGNITE-19947 URL: https://issues.apache.org/jira/browse/IGNITE-19947

[jira] [Created] (IGNITE-20009) Sql. Rework 2-phase aggregates part 2. AVG as SUM / COUNT.

2023-07-20 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created IGNITE-20009: - Summary: Sql. Rework 2-phase aggregates part 2. AVG as SUM / COUNT. Key: IGNITE-20009 URL: https://issues.apache.org/jira/browse/IGNITE-20009 Project: Ignite

[jira] [Updated] (IGNITE-20009) Sql. Rework 2-phase aggregates part 2. AVG as SUM / COUNT.

2023-07-20 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-20009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-20009: -- Description: Map/reduce implementation of some aggregates requires replacing an aggre

[jira] [Updated] (IGNITE-20009) Sql. Rework 2-phase aggregates part 2. AVG as SUM / COUNT.

2023-07-20 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-20009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-20009: -- Description: Map/reduce implementation of some aggregates requires replacing an aggre

[jira] [Updated] (IGNITE-20009) Sql. Rework 2-phase aggregates part 2. AVG as SUM / COUNT.

2023-07-20 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-20009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-20009: -- Description: Map/reduce implementation of some aggregates requires replacing an aggre

[jira] [Assigned] (IGNITE-18453) Query executor thread synchronously waits for leaders on query mapping.

2023-07-20 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-18453?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-18453: - Assignee: (was: Maksim Zhuravkov) > Query executor thread synchronously wa

[jira] [Assigned] (IGNITE-18453) Query executor thread synchronously waits for leaders on query mapping.

2023-07-20 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-18453?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-18453: - Assignee: Maksim Zhuravkov > Query executor thread synchronously waits for lea

[jira] [Assigned] (IGNITE-18453) Query executor thread synchronously waits for leaders on query mapping.

2023-07-20 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-18453?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-18453: - Assignee: Maksim Zhuravkov > Query executor thread synchronously waits for lea

[jira] [Updated] (IGNITE-20009) Sql. Rework 2-phase aggregates part 2. AVG as SUM / COUNT.

2023-07-20 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-20009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-20009: -- Description: Map/reduce implementation of some aggregates requires replacing an aggre

[jira] [Updated] (IGNITE-20009) Sql. Rework 2-phase aggregates part 2. AVG as SUM / COUNT.

2023-07-20 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-20009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-20009: -- Description: Map/reduce implementation of some aggregates requires replacing an aggre

[jira] [Created] (IGNITE-20083) Sql. Investigate cost calculation for MAP/REDUCE aggregate.

2023-07-28 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created IGNITE-20083: - Summary: Sql. Investigate cost calculation for MAP/REDUCE aggregate. Key: IGNITE-20083 URL: https://issues.apache.org/jira/browse/IGNITE-20083 Project: Igni

[jira] [Updated] (IGNITE-20083) Sql. Investigate cost calculation for MAP/REDUCE aggregate.

2023-07-28 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-20083?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-20083: -- Description: After removing complex objects between MAP/REDUCE phase cost computation

[jira] [Created] (IGNITE-20095) Sql. Exchange can not be moved past MAP aggregates in some cases.

2023-07-28 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created IGNITE-20095: - Summary: Sql. Exchange can not be moved past MAP aggregates in some cases. Key: IGNITE-20095 URL: https://issues.apache.org/jira/browse/IGNITE-20095 Project

[jira] [Updated] (IGNITE-20095) Sql. Map part of MAP/REDUCE aggregate can not be moved past Exchange in some cases.

2023-07-28 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-20095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-20095: -- Summary: Sql. Map part of MAP/REDUCE aggregate can not be moved past Exchange in some

[jira] [Updated] (IGNITE-20095) Sql. Map part of MAP/REDUCE aggregate sometimes can not be moved past Exchange.

2023-07-28 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-20095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-20095: -- Summary: Sql. Map part of MAP/REDUCE aggregate sometimes can not be moved past Exchan

[jira] [Updated] (IGNITE-20095) Sql. Map part of MAP/REDUCE aggregate sometimes can not be moved past Exchange.

2023-07-31 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-20095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-20095: -- Description: See examples in MapReduceSortAggregatePlannerTest: {code:java} assertP

[jira] [Updated] (IGNITE-20095) Sql. Map part of MAP/REDUCE aggregate sometimes can not be moved past Exchange.

2023-07-31 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-20095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-20095: -- Description: See examples in MapReduceSortAggregatePlannerTest: {code:java} SELECT

[jira] [Updated] (IGNITE-20009) Sql. Rework 2-phase aggregates part 2. AVG as SUM / COUNT.

2023-07-31 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-20009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-20009: -- Description: Map/reduce implementation of some aggregates requires replacing an aggre

[jira] [Updated] (IGNITE-20009) Sql. Rework 2-phase aggregates part 2. AVG as SUM / COUNT.

2023-07-31 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-20009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-20009: -- Description: Map/reduce implementation of some aggregates requires replacing an aggre

[jira] [Assigned] (IGNITE-19481) Sql. Inconsistent behaviour of DML operations introduced by implicit type casts.

2023-07-31 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19481?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov reassigned IGNITE-19481: - Assignee: (was: Maksim Zhuravkov) > Sql. Inconsistent behaviour of DML ope

[jira] [Updated] (IGNITE-19947) Sql. Fix CAST(n AS DECIMAL(precision, scale) behaviour for scale > precision.

2023-07-31 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19947: -- Description: CAST(n AS DECIMAL(p, s) always returns `numeric field overflow` error wh

[jira] [Commented] (IGNITE-19947) Sql. Fix CAST(n AS DECIMAL(precision, scale) behaviour for scale > precision.

2023-07-31 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17749198#comment-17749198 ] Maksim Zhuravkov commented on IGNITE-19947: --- [~zstan] PG accepts the followi

[jira] [Updated] (IGNITE-19947) Sql. Fix CAST(n AS DECIMAL(precision, scale) behaviour for scale > precision.

2023-07-31 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19947: -- Description: CAST(n AS DECIMAL(p, s) always returns `numeric field overflow` error wh

[jira] [Updated] (IGNITE-19947) Sql. Fix CAST(n AS DECIMAL(precision, scale) behaviour for scale > precision.

2023-08-01 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19947: -- Description: CAST(n AS DECIMAL(p, s) always returns `numeric field overflow` error wh

[jira] [Commented] (IGNITE-19947) Sql. Fix CAST(n AS DECIMAL(precision, scale) behaviour for scale > precision.

2023-08-01 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17749564#comment-17749564 ] Maksim Zhuravkov commented on IGNITE-19947: --- [~zstan] Thanks. Updated descrip

[jira] [Updated] (IGNITE-19947) Sql. Fix CAST(n AS DECIMAL(precision, scale) behaviour for scale > precision.

2023-08-01 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19947: -- Description: CAST(n AS DECIMAL(p, s) always returns `numeric field overflow` error wh

[jira] [Updated] (IGNITE-19947) Sql. Fix CAST(n AS DECIMAL(precision, scale) behaviour for scale > precision.

2023-08-01 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-19947: -- Description: CAST(n AS DECIMAL(p, s) always returns `numeric field overflow` error wh

[jira] [Created] (IGNITE-20162) Sql. Support collection types in RowSchema.

2023-08-03 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created IGNITE-20162: - Summary: Sql. Support collection types in RowSchema. Key: IGNITE-20162 URL: https://issues.apache.org/jira/browse/IGNITE-20162 Project: Ignite Issu

[jira] [Created] (IGNITE-20163) Sql. Investigate how to JSON functions in BinaryTuple-based execution.

2023-08-03 Thread Maksim Zhuravkov (Jira)
Maksim Zhuravkov created IGNITE-20163: - Summary: Sql. Investigate how to JSON functions in BinaryTuple-based execution. Key: IGNITE-20163 URL: https://issues.apache.org/jira/browse/IGNITE-20163 Pr

[jira] [Updated] (IGNITE-20164) Sql. Incorrect propagation of RelCollation trait for Sort-based Map/reduce aggregates.

2023-08-04 Thread Maksim Zhuravkov (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-20164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maksim Zhuravkov updated IGNITE-20164: -- Affects Version/s: 3.0.0-beta1 > Sql. Incorrect propagation of RelCollation trait for

  1   2   3   4   5   6   7   8   9   10   >