Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Test cases for length() of a large blob in an aggregate query. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | faster-typeof-and-length |
Files: | files | file ages | folders |
SHA1: |
d095fa4bfabd765c8e935ed227a33416 |
User & Date: | drh 2012-03-28 02:51:51.807 |
Context
2012-03-28
| ||
13:41 | Improvements to comments. Minor changes to code in the hot path of OP_Column - with the hope of get a few cycles of performance improvement. (check-in: ca09310343 user: drh tags: faster-typeof-and-length) | |
02:51 | Test cases for length() of a large blob in an aggregate query. (check-in: d095fa4bfa user: drh tags: faster-typeof-and-length) | |
02:43 | Fix the typeof() and length() optimization so that it works for aggregates as well as scalar queries. (check-in: bc18215a8a user: drh tags: faster-typeof-and-length) | |
Changes
Changes to test/func.test.
︙ | ︙ | |||
1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 | db eval {SELECT typeof(+x) FROM t29 ORDER BY id} } {integer null real blob text} do_test func-29.4 { set x [lindex [sqlite3_db_status db CACHE_MISS 1] 1] if {$x>100} {set x many} set x } {many} finish_test | > > > > > > > > > > > | 1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 | db eval {SELECT typeof(+x) FROM t29 ORDER BY id} } {integer null real blob text} do_test func-29.4 { set x [lindex [sqlite3_db_status db CACHE_MISS 1] 1] if {$x>100} {set x many} set x } {many} do_test func-29.5 { db close sqlite3 db test.db sqlite3_db_status db CACHE_MISS 1 db eval {SELECT sum(length(x)) FROM t29} } {1000009} do_test func-29.6 { set x [lindex [sqlite3_db_status db CACHE_MISS 1] 1] if {$x<5} {set x 1} set x } {1} finish_test |