SQL Export Broken in 12.6.0.6823

neik's profile image neik posted 2 weeks ago in General Permalink

I am trying to export the schema of my SQLite database. There are two errors:

  1. Triggers are not exported at all
  2. Views are exported as tables, in my case with "ENGINE=MyISAM" (This is SQLite!)

Is this a known problem?

ansgar's profile image ansgar posted 2 weeks ago Permalink

Yes, the SQL export of DDL queries is mostly compatible to MySQL and MariaDB only. SQLite exports should only be used for data, not structure.

Please login to leave a reply, or register at first.