Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.8, 12.0(EOL), 12.1
-
Can result in unexpected behaviour
Description
INSTALL PLUGIN Spider SONAME 'ha_spider.so'; |
CREATE SERVER srv FOREIGN DATA WRAPPER mysql OPTIONS (SOCKET '../socket.sock',DATABASE'',USER'',PASSWORD''); |
CREATE TABLE tm (c INT) ENGINE=InnoDB; |
CREATE TABLE t (c INT) ENGINE=Spider; |
CREATE TABLE t2 (c INT KEY) ENGINE=Spider COMMENT='WRAPPER "mysql",SRV "srv",TABLE "tm"'; |
SHOW CREATE TABLE t2; |
CREATE TEMPORARY TABLE t2 (c INT) ENGINE=InnoDB; |
INSERT INTO t VALUES (1); |
SET GLOBAL collation_connection=utf16_vietnamese_ci; |
DROP TABLE t,t2; |
CREATE TEMPORARY TABLE t (a INT) ENGINE=InnoDB; |
INSERT INTO t VALUES (1),(1),(1); |
SELECT a FROM t JOIN t2; |
Leads to:
|
CS 12.0.1 ef3d171e7e739dc79d972b98174db75578afc45b (Debug, Clang) Build 28/07/2025 |
12.0.1-dbg>SELECT a FROM t JOIN t2;
|
ERROR 1298 (HY000): Unknown or incorrect time zone: '+00:00'
|
And in the error log:
|
CS 12.0.1 ef3d171e7e739dc79d972b98174db75578afc45b (Debug, Clang) Build 28/07/2025 |
2025-08-07 10:41:37 4 [ERROR] Got error 1298 when reading table './test/t2'
|
Even making small further tweaks to the testcase makes the error log error not appear/reproduce (though the client will still in various cases display it).
|
Bug Detection Matrix |
Rel o/d Build Commit UniqueID observed
|
CS 10.6 dbg 280725 49febfad21ab6131a4ca421cd08fb25107d42509 No bug found
|
CS 10.6 opt 280725 49febfad21ab6131a4ca421cd08fb25107d42509 No bug found
|
CS 10.11 dbg 280725 2147951560c013fc084c4c06dcf8e09ec403dd9f No bug found
|
CS 10.11 opt 280725 2147951560c013fc084c4c06dcf8e09ec403dd9f No bug found
|
CS 11.4 dbg 280725 57dd23dad82d69639a589b8e1c7115823915401c No bug found
|
CS 11.4 opt 280725 57dd23dad82d69639a589b8e1c7115823915401c No bug found
|
CS 11.8 dbg 280725 9d3af2c8e31ad0fd8ccc240e0b1e25914b2eacbf GOT_ERROR|Got error 1298|when reading table
|
CS 11.8 opt 280725 9d3af2c8e31ad0fd8ccc240e0b1e25914b2eacbf GOT_ERROR|Got error 1298|when reading table
|
CS 12.0 dbg 280725 ef3d171e7e739dc79d972b98174db75578afc45b GOT_ERROR|Got error 1298|when reading table
|
CS 12.0 opt 280725 ef3d171e7e739dc79d972b98174db75578afc45b GOT_ERROR|Got error 1298|when reading table
|
CS 12.1 dbg 280725 823a3a258f03037fea0995a9b70e43acebec7006 GOT_ERROR|Got error 1298|when reading table
|
CS 12.1 opt 280725 823a3a258f03037fea0995a9b70e43acebec7006 GOT_ERROR|Got error 1298|when reading table
|
ES 10.5 dbg 280725 70586522eacf09d04d49962072e14325a75d8155 No bug found
|
ES 10.5 opt 280725 70586522eacf09d04d49962072e14325a75d8155 No bug found
|
ES 10.6 dbg 280725 9b794f34b48fb7eee490b6da44edc0f33a947447 No bug found
|
ES 10.6 opt 280725 9b794f34b48fb7eee490b6da44edc0f33a947447 No bug found
|
ES 11.4 dbg 280725 a93c2343925a40812ed123885a5abcee818e0e08 No bug found
|
ES 11.4 opt 280725 a93c2343925a40812ed123885a5abcee818e0e08 No bug found
|
ES 11.8 dbg 280725 03d6d9e512a553413caf2707201e59b3fde6de59 No bug found
|
ES 11.8 opt 280725 03d6d9e512a553413caf2707201e59b3fde6de59 No bug found
|
It also seems to be a regression:
|
CS 10.6.23 49febfad21ab6131a4ca421cd08fb25107d42509 (Debug, Clang) Build 28/07/2025 |
10.6.23-dbg>SELECT a FROM t JOIN t2;
|
Empty set (0.001 sec)
|
|
CS 11.4.8 57dd23dad82d69639a589b8e1c7115823915401c (Optimized, Clang) Build 28/07/2025 |
11.4.8-opt>SELECT a FROM t JOIN t2;
|
Empty set (0.010 sec)
|
Any change in the CREATE SERVER statement makes the bug unable to reproduce due to incorrect connection information.