Re: [I] [Bug] NOT LIKE parsing exception [doris]

[via GitHub]

baofengzhouyu commented on issue #29323:
URL: https://github.com/apache/doris/issues/29323#issuecomment-1891199071

   > 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 alt="image" width="1727" 
src="https://private-user-images.githubusercontent.com/11454734/293579623-704cb065-a956-4cf8-9c0a-afbafce5cda7.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MDUwNTY3MDAsIm5iZiI6MTcwNTA1NjQwMCwicGF0aCI6Ii8xMTQ1NDczNC8yOTM1Nzk2MjMtNzA0Y2IwNjUtYTk1Ni00Y2Y4LTljMGEtYWZiYWZjZTVjZGE3LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDAxMTIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwMTEyVDEwNDY0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWZjYTcyZTM1YzIxMTFlOTYwY2E3M2ZmN2JhYWYwZGE0OGVjMzI5NTFmNTcxOTBiNTVkNzQ3ODMxMzIwMGIwYmQmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.hjVk8p5-ZYHFnh52vx4QCcqJZRnhKygIg61VSE4iPOM";>
 Old planner: <img alt="im
 age" width="1727" 
src="https://private-user-images.githubusercontent.com/11454734/293579708-7baae90b-d6dd-437d-bbcf-7a286a998fff.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MDUwNTY3MDAsIm5iZiI6MTcwNTA1NjQwMCwicGF0aCI6Ii8xMTQ1NDczNC8yOTM1Nzk3MDgtN2JhYWU5MGItZDZkZC00MzdkLWJiY2YtN2EyODZhOTk4ZmZmLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDAxMTIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwMTEyVDEwNDY0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTZjYTk5YjE4YjZkZDI0Y2VhNWU4ZTZkNGNiZDgxMmU3ZGEwODBmNjZlNDJlNDExMzBjZDkxM2UzMDUwOTgwNzAmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.6V9n2R62Uz3RaYrp-EqOmlGiyyjFHQWuGJu0-R2mknY";>
 Maybe you can upgrade your Doris? @Wilson-BT cc @yiguolei
   
   I have the same problem.  
   version: 2.0.3
   Is there a bug in the latest 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-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