4 ms·
I was a fan of SQLite until I needed a full outer join of two tables. It was such a pain to create a workaround when I found out it isn't supported, and the re
by flyflyFenix 6y ago
I was a fan of SQLite until I needed a full outer join of two tables. It was such a pain to create a workaround when I found out it isn't supported, and the result was still sub-optimal and needlessly complex. Is running a full outer joins such a unreasonable assumption within a DBMS?
- justin_oaks 6y agoI hear you. MySQL still doesn't have full outer joins either. I would think this would be one of the easier features to add. Of course, I'm sure the people working on MySQL or SQLite would say "Patches welcome!"
- yawaramin 6y agoActually, for SQLite at least, they wouldn't. https://www.sqlite.org/copyright.html#notopencontrib https://www.sqlite.org/copyright.html#notopencontrib