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

DB schema breaking when using older MariaDB with Laravel 11.x #51409

Closed
leomedeiros opened this issue May 14, 2024 · 2 comments
Closed

DB schema breaking when using older MariaDB with Laravel 11.x #51409

leomedeiros opened this issue May 14, 2024 · 2 comments

Comments

@leomedeiros
Copy link

Laravel Version

11.x

PHP Version

8.2.17

Database Driver & Version

No response

Description

Background

MariaDB only added the generation_expression column to the information_schema.columns table on version 10.2 (https://jira.mariadb.org/browse/MDEV-9255).

Database\Schema\Grammars\MariaDbGrammar extends Database\Schema\Grammars\MySqlGrammar.

Starting on version 11.x (6f3ddc3) , MySqlGrammar->compileColumns() started to pull generation_expression from information_schema.columns.

Problem

If you are running Laravel 11.x on a MariaDB older than 10.2, it will break because the information_schema.columns table won't have the generation_expression column.

Steps To Reproduce

Setup Laravel 11.x on a MariaDB server and try to run a Schema.hasColumn() command. It will break.

@Jubeki
Copy link
Contributor

Jubeki commented May 14, 2024

Laravel only supports MariaDB 10.3+ (See https://laravel.com/docs/11.x/database#introduction)

@driesvints
Copy link
Member

I'm afraid we don't support this version, sorry.

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

3 participants