Wilson-BT commented on issue #29323:
URL: https://github.com/apache/doris/issues/29323#issuecomment-1873117502
> @Wilson-BT Need table schema and query sql information.
it`s a jdbc catalog table, table schema:
```
CREATE TABLE `organization` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
`full_name` varchar(150) NULL COMMENT '组织名称',
`update_time` datetimev2(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT
'更新时间',
`create_time` datetimev2(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT
'创建时间'
) ENGINE=JDBC_EXTERNAL_TABLE;
```
Sql ：
```
select *
from tidb_prod_tikv.ehr_sync.organization
where (full_name not like '%虚店%' )and (full_name not like '%直播%')
```
I think,you can create any jdbc catalog table, and use `not like 'xxx'` to
reproduce this issue.
--
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
