You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I was testing the plugin with the https://github.com/aaemnnosttv/wp-sqlite-db drop-in and found that the shared auto-increment does not work. This is because sqlite has an entirely different syntax for managing auto-increment to mysql.
Equivalent code for mysql:
SELECT `auto_increment` FROM `information_schema`.`tables` WHERE `table_schema` = 'dbname' AND `table_name` = 'wp_posts';
ALTER TABLE `wp_posts` AUTO_INCREMENT = 100;
Equivalent code for sqlite:
SELECT `seq` FROM `sqlite_sequence` WHERE `name` = 'wp_posts';
UPDATE `sqlite_sequence` SET `seq` = 100 WHERE `name` = 'wp_posts';
The text was updated successfully, but these errors were encountered:
Upon inspecting the drop-in code, it looks like it rewrites some of the syntax differences itself and perhaps it should handle this too. Given that sqlite support is in flux right now, having been moved into the Performance Lab plugin and potentially later into core, it might be wise to wait for a while before deciding how to proceed.
I was testing the plugin with the https://github.com/aaemnnosttv/wp-sqlite-db drop-in and found that the shared auto-increment does not work. This is because sqlite has an entirely different syntax for managing auto-increment to mysql.
Equivalent code for mysql:
Equivalent code for sqlite:
The text was updated successfully, but these errors were encountered: