Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.4
-
Windows 10 64bit
Description
I'm evaluating the possibility of migrating and existing SQL Anywhere database to MariaDB. While trying to port the existing tables, I've come across a scenario which crashes the mysqld server and renders the database useless. I can restart the server but when I attempt to do anything with the database, it crashes again (error log attached).
Here is SQL that that will reproduce this problem:
CREATE TABLE column_code |
( column_name varchar(50) |
, code char(2) |
, description varchar(255) |
, primary key (column_name, code asc) |
);
|
CREATE TABLE sample_table |
( id integer NOT NULL AUTO_INCREMENT PRIMARY KEY |
, value1 integer |
, value2 char(1) |
, some_code char(2) NOT NULL CHECK(@column in (select code from column_code where column_name = 'sample_table.some_code')) |
);
|
I'm not defending the way this was implemented, but it is what it is. I haven't found any documentation stating this shouldn't work. Please let me know if that's the case.
Thanks!