ariga / atlas

Manage your database schema as code
https://atlasgo.io
Apache License 2.0
5.61k stars 248 forks source link

Unsupported MySQL 8 Heatwave #2048

Open tonybolzan opened 11 months ago

tonybolzan commented 11 months ago

MySQL 8 Heatwave database schema can contains SECONDARY Engine:

CREATE DATABASE example;

CREATE TABLE example.test (
  id int unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
  test mediumtext NOT NULL NOT SECONDARY
) ENGINE=InnoDB SECONDARY_ENGINE=RAPID;

On running schema inspect

atlas schema inspect -d "mysql://root:root@tcp(localhost:3306)/example" > example.hcl

I receive following error:

Error: mysql: unknown extra column attribute "NOT SECONDARY"

https://dev.mysql.com/doc/heatwave/en/mys-hw-exclude-table-columns.html https://dev.mysql.com/doc/heatwave/en/mys-hw-defining-secondary-engine.html

tonybolzan commented 10 months ago

Any progress on this demand?

tonybolzan commented 9 months ago

If you can't support these now, please, only allow this keywords to exists in the HCL.