sqlite.org

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

Overview

Comment:Correctly handle SELECT DISTINCT ... ORDER BY when all of the result set terms are constant and there are more result set terms than ORDER BY terms. Fix for these tickets: [c36cdb4afd504dc1], [4051a7f931d9ba24], [d6fd512f50513ab7].
Downloads: See separate download page
Timelines: family | ancestors | descendants | path-to-release | both | trunk
Files: files | file ages | folders
SHA3-256: 12ad822d9b827777526ca5ed5bf3e678 d600294fc9b5c25482dfff2a021328a4
User & Date: drh 2023-03-16 20:54:29.173

Context

2023-03-17

00:01 Fix assert() statements that would (incorrectly) fire if an IF NOT EXISTS trigger that already exists contained two or more RETURNING clauses. Tickets [89d259d45b855a0d] and [d15b3a4ea901ef0d]. (check-in: 648899e4de ... user: drh tags: trunk)

2023-03-16

21:05 Correctly handle SELECT DISTINCT ... ORDER BY when all of the result set terms are constant and there are more result set terms than ORDER BY terms. (check-in: 097512b604 ... user: drh tags: branch-3.41)
20:54 Correctly handle SELECT DISTINCT ... ORDER BY when all of the result set terms are constant and there are more result set terms than ORDER BY terms. Fix for these tickets: [c36cdb4afd504dc1], [4051a7f931d9ba24], [d6fd512f50513ab7]. (check-in: 12ad822d9b ... user: drh tags: trunk)
12:28 Additional debug/test output from the query invariant checker showing the row-number that is being checked. (check-in: e4b6eb58e6 ... user: drh tags: trunk)

Changes

Changes to src/where.c.

Changes to test/distinct.test.

Read the original on sqlite.org ↗