Re:SQLite – The “server-process-edition” branch
by Groxx on Sunday August 19, 2018 @02:25AM
(#17792887)
TBH I like the ability to do this. Sometimes you truly don't care which value you get, you just want one. Sometimes you have application-level constraints which mean the one it picks is guaranteed to be correct, but you can avoid the cost of enforcing that (at insertion time and at lookup time). It's a handy tool when it's appropriate.
But hell yes, tools should warn you about this loudly, as it's not generally correct.
But hell yes, tools should warn you about this loudly, as it's not generally correct.