sea-schema icon indicating copy to clipboard operation
sea-schema copied to clipboard

sea-orm-cli generate entity -> Unknown column 'generation_expression' error

Open easykoala opened this issue 2 years ago • 1 comments

Description

sea-orm-cli generate entity
-u mysql://sea:sea@localhost/bakery
-o entity/src

SELECT column_name, column_type, is_nullable, column_key, column_default, extra, generation_expression, column_comment FROM information_schema.columns WHERE table_schema = ? AND table_name = ? ORDER BY ordinal_position ASC

thread 'main' panicked at 'called Result::unwrap() on an Err value: Database(MySqlDatabaseError { code: Some("42S22"), number: 1054, message: "Unknown column 'generation_expression' in 'field list'" })', F:\cargo\registry\src\github.com-1ecc6299db9ec823\sea-schema-0.8.0\src\mysql\discovery\executor\real.rs:32:14 note: run with RUST_BACKTRACE=1 environment variable to display a backtrace

Steps to Reproduce

  1. sea-orm-cli generate entity
    -u mysql://sea:sea@localhost/bakery
    -o entity/src
    -v

Expected Behavior

Actual Behavior

Reproduces How Often

always

Versions

mysql 5.6

Additional Information

easykoala avatar May 18 '22 09:05 easykoala

Hey @easykoala, thanks for the report! I believe this is a compatibility issue of MySQL 5.6. The minimum supported version was MySQL 5.7

billy1624 avatar May 18 '22 10:05 billy1624