[jira] [Updated] (IGNITE-21996) Sql. SET DATA TYPE command allow change from null to not null

2024-04-08 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-21996?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-21996: Summary: Sql. SET DATA TYPE command allow change from null to not null (was:

[jira] [Updated] (IGNITE-20384) Clean up abandoned resources for destroyed tables in catalog

2024-04-08 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-20384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-20384: Epic Link: IGNITE-21991 (was: IGNITE-21211) > Clean up abandoned resources for

[jira] [Commented] (IGNITE-19331) Sql. CAST with Boolean operations is failed.

2024-05-22 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19331?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17848484#comment-17848484 ] Iurii Gerzhedovich commented on IGNITE-19331: - [~zstan] As I see we failed such queries

[jira] [Created] (IGNITE-22328) Improve test coverage for SQL planner optimization for JOIN

2024-05-24 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22328: --- Summary: Improve test coverage for SQL planner optimization for JOIN Key: IGNITE-22328 URL: https://issues.apache.org/jira/browse/IGNITE-22328 Project:

[jira] [Updated] (IGNITE-22328) Improve test coverage for SQL planner optimization for JOIN

2024-05-24 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22328?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22328: Epic Link: IGNITE-20729 > Improve test coverage for SQL planner optimization for

[jira] [Updated] (IGNITE-22328) Improve test coverage for SQL planner optimization for JOIN

2024-05-24 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22328?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22328: Description: During implementation  planner optimization for JOIN in SQL (

[jira] [Created] (IGNITE-22283) Get rid of not supported native types

2024-05-20 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22283: --- Summary: Get rid of not supported native types Key: IGNITE-22283 URL: https://issues.apache.org/jira/browse/IGNITE-22283 Project: Ignite Issue

[jira] [Assigned] (IGNITE-22283) Get rid of not supported native types

2024-05-29 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22283?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich reassigned IGNITE-22283: --- Assignee: Iurii Gerzhedovich > Get rid of not supported native types >

[jira] [Resolved] (IGNITE-22181) BigDecimal scale is lost during create table

2024-05-30 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich resolved IGNITE-22181. - Resolution: Invalid > BigDecimal scale is lost during create table >

[jira] [Resolved] (IGNITE-21519) Improve test coverage for Java API for SQL

2024-05-22 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-21519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich resolved IGNITE-21519. - Resolution: Invalid Sessions have been removed under IGNITE-21669 > Improve

[jira] [Commented] (IGNITE-22301) Test CatalogManagerSelfTest.alwaysWaitForActivationTime is flaky

2024-06-03 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17851637#comment-17851637 ] Iurii Gerzhedovich commented on IGNITE-22301: - [~korlov]  LGTM > Test

[jira] [Created] (IGNITE-22406) Jdbc. Schema can't be set as parameter in URL

2024-06-04 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22406: --- Summary: Jdbc. Schema can't be set as parameter in URL Key: IGNITE-22406 URL: https://issues.apache.org/jira/browse/IGNITE-22406 Project: Ignite

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

2024-05-28 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19307?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich resolved IGNITE-19307. - Resolution: Cannot Reproduce > Sql. Set operations: Conversion to relational

[jira] [Commented] (IGNITE-22181) BigDecimal scale is lost during create table

2024-05-30 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17850614#comment-17850614 ] Iurii Gerzhedovich commented on IGNITE-22181: - [~aleksandr.pakhomov] which scale is

[jira] [Assigned] (IGNITE-22193) Move IgniteJdbcDriver to non internal package

2024-05-31 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich reassigned IGNITE-22193: --- Assignee: Iurii Gerzhedovich > Move IgniteJdbcDriver to non internal

[jira] [Created] (IGNITE-22501) SQL. Batching DDL statement for scripts

2024-06-13 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22501: --- Summary: SQL. Batching DDL statement for scripts Key: IGNITE-22501 URL: https://issues.apache.org/jira/browse/IGNITE-22501 Project: Ignite

[jira] [Commented] (IGNITE-21243) SQL. Bump calcite version to 1.37

2024-06-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-21243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17853705#comment-17853705 ] Iurii Gerzhedovich commented on IGNITE-21243: - [~korlov] could you please review the patch?

[jira] [Updated] (IGNITE-22200) Sql. Error in case combine CTE and SET operation

2024-06-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22200: Issue Type: Bug (was: Improvement) > Sql. Error in case combine CTE and SET

[jira] [Created] (IGNITE-22462) Sql. Add planner test to verify type coercion for set operations like UNION, INTERSECT and EXCEPT

2024-06-11 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22462: --- Summary: Sql. Add planner test to verify type coercion for set operations like UNION, INTERSECT and EXCEPT Key: IGNITE-22462 URL:

[jira] [Assigned] (IGNITE-21243) SQL. Bump calcite version to 1.37

2024-06-05 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-21243?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich reassigned IGNITE-21243: --- Assignee: Iurii Gerzhedovich > SQL. Bump calcite version to 1.37 >

[jira] [Updated] (IGNITE-22262) Startup instructions missing in SqlApiExample

2024-06-12 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22262: Description: * Standard header with node start instructions is missing. * The

[jira] [Updated] (IGNITE-22466) Sql. Support mapping on backup replicas

2024-06-11 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22466: Epic Link: IGNITE-22468 > Sql. Support mapping on backup replicas >

[jira] [Updated] (IGNITE-22466) Sql. Support mapping on backup replicas

2024-06-11 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22466: Description: At the moment, mapping service support mapping only on primary

[jira] [Assigned] (IGNITE-22462) Sql. Add planner test to verify type coercion for set operations like UNION, INTERSECT and EXCEPT

2024-06-13 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich reassigned IGNITE-22462: --- Assignee: Iurii Gerzhedovich > Sql. Add planner test to verify type

[jira] [Created] (IGNITE-22480) Sql. Optimize performance of multistatement with simple inserts

2024-06-13 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22480: --- Summary: Sql. Optimize performance of multistatement with simple inserts Key: IGNITE-22480 URL: https://issues.apache.org/jira/browse/IGNITE-22480

[jira] [Updated] (IGNITE-22480) Sql. Optimize performance of multistatement with simple inserts

2024-06-13 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22480?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22480: Description: Execution multistatement contains a big amount of INSERT statements

[jira] [Assigned] (IGNITE-22448) Sql. Incorrect error message when aggregate function is called with UUID type

2024-07-01 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich reassigned IGNITE-22448: --- Assignee: Maksim Zhuravkov > Sql. Incorrect error message when aggregate

[jira] [Updated] (IGNITE-22587) Catalog compaction

2024-07-01 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22587?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22587: Labels: ignite-3 (was: ) > Catalog compaction > -- > >

[jira] [Created] (IGNITE-22635) Sql. Unable to optimize plan error for input out of range

2024-07-01 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22635: --- Summary: Sql. Unable to optimize plan error for input out of range Key: IGNITE-22635 URL: https://issues.apache.org/jira/browse/IGNITE-22635 Project:

[jira] [Created] (IGNITE-22639) Sql. Different casts for literals and for dynamic parameters

2024-07-01 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22639: --- Summary: Sql. Different casts for literals and for dynamic parameters Key: IGNITE-22639 URL: https://issues.apache.org/jira/browse/IGNITE-22639

[jira] [Updated] (IGNITE-22639) Sql. Different casts for literals and for dynamic parameters

2024-07-01 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22639: Labels: ignite-3 (was: ) > Sql. Different casts for literals and for dynamic

[jira] [Updated] (IGNITE-22639) Sql. Different casts for literals and for dynamic parameters

2024-07-01 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22639: Description: We have different casts for literals and for dynamic parameters.

[jira] [Updated] (IGNITE-22639) Sql. Different casts for literals and for dynamic parameters

2024-07-01 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22639: Description: We have different casts for literals and for dynamic parameters.

[jira] [Updated] (IGNITE-22639) Sql. Different casts for literals and for dynamic parameters

2024-07-01 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22639: Component/s: sql > Sql. Different casts for literals and for dynamic parameters

[jira] [Resolved] (IGNITE-22421) Sql. Interval type. DDL statements should return a proper error

2024-06-20 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22421?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich resolved IGNITE-22421. - Resolution: Fixed [~mzhuravkov] Thanks for the contribution! merged commit 

[jira] [Updated] (IGNITE-22462) Sql. Add planner test to verify type coercion for set operations like UNION, INTERSECT and EXCEPT

2024-06-20 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22462: Summary:Sql. Add planner test to verify type coercion for set operations

[jira] [Updated] (IGNITE-22462) ю

2024-06-20 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22462: Summary: ю (was: Sql. Add planner test to verify type coercion for set

[jira] [Created] (IGNITE-22655) Sql. incorrect error for quoted SQL

2024-07-03 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22655: --- Summary: Sql. incorrect error for quoted SQL Key: IGNITE-22655 URL: https://issues.apache.org/jira/browse/IGNITE-22655 Project: Ignite Issue

[jira] [Updated] (IGNITE-15624) Calcite. Support different connections in logical tests.

2024-07-09 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-15624: Description: As of now we have many sql logic tests wiSupport different

[jira] [Updated] (IGNITE-15624) Calcite. Support different connections in logical tests.

2024-07-09 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-15624: Description: As of now we have bunch of sql logic tests wiSupport different

[jira] [Updated] (IGNITE-15624) Calcite. Support different connections in logical tests.

2024-07-09 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-15624: Description: As of now, we have a bunch of sql logic tests that require support

[jira] [Updated] (IGNITE-18362) Sql. Unexpected date time output formatting.

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-18362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-18362: Epic Link: IGNITE-22700 > Sql. Unexpected date time output formatting. >

[jira] [Updated] (IGNITE-15567) Calcite. Support REPEAT functionality or remove it from tests.

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-15567: Epic Link: IGNITE-22700 > Calcite. Support REPEAT functionality or remove it

[jira] [Updated] (IGNITE-20835) Sql. Update statements incorrectly use scalar subqueries in target columns

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-20835?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-20835: Epic Link: IGNITE-22700 > Sql. Update statements incorrectly use scalar

[jira] [Updated] (IGNITE-17373) Sql. Investigate interval types for Ignite 3

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-17373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-17373: Epic Link: IGNITE-22700 > Sql. Investigate interval types for Ignite 3 >

[jira] [Created] (IGNITE-22702) Rewrite CREATE TABLE FROM QUERY RESULT in tests.

2024-07-10 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22702: --- Summary: Rewrite CREATE TABLE FROM QUERY RESULT in tests. Key: IGNITE-22702 URL: https://issues.apache.org/jira/browse/IGNITE-22702 Project: Ignite

[jira] [Updated] (IGNITE-15123) Calcite. Multi-tuple insert fails on validation

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15123?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-15123: Epic Link: IGNITE-22700 > Calcite. Multi-tuple insert fails on validation >

[jira] [Updated] (IGNITE-18667) sql. left outer join with correlated subquery fails

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-18667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-18667: Epic Link: IGNITE-22700 > sql. left outer join with correlated subquery fails >

[jira] [Updated] (IGNITE-19402) Sql. Incorrect validation for query contains aggregates by outer query

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-19402: Epic Link: IGNITE-22700 > Sql. Incorrect validation for query contains

[jira] [Updated] (IGNITE-14540) Calcite engine. Support correlated subquery in having

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-14540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-14540: Epic Link: IGNITE-22700 > Calcite engine. Support correlated subquery in having

[jira] [Updated] (IGNITE-22314) Sql. Incorrect result while using ALL operator.

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22314: Epic Link: IGNITE-22700 > Sql. Incorrect result while using ALL operator. >

[jira] [Assigned] (IGNITE-22580) Sql. Add planner test to verify numeric type coercion for CASE operator

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich reassigned IGNITE-22580: --- Assignee: (was: Iurii Gerzhedovich) > Sql. Add planner test to verify

[jira] [Created] (IGNITE-22700) Improve SQL quality in AI3

2024-07-10 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22700: --- Summary: Improve SQL quality in AI3 Key: IGNITE-22700 URL: https://issues.apache.org/jira/browse/IGNITE-22700 Project: Ignite Issue Type: Epic

[jira] [Assigned] (IGNITE-22283) Get rid of not supported native types

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22283?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich reassigned IGNITE-22283: --- Assignee: (was: Iurii Gerzhedovich) > Get rid of not supported native

[jira] [Updated] (IGNITE-22580) Sql. Add planner test to verify numeric type coercion for CASE operator

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22580: Epic Link: IGNITE-22700 > Sql. Add planner test to verify numeric type coercion

[jira] [Updated] (IGNITE-21856) Unable to insert values with exponent values >=39 for FLOAT and REAL

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-21856?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-21856: Epic Link: IGNITE-22700 > Unable to insert values with exponent values >=39 for

[jira] [Updated] (IGNITE-18883) Bug. Potentially incorrect definition of rows to insert for MERGE

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-18883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-18883: Epic Link: IGNITE-22700 > Bug. Potentially incorrect definition of rows to

[jira] [Created] (IGNITE-22703) Sql. Low performance for select with mixed projection

2024-07-10 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22703: --- Summary: Sql. Low performance for select with mixed projection Key: IGNITE-22703 URL: https://issues.apache.org/jira/browse/IGNITE-22703 Project: Ignite

[jira] [Updated] (IGNITE-22703) Sql. Low performance for select with mixed projection

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22703?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22703: Labels: ignite-3 (was: sql) > Sql. Low performance for select with mixed

[jira] [Updated] (IGNITE-19701) Type exception on insert into uuid columns with gen_random_uuid

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19701?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-19701: Epic Link: IGNITE-22700 > Type exception on insert into uuid columns with

[jira] [Updated] (IGNITE-15583) Calcite. Column not found error with correlated sub query.

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-15583: Epic Link: IGNITE-22700 > Calcite. Column not found error with correlated sub

[jira] [Assigned] (IGNITE-22579) Sql. Add planner test to verify numeric type coercion for IN operator

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22579?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich reassigned IGNITE-22579: --- Assignee: (was: Iurii Gerzhedovich) > Sql. Add planner test to verify

[jira] [Updated] (IGNITE-22700) Improve SQL quality in AI3

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22700: Description: We have many bugs and discrepancies with SQL Standard. Let's

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

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-19890: Epic Link: IGNITE-22700 > Sql. VARCHAR. SUBSTRING function call with length

[jira] [Updated] (IGNITE-22417) Sql. Validator accepts f(BIGINT) but SQL runtime does not define f(long) it has f(int)

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22417: Epic Link: IGNITE-22700 > Sql. Validator accepts f(BIGINT) but SQL runtime does

[jira] [Updated] (IGNITE-15001) Calcite engine. Sort out tests for REGEXP_REPLACE function

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-15001: Epic Link: IGNITE-22700 > Calcite engine. Sort out tests for REGEXP_REPLACE

[jira] [Updated] (IGNITE-15582) Calcite. Numerous errors with any\all scalars.

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-15582: Epic Link: IGNITE-22700 > Calcite. Numerous errors with any\all scalars. >

[jira] [Updated] (IGNITE-15004) Calcite engine. LIKE ESCAPE fails with empty escape string

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15004?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-15004: Epic Link: IGNITE-22700 > Calcite engine. LIKE ESCAPE fails with empty escape

[jira] [Updated] (IGNITE-22655) Sql. incorrect error for quoted SQL

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22655?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22655: Epic Link: IGNITE-22700 > Sql. incorrect error for quoted SQL >

[jira] [Updated] (IGNITE-20889) Sql. Change type derivation for literals and expressions for overflowed BIGINT

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-20889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-20889: Epic Link: IGNITE-22700 > Sql. Change type derivation for literals and

[jira] [Updated] (IGNITE-15605) Calcite. Unexpected result with aggregate inside subquery.

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-15605: Epic Link: IGNITE-22700 > Calcite. Unexpected result with aggregate inside

[jira] [Updated] (IGNITE-22295) Sql. Allow comparable types for common columns in NATURAL / USING join conditions

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22295?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22295: Epic Link: IGNITE-22700 > Sql. Allow comparable types for common columns in

[jira] [Updated] (IGNITE-15570) JOIN with USING with common column names failed.

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15570?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-15570: Epic Link: IGNITE-22700 > JOIN with USING with common column names failed. >

[jira] [Created] (IGNITE-22706) Sql. Unignore sql test related to group by alias

2024-07-10 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22706: --- Summary: Sql. Unignore sql test related to group by alias Key: IGNITE-22706 URL: https://issues.apache.org/jira/browse/IGNITE-22706 Project: Ignite

[jira] [Updated] (IGNITE-22697) Sql. Comparison on BIGINT cast brings overflow

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22697: Epic Link: IGNITE-22700 > Sql. Comparison on BIGINT cast brings overflow >

[jira] [Updated] (IGNITE-18414) SQL. Cannot use BigInteger class as parameters for query

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-18414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-18414: Epic Link: IGNITE-22700 > SQL. Cannot use BigInteger class as parameters for

[jira] [Updated] (IGNITE-22706) Sql. Unignore sql test related to group by alias

2024-07-10 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22706?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22706: Epic Link: IGNITE-22700 > Sql. Unignore sql test related to group by alias >

[jira] [Commented] (IGNITE-15080) Calcite. Functions extends string parameters by trailing spaces

2024-07-11 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15080?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17864960#comment-17864960 ] Iurii Gerzhedovich commented on IGNITE-15080: - [~alex_pl] can I remove the assignee from

[jira] [Updated] (IGNITE-15080) Calcite. Functions extends string parameters by trailing spaces

2024-07-11 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-15080?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-15080: Epic Link: IGNITE-22700 > Calcite. Functions extends string parameters by

[jira] [Commented] (IGNITE-19162) Sql. Trim all less than millisecond information from timestamp.

2024-06-26 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17860120#comment-17860120 ] Iurii Gerzhedovich commented on IGNITE-19162: - It can't be fixed on the Ignite side, it

[jira] [Created] (IGNITE-22587) Catalog compaction

2024-06-26 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22587: --- Summary: Catalog compaction Key: IGNITE-22587 URL: https://issues.apache.org/jira/browse/IGNITE-22587 Project: Ignite Issue Type: Epic

[jira] [Updated] (IGNITE-19997) Sql. Enhancing test coverage of type coercion

2024-06-26 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-19997: Description: Currently, we have neither an understanding of how type coercion

[jira] [Updated] (IGNITE-19997) Sql. Enhancing test coverage of type coercion

2024-06-26 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-19997: Epic Link: (was: IGNITE-21956) > Sql. Enhancing test coverage of type coercion

[jira] [Created] (IGNITE-22588) AI3 JDBC performance is low

2024-06-26 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22588: --- Summary: AI3 JDBC performance is low Key: IGNITE-22588 URL: https://issues.apache.org/jira/browse/IGNITE-22588 Project: Ignite Issue Type:

[jira] [Resolved] (IGNITE-22326) KeyValue/RecordView. Update marshaller code to restrict range of values legal for year field of LocalDate/LocalDateTime types

2024-06-26 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich resolved IGNITE-22326. - Resolution: Won't Fix There are cases when restriction from SQL is not

[jira] [Resolved] (IGNITE-21956) SQL Features tests. Phase 2

2024-06-26 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-21956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich resolved IGNITE-21956. - Resolution: Done > SQL Features tests. Phase 2 > --- >

[jira] [Updated] (IGNITE-22581) Sql. Add planner test to verify numeric type coercion of source for INSERT, UPDATE and MERGE operators

2024-06-26 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22581: Description: Let's add new tests to validate type coercion of source for INSERT,

[jira] [Updated] (IGNITE-22581) Sql. Add planner test to verify numeric type coercion of source for INSERT, UPDATE and MERGE operators

2024-06-26 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22581: Summary: Sql. Add planner test to verify numeric type coercion of source for

[jira] [Created] (IGNITE-22581) Sql. Add planner test to verify numeric type coercion for INSERT, UPDATE and MERGE operators

2024-06-26 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22581: --- Summary: Sql. Add planner test to verify numeric type coercion for INSERT, UPDATE and MERGE operators Key: IGNITE-22581 URL:

[jira] [Resolved] (IGNITE-22406) Jdbc. Schema can't be set as parameter in URL

2024-06-26 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22406?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich resolved IGNITE-22406. - Resolution: Not A Problem It was intentionally implemented so. We have a

[jira] [Updated] (IGNITE-22580) Sql. Add planner test to verify numeric type coercion for CASE operator

2024-06-26 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22580: Description: Let's add new tests to validate type coercion for CASE operator.

[jira] [Created] (IGNITE-22579) Sql. Add planner test to verify numeric type coercion for IN operator

2024-06-26 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22579: --- Summary: Sql. Add planner test to verify numeric type coercion for IN operator Key: IGNITE-22579 URL: https://issues.apache.org/jira/browse/IGNITE-22579

[jira] [Updated] (IGNITE-22579) Sql. Add planner test to verify numeric type coercion for IN operator

2024-06-26 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22579?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22579: Description: Let's add new tests to validate type coercion for IN operator. The

[jira] [Commented] (IGNITE-22262) Sql. Fix SQL API usage example (SqlApiExample)

2024-06-26 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22262?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17860111#comment-17860111 ] Iurii Gerzhedovich commented on IGNITE-22262: - [~xtern] LGTM. Thanks! > Sql. Fix SQL API

[jira] [Updated] (IGNITE-19997) Sql. Enhancing test coverage of type coercion

2024-06-26 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-19997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-19997: Description: Currently, we have neither an understanding of how type coercion

[jira] [Created] (IGNITE-22580) Sql. Add planner test to verify numeric type coercion for CASE operator

2024-06-26 Thread Iurii Gerzhedovich (Jira)
Iurii Gerzhedovich created IGNITE-22580: --- Summary: Sql. Add planner test to verify numeric type coercion for CASE operator Key: IGNITE-22580 URL: https://issues.apache.org/jira/browse/IGNITE-22580

[jira] [Assigned] (IGNITE-22588) AI3 JDBC performance is low

2024-06-28 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22588?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich reassigned IGNITE-22588: --- Assignee: Konstantin Orlov > AI3 JDBC performance is low >

[jira] [Updated] (IGNITE-22611) SQL. Statement should not extends AutoClosable

2024-06-28 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22611?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22611: Labels: ignite-3 (was: ) > SQL. Statement should not extends AutoClosable >

[jira] [Updated] (IGNITE-22611) SQL. Statement should not extends AutoClosable

2024-06-28 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22611?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich updated IGNITE-22611: Component/s: sql > SQL. Statement should not extends AutoClosable >

[jira] [Resolved] (IGNITE-22639) Sql. Different casts for literals and for dynamic parameters

2024-07-08 Thread Iurii Gerzhedovich (Jira)
[ https://issues.apache.org/jira/browse/IGNITE-22639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Iurii Gerzhedovich resolved IGNITE-22639. - Resolution: Cannot Reproduce It's already fixed and doesn't reproduce. > Sql.

<    1   2   3   4   5   >