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

v1.8.0 MariaDB/MySQL internal migration scripts syntax error #616

Open
Coedgy opened this issue Jan 22, 2025 · 0 comments
Open

v1.8.0 MariaDB/MySQL internal migration scripts syntax error #616

Coedgy opened this issue Jan 22, 2025 · 0 comments

Comments

@Coedgy
Copy link

Coedgy commented Jan 22, 2025

Describe the bug
Internal migration scripts break MySQL 8.0, same issue as Vilma had previously at #569. This doesn't seem to fix my problems though, and I can only assume it's because of older MySQL version. MySQL 8.0 is the version that the majority uses, so I'd say it would be good to have compatibility with it, even if it's an older version. The error is exactly same as Vilma had, but I'm going to include it here as well:

Update ("up"):
--------------------------------------------------------------------------------
grate-internal\00_02_fix_version_table_casing_if_exists.sql: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS (SELECT 1
                  FROM INFORMATION_SCHEMA.TABLES
        ' at line 1

To Reproduce
Have a MySQL server
Run grate -cs "XXX" --dbt "mariadb" --files "XXX"

Expected behavior
The script should not break the database migration.

Desktop (please complete the following information):

  • OS: Windows 11 Enterprise
  • Version: 1.8.0

Reference to the issue where this was "solved": #569

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

1 participant