3 ms·
I'm surprised FULL OUTER JOINs weren't discussed. Then I realized SQLite doesn't support them. Perhaps it should have been titled: "How to Check 2 SQLite Table
by ttfkam 3y ago
I'm surprised FULL OUTER JOINs weren't discussed. Then I realized SQLite doesn't support them. Perhaps it should have been titled:
"How to Check 2 SQLite Tables Are the Same"
I think SQLite's great, but "fully featured SQL engine" is not one of them. More like "perfectly adequate SQL engine" in an astoundingly compact operating envelope.
- cryptonector 3y agoFULL OUTER JOINs were added in SQLite3 3.39.0. I've not checked if that includes NATURAL FULL OUTER JOIN. https://sqlite.org/releaselog/3_39_0.html https://sqlite.org/releaselog/3_39_0.html