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 2022/04/07 09:43:21 UTC
[GitHub] [incubator-doris] wang1xinai opened a new issue, #8898: [Bug] 针对datetime类型的字段，进行where查询时，where create_time>"0000-00-00 00:00:00"返回结果为空
wang1xinai opened a new issue, #8898:
URL: https://github.com/apache/incubator-doris/issues/8898
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Version
5.1.0
### What's Wrong?
问题：针对datetime类型的字段，进行where查询时，where create_time>"0000-00-00 00:00:00"返回结果为空
操作过程:
use testdb;
CREATE TABLE `test_tbl` (
`create_time` datetime NOT NULL COMMENT "创建时间"
) ENGINE=OLAP
DUPLICATE KEY(`create_time`)
COMMENT "test"
DISTRIBUTED BY HASH(`create_time`) BUCKETS 1;
insert into test_tbl values("2022-02-02 00:00:00");
insert into test_tbl values("2022-02-03 00:00:00");
insert into test_tbl values("2022-02-04 00:00:00");
insert into test_tbl values("2022-02-05 00:00:00");
insert into test_tbl values("2022-02-06 00:00:00");
select * from test_2.test_tbl;
select * from test_2.test_tbl where create_time>"2022-02-02 00:00:00";
select * from test_2.test_tbl where create_time>"0000-00-00 00:00:00";
### What You Expected?
where create_time>"0000-00-00 00:00:00"返回结果正常
### How to Reproduce?
_No response_
### Anything Else?
_No response_
### Are you willing to submit PR?
- [X] 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] [incubator-doris] wang1xinai commented on issue #8898: [Bug] 针对datetime类型的字段，进行where查询时，where create_time>"0000-00-00 00:00:00"返回结果为空
Posted by GitBox <gi...@apache.org>.
wang1xinai commented on issue #8898:
URL: https://github.com/apache/incubator-doris/issues/8898#issuecomment-1093741913
> > What does version `5.1.0` mean in Doris? Is it a bug for Vectorization Version?
>
> This version is used to adapt to mysql.
666
--
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] [incubator-doris] dataroaring commented on issue #8898: [Bug] 针对datetime类型的字段，进行where查询时，where create_time>"0000-00-00 00:00:00"返回结果为空
Posted by GitBox <gi...@apache.org>.
dataroaring commented on issue #8898:
URL: https://github.com/apache/incubator-doris/issues/8898#issuecomment-1091747164
Please add a test case under regression-test.
--
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] [incubator-doris] wang1xinai commented on issue #8898: [Bug] 针对datetime类型的字段，进行where查询时，where create_time>"0000-00-00 00:00:00"返回结果为空
Posted by GitBox <gi...@apache.org>.
wang1xinai commented on issue #8898:
URL: https://github.com/apache/incubator-doris/issues/8898#issuecomment-1092398961
> What does version `5.1.0` mean in Doris? Is it a bug for Vectorization Version?
doris编译版本是：0.14.x
5.1.0是指在doris中执行命令select VERSION()，显示出的版本。
--
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] [incubator-doris] BiteTheDDDDt commented on issue #8898: [Bug] 针对datetime类型的字段，进行where查询时，where create_time>"0000-00-00 00:00:00"返回结果为空
Posted by GitBox <gi...@apache.org>.
BiteTheDDDDt commented on issue #8898:
URL: https://github.com/apache/incubator-doris/issues/8898#issuecomment-1092483826
> What does version `5.1.0` mean in Doris? Is it a bug for Vectorization Version?
This version is used to adapt to mysql.
--
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] [incubator-doris] BiteTheDDDDt commented on issue #8898: [Bug] 针对datetime类型的字段，进行where查询时，where create_time>"0000-00-00 00:00:00"返回结果为空
Posted by GitBox <gi...@apache.org>.
BiteTheDDDDt commented on issue #8898:
URL: https://github.com/apache/incubator-doris/issues/8898#issuecomment-1092509292
This case is already fixed by master version.
--
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] [incubator-doris] wangbo commented on issue #8898: [Bug] 针对datetime类型的字段，进行where查询时，where create_time>"0000-00-00 00:00:00"返回结果为空
Posted by GitBox <gi...@apache.org>.
wangbo commented on issue #8898:
URL: https://github.com/apache/incubator-doris/issues/8898#issuecomment-1091464970
What does version ```5.1.0``` mean in Doris?
Is it a bug for Vectorization Version?
--
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] [incubator-doris] wang1xinai commented on issue #8898: [Bug] 针对datetime类型的字段，进行where查询时，where create_time>"0000-00-00 00:00:00"返回结果为空
Posted by GitBox <gi...@apache.org>.
wang1xinai commented on issue #8898:
URL: https://github.com/apache/incubator-doris/issues/8898#issuecomment-1092399352
> 在正文What's Wrong?部分详细写明了操作过程
--
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