bug: expected supported SQL sytax not support (UNION ALL, LIKE)

[ZhengLin-Li]

Have you read the Contributing Guidelines on issues?

• [X] I have read the Contributing Guidelines on issues.

Please confirm if bug report does NOT exists already ?

• [X] I confirm there is no existing issue for this

Describe the problem

According to https://stonedb.io/docs/developer-guide/statements-for-queries, StoneDB support UNION ALL and LIKE.

But when execting the following command, StoneDB return "ERROR 6 (HY000): The query includes syntax that is not supported by the storage engine. Either restructure the query with supported syntax, or enable the MySQL core::Query Path in config file to execute the query with reduced performance."

The command:

SELECT *
FROM t0
WHERE ((t0.c0) LIKE (t0.c0))
UNION ALL
SELECT *
FROM t0
WHERE (NOT ((t0.c0) LIKE (t0.c0)))
UNION ALL
SELECT *
FROM t0
WHERE ((((t0.c0) LIKE (t0.c0))) IS NULL);

Expected behavior

Such query is supported

How To Reproduce

CREATE TABLE t0
(
    c0 INT
);

SELECT *
FROM t0
WHERE ((t0.c0) LIKE (t0.c0))
UNION ALL
SELECT *
FROM t0
WHERE (NOT ((t0.c0) LIKE (t0.c0)))
UNION ALL
SELECT *
FROM t0
WHERE ((((t0.c0) LIKE (t0.c0))) IS NULL);

Environment

Docker v1.0.4

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

• [ ] Yes, I will!