You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2023/01/04 03:56:12 UTC
[GitHub] [doris] zhangy5 opened a new issue, #15593: [Bug] [daily] be core when query with rollup
zhangy5 opened a new issue, #15593:
URL: https://github.com/apache/doris/issues/15593
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
### Version
master doris-0.0.0-trunk-a97f582
### What's Wrong?
jenkins daily: https://ci-builds.apache.org/job/Doris/job/doris_daily_enable_vectorized/164/testReport/(root)/test_sys_load_column_func/test_replace_if_not_null_with_rollup/
query: select k1,k2,v10,v11 from s6275_olumn_func_test_replace_if_not_null_with_rollup_tb_s order by k1 nulls last,k2 nulls last
### What You Expected?
query ok
### How to Reproduce?
_No response_
### Anything Else?
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] yiguolei closed issue #15593: [Bug] [daily] be core when query with rollup
Posted by GitBox <gi...@apache.org>.
yiguolei closed issue #15593: [Bug] [daily] be core when query with rollup
URL: https://github.com/apache/doris/issues/15593
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] cambyzju commented on issue #15593: [Bug] [daily] be core when query with rollup
Posted by GitBox <gi...@apache.org>.
cambyzju commented on issue #15593:
URL: https://github.com/apache/doris/issues/15593#issuecomment-1374825335
simple way to reproduce:
1. create table:
```
CREATE TABLE `s6275_olumn_func_test_replace_if_not_null_with_rollup_tb_s` (
`k1` bigint(20) NULL,
`k2` bigint(20) NULL,
`v1` tinyint(4) SUM NULL,
`v2` tinyint(4) REPLACE NULL,
`v3` tinyint(4) REPLACE_IF_NOT_NULL NULL,
`v4` smallint(6) REPLACE_IF_NOT_NULL NULL,
`v5` int(11) REPLACE_IF_NOT_NULL NULL,
`v6` bigint(20) REPLACE_IF_NOT_NULL NULL,
`v7` largeint(40) REPLACE_IF_NOT_NULL NULL,
`v8` datetime REPLACE_IF_NOT_NULL NULL,
`v9` date REPLACE_IF_NOT_NULL NULL,
`v10` char(10) REPLACE_IF_NOT_NULL NULL,
`v11` varchar(6) REPLACE_IF_NOT_NULL NULL,
`v12` decimal(27, 9) REPLACE_IF_NOT_NULL NULL
) ENGINE=OLAP
AGGREGATE KEY(`k1`, `k2`)
COMMENT 'OLAP'
PARTITION BY RANGE(`k1`)
(PARTITION partition_a VALUES [("-9223372036854775808"), ("100000")),
PARTITION partition_b VALUES [("100000"), ("1000000000")),
PARTITION partition_c VALUES [("1000000000"), ("10000000000")),
PARTITION partition_d VALUES [("10000000000"), (MAXVALUE)))
DISTRIBUTED BY HASH(`k1`, `k2`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"in_memory" = "false",
"storage_format" = "V2",
"light_schema_change" = "true",
"disable_auto_compaction" = "false"
);
```
2. add some data:
`insert into s6275_olumn_func_test_replace_if_not_null_with_rollup_tb_s values(1,2,1,2,3,4,5,6,"7",8,"2022-10-10","11",null,1.1);`
3. trigger linked schema change:
`ALTER TABLE s6275_olumn_func_test_replace_if_not_null_with_rollup_tb_s ADD ROLLUP sc038_mn_func_test_replace_if_not_null_with_rollup_index_s (k1,k2,v10,v11);`
4. query by rollup:
`select k1,k2,v10,v11 from s6275_olumn_func_test_replace_if_not_null_with_rollup_tb_s;`
The problem is:
1. Column UniqueId not the same inside base table and rollup;
2. We use linked schema change, the segment file footer save columns and unique ids of base table;
3. While we query with rollup, we use rollup column unique id to find column inside segment file, the column type is not correct;
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org