[jira] [Updated] (IGNITE-17271) Sort out sqlogic tests on Ignite 3
[
https://issues.apache.org/jira/browse/IGNITE-17271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-17271:
--
Epic Link: (was: IGNITE-17185)
> Sort out sqlogic tests on Ignite 3
> --
>
> Key: IGNITE-17271
> URL: https://issues.apache.org/jira/browse/IGNITE-17271
> Project: Ignite
> Issue Type: Task
> Components: sql
>Reporter: Taras Ledkov
>Priority: Major
> Labels: ignite-3, tech-debt
>
> All the tests from the lists below are muted by rename {{}} ->
> {{_ignored}}.
> If the muted test already contains muted part (file {{_ignored}}
> already exists) the file is renamed to {{_ignored_old}}.
> Tests to investigate:
> *Implement: {{STRING_AGG}}*
> {code}
> sql/aggregate/aggregates/test_aggregate_types.test
> sql/aggregate/aggregates/test_distinct_string_agg.test
> sql/aggregate/aggregates/test_perfect_ht.test
> sql/aggregate/aggregates/test_string_agg.test
> sql/aggregate/aggregates/test_string_agg_big.test
> sql/aggregate/aggregates/test_string_agg_many_groups.test
> {code}
> *Metadata issue*
> {code}
> Caused by: java.lang.AssertionError: Unexpected type of result: NULL
> at
> org.apache.ignite.internal.sql.engine.util.TypeUtils.columnType(TypeUtils.java:343)
> at
> org.apache.ignite.internal.sql.engine.prepare.PrepareServiceImpl.lambda$resultSetMetadata$5(PrepareServiceImpl.java:271)
> at
> org.apache.ignite.internal.sql.engine.prepare.LazyResultSetMetadata.columns(LazyResultSetMetadata.java:43)
> at
> org.apache.ignite.internal.sql.script.SqlScriptRunner.lambda$sql$2(SqlScriptRunner.java:173)
> at
> java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
> {code}
> {code}
> sql/aggregate/aggregates/test_aggregate_types_scalar.test
> sql/aggregate/aggregates/test_avg.test
> sql/aggregate/aggregates/test_scalar_aggr.test
> sql/function/generic/test_nvl.test
> sql/function/numeric/test_truncate.test
> sql/function/string/test_caseconvert.test
> sql/function/string/test_initcap.test
> sql/function/string/test_left.test
> sql/function/string/test_repeat.test
> sql/function/string/test_replace.test
> sql/function/string/test_reverse.test
> sql/function/string/test_right.test
> sql/function/string/test_substring.test
> sql/function/string/test_trim.test
> sql/types/null/test_null.test
> {code}
> *Support INTERVAL TYPE*
> {code}
> sql/function/interval/test_extract.test
> sql/types/interval/test_interval_ops.test
> {code}
> *Unsorted / Not expected results*
> {code}
> sql/function/timestamp/test_extract.test
> sql/function/timestamp/test_extract_ms.test
> sql/function/timestamp/test_timestampadd.test
> sql/insert/test_insert_type.test
> sql/order/test_order_same_value.test_slow
> sql/types/blob/test_blob.test
> sql/types/blob/test_blob_function.test
> sql/types/blob/test_blob_operator.test
> sql/types/blob/test_blob_string.test
> sql/types/collections/array.test
> sql/types/collections/array.test
> sql/types/collections/array.test
> sql/types/collections/array.test
> sql/types/decimal/cast_from_decimal.test
> sql/types/decimal/cast_to_decimal.test
> sql/types/interval/interval_constants.test
> sql/types/interval/test_interval_addition.test
> sql/types/null/test_is_null.test
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Updated] (IGNITE-17271) Sort out sqlogic tests on Ignite 3
[
https://issues.apache.org/jira/browse/IGNITE-17271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-17271:
--
Epic Link: IGNITE-17185
> Sort out sqlogic tests on Ignite 3
> --
>
> Key: IGNITE-17271
> URL: https://issues.apache.org/jira/browse/IGNITE-17271
> Project: Ignite
> Issue Type: Task
> Components: sql
>Reporter: Taras Ledkov
>Priority: Major
> Labels: ignite-3, tech-debt
>
> All the tests from the lists below are muted by rename {{}} ->
> {{_ignored}}.
> If the muted test already contains muted part (file {{_ignored}}
> already exists) the file is renamed to {{_ignored_old}}.
> Tests to investigate:
> *Implement: {{STRING_AGG}}*
> {code}
> sql/aggregate/aggregates/test_aggregate_types.test
> sql/aggregate/aggregates/test_distinct_string_agg.test
> sql/aggregate/aggregates/test_perfect_ht.test
> sql/aggregate/aggregates/test_string_agg.test
> sql/aggregate/aggregates/test_string_agg_big.test
> sql/aggregate/aggregates/test_string_agg_many_groups.test
> {code}
> *Metadata issue*
> {code}
> Caused by: java.lang.AssertionError: Unexpected type of result: NULL
> at
> org.apache.ignite.internal.sql.engine.util.TypeUtils.columnType(TypeUtils.java:343)
> at
> org.apache.ignite.internal.sql.engine.prepare.PrepareServiceImpl.lambda$resultSetMetadata$5(PrepareServiceImpl.java:271)
> at
> org.apache.ignite.internal.sql.engine.prepare.LazyResultSetMetadata.columns(LazyResultSetMetadata.java:43)
> at
> org.apache.ignite.internal.sql.script.SqlScriptRunner.lambda$sql$2(SqlScriptRunner.java:173)
> at
> java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
> {code}
> {code}
> sql/aggregate/aggregates/test_aggregate_types_scalar.test
> sql/aggregate/aggregates/test_avg.test
> sql/aggregate/aggregates/test_scalar_aggr.test
> sql/function/generic/test_nvl.test
> sql/function/numeric/test_truncate.test
> sql/function/string/test_caseconvert.test
> sql/function/string/test_initcap.test
> sql/function/string/test_left.test
> sql/function/string/test_repeat.test
> sql/function/string/test_replace.test
> sql/function/string/test_reverse.test
> sql/function/string/test_right.test
> sql/function/string/test_substring.test
> sql/function/string/test_trim.test
> sql/types/null/test_null.test
> {code}
> *Support INTERVAL TYPE*
> {code}
> sql/function/interval/test_extract.test
> sql/types/interval/test_interval_ops.test
> {code}
> *Unsorted / Not expected results*
> {code}
> sql/function/timestamp/test_extract.test
> sql/function/timestamp/test_extract_ms.test
> sql/function/timestamp/test_timestampadd.test
> sql/insert/test_insert_type.test
> sql/order/test_order_same_value.test_slow
> sql/types/blob/test_blob.test
> sql/types/blob/test_blob_function.test
> sql/types/blob/test_blob_operator.test
> sql/types/blob/test_blob_string.test
> sql/types/collections/array.test
> sql/types/collections/array.test
> sql/types/collections/array.test
> sql/types/collections/array.test
> sql/types/decimal/cast_from_decimal.test
> sql/types/decimal/cast_to_decimal.test
> sql/types/interval/interval_constants.test
> sql/types/interval/test_interval_addition.test
> sql/types/null/test_is_null.test
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[jira] [Updated] (IGNITE-17271) Sort out sqlogic tests on Ignite 3
Title: Message Title
Taras Ledkov updated an issue
Ignite / IGNITE-17271
Sort out sqlogic tests on Ignite 3
Change By:
Taras Ledkov
All the tests from the lists below are muted by rename {{}} -> {{_ignored}}.If the muted test already contains muted part (file {{_ignored}} already exists) the file is renamed to {{_ignored_old}}. Tests to investigate:*Implement: {{STRING_AGG}}*{code}sql/aggregate/aggregates/test_aggregate_types.testsql/aggregate/aggregates/test_distinct_string_agg.testsql/aggregate/aggregates/test_perfect_ht.testsql/aggregate/aggregates/test_string_agg.testsql/aggregate/aggregates/test_string_agg_big.testsql/aggregate/aggregates/test_string_agg_many_groups.test{code}*Metadata issue*{code}Caused by: java.lang.AssertionError: Unexpected type of result: NULL at org.apache.ignite.internal.sql.engine.util.TypeUtils.columnType(TypeUtils.java:343) at org.apache.ignite.internal.sql.engine.prepare.PrepareServiceImpl.lambda$resultSetMetadata$5(PrepareServiceImpl.java:271) at org.apache.ignite.internal.sql.engine.prepare.LazyResultSetMetadata.columns(LazyResultSetMetadata.java:43) at org.apache.ignite.internal.sql.script.SqlScriptRunner.lambda$sql$2(SqlScriptRunner.java:173) at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195){code}{code}sql/aggregate/aggregates/test_aggregate_types_scalar.testsql/aggregate/aggregates/test_avg.testsql/aggregate/aggregates/test_scalar_aggr.testsql/function/generic/test_nvl.testsql/function/numeric/test_truncate.testsql/function/string/test_caseconvert.testsql/function/string/test_initcap.testsql/function/string/test_left.testsql/function/string/test_repeat.testsql/function/string/test_replace.testsql/function/string/test_reverse.testsql/function/string/test_right.testsql/function/string/test_substring.testsql/function/string/test_trim.testsql/types/null/test_null.test{code}*Support INTERVAL TYPE*{code}sql/function/interval/test_extract.testsql/types/interval/test_interval_ops.test{code}*Unsorted / Not expected results*{code}sql/function/timestamp/test_extract.testsql/function/timestamp/test_extract_ms.testsql/function/timestamp/test_timestampadd.testsql/insert/test_insert_type.testsql/order/test_order_same_value.test_slowsql/types/blob/test_blob.testsql/types/blob/test_blob_function.testsql/types/blob/test_blob_operator.testsql/types/blob/test_blob_string.testsql/types/collections/array.testsql/types/collections/array.testsql/types/collections/array.testsql/types/collections/array.testsql/types/decimal/cast_from_decimal.testsql/types/decimal/cast_to_decimal.testsql/types/interval/interval_constants.testsql/types/interval/test_interval_addition.testsql/types/null/test_is_null.test{code}
[jira] [Updated] (IGNITE-17271) Sort out sqlogic tests on Ignite 3
Title: Message Title
Taras Ledkov updated an issue
Ignite / IGNITE-17271
Sort out sqlogic tests on Ignite 3
Change By:
Taras Ledkov
Tests to investigate:*Implement: {{STRING_AGG}}*{code}sql/aggregate/aggregates/test_aggregate_types.testsql/aggregate/aggregates/test_distinct_string_agg.testsql/aggregate/aggregates/test_perfect_ht.testsql/aggregate/aggregates/test_string_agg.testsql/aggregate/aggregates/test_string_agg_big.testsql/aggregate/aggregates/test_string_agg_many_groups.test{code}*Metadata issue*{code}Caused by: java.lang.AssertionError: Unexpected type of result: NULL at org.apache.ignite.internal.sql.engine.util.TypeUtils.columnType(TypeUtils.java:343) at org.apache.ignite.internal.sql.engine.prepare.PrepareServiceImpl.lambda$resultSetMetadata$5(PrepareServiceImpl.java:271) at org.apache.ignite.internal.sql.engine.prepare.LazyResultSetMetadata.columns(LazyResultSetMetadata.java:43) at org.apache.ignite.internal.sql.script.SqlScriptRunner.lambda$sql$2(SqlScriptRunner.java:173) at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195){code}{code}sql/aggregate/aggregates/test_aggregate_types_scalar.testsql/aggregate/aggregates/test_avg.testsql/aggregate/aggregates/test_scalar_aggr.testsql/function/generic/test_nvl.testsql/function/numeric/test_truncate.testsql/function/string/test_caseconvert.testsql/function/string/test_initcap.testsql/function/string/test_left.testsql/function/string/test_repeat.testsql/function/string/test_replace.testsql/function/string/test_reverse.testsql/function/string/test_right.testsql/function/string/test_substring.testsql/function/string/test_trim.test sql/types/null/test_null.test {code}*Support INTERVAL TYPE*{code}sql/function/interval/test_extract.test sql/types/interval/test_interval_ops.test {code}*Unsorted / Not expected results*{code}sql/function/timestamp/test_extract.testsql/function/timestamp/test_extract_ms.testsql/function/timestamp/test_timestampadd.testsql/insert/test_insert_type.testsql/order/test_order_same_value.test_slowsql/types/blob/test_blob.testsql/types/blob/test_blob_function.testsql/types/blob/test_blob_operator.testsql/types/blob/test_blob_string.testsql/types/collections/array.testsql/types/collections/array.testsql/types/collections/array.testsql/types/collections/array.testsql/types/decimal/cast_from_decimal.testsql/types/decimal/cast_to_decimal.test sql/types/interval/interval_constants.test sql/types/interval/test_interval_addition.testsql/types/null/test_is_null.test {code}
[jira] [Updated] (IGNITE-17271) Sort out sqlogic tests on Ignite 3
Title: Message Title
Taras Ledkov updated an issue
Ignite / IGNITE-17271
Sort out sqlogic tests on Ignite 3
Change By:
Taras Ledkov
Tests to investigate:*Implement: {{STRING_AGG}}*{code}sql/aggregate/aggregates/test_aggregate_types.testsql/aggregate/aggregates/test_distinct_string_agg.testsql/aggregate/aggregates/test_perfect_ht.testsql/aggregate/aggregates/test_string_agg.testsql/aggregate/aggregates/test_string_agg_big.testsql/aggregate/aggregates/test_string_agg_many_groups.test{code}*Metadata issue*{code}Caused by: java.lang.AssertionError: Unexpected type of result: NULL at org.apache.ignite.internal.sql.engine.util.TypeUtils.columnType(TypeUtils.java:343) at org.apache.ignite.internal.sql.engine.prepare.PrepareServiceImpl.lambda$resultSetMetadata$5(PrepareServiceImpl.java:271) at org.apache.ignite.internal.sql.engine.prepare.LazyResultSetMetadata.columns(LazyResultSetMetadata.java:43) at org.apache.ignite.internal.sql.script.SqlScriptRunner.lambda$sql$2(SqlScriptRunner.java:173) at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195){code}{code}sql/aggregate/aggregates/test_aggregate_types_scalar.testsql/aggregate/aggregates/test_avg.testsql/aggregate/aggregates/test_scalar_aggr.testsql/function/generic/test_nvl.testsql/function/numeric/test_truncate.testsql/function/string/test_caseconvert.testsql/function/string/test_initcap.testsql/function/string/test_left.testsql/function/string/test_repeat.testsql/function/string/test_replace.testsql/function/string/test_reverse.testsql/function/string/test_right.testsql/function/string/test_substring.testsql/function/string/test_trim.test{code} *Support INTERVAL TYPE*{code}sql/function/interval/test_extract.test{code}*Unsorted / Not expected results*{code}sql/function/timestamp/test_extract.testsql/function/timestamp/test_extract_ms.testsql/function/timestamp/test_timestampadd.testsql/insert/test_insert_type.testsql/order/test_order_same_value.test_slowsql/types/blob/test_blob.testsql/types/blob/test_blob_function.testsql/types/blob/test_blob_operator.testsql/types/blob/test_blob_string.testsql/types/collections/array.testsql/types/collections/array.testsql/types/collections/array.testsql/types/collections/array.testsql/types/decimal/cast_from_decimal.testsql/types/decimal/cast_to_decimal.test{code}
[jira] [Updated] (IGNITE-17271) Sort out sqlogic tests on Ignite 3
Title: Message Title
Taras Ledkov updated an issue
Ignite / IGNITE-17271
Sort out sqlogic tests on Ignite 3
Change By:
Taras Ledkov
Tests to investigate:*Implement: {{STRING_AGG}}*{code}sql/aggregate/aggregates/test_aggregate_types.testsql/aggregate/aggregates/test_distinct_string_agg.testsql/aggregate/aggregates/test_perfect_ht.testsql/aggregate/aggregates/test_string_agg.testsql/aggregate/aggregates/test_string_agg_big.testsql/aggregate/aggregates/test_string_agg_many_groups.test{code} *Metadata issue*{code} Caused by: java.lang.AssertionError: Unexpected type of result: NULL at org.apache.ignite.internal. sql .engine.util.TypeUtils.columnType(TypeUtils.java:343) at org.apache.ignite.internal.sql.engine.prepare.PrepareServiceImpl.lambda$resultSetMetadata$5(PrepareServiceImpl.java:271) at org.apache.ignite.internal.sql.engine.prepare.LazyResultSetMetadata.columns(LazyResultSetMetadata.java:43) at org.apache.ignite.internal.sql.script.SqlScriptRunner.lambda$sql$2(SqlScriptRunner.java:173) at java.base / java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195){code}{code}sql/ aggregate/aggregates/test_aggregate_types_scalar.testsql/aggregate/aggregates/test_avg.testsql/aggregate/aggregates/test_scalar_aggr.testsql/function/generic/test_nvl.testsql/function/numeric/test_truncate.testsql/function/string/test_caseconvert.testsql/function/string/test_initcap.testsql/function/string/test_left.testsql/function/string/test_repeat.testsql/function/string/test_replace.testsql/function/string/test_reverse.testsql/function/string/test_right.testsql/function/string/test_substring.testsql/function/string/test_trim.test{code}
Add Comment
[jira] [Updated] (IGNITE-17271) Sort out sqlogic tests on Ignite 3
Title: Message Title
Taras Ledkov updated an issue
Ignite / IGNITE-17271
Sort out sqlogic tests on Ignite 3
Change By:
Taras Ledkov
Tests to investigate:*Implement: {{STRING_AGG}}*{code}sql/aggregate/aggregates/test_aggregate_types.testsql/aggregate/aggregates/test_distinct_string_agg.testsql/aggregate/aggregates/test_perfect_ht.testsql/aggregate/aggregates/test_string_agg.testsql/aggregate/aggregates/test_string_agg_big.testsql/aggregate/aggregates/test_string_agg_many_groups.test{code} *Metadata issue*{code}sql/aggregate/aggregates/test_aggregate_types_scalar.testsql/aggregate/aggregates/test_avg.testsql/aggregate/aggregates/test_scalar_aggr.testsql/function/generic/test_nvl.testsql/function/numeric/test_truncate.testsql/function/string/test_caseconvert.testsql/function/string/test_initcap.testsql/function/string/test_left.testsql/function/string/test_repeat.testsql/function/string/test_replace.testsql/function/string/test_reverse.testsql/function/string/test_right.testsql/function/string/test_substring.testsql/function/string/test_trim.test{code}
Add Comment
This message was sent by Atlassian Jira (v8.20.10#820010-sha1:ace47f9)
[jira] [Updated] (IGNITE-17271) Sort out sqlogic tests on Ignite 3
Title: Message Title
Taras Ledkov updated an issue
Ignite / IGNITE-17271
Sort out sqlogic tests on Ignite 3
Change By:
Taras Ledkov
Tests to investigate: * Implement: {{STRING_AGG}} * {code}sql/aggregate/aggregates/test_aggregate_types.testsql/aggregate/aggregates/test_distinct_string_agg.testsql/aggregate/aggregates/test_perfect_ht.testsql/aggregate/aggregates/test_string_agg.testsql/aggregate/aggregates/test_string_agg_big.testsql/aggregate/aggregates/test_string_agg_many_groups.test{code}
Add Comment
This message was sent by Atlassian Jira (v8.20.10#820010-sha1:ace47f9)
[jira] [Updated] (IGNITE-17271) Sort out sqlogic tests on Ignite 3
Title: Message Title
Taras Ledkov updated an issue
Ignite / IGNITE-17271
Sort out sqlogic tests on Ignite 3
Change By:
Taras Ledkov
Tests to investigate: Implement: {{STRING_AGG}}{code}sql/aggregate/aggregates/test_aggregate_types.testsql/aggregate/aggregates/test_distinct_string_agg.testsql/aggregate/aggregates/test_perfect_ht.testsql/aggregate/aggregates/test_string_agg.testsql/aggregate/aggregates/test_string_agg_big.testsql/aggregate/aggregates/test_string_agg_many_groups.test{code}
Add Comment
This message was sent by Atlassian Jira (v8.20.10#820010-sha1:ace47f9)
[jira] [Updated] (IGNITE-17271) Sort out sqlogic tests on Ignite 3
Title: Message Title Taras Ledkov updated an issue Ignite / IGNITE-17271 Sort out sqlogic tests on Ignite 3 Change By: Taras Ledkov Labels: ignite-3 tech-debt Add Comment This message was sent by Atlassian Jira (v8.20.10#820010-sha1:ace47f9)
