diff options
| author | willhan <526786050@qq.com> | 2019-04-16 22:10:05 +0800 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2019-11-25 15:40:01 +0100 |
| commit | 3551cd32a8df667e1257ae5118873b5d1ef1b631 (patch) | |
| tree | 47029244dbab6c22d6c2368bbb50c43854a66bfa /sql/item_cmpfunc.h | |
| parent | d30e51fafb8da04063b6b172c6fbe46ab59afd3e (diff) | |
| download | mariadb-git-3551cd32a8df667e1257ae5118873b5d1ef1b631.tar.gz | |
MDEV-17508 Fix bug for spider when using "not like"
fix bug for spider where using "not like" (#890)
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
Diffstat (limited to 'sql/item_cmpfunc.h')
| -rw-r--r-- | sql/item_cmpfunc.h | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/item_cmpfunc.h b/sql/item_cmpfunc.h index 0a5abfe6273..613fb75bcd6 100644 --- a/sql/item_cmpfunc.h +++ b/sql/item_cmpfunc.h @@ -1899,7 +1899,6 @@ class Item_func_like :public Item_bool_func2 bool escape_used_in_parsing; bool use_sampling; - bool negated; DTCollation cmp_collation; String cmp_value1, cmp_value2; @@ -1916,6 +1915,7 @@ protected: Item_func::Functype type, Item *value); public: int escape; + bool negated; Item_func_like(THD *thd, Item *a, Item *b, Item *escape_arg, bool escape_used): Item_bool_func2(thd, a, b), canDoTurboBM(FALSE), pattern(0), pattern_len(0), |