Unknown column 'expression' in 'field list'

[hooliy]

Describe the bug

yarn mikro-orm schema:fresh -r

Error: select table_name as table_name, nullif(table_schema, schema()) as schema_name, index_name as index_name, non_unique as non_unique, column_name as column_name, expression as expression
from information_schema.statistics where table_schema = database()
and table_name in ('book')
order by schema_name, table_name, index_name, seq_in_index - Unknown column 'expression' in 'field list'

Reproduction

no

What driver are you using?

@mikro-orm/mysql

MikroORM version

@mikro-orm/cli@6.0.1

Node.js version

v20.5.1

Operating system

No response

Validations

• Read the Contributing Guidelines.
• Read the docs.
• Check that there isn't already an issue that reports the same bug to avoid creating a duplicate.
• Check that this is a concrete bug. For Q&A open a GitHub Discussion or join our Slack.
• The provided reproduction is a minimal reproducible example of the bug.

[B4nan]

Sounds like you are using an old MySQL version, we test with MySQL 8 only. If you are using MySQL 5.7, you should upgrade, it already reached the end of life a few months ago.

[hooliy]

Sounds like you are using an old MySQL version, we test with MySQL 8 only. If you are using MySQL 5.7, you should upgrade, it already reached the end of life a few months ago.

MySQL version: 8.0.2-dmr

[B4nan]

Then try upgrading, not sure what dmr means, but based on mysql website, v8.0.2 is ~7 years old, so pretty dated as well.

https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-2.html

[B4nan]

Looking at this, you will need MySQL v8.0.13 or newer (that version is also more than 5 years old btw).

edit: let's see how common this will be, we could make it conditional, just like we handle support for check constraints

[hooliy]

Looking at this, you will need MySQL v8.0.13 or newer (that version is also more than 5 years old btw).

edit: let's see how common this will be, we could make it conditional, just like we handle support for check constraints

Thank you. After testing, there are no bugs in MySQL v8.0.13.