]> git.ipfire.org Git - thirdparty/sqlite.git/commit
projects / thirdparty / sqlite.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 99f8fb6) | patch
Do not consider a DISTINCT clause redundant unless a subset of the result-set is...
authordan <dan@noemail.net>
Fri, 20 Apr 2012 16:59:24 +0000 (16:59 +0000)
committerdan <dan@noemail.net>
Fri, 20 Apr 2012 16:59:24 +0000 (16:59 +0000)
commit6a36f43586c0ad583e9c31e1cb559852a7504142
tree9e624136518957370a384ac84139a9e2f70831c2tree | snapshot
parent99f8fb66a44fda5c7e9ab49682d87d31cfb8a570commit | diff
Do not consider a DISTINCT clause redundant unless a subset of the result-set is collectively subject to a UNIQUE constraint and it can be guaranteed that all columns of the subset are NOT NULL (either due to NOT NULL constraints WHERE clause terms). Fix for [385a5b56b9].

FossilOrigin-Name: 7b8548b1872cc1225355ba8311e93dd08d6526e2
manifest diff | blob | blame | history
manifest.uuid diff | blob | blame | history
src/where.c diff | blob | blame | history
test/distinct.test diff | blob | blame | history
test/tkt-385a5b56b9.test [new file with mode: 0644] blob
Mirror of https://github.com/sqlite/sqlite.git