bug: Tianmu error ERROR 6 (HY000)，when execute select..where like NULL

[davidshiz]

Have you read the Contributing Guidelines on issues?

• I have read the Contributing Guidelines on issues.

Please confirm if bug report does NOT exists already ?

• I confirm there is no existing issue for this

Describe the problem

mysql> create table tlike (val varchar(255));
Query OK, 0 rows affected (0.00 sec)

mysql> insert into tlike values ('abcde');
Query OK, 1 row affected (0.00 sec)

mysql> select * from tlike where val like NULL;
ERROR 6 (HY000): The query includes syntax that is not supported by the storagngine. Either restructure the query with supported syntax, or enable the MySQLre::Query Path in config file to execute the query with reduced performance.

Expected behavior

mysql> create table tlike (val varchar(255));
Query OK, 0 rows affected (0.03 sec)

mysql> insert into tlike values ('abcde');
Query OK, 1 row affected (0.01 sec)

mysql> select * from tlike where val like NULL;
Empty set (0.00 sec)

How To Reproduce

No response

Environment

ubuntu@ubuntu:~$ cat /etc/os-release
NAME="Ubuntu"
VERSION="20.04.4 LTS (Focal Fossa)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 20.04.4 LTS"
VERSION_ID="20.04"

ubuntu@ubuntu:~$ /stonedb57/install/bin/mysqld --version
/stonedb57/install/bin/mysqld Ver 5.7.36-StoneDB for Linux on x86_64 (build-)
build information as follow:
Repository address: https://github.com/stoneatom/stonedb.git:stonedb-5.7-dev
Branch name: stonedb-5.7-dev
Last commit ID: 5d996f9
Last commit time: Date: Sat Oct 8 14:34:42 2022 +0800
Build time: Date: Fri 14 Oct 2022 12:28:00 PM UTC

Are you interested in submitting a PR to solve the problem?

• Yes, I will!

[isredstar]

ACK