Details
-
Bug
-
Status: Needs Feedback (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11, 11.4, 11.8, 12.3, 12.3.2
-
None
-
Windows Server 2019
-
Can result in hang or crash
Description
In prepare for upgrade in our enviroment from MariaDB 10.3.15 to MariaDB 12.3.2, I have one MariaDB server with new version replicating from a chain of old servers.
Query:
CREATE TABLE IF NOT EXISTS `table`( |
...
|
`geometry` point NOT NULL, |
SPATIAL KEY `xgeometry` (`geometry`) |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
gets propagated through replication on MariaDB 10.3 without a problem, but 12.3.2 crashes with exception 0xc0000005 at server.dll!Sql_cmd_create_table_like::execute() .
If I take the same query from binlog on master server and run it manually on new server (12.3.2) it passes correctly and server doesnt crash.
So this issue have to be specific for those:
- source of query is replication
- CREATE TABLE IF NOT EXISTS gets wrongly passed to method Sql_cmd_create_table_like (there is no LIKE in this CREATE TABLE)
- crash only happens when there is SPATIAL KEY