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 | SQL 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 |
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: ca093103 user: drh tags: faster-typeof-and-length | |
| 02:51 | Test cases for length() of a large blob in an aggregate query. check-in: d095fa4b 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: bc18215a 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
|