bug: select...in...An error was reported when the date was included

[shangyanwen]

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> SELECT * FROM t1 WHERE t1_datetime IN ('1111-11-11 11:11:11','1111-11-13 0:0:0');

ERROR 1105 (HY000): Tianmu other specific error

Expected behavior

#####Here is the result of innodb execution
SELECT * FROM t1 WHERE t1_datetime IN ('1111-11-11 11:11:11','1111-11-13 0:0:0');

+------------+----------+------------+------------+----------------------+---------+----------------------+---------------------+
| t1_tinyint | t1_int   | t1_bigint  | t1_decimal | t1_text              | t1_char | t1_varchar           | t1_datetime         |
+------------+----------+------------+------------+----------------------+---------+----------------------+---------------------+
|          1 |   123456 |  987654321 |     122.32 | zzzzzzzzzzzzzzzzzzzz | aaa     | aaaaaaaaaaaaaaaaaaaa | 1111-11-11 11:11:11 |
|          0 |  1023456 |  887654321 |     222.32 | yyyyyyyyyyyyyyyyyyyy | aaa     | bbbbbbbbbbbbbbbbbbbb | 1111-11-11 11:11:11 |
|          1 |  -123456 | -987654321 |    -122.32 | zzzzzzzzzzzzzzzzzzzz | bbb     | aaaaaaaaaaaaaaaaaaaa | 1111-11-11 11:11:11 |
|          0 | -1023456 | -887654321 |    -222.32 | xxxxxxxxxxxxxxxxxxxx | bbb     | bbbbbbbbbbbbbbbbbbbb | 1111-11-11 11:11:11 |
+------------+----------+------------+------------+----------------------+---------+----------------------+---------------------+
4 rows in set (0.00 sec)

How To Reproduce

CREATE TABLE t1
(
 t1_tinyint TINYINT DEFAULT 0,
 t1_int INT DEFAULT NULL,
 t1_bigint BIGINT,
 t1_decimal DECIMAL(5,2),
 t1_text TEXT,
 t1_char CHAR(5),
 t1_varchar VARCHAR(255) DEFAULT 'hello world!',
 t1_datetime DATETIME
)ENGINE=tianmu;

INSERT INTO t1 VALUES();
INSERT INTO t1 VALUES(NULL, NULL, NULL, NULL, '', '', '', NULL);
INSERT INTO t1 VALUES(1, 123456, 987654321, 122.32, repeat('z', 20), 'aaa', repeat('a', 20), '1111-11-11 11:11:11');
INSERT INTO t1 VALUES(0, 1023456, 887654321, 222.32, repeat('y', 20), 'aaa', repeat('b', 20), '1111-11-11 11:11:11');
INSERT INTO t1 VALUES(1, -123456, -987654321, -122.32, repeat('z', 20), 'bbb', repeat('a', 20), '1111-11-11 11:11:11');
INSERT INTO t1 VALUES(0, -1023456, -887654321, -222.32, repeat('x', 20), 'bbb', repeat('b', 20), '1111-11-11 11:11:11');

SELECT * FROM t1 WHERE t1_datetime IN ('1111-11-11 11:11:11','1111-11-13 0:0:0');

Environment

Ver 14.14 Distrib 5.7.36-StoneDB, for Linux (x86_64) using EditLine wrapper

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

• Yes, I will!