3 ms·

I was expecting some really esoteric SQL used in that file but the most advanced query I see contains a subquery with a union. Does SQLite not support these bas

• technion 4y ago
  I didn't spend time looking for specific features, as much as pointing out the standard is to be extremely hand wrangled and therefore prone to such issues. I have no idea if this sort of nonsense (this is an official Automattic plugin) is going to work in SQLite: https://github.com/Automattic/jetpack/blob/2447e267e40f2d133a5c15c2320b776e4c395ec8/projects/plugins/vaultpress/class.vaultpress-database.php#L160 https://github.com/Automattic/jetpack/blob/2447e267e40f2d133... But certainly creating a new table with ENGINE= which you can also find in that file isn't likely to work as intended on other platforms.
  • dncornholio 4y ago
    "This sort of nonsense". I don't think you know what this plugin is actually doing, but it seems to be a backup plugin. So I don't think seeing MySQL specific stuff there is worth mentioning. I think you're trying a little bit too hard buddy