SQLite

All files named ”test/nulls1.test”
Login

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

History for test/nulls1.test

2021-03-20
15:11
[7a5e4346ee] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 9526)
2020-03-02
01:16
[82c5bc3314] part of check-in [704bb9a39a] Ensure that the NULL-scan pass counter is initialized when a ORDER BY NULLS LAST is used on the right table of a LEFT JOIN. Ticket [e12a0ae526bb51c7]. (check-in: [704bb9a39a] user: drh branch: trunk, size: 9556)
2019-12-28
18:08
[fe4153fd59] part of check-in [82be135dee] Change an assert() in where.c to a testcase() macro, since the condition may be false. This was a problem with the assert() only, there is no bug in release builds that omit assert(). (check-in: [82be135dee] user: dan branch: trunk, size: 8191)
2019-12-19
17:42
[c8fc1b223f] part of check-in [4417c5bf0a] Detect the invalid use of NULLS LAST on an INTEGER PRIMARY KEY definition of a WITHOUT ROWID table. (check-in: [4417c5bf0a] user: drh branch: trunk, size: 7201)
2019-10-29
16:18
[a325e2f214] part of check-in [4d424f3047] Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab] (check-in: [4d424f3047] user: drh branch: trunk, size: 6983)
2019-08-29
21:16
[725fb4d99d] part of check-in [e8e9f77d52] Improve vdbe branch coverage of NULLS LAST code. (check-in: [e8e9f77d52] user: dan branch: trunk, size: 6985)
2019-08-20
20:09
[5b978fbae9] part of check-in [0dbbb51f4d] Further tests for the special null-handling on this branch. (check-in: [0dbbb51f4d] user: dan branch: nulls-last, size: 6596)
17:51
[abf8ab5643] part of check-in [09d660ecde] Add tests for sort-by-index cases that use IN() and non-default NULL handling. (check-in: [09d660ecde] user: dan branch: nulls-last, size: 5603)
15:47
[085aae8cd3] part of check-in [a9a82ee88d] Do not pass ORDER BY clauses with non-standard NULL handling to virtual table implementations. (check-in: [a9a82ee88d] user: dan branch: nulls-last, size: 4256)
2019-08-19
19:59
[d2f1da489f] part of check-in [75d665a494] Fix problems with window frames that use ORDER BY ... NULLS LAST etc. (check-in: [75d665a494] user: dan branch: nulls-last, size: 3353)
17:26
[6d226787ee] part of check-in [bb9767a287] Prevent NULLS FIRST/LAST from being used in CREATE INDEX and other statements. (check-in: [bb9767a287] user: dan branch: nulls-last, size: 3363)
2019-08-16
21:07
[522f0da688] part of check-in [81069d7196] Add support for using indexes for some ORDER BY clauses that use non-default NULL handling. Still some problems on this branch. (check-in: [81069d7196] user: dan branch: nulls-last, size: 1968)
2019-08-12
16:36
Added: [eac9f46d9b] part of check-in [07babb0f89] Experimental implementation of NULLS FIRST/LAST. This branch still has problems - the most significant of which is that ORDER BY clauses with a non-default NULLS FIRST/LAST qualifier can never use an index. (check-in: [07babb0f89] user: dan branch: nulls-last, size: 1448)