3 ms·
not according to https://www.sqlite.org/omitted.html https://www.sqlite.org/omitted.html
by deknos 6y ago
not according to https://www.sqlite.org/omitted.html https://www.sqlite.org/omitted.html
- simonw 6y agoIf you can do a LEFT OUTER JOIN I don't see that there's any benefit in being able to do RIGHT OUTER JOIN - surely you can change the table order yourself? It looks like you can emulate FULL OUTER JOIN by doing a UNION between two LEFT joins, see https://www.sqlitetutorial.net/sqlite-full-outer-join/ https://www.sqlitetutorial.net/sqlite-full-outer-join/
- deknos 6y agomy worries are more, if i use it, like everywhere, that at some point, some "ORM Layer" like for example hibernate will use the right outer join for something and then break since this is not implemented. and there are also a few other quirks where i am not sure, if some systems do not need them (grant/revoke is of course meaning less)
- aembleton 6y agoWouldn't the ORM layer have knowledge of the SQL language of your DB engine? I thought that was one of the big wins of using an ORM.
- deknos 6y agoIn theory. In practice i do not tend to trust all these layer not so much as i have seen to many "edge cases" fail. :( but let's hope that works :D