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 2020/02/19 06:05:12 UTC
[GitHub] [incubator-doris] kangkaisen opened a new issue #2946: coalesce
date result is wrong
kangkaisen opened a new issue #2946: coalesce date result is wrong
URL: https://github.com/apache/incubator-doris/issues/2946
**Describe the bug**
```
CREATE TABLE `baseall_date` (
`k1` date not NULL COMMENT "",
`k3` int(11) not NULL COMMENT "",
`k9` float not NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`k1`, `k3`)
PARTITION BY RANGE (k1)
(
PARTITION p1 VALUES LESS THAN ("2020-02-15"),
PARTITION p2 VALUES LESS THAN ("2020-02-16"),
PARTITION p3 VALUES LESS THAN ("2020-02-17")
)
DISTRIBUTED BY HASH(`k3`) BUCKETS 10
PROPERTIES (
"replication_num" = "1"
);
insert into baseall_date (k1,k3,k9) values ('2020-02-16', 2147483647, 12.17);
```
```
select coalesce(k1, k1) from baseall_date;
```
The result is `20200216`, should be `2020-02-16`
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] chaoyli edited a comment on issue #2946: coalesce
date result is wrong
Posted by GitBox <gi...@apache.org>.
chaoyli edited a comment on issue #2946: coalesce date result is wrong
URL: https://github.com/apache/incubator-doris/issues/2946#issuecomment-588081302
I test the case in the 0.11.28 branch, it is OK.
But it is not OK in master.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] chaoyli commented on issue #2946: coalesce date
result is wrong
Posted by GitBox <gi...@apache.org>.
chaoyli commented on issue #2946: coalesce date result is wrong
URL: https://github.com/apache/incubator-doris/issues/2946#issuecomment-588081302
I test the case in the master branch, it is OK.
It may be fixed by another people.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] kangkaisen closed issue #2946: coalesce date
result is wrong
Posted by GitBox <gi...@apache.org>.
kangkaisen closed issue #2946: coalesce date result is wrong
URL: https://github.com/apache/incubator-doris/issues/2946
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org