WinkerDu commented on issue #29323:
URL: https://github.com/apache/doris/issues/29323#issuecomment-1873260391
I try to create jdbc catalog for external mysql table:
```
CREATE TABLE `organization` (
`id` bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`full_name` varchar(150) NULL,
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
)
```
then execute query like:
```
explain select *
from mysql_jdbc_catalog.drp_db.organization
where (full_name not like '%虚店%' )and (full_name not like '%直播%');
```
I cannot reproduce this issue in `Branch-2.0` branch for both Nereids
planner and Old planner.
Nereids planner:
<img width="1727" alt="image"
src="https://github.com/apache/doris/assets/11454734/704cb065-a956-4cf8-9c0a-afbafce5cda7";>
Old planner:
<img width="1727" alt="image"
src="https://github.com/apache/doris/assets/11454734/7baae90b-d6dd-437d-bbcf-7a286a998fff";>
Maybe you can upgrade your Doris? @Wilson-BT
cc @yiguolei
--
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-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
