You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "lide-reed (via GitHub)" <gi...@apache.org> on 2023/04/07 09:22:03 UTC
[GitHub] [doris] lide-reed opened a new issue, #18466: [Bug] The query result is not stable, sometimes is empty
lide-reed opened a new issue, #18466:
URL: https://github.com/apache/doris/issues/18466
### 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
doris-1.2.3-rc02-d69c2ce
### What's Wrong?
MySQL [testdb]> SELECT * FROM t1 WHERE c1=(SELECT max(c1) FROM t1);
Empty set (0.02 sec)
MySQL [testdb]> SELECT * FROM t1 WHERE c1=(SELECT max(c1) FROM t1);
+---------------------+----------+
| c1 | c2 |
+---------------------+----------+
| 2023-04-06 00:00:00 | zhangsan |
+---------------------+----------+
1 row in set (0.02 sec)
### What You Expected?
MySQL [testdb]> SELECT * FROM t1 WHERE c1=(SELECT max(c1) FROM t1);
+---------------------+----------+
| c1 | c2 |
+---------------------+----------+
| 2023-04-06 00:00:00 | zhangsan |
+---------------------+----------+
1 row in set (0.02 sec)
### How to Reproduce?
CREATE TABLE t1
(
c1 datetime,
c2 string
)
UNIQUE KEY(c1)
DISTRIBUTED BY HASH(c1) BUCKETS 2;
insert into t1 values('2023-04-06 00:00:00', 'zhangsan');
insert into t1 values('2023-04-05 00:00:00', 'lisi');
SELECT * FROM t1 WHERE c1=(SELECT max(c1) FROM t1);
### 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] jacktengg commented on issue #18466: [Bug] The query result is not stable, sometimes is empty
Posted by "jacktengg (via GitHub)" <gi...@apache.org>.
jacktengg commented on issue #18466:
URL: https://github.com/apache/doris/issues/18466#issuecomment-1501585348
@lide-reed Hi, I used the same version and 1fe 3be and cannot reproduce this problem, is there any special vars of config in your env?
--
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] lide-reed commented on issue #18466: [Bug] The query result is not stable, sometimes is empty
Posted by "lide-reed (via GitHub)" <gi...@apache.org>.
lide-reed commented on issue #18466:
URL: https://github.com/apache/doris/issues/18466#issuecomment-1500110725
[profile_wrong.txt](https://github.com/apache/doris/files/11177763/profile_wrong.txt)
[profile_right.txt](https://github.com/apache/doris/files/11177764/profile_right.txt)
--
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] stalary closed issue #18466: [Bug] The query result is not stable, sometimes is empty
Posted by "stalary (via GitHub)" <gi...@apache.org>.
stalary closed issue #18466: [Bug] The query result is not stable, sometimes is empty
URL: https://github.com/apache/doris/issues/18466
--
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] zzzzzzzs commented on issue #18466: [Bug] The query result is not stable, sometimes is empty
Posted by "zzzzzzzs (via GitHub)" <gi...@apache.org>.
zzzzzzzs commented on issue #18466:
URL: https://github.com/apache/doris/issues/18466#issuecomment-1501600412
> @lide-reed Hi, I'm investigating this issue, I used the same version and 1fe 3be and cannot reproduce this problem, is there any special vars or config in your env?
I can reproduce this problem.You need to execute the query statement multiple times.
--
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