Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] uuid field of MariaDB (and MySQL) throws error - currently unknown #361

Open
datenbank-projekt opened this issue Mar 14, 2025 · 1 comment

Comments

@datenbank-projekt
Copy link

Describe the bug
trying to import MariaDB SQL to create the diagram fails because some definition is expected - but uuid is present.
In the current MariaDB this is a valid fieldtype: https://mariadb.com/kb/en/uuid-data-type/
This fails in Line 2 at "uuid"

CREATE TABLE IF NOT EXISTS address_book_fields (
address_book_id uuid DEFAULT NULL,
field_id uuid NOT NULL,
column_name varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
name varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
default_field tinyint(4) NOT NULL,
optional_default_field tinyint(4) NOT NULL,
sort_key int(11) NOT NULL,
PRIMARY KEY (field_id),
KEY IX_address_book_id (address_book_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

expected:
create a table like this

Here a screenshot of the trial to import the SQL above as MariaDB

Image

@1ilit
Copy link
Member

1ilit commented Mar 16, 2025

reported: taozhi8833998/node-sql-parser#2354

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants