[MDEV-19253] fix bug for spider where using "not like" Created: 2019-04-15  Updated: 2019-04-16  Due: 2019-04-15  Resolved: 2019-04-16

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.4.4
Fix Version/s: 10.4.5

Type: Bug Priority: Major
Reporter: Kentoku Shiba (Inactive) Assignee: Kentoku Shiba (Inactive)
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-17508 Fix bug for spider when using "not like" Closed

 Description   

test case:
t1 is a spider engine table;
CREATE TABLE `t1` (
`id` int(11) NOT NULL DEFAULT '0',
`name` char(64) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=SPIDER

query: "select * from t1 where name not like 'x%' " would dispatch "select xxx name name like 'x%' " to remote mysqld, is wrong
Generated at Thu Feb 08 08:50:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.