[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)