That's actually neat, I can finally do a full sweep of something I found after the recent post about Lobsters migration, I came across a query that evaluates differently in MariaDB and SQLite.
SELECT CASE WHEN 1 / 5 * 100.0 = 1 * 100.0 / 5 THEN 1 ELSE 0 END AS Huh
In some engines that evaluates to 1 and in some it evaluates to 0.
In some ( oracle ), it doesn't evaluate at all without a trick to bind it to a table.
That's actually neat, I can finally do a full sweep of something I found after the recent post about Lobsters migration, I came across a query that evaluates differently in MariaDB and SQLite.
In some engines that evaluates to 1 and in some it evaluates to 0.In some ( oracle ), it doesn't evaluate at all without a trick to bind it to a table.