lujinke

Set类型解析有问题

4

``` CREATE TABLE `ttt` ( `id` int(11) NOT NULL, `c1` set('a','b','c') COLLATE utf8mb4_unicode_ci DEFAULT NULL, `c2` bit(16) DEFAULT NULL, `c3` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB...

Value order does matter in MySQL SET type value comparisons, so when parsing the binlog event we should preserve the set value order very carefully. e.g. ``` CREATE TABLE `test`...

Segmentation fault

3

```sql select * from rocket_release where end_time>start_time order by id desc ``` 日志： 2020-06-03 15:38:00 7482 [Note] 第1步: 对SQL解析优化之后得到的SQL:select `*` AS `*` from `nasa`.`rocket_release` where (`end_time` > `start_time`) order by...