/ Check-in [45e581bf]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Merge experimental changes improving optimization of DISTINCT queries with the trunk.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 45e581bff7a75db6c9a2c45b73d034d0b8a166d1
User & Date: dan 2011-07-02 09:46:52
References
2014-02-08
18:47 New ticket [fccbde53] DISTINCT thinks a zeroblob() and blob of all zeros are different. artifact: 74e2e659 user: drh
2012-04-20
17:27 Ticket [385a5b56] A DISTINCT SELECT optimized using a UNIQUE index may allow duplicate NULL values. status still Open with 1 other change artifact: 2a938c78 user: dan
2012-03-03
01:35 Ticket [3557ad65] Incorrect DISTINCT on an indexed query with IN status still Open with 3 other changes artifact: bf8e83ba user: drh
2011-07-02
13:34
Cherrypick [45e581bff7] into the 3.7.2 branch. check-in: c593792c user: dan tags: branch-3.7.2
Context
2011-07-02
15:32
Ensure that automatic indexes are only created in scenarios where they may be used more than once. check-in: 27c65d4d user: dan tags: trunk
09:46
Merge experimental changes improving optimization of DISTINCT queries with the trunk. check-in: 45e581bf user: dan tags: trunk
06:44
Fix a broken assert() in where.c. Closed-Leaf check-in: 090b2917 user: dan tags: experimental
2011-07-01
14:22
Test case for ticket [d6ddba6706353915ceed] check-in: 953e169e user: drh tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/delete.c.

Changes to src/fkey.c.

Changes to src/select.c.

Changes to src/sqliteInt.h.

Changes to src/update.c.

Changes to src/where.c.

Changes to test/collate5.test.

Added test/distinct.test.

Changes to test/e_select.test.

Changes to test/fuzzer1.test.

Changes to test/insert4.test.

Changes to test/misc5.test.

Changes to test/selectB.test.

Changes to test/tester.tcl.