diff options
| author | Jan Mercl <0xjnml@gmail.com> | 2020-07-31 14:18:38 +0200 |
|---|---|---|
| committer | Jan Mercl <0xjnml@gmail.com> | 2020-07-31 14:18:38 +0200 |
| commit | 1349149922b282e74a77c7d51c316d883fba5b89 (patch) | |
| tree | 6aef7056dbfe750984954ba25cbb97feb251d4cf /speedtest1 | |
| parent | 3337c85b5e539021d90ccec9891d73b14c64671b (diff) | |
use crt v3.24.9
Diffstat (limited to 'speedtest1')
| -rw-r--r-- | speedtest1/main_linux_amd64.go | 636 |
1 files changed, 316 insertions, 320 deletions
diff --git a/speedtest1/main_linux_amd64.go b/speedtest1/main_linux_amd64.go index c569b76..eb44b50 100644 --- a/speedtest1/main_linux_amd64.go +++ b/speedtest1/main_linux_amd64.go @@ -1,4 +1,4 @@ -// Code generated by 'ccgo -o speedtest1/main_linux_amd64.go testdata/sqlite-src-3320300/test/speedtest1.c -Itestdata/sqlite-amalgamation-3320300 -l modernc.org/sqlite/lib -DHAVE_USLEEP -DLONGDOUBLE_TYPE=double -DSQLITE_DEFAULT_MEMSTATUS=0 -DSQLITE_DEFAULT_PAGE_SIZE=1024 -DSQLITE_DEFAULT_WAL_SYNCHRONOUS=1 -DSQLITE_DQS=0 -DSQLITE_ENABLE_UNLOCK_NOTIFY -DSQLITE_LIKE_DOESNT_MATCH_BLOBS -DSQLITE_MAX_EXPR_DEPTH=0 -DSQLITE_MUTEX_APPDEF=1 -DSQLITE_MUTEX_NOOP -DSQLITE_OMIT_PROGRESS_CALLBACK -DSQLITE_OMIT_UTF16 -DSQLITE_TEST -DSQLITE_THREADSAFE=2 -ccgo-long-double-is-double', DO NOT EDIT. +// Code generated by 'ccgo -o speedtest1/main_linux_amd64.go testdata/sqlite-src-3320300/test/speedtest1.c -Itestdata/sqlite-amalgamation-3320300 -l modernc.org/sqlite/lib -DHAVE_USLEEP -DLONGDOUBLE_TYPE=double -DNDEBUG -DSQLITE_CORE -DSQLITE_DEFAULT_MEMSTATUS=0 -DSQLITE_DEFAULT_PAGE_SIZE=1024 -DSQLITE_DEFAULT_WAL_SYNCHRONOUS=1 -DSQLITE_DQS=0 -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_STMTVTAB -DSQLITE_ENABLE_UNLOCK_NOTIFY -DSQLITE_HAVE_ZLIB=1 -DSQLITE_LIKE_DOESNT_MATCH_BLOBS -DSQLITE_MAX_EXPR_DEPTH=0 -DSQLITE_MAX_MMAP_SIZE=8589934592 -DSQLITE_MUTEX_APPDEF=1 -DSQLITE_MUTEX_NOOP -DSQLITE_NO_SYNC=1 -DSQLITE_OS_UNIX=1 -DSQLITE_SERIES_CONSTRAINT_VERIFY=1 -DSQLITE_SERVER=1 -DSQLITE_TEMP_STORE=1 -DSQLITE_TEST -DSQLITE_THREADSAFE=1 -ccgo-long-double-is-double', DO NOT EDIT. package main @@ -3594,16 +3594,14 @@ func speedtest1_run(tls *crt.TLS) { /* speedtest1.c:396:6: */ if g.bSqlOnly != 0 { return } - if !(g.pStmt != 0) { - crt.X__assert_fail(tls, ts+2513 /* "g.pStmt" */, ts+2521 /* "testdata/sqlite-..." */, uint32(399), uintptr(unsafe.Pointer(&__func__))) - } + g.nResult = 0 for sqlite3.Xsqlite3_step(tls, g.pStmt) == 100 { n = sqlite3.Xsqlite3_column_count(tls, g.pStmt) for i = 0; i < n; i++ { var z uintptr = sqlite3.Xsqlite3_column_text(tls, g.pStmt, i) if z == uintptr(0) { - z = ts + 2567 /* "nil" */ + z = ts + 2513 /* "nil" */ } len = int32(crt.Xstrlen(tls, z)) if (uint64(g.nResult + len)) < (uint64(unsafe.Sizeof([3000]int8{})) - uint64(2)) { @@ -3627,8 +3625,6 @@ func speedtest1_run(tls *crt.TLS) { /* speedtest1.c:396:6: */ speedtest1_shrink_memory(tls) } -var __func__ = *(*[15]int8)(unsafe.Pointer(ts + 2571 /* "speedtest1_run" */)) /* speedtest1.c:396:26 */ - // The sqlite3_trace() callback function func traceCallback(tls *crt.TLS, NotUsed uintptr, zSql uintptr) { /* speedtest1.c:430:13: */ bp := tls.Alloc(16) @@ -3680,11 +3676,11 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sz = crt.AssignInt32(&n, (g.szTest * 500)) *(*int8)(unsafe.Pointer(bp + 568 /* &zNum[0] */ + uintptr(0))) = int8(0) maxb = int32(roundup_allones(tls, uint32(sz))) - speedtest1_begin_test(tls, 100, ts+2586 /* "%d INSERTs into ..." */, crt.VaList(bp, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) - speedtest1_exec(tls, ts+2628, /* "CREATE%s TABLE t..." */ + speedtest1_begin_test(tls, 100, ts+2517 /* "%d INSERTs into ..." */, crt.VaList(bp, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) + speedtest1_exec(tls, ts+2559, /* "CREATE%s TABLE t..." */ crt.VaList(bp+8, isTemp(tls, 9), g.zNN, g.zNN, g.zNN)) - speedtest1_prepare(tls, ts+2686 /* "INSERT INTO t1 V..." */, crt.VaList(bp+40, n)) + speedtest1_prepare(tls, ts+2617 /* "INSERT INTO t1 V..." */, crt.VaList(bp+40, n)) for i = 1; i <= n; i++ { x1 = swizzle(tls, uint32(i), uint32(maxb)) speedtest1_numbername(tls, x1, bp+568 /* &zNum[0] */, int32(unsafe.Sizeof([2000]int8{}))) @@ -3693,16 +3689,16 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sqlite3.Xsqlite3_bind_text(tls, g.pStmt, 3, bp+568 /* &zNum[0] */, -1, uintptr(0)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) n = sz - speedtest1_begin_test(tls, 110, ts+2739 /* "%d ordered INSER..." */, crt.VaList(bp+48, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) + speedtest1_begin_test(tls, 110, ts+2670 /* "%d ordered INSER..." */, crt.VaList(bp+48, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) speedtest1_exec(tls, - ts+2776, /* "CREATE%s TABLE t..." */ + ts+2707, /* "CREATE%s TABLE t..." */ crt.VaList(bp+56, isTemp(tls, 5), g.zNN, g.zPK, g.zNN, g.zNN, g.zWR)) - speedtest1_prepare(tls, ts+2839 /* "INSERT INTO t2 V..." */, crt.VaList(bp+104, n)) + speedtest1_prepare(tls, ts+2770 /* "INSERT INTO t2 V..." */, crt.VaList(bp+104, n)) for i = 1; i <= n; i++ { x1 = swizzle(tls, uint32(i), uint32(maxb)) speedtest1_numbername(tls, x1, bp+568 /* &zNum[0] */, int32(unsafe.Sizeof([2000]int8{}))) @@ -3711,16 +3707,16 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sqlite3.Xsqlite3_bind_text(tls, g.pStmt, 3, bp+568 /* &zNum[0] */, -1, uintptr(0)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) n = sz - speedtest1_begin_test(tls, 120, ts+2884 /* "%d unordered INS..." */, crt.VaList(bp+112, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) + speedtest1_begin_test(tls, 120, ts+2815 /* "%d unordered INS..." */, crt.VaList(bp+112, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) speedtest1_exec(tls, - ts+2923, /* "CREATE%s TABLE t..." */ + ts+2854, /* "CREATE%s TABLE t..." */ crt.VaList(bp+120, isTemp(tls, 3), g.zNN, g.zPK, g.zNN, g.zNN, g.zWR)) - speedtest1_prepare(tls, ts+2986 /* "INSERT INTO t3 V..." */, crt.VaList(bp+168, n)) + speedtest1_prepare(tls, ts+2917 /* "INSERT INTO t3 V..." */, crt.VaList(bp+168, n)) for i = 1; i <= n; i++ { x1 = swizzle(tls, uint32(i), uint32(maxb)) speedtest1_numbername(tls, x1, bp+568 /* &zNum[0] */, int32(unsafe.Sizeof([2000]int8{}))) @@ -3729,15 +3725,15 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sqlite3.Xsqlite3_bind_text(tls, g.pStmt, 3, bp+568 /* &zNum[0] */, -1, uintptr(0)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) n = 25 - speedtest1_begin_test(tls, 130, ts+3031 /* "%d SELECTS, nume..." */, crt.VaList(bp+176, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) + speedtest1_begin_test(tls, 130, ts+2962 /* "%d SELECTS, nume..." */, crt.VaList(bp+176, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) speedtest1_prepare(tls, - ts+3070 /* "SELECT count(*),..." */, crt.VaList(bp+184, n)) + ts+3001 /* "SELECT count(*),..." */, crt.VaList(bp+184, n)) for i = 1; i <= n; i++ { if ((i - 1) % g.nRepeat) == 0 { x1 = (speedtest1_random(tls) % uint32(maxb)) @@ -3747,15 +3743,15 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 2, int32(x2)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) n = 10 - speedtest1_begin_test(tls, 140, ts+3175 /* "%d SELECTS, LIKE..." */, crt.VaList(bp+192, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) + speedtest1_begin_test(tls, 140, ts+3106 /* "%d SELECTS, LIKE..." */, crt.VaList(bp+192, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) speedtest1_prepare(tls, - ts+3203 /* "SELECT count(*),..." */, crt.VaList(bp+200, n)) + ts+3134 /* "SELECT count(*),..." */, crt.VaList(bp+200, n)) for i = 1; i <= n; i++ { if ((i - 1) % g.nRepeat) == 0 { x1 = (speedtest1_random(tls) % uint32(maxb)) @@ -3767,15 +3763,15 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sqlite3.Xsqlite3_bind_text(tls, g.pStmt, 1, bp+568 /* &zNum[0] */, (len + 1), uintptr(0)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) n = 10 - speedtest1_begin_test(tls, 142, ts+3298 /* "%d SELECTS w/ORD..." */, crt.VaList(bp+208, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) + speedtest1_begin_test(tls, 142, ts+3229 /* "%d SELECTS w/ORD..." */, crt.VaList(bp+208, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) speedtest1_prepare(tls, - ts+3331 /* "SELECT a, b, c F..." */, crt.VaList(bp+216, n)) + ts+3262 /* "SELECT a, b, c F..." */, crt.VaList(bp+216, n)) for i = 1; i <= n; i++ { if ((i - 1) % g.nRepeat) == 0 { x1 = (speedtest1_random(tls) % uint32(maxb)) @@ -3787,15 +3783,15 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sqlite3.Xsqlite3_bind_text(tls, g.pStmt, 1, bp+568 /* &zNum[0] */, (len + 1), uintptr(0)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) n = 10 // g.szTest/5; - speedtest1_begin_test(tls, 145, ts+3395 /* "%d SELECTS w/ORD..." */, crt.VaList(bp+224, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) + speedtest1_begin_test(tls, 145, ts+3326 /* "%d SELECTS w/ORD..." */, crt.VaList(bp+224, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) speedtest1_prepare(tls, - ts+3438 /* "SELECT a, b, c F..." */, crt.VaList(bp+232, n)) + ts+3369 /* "SELECT a, b, c F..." */, crt.VaList(bp+232, n)) for i = 1; i <= n; i++ { if ((i - 1) % g.nRepeat) == 0 { x1 = (speedtest1_random(tls) % uint32(maxb)) @@ -3807,25 +3803,25 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sqlite3.Xsqlite3_bind_text(tls, g.pStmt, 1, bp+568 /* &zNum[0] */, (len + 1), uintptr(0)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) - speedtest1_begin_test(tls, 150, ts+3511 /* "CREATE INDEX fiv..." */, 0) - speedtest1_exec(tls, ts+3535 /* "BEGIN;" */, 0) - speedtest1_exec(tls, ts+3542 /* "CREATE UNIQUE IN..." */, 0) - speedtest1_exec(tls, ts+3576 /* "CREATE INDEX t1c..." */, 0) - speedtest1_exec(tls, ts+3603 /* "CREATE UNIQUE IN..." */, 0) - speedtest1_exec(tls, ts+3637 /* "CREATE INDEX t2c..." */, 0) - speedtest1_exec(tls, ts+3669 /* "CREATE INDEX t3b..." */, 0) - speedtest1_exec(tls, ts+3699 /* "COMMIT;" */, 0) + speedtest1_begin_test(tls, 150, ts+3442 /* "CREATE INDEX fiv..." */, 0) + speedtest1_exec(tls, ts+3466 /* "BEGIN;" */, 0) + speedtest1_exec(tls, ts+3473 /* "CREATE UNIQUE IN..." */, 0) + speedtest1_exec(tls, ts+3507 /* "CREATE INDEX t1c..." */, 0) + speedtest1_exec(tls, ts+3534 /* "CREATE UNIQUE IN..." */, 0) + speedtest1_exec(tls, ts+3568 /* "CREATE INDEX t2c..." */, 0) + speedtest1_exec(tls, ts+3600 /* "CREATE INDEX t3b..." */, 0) + speedtest1_exec(tls, ts+3630 /* "COMMIT;" */, 0) speedtest1_end_test(tls) n = (sz / 5) - speedtest1_begin_test(tls, 160, ts+3707 /* "%d SELECTS, nume..." */, crt.VaList(bp+240, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) + speedtest1_begin_test(tls, 160, ts+3638 /* "%d SELECTS, nume..." */, crt.VaList(bp+240, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) speedtest1_prepare(tls, - ts+3744 /* "SELECT count(*),..." */, crt.VaList(bp+248, n)) + ts+3675 /* "SELECT count(*),..." */, crt.VaList(bp+248, n)) for i = 1; i <= n; i++ { if ((i - 1) % g.nRepeat) == 0 { x1 = (speedtest1_random(tls) % uint32(maxb)) @@ -3835,15 +3831,15 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 2, int32(x2)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) n = (sz / 5) - speedtest1_begin_test(tls, 161, ts+3849 /* "%d SELECTS, nume..." */, crt.VaList(bp+256, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) + speedtest1_begin_test(tls, 161, ts+3780 /* "%d SELECTS, nume..." */, crt.VaList(bp+256, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) speedtest1_prepare(tls, - ts+3881 /* "SELECT count(*),..." */, crt.VaList(bp+264, n)) + ts+3812 /* "SELECT count(*),..." */, crt.VaList(bp+264, n)) for i = 1; i <= n; i++ { if ((i - 1) % g.nRepeat) == 0 { x1 = (speedtest1_random(tls) % uint32(maxb)) @@ -3853,15 +3849,15 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 2, int32(x2)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) n = (sz / 5) - speedtest1_begin_test(tls, 170, ts+3986 /* "%d SELECTS, text..." */, crt.VaList(bp+272, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) + speedtest1_begin_test(tls, 170, ts+3917 /* "%d SELECTS, text..." */, crt.VaList(bp+272, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) speedtest1_prepare(tls, - ts+4020 /* "SELECT count(*),..." */, crt.VaList(bp+280, n)) + ts+3951 /* "SELECT count(*),..." */, crt.VaList(bp+280, n)) for i = 1; i <= n; i++ { if ((i - 1) % g.nRepeat) == 0 { x1 = swizzle(tls, uint32(i), uint32(maxb)) @@ -3870,42 +3866,42 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sqlite3.Xsqlite3_bind_text(tls, g.pStmt, 1, bp+568 /* &zNum[0] */, len, uintptr(0)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) n = sz - speedtest1_begin_test(tls, 180, ts+4132 /* "%d INSERTS with ..." */, crt.VaList(bp+288, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) + speedtest1_begin_test(tls, 180, ts+4063 /* "%d INSERTS with ..." */, crt.VaList(bp+288, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) speedtest1_exec(tls, - ts+4162, /* "CREATE%s TABLE t..." */ + ts+4093, /* "CREATE%s TABLE t..." */ crt.VaList(bp+296, isTemp(tls, 1), g.zNN, g.zPK, g.zNN, g.zNN, g.zWR)) - speedtest1_exec(tls, ts+4233 /* "CREATE INDEX t4b..." */, 0) - speedtest1_exec(tls, ts+4259 /* "CREATE INDEX t4c..." */, 0) - speedtest1_exec(tls, ts+4285 /* "INSERT INTO t4 S..." */, 0) - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+4164 /* "CREATE INDEX t4b..." */, 0) + speedtest1_exec(tls, ts+4190 /* "CREATE INDEX t4c..." */, 0) + speedtest1_exec(tls, ts+4216 /* "INSERT INTO t4 S..." */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) n = sz - speedtest1_begin_test(tls, 190, ts+4317 /* "DELETE and REFIL..." */, crt.VaList(bp+344, n)) - speedtest1_exec(tls, ts+4345 /* "DELETE FROM t2;" */, 0) - speedtest1_exec(tls, ts+4361 /* "INSERT INTO t2 S..." */, 0) + speedtest1_begin_test(tls, 190, ts+4248 /* "DELETE and REFIL..." */, crt.VaList(bp+344, n)) + speedtest1_exec(tls, ts+4276 /* "DELETE FROM t2;" */, 0) + speedtest1_exec(tls, ts+4292 /* "INSERT INTO t2 S..." */, 0) speedtest1_end_test(tls) - speedtest1_begin_test(tls, 200, ts+4394 /* "VACUUM" */, 0) - speedtest1_exec(tls, ts+4394 /* "VACUUM" */, 0) + speedtest1_begin_test(tls, 200, ts+4325 /* "VACUUM" */, 0) + speedtest1_exec(tls, ts+4325 /* "VACUUM" */, 0) speedtest1_end_test(tls) - speedtest1_begin_test(tls, 210, ts+4401 /* "ALTER TABLE ADD ..." */, 0) - speedtest1_exec(tls, ts+4435 /* "ALTER TABLE t2 A..." */, 0) - speedtest1_exec(tls, ts+4475 /* "SELECT sum(d) FR..." */, 0) + speedtest1_begin_test(tls, 210, ts+4332 /* "ALTER TABLE ADD ..." */, 0) + speedtest1_exec(tls, ts+4366 /* "ALTER TABLE t2 A..." */, 0) + speedtest1_exec(tls, ts+4406 /* "SELECT sum(d) FR..." */, 0) speedtest1_end_test(tls) n = (sz / 5) - speedtest1_begin_test(tls, 230, ts+4497 /* "%d UPDATES, nume..." */, crt.VaList(bp+352, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) + speedtest1_begin_test(tls, 230, ts+4428 /* "%d UPDATES, nume..." */, crt.VaList(bp+352, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) speedtest1_prepare(tls, - ts+4534 /* "UPDATE t2 SET d=..." */, crt.VaList(bp+360, n)) + ts+4465 /* "UPDATE t2 SET d=..." */, crt.VaList(bp+360, n)) for i = 1; i <= n; i++ { x1 = (speedtest1_random(tls) % uint32(maxb)) x2 = (((speedtest1_random(tls) % uint32(10)) + (uint32(sz / 5000))) + x1) @@ -3913,35 +3909,35 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 2, int32(x2)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) n = sz - speedtest1_begin_test(tls, 240, ts+4593 /* "%d UPDATES of in..." */, crt.VaList(bp+368, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) + speedtest1_begin_test(tls, 240, ts+4524 /* "%d UPDATES of in..." */, crt.VaList(bp+368, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) speedtest1_prepare(tls, - ts+4623 /* "UPDATE t2 SET d=..." */, crt.VaList(bp+376, n)) + ts+4554 /* "UPDATE t2 SET d=..." */, crt.VaList(bp+376, n)) for i = 1; i <= n; i++ { x1 = ((speedtest1_random(tls) % uint32(sz)) + uint32(1)) sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, int32(x1)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) - speedtest1_begin_test(tls, 250, ts+4667 /* "One big UPDATE o..." */, crt.VaList(bp+384, sz)) - speedtest1_exec(tls, ts+4708 /* "UPDATE t2 SET d=..." */, 0) + speedtest1_begin_test(tls, 250, ts+4598 /* "One big UPDATE o..." */, crt.VaList(bp+384, sz)) + speedtest1_exec(tls, ts+4639 /* "UPDATE t2 SET d=..." */, 0) speedtest1_end_test(tls) - speedtest1_begin_test(tls, 260, ts+4728 /* "Query added colu..." */, 0) - speedtest1_exec(tls, ts+4475 /* "SELECT sum(d) FR..." */, 0) + speedtest1_begin_test(tls, 260, ts+4659 /* "Query added colu..." */, 0) + speedtest1_exec(tls, ts+4406 /* "SELECT sum(d) FR..." */, 0) speedtest1_end_test(tls) n = (sz / 5) - speedtest1_begin_test(tls, 270, ts+4761 /* "%d DELETEs, nume..." */, crt.VaList(bp+392, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) + speedtest1_begin_test(tls, 270, ts+4692 /* "%d DELETEs, nume..." */, crt.VaList(bp+392, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) speedtest1_prepare(tls, - ts+4798 /* "DELETE FROM t2 W..." */, crt.VaList(bp+400, n)) + ts+4729 /* "DELETE FROM t2 W..." */, crt.VaList(bp+400, n)) for i = 1; i <= n; i++ { x1 = ((speedtest1_random(tls) % uint32(maxb)) + uint32(1)) x2 = (((speedtest1_random(tls) % uint32(10)) + (uint32(sz / 5000))) + x1) @@ -3949,41 +3945,41 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 2, int32(x2)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) n = sz - speedtest1_begin_test(tls, 280, ts+4852 /* "%d DELETEs of in..." */, crt.VaList(bp+408, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) + speedtest1_begin_test(tls, 280, ts+4783 /* "%d DELETEs of in..." */, crt.VaList(bp+408, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) speedtest1_prepare(tls, - ts+4882 /* "DELETE FROM t3 W..." */, crt.VaList(bp+416, n)) + ts+4813 /* "DELETE FROM t3 W..." */, crt.VaList(bp+416, n)) for i = 1; i <= n; i++ { x1 = ((speedtest1_random(tls) % uint32(sz)) + uint32(1)) sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, int32(x1)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) - speedtest1_begin_test(tls, 290, ts+4921 /* "Refill two %d-ro..." */, crt.VaList(bp+424, sz)) - speedtest1_exec(tls, ts+4960 /* "REPLACE INTO t2(..." */, 0) - speedtest1_exec(tls, ts+5004 /* "REPLACE INTO t3(..." */, 0) + speedtest1_begin_test(tls, 290, ts+4852 /* "Refill two %d-ro..." */, crt.VaList(bp+424, sz)) + speedtest1_exec(tls, ts+4891 /* "REPLACE INTO t2(..." */, 0) + speedtest1_exec(tls, ts+4935 /* "REPLACE INTO t3(..." */, 0) speedtest1_end_test(tls) - speedtest1_begin_test(tls, 300, ts+5048 /* "Refill a %d-row ..." */, crt.VaList(bp+432, sz)) - speedtest1_exec(tls, ts+4345 /* "DELETE FROM t2;" */, 0) + speedtest1_begin_test(tls, 300, ts+4979 /* "Refill a %d-row ..." */, crt.VaList(bp+432, sz)) + speedtest1_exec(tls, ts+4276 /* "DELETE FROM t2;" */, 0) speedtest1_exec(tls, - ts+5089 /* "INSERT INTO t2(a..." */, 0) + ts+5020 /* "INSERT INTO t2(a..." */, 0) speedtest1_exec(tls, - ts+5154 /* "INSERT INTO t2(a..." */, 0) + ts+5085 /* "INSERT INTO t2(a..." */, 0) speedtest1_end_test(tls) n = (sz / 5) - speedtest1_begin_test(tls, 310, ts+5219 /* "%d four-ways joi..." */, crt.VaList(bp+440, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) + speedtest1_begin_test(tls, 310, ts+5150 /* "%d four-ways joi..." */, crt.VaList(bp+440, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) speedtest1_prepare(tls, - ts+5238 /* "SELECT t1.c FROM..." */, 0) + ts+5169 /* "SELECT t1.c FROM..." */, 0) for i = 1; i <= n; i++ { x1 = ((speedtest1_random(tls) % uint32(sz)) + uint32(1)) x2 = (((speedtest1_random(tls) % uint32(10)) + x1) + uint32(4)) @@ -3991,13 +3987,13 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 2, int32(x2)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) - speedtest1_begin_test(tls, 320, ts+5351 /* "subquery in resu..." */, crt.VaList(bp+448, n)) + speedtest1_begin_test(tls, 320, ts+5282 /* "subquery in resu..." */, crt.VaList(bp+448, n)) speedtest1_prepare(tls, - ts+5374 /* "SELECT sum(a), m..." */, 0) + ts+5305 /* "SELECT sum(a), m..." */, 0) sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (est_square_root(tls, g.szTest) * 50)) speedtest1_run(tls) speedtest1_end_test(tls) @@ -4005,11 +4001,11 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sz = crt.AssignInt32(&n, (g.szTest * 700)) *(*int8)(unsafe.Pointer(bp + 568 /* &zNum[0] */ + uintptr(0))) = int8(0) maxb = int32(roundup_allones(tls, (uint32(sz / 3)))) - speedtest1_begin_test(tls, 400, ts+5492 /* "%d REPLACE ops o..." */, crt.VaList(bp+456, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) - speedtest1_exec(tls, ts+5517, /* "CREATE%s TABLE t..." */ + speedtest1_begin_test(tls, 400, ts+5423 /* "%d REPLACE ops o..." */, crt.VaList(bp+456, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) + speedtest1_exec(tls, ts+5448, /* "CREATE%s TABLE t..." */ crt.VaList(bp+464, isTemp(tls, 9), g.zNN)) - speedtest1_prepare(tls, ts+5565 /* "REPLACE INTO t5 ..." */, crt.VaList(bp+480, n)) + speedtest1_prepare(tls, ts+5496 /* "REPLACE INTO t5 ..." */, crt.VaList(bp+480, n)) for i = 1; i <= n; i++ { x1 = swizzle(tls, uint32(i), uint32(maxb)) speedtest1_numbername(tls, uint32(i), bp+568 /* &zNum[0] */, int32(unsafe.Sizeof([2000]int8{}))) @@ -4017,10 +4013,10 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sqlite3.Xsqlite3_bind_text(tls, g.pStmt, 2, bp+568 /* &zNum[0] */, -1, uintptr(0)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) - speedtest1_begin_test(tls, 410, ts+5609 /* "%d SELECTS on an..." */, crt.VaList(bp+488, n)) - speedtest1_prepare(tls, ts+5630 /* "SELECT b FROM t5..." */, crt.VaList(bp+496, n)) + speedtest1_begin_test(tls, 410, ts+5540 /* "%d SELECTS on an..." */, crt.VaList(bp+488, n)) + speedtest1_prepare(tls, ts+5561 /* "SELECT b FROM t5..." */, crt.VaList(bp+496, n)) for i = 1; i <= n; i++ { x1 = swizzle(tls, uint32(i), uint32(maxb)) sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, int32(sqlite3_int64(x1))) @@ -4031,17 +4027,17 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sz = crt.AssignInt32(&n, (g.szTest * 700)) *(*int8)(unsafe.Pointer(bp + 568 /* &zNum[0] */ + uintptr(0))) = int8(0) maxb = int32(roundup_allones(tls, (uint32(sz / 3)))) - speedtest1_begin_test(tls, 500, ts+5672 /* "%d REPLACE on TE..." */, crt.VaList(bp+504, n)) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) - speedtest1_exec(tls, ts+5694, /* "CREATE%s TABLE t..." */ + speedtest1_begin_test(tls, 500, ts+5603 /* "%d REPLACE on TE..." */, crt.VaList(bp+504, n)) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) + speedtest1_exec(tls, ts+5625, /* "CREATE%s TABLE t..." */ crt.VaList(bp+512, isTemp(tls, 9), g.zNN, func() uintptr { if sqlite3.Xsqlite3_libversion_number(tls) >= 3008002 { - return ts + 5741 /* "WITHOUT ROWID" */ + return ts + 5672 /* "WITHOUT ROWID" */ } return ts + 1988 /* "" */ }())) - speedtest1_prepare(tls, ts+5755 /* "REPLACE INTO t6 ..." */, crt.VaList(bp+536, n)) + speedtest1_prepare(tls, ts+5686 /* "REPLACE INTO t6 ..." */, crt.VaList(bp+536, n)) for i = 1; i <= n; i++ { x1 = swizzle(tls, uint32(i), uint32(maxb)) speedtest1_numbername(tls, x1, bp+568 /* &zNum[0] */, int32(unsafe.Sizeof([2000]int8{}))) @@ -4049,10 +4045,10 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ sqlite3.Xsqlite3_bind_text(tls, g.pStmt, 1, bp+568 /* &zNum[0] */, -1, uintptr(0)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) - speedtest1_begin_test(tls, 510, ts+5799 /* "%d SELECTS on a ..." */, crt.VaList(bp+544, n)) - speedtest1_prepare(tls, ts+5823 /* "SELECT b FROM t6..." */, crt.VaList(bp+552, n)) + speedtest1_begin_test(tls, 510, ts+5730 /* "%d SELECTS on a ..." */, crt.VaList(bp+544, n)) + speedtest1_prepare(tls, ts+5754 /* "SELECT b FROM t6..." */, crt.VaList(bp+552, n)) for i = 1; i <= n; i++ { x1 = swizzle(tls, uint32(i), uint32(maxb)) speedtest1_numbername(tls, x1, bp+568 /* &zNum[0] */, int32(unsafe.Sizeof([2000]int8{}))) @@ -4060,17 +4056,17 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */ speedtest1_run(tls) } speedtest1_end_test(tls) - speedtest1_begin_test(tls, 520, ts+5865 /* "%d SELECT DISTIN..." */, crt.VaList(bp+560, n)) - speedtest1_exec(tls, ts+5884 /* "SELECT DISTINCT ..." */, 0) - speedtest1_exec(tls, ts+5911 /* "SELECT DISTINCT ..." */, 0) + speedtest1_begin_test(tls, 520, ts+5796 /* "%d SELECT DISTIN..." */, crt.VaList(bp+560, n)) + speedtest1_exec(tls, ts+5815 /* "SELECT DISTINCT ..." */, 0) + speedtest1_exec(tls, ts+5842 /* "SELECT DISTINCT ..." */, 0) speedtest1_end_test(tls) - speedtest1_begin_test(tls, 980, ts+5938 /* "PRAGMA integrity..." */, 0) - speedtest1_exec(tls, ts+5938 /* "PRAGMA integrity..." */, 0) + speedtest1_begin_test(tls, 980, ts+5869 /* "PRAGMA integrity..." */, 0) + speedtest1_exec(tls, ts+5869 /* "PRAGMA integrity..." */, 0) speedtest1_end_test(tls) - speedtest1_begin_test(tls, 990, ts+5961 /* "ANALYZE" */, 0) - speedtest1_exec(tls, ts+5961 /* "ANALYZE" */, 0) + speedtest1_begin_test(tls, 990, ts+5892 /* "ANALYZE" */, 0) + speedtest1_exec(tls, ts+5892 /* "ANALYZE" */, 0) speedtest1_end_test(tls) } @@ -4091,37 +4087,37 @@ func testset_cte(tls *crt.TLS) { /* speedtest1.c:975:6: */ } else { zPuz = azPuzzle[2] } - speedtest1_begin_test(tls, 100, ts+5969 /* "Sudoku with recu..." */, 0) + speedtest1_begin_test(tls, 100, ts+5900 /* "Sudoku with recu..." */, 0) speedtest1_prepare(tls, - ts+6000 /* "WITH RECURSIVE\n ..." */, 0) + ts+5931 /* "WITH RECURSIVE\n ..." */, 0) sqlite3.Xsqlite3_bind_text(tls, g.pStmt, 1, zPuz, -1, uintptr(0)) speedtest1_run(tls) speedtest1_end_test(tls) - speedtest1_begin_test(tls, 200, ts+6804 /* "Sudoku with VALU..." */, 0) + speedtest1_begin_test(tls, 200, ts+6735 /* "Sudoku with VALU..." */, 0) speedtest1_prepare(tls, - ts+6832 /* "WITH RECURSIVE\n ..." */, 0) + ts+6763 /* "WITH RECURSIVE\n ..." */, 0) sqlite3.Xsqlite3_bind_text(tls, g.pStmt, 1, zPuz, -1, uintptr(0)) speedtest1_run(tls) speedtest1_end_test(tls) rSpacing = (5.0 / float64(g.szTest)) - speedtest1_begin_test(tls, 300, ts+7644 /* "Mandelbrot Set w..." */, crt.VaList(bp, rSpacing)) + speedtest1_begin_test(tls, 300, ts+7575 /* "Mandelbrot Set w..." */, crt.VaList(bp, rSpacing)) speedtest1_prepare(tls, - ts+7675 /* "WITH RECURSIVE \n..." */, 0) + ts+7606 /* "WITH RECURSIVE \n..." */, 0) sqlite3.Xsqlite3_bind_double(tls, g.pStmt, 1, (rSpacing * .05)) sqlite3.Xsqlite3_bind_double(tls, g.pStmt, 2, rSpacing) speedtest1_run(tls) speedtest1_end_test(tls) nElem = (10000 * g.szTest) - speedtest1_begin_test(tls, 400, ts+8271 /* "EXCEPT operator ..." */, crt.VaList(bp+8, nElem)) + speedtest1_begin_test(tls, 400, ts+8202 /* "EXCEPT operator ..." */, crt.VaList(bp+8, nElem)) speedtest1_prepare(tls, - ts+8308, /* "WITH RECURSIVE \n..." */ + ts+8239, /* "WITH RECURSIVE \n..." */ crt.VaList(bp+16, nElem, nElem)) speedtest1_run(tls) speedtest1_end_test(tls) @@ -4130,15 +4126,15 @@ func testset_cte(tls *crt.TLS) { /* speedtest1.c:975:6: */ var azPuzzle = [3]uintptr{ // Easy - ts + 8539, /* "534...9..67.195...." */ + ts + 8470, /* "534...9..67.195...." */ // Medium - ts + 8621, /* "53....9..6..195...." */ + ts + 8552, /* "53....9..6..195...." */ // Hard - ts + 8703, /* "53.......6..195...." */ + ts + 8634, /* "53.......6..195...." */ } /* speedtest1.c:976:21 */ // Compute a pseudo-random floating point ascii number. @@ -4154,7 +4150,7 @@ func speedtest1_random_ascii_fp(tls *crt.TLS, zFP uintptr) { /* speedtest1.c:112 z = -z } y = y / (10) - sqlite3.Xsqlite3_snprintf(tls, 100, zFP, ts+8785 /* "%d.%de%d" */, crt.VaList(bp, y, z, (x%200))) + sqlite3.Xsqlite3_snprintf(tls, 100, zFP, ts+8716 /* "%d.%de%d" */, crt.VaList(bp, y, z, (x%200))) } // A testset for floating-point numbers. @@ -4169,11 +4165,11 @@ func testset_fp(tls *crt.TLS) { /* speedtest1.c:1141:6: */ // var zFP2 [100]int8 at bp+172, 100 n = (g.szTest * 5000) - speedtest1_begin_test(tls, 100, ts+8794 /* "Fill a table wit..." */, crt.VaList(bp, (n*2))) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) - speedtest1_exec(tls, ts+8825, /* "CREATE%s TABLE t..." */ + speedtest1_begin_test(tls, 100, ts+8725 /* "Fill a table wit..." */, crt.VaList(bp, (n*2))) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) + speedtest1_exec(tls, ts+8756, /* "CREATE%s TABLE t..." */ crt.VaList(bp+8, isTemp(tls, 1), g.zNN, g.zNN)) - speedtest1_prepare(tls, ts+8866 /* "INSERT INTO t1 V..." */, crt.VaList(bp+32, n)) + speedtest1_prepare(tls, ts+8797 /* "INSERT INTO t1 V..." */, crt.VaList(bp+32, n)) for i = 1; i <= n; i++ { speedtest1_random_ascii_fp(tls, bp+72 /* &zFP1[0] */) speedtest1_random_ascii_fp(tls, bp+172 /* &zFP2[0] */) @@ -4181,12 +4177,12 @@ func testset_fp(tls *crt.TLS) { /* speedtest1.c:1141:6: */ sqlite3.Xsqlite3_bind_text(tls, g.pStmt, 2, bp+172 /* &zFP2[0] */, -1, uintptr(0)) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) n = ((g.szTest / 25) + 2) - speedtest1_begin_test(tls, 110, ts+8908 /* "%d range queries" */, crt.VaList(bp+40, n)) - speedtest1_prepare(tls, ts+8925 /* "SELECT sum(b) FR..." */, 0) + speedtest1_begin_test(tls, 110, ts+8839 /* "%d range queries" */, crt.VaList(bp+40, n)) + speedtest1_prepare(tls, ts+8856 /* "SELECT sum(b) FR..." */, 0) for i = 1; i <= n; i++ { speedtest1_random_ascii_fp(tls, bp+72 /* &zFP1[0] */) speedtest1_random_ascii_fp(tls, bp+172 /* &zFP2[0] */) @@ -4196,17 +4192,17 @@ func testset_fp(tls *crt.TLS) { /* speedtest1.c:1141:6: */ } speedtest1_end_test(tls) - speedtest1_begin_test(tls, 120, ts+8973 /* "CREATE INDEX thr..." */, 0) - speedtest1_exec(tls, ts+3535 /* "BEGIN;" */, 0) - speedtest1_exec(tls, ts+8998 /* "CREATE INDEX t1a..." */, 0) - speedtest1_exec(tls, ts+9025 /* "CREATE INDEX t1b..." */, 0) - speedtest1_exec(tls, ts+9052 /* "CREATE INDEX t1a..." */, 0) - speedtest1_exec(tls, ts+3699 /* "COMMIT;" */, 0) + speedtest1_begin_test(tls, 120, ts+8904 /* "CREATE INDEX thr..." */, 0) + speedtest1_exec(tls, ts+3466 /* "BEGIN;" */, 0) + speedtest1_exec(tls, ts+8929 /* "CREATE INDEX t1a..." */, 0) + speedtest1_exec(tls, ts+8956 /* "CREATE INDEX t1b..." */, 0) + speedtest1_exec(tls, ts+8983 /* "CREATE INDEX t1a..." */, 0) + speedtest1_exec(tls, ts+3630 /* "COMMIT;" */, 0) speedtest1_end_test(tls) n = ((g.szTest / 3) + 2) - speedtest1_begin_test(tls, 130, ts+9082 /* "%d indexed range..." */, crt.VaList(bp+48, n)) - speedtest1_prepare(tls, ts+8925 /* "SELECT sum(b) FR..." */, 0) + speedtest1_begin_test(tls, 130, ts+9013 /* "%d indexed range..." */, crt.VaList(bp+48, n)) + speedtest1_prepare(tls, ts+8856 /* "SELECT sum(b) FR..." */, 0) for i = 1; i <= n; i++ { speedtest1_random_ascii_fp(tls, bp+72 /* &zFP1[0] */) speedtest1_random_ascii_fp(tls, bp+172 /* &zFP2[0] */) @@ -4217,14 +4213,14 @@ func testset_fp(tls *crt.TLS) { /* speedtest1.c:1141:6: */ speedtest1_end_test(tls) n = (g.szTest * 5000) - speedtest1_begin_test(tls, 140, ts+9107 /* "%d calls to roun..." */, crt.VaList(bp+56, n)) - speedtest1_exec(tls, ts+9127 /* "SELECT sum(round..." */, 0) + speedtest1_begin_test(tls, 140, ts+9038 /* "%d calls to roun..." */, crt.VaList(bp+56, n)) + speedtest1_exec(tls, ts+9058 /* "SELECT sum(round..." */, 0) speedtest1_end_test(tls) - speedtest1_begin_test(tls, 150, ts+9170 /* "%d printf() call..." */, crt.VaList(bp+64, (n*4))) + speedtest1_begin_test(tls, 150, ts+9101 /* "%d printf() call..." */, crt.VaList(bp+64, (n*4))) speedtest1_exec(tls, - ts+9188 /* "WITH c(fmt) AS (..." */, 0) + ts+9119 /* "WITH c(fmt) AS (..." */, 0) speedtest1_end_test(tls) } @@ -4243,13 +4239,13 @@ func testset_orm(tls *crt.TLS) { /* speedtest1.c:1443:6: */ // var zNum [2000]int8 at bp+16, 2000 nRow = crt.AssignUint32(&n, (uint32(g.szTest * 250))) - speedtest1_begin_test(tls, 100, ts+9283 /* "Fill %d rows" */, crt.VaList(bp, n)) + speedtest1_begin_test(tls, 100, ts+9214 /* "Fill %d rows" */, crt.VaList(bp, n)) speedtest1_exec(tls, - ts+9296 /* "BEGIN;CREATE TAB..." */, 0) + ts+9227 /* "BEGIN;CREATE TAB..." */, 0) speedtest1_prepare(tls, - ts+13196 /* "INSERT INTO ZLOO..." */, 0) + ts+13127 /* "INSERT INTO ZLOO..." */, 0) for i = uint32(0); i < n; i++ { x1 = speedtest1_random(tls) speedtest1_numbername(tls, (x1 % uint32(1000)), bp+16 /* &zNum[0] */, int32(unsafe.Sizeof([2000]int8{}))) @@ -4275,14 +4271,14 @@ func testset_orm(tls *crt.TLS) { /* speedtest1.c:1443:6: */ } speedtest1_run(tls) } - speedtest1_exec(tls, ts+3699 /* "COMMIT;" */, 0) + speedtest1_exec(tls, ts+3630 /* "COMMIT;" */, 0) speedtest1_end_test(tls) n = (uint32(g.szTest * 250)) - speedtest1_begin_test(tls, 110, ts+16440 /* "Query %d rows by..." */, crt.VaList(bp+8, n)) + speedtest1_begin_test(tls, 110, ts+16371 /* "Query %d rows by..." */, crt.VaList(bp+8, n)) speedtest1_prepare(tls, - ts+16463 /* "SELECT ZCYANBASE..." */, 0) + ts+16394 /* "SELECT ZCYANBASE..." */, 0) for i = uint32(0); i < n; i++ { x1 = (speedtest1_random(tls) % nRow) sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, int32(x1)) @@ -4291,7 +4287,7 @@ func testset_orm(tls *crt.TLS) { /* speedtest1.c:1443:6: */ speedtest1_end_test(tls) } -var zType = *(*[120]int8)(unsafe.Pointer(ts + 19216 /* "IBBIIITIVVITBTBF..." */)) /* speedtest1.c:1448:21 */ +var zType = *(*[120]int8)(unsafe.Pointer(ts + 19147 /* "IBBIIITIVVITBTBF..." */)) /* speedtest1.c:1448:21 */ // func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */ @@ -4308,9 +4304,9 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */ speedtest1_exec(tls, - ts+19336 /* "BEGIN;CREATE TAB..." */, 0) + ts+19267 /* "BEGIN;CREATE TAB..." */, 0) for jj = 1; jj <= 3; jj++ { - speedtest1_prepare(tls, ts+19664 /* "INSERT INTO t%d ..." */, crt.VaList(bp, jj)) + speedtest1_prepare(tls, ts+19595 /* "INSERT INTO t%d ..." */, crt.VaList(bp, jj)) for ii = 0; ii < NROW; ii++ { var x1 int32 = (int32(speedtest1_random(tls) % uint32(NROW))) speedtest1_numbername(tls, uint32(x1), bp+32 /* &zNum[0] */, int32(unsafe.Sizeof([2000]int8{}))) @@ -4321,23 +4317,23 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */ } speedtest1_exec(tls, - ts+19699 /* "CREATE INDEX i1 ..." */, 0) + ts+19630 /* "CREATE INDEX i1 ..." */, 0) - speedtest1_begin_test(tls, 100, ts+19782 /* "speed4p-join1" */, 0) + speedtest1_begin_test(tls, 100, ts+19713 /* "speed4p-join1" */, 0) speedtest1_prepare(tls, - ts+19796 /* "SELECT * FROM t1..." */, 0) + ts+19727 /* "SELECT * FROM t1..." */, 0) speedtest1_run(tls) speedtest1_end_test(tls) - speedtest1_begin_test(tls, 110, ts+19863 /* "speed4p-join2" */, 0) + speedtest1_begin_test(tls, 110, ts+19794 /* "speed4p-join2" */, 0) speedtest1_prepare(tls, - ts+19877 /* "SELECT * FROM t1..." */, 0) + ts+19808 /* "SELECT * FROM t1..." */, 0) speedtest1_run(tls) speedtest1_end_test(tls) - speedtest1_begin_test(tls, 120, ts+19936 /* "speed4p-view1" */, 0) + speedtest1_begin_test(tls, 120, ts+19867 /* "speed4p-view1" */, 0) for jj = 1; jj <= 3; jj++ { - speedtest1_prepare(tls, ts+19950 /* "SELECT * FROM v%..." */, crt.VaList(bp+8, jj)) + speedtest1_prepare(tls, ts+19881 /* "SELECT * FROM v%..." */, crt.VaList(bp+8, jj)) for ii = 0; ii < NROW2; ii = ii + (3) { sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (ii * 3)) speedtest1_run(tls) @@ -4345,9 +4341,9 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */ } speedtest1_end_test(tls) - speedtest1_begin_test(tls, 130, ts+19984 /* "speed4p-table1" */, 0) + speedtest1_begin_test(tls, 130, ts+19915 /* "speed4p-table1" */, 0) for jj = 1; jj <= 3; jj++ { - speedtest1_prepare(tls, ts+19999 /* "SELECT * FROM t%..." */, crt.VaList(bp+16, jj)) + speedtest1_prepare(tls, ts+19930 /* "SELECT * FROM t%..." */, crt.VaList(bp+16, jj)) for ii = 0; ii < NROW2; ii = ii + (3) { sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (ii * 3)) speedtest1_run(tls) @@ -4355,9 +4351,9 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */ } speedtest1_end_test(tls) - speedtest1_begin_test(tls, 140, ts+19984 /* "speed4p-table1" */, 0) + speedtest1_begin_test(tls, 140, ts+19915 /* "speed4p-table1" */, 0) for jj = 1; jj <= 3; jj++ { - speedtest1_prepare(tls, ts+19999 /* "SELECT * FROM t%..." */, crt.VaList(bp+24, jj)) + speedtest1_prepare(tls, ts+19930 /* "SELECT * FROM t%..." */, crt.VaList(bp+24, jj)) for ii = 0; ii < NROW2; ii = ii + (3) { sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (ii * 3)) speedtest1_run(tls) @@ -4365,37 +4361,37 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */ } speedtest1_end_test(tls) - speedtest1_begin_test(tls, 150, ts+20033 /* "speed4p-subselec..." */, 0) + speedtest1_begin_test(tls, 150, ts+19964 /* "speed4p-subselec..." */, 0) speedtest1_prepare(tls, - ts+20052 /* "SELECT (SELECT t..." */, 0) + ts+19983 /* "SELECT (SELECT t..." */, 0) for jj = 0; jj < NROW2; jj++ { sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (jj * 3)) speedtest1_run(tls) } speedtest1_end_test(tls) - speedtest1_begin_test(tls, 160, ts+20167 /* "speed4p-rowid-up..." */, 0) - speedtest1_exec(tls, ts+2622 /* "BEGIN" */, 0) - speedtest1_prepare(tls, ts+20188 /* "UPDATE t1 SET i=..." */, 0) + speedtest1_begin_test(tls, 160, ts+20098 /* "speed4p-rowid-up..." */, 0) + speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0) + speedtest1_prepare(tls, ts+20119 /* "UPDATE t1 SET i=..." */, 0) for jj = 0; jj < NROW2; jj++ { sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, jj) speedtest1_run(tls) } - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) speedtest1_end_test(tls) - speedtest1_exec(tls, ts+20223 /* "CREATE TABLE t5(..." */, 0) - speedtest1_begin_test(tls, 170, ts+20271 /* "speed4p-insert-i..." */, 0) - speedtest1_exec(tls, ts+20293 /* "INSERT OR IGNORE..." */, 0) + speedtest1_exec(tls, ts+20154 /* "CREATE TABLE t5(..." */, 0) + speedtest1_begin_test(tls, 170, ts+20202 /* "speed4p-insert-i..." */, 0) + speedtest1_exec(tls, ts+20224 /* "INSERT OR IGNORE..." */, 0) speedtest1_end_test(tls) speedtest1_exec(tls, - ts+20338 /* "CREATE TABLE log..." */, 0) + ts+20269 /* "CREATE TABLE log..." */, 0) - speedtest1_begin_test(tls, 180, ts+20828 /* "speed4p-trigger1" */, 0) - speedtest1_prepare(tls, ts+20845 /* "INSERT INTO t4 V..." */, 0) + speedtest1_begin_test(tls, 180, ts+20759 /* "speed4p-trigger1" */, 0) + speedtest1_prepare(tls, ts+20776 /* "INSERT INTO t4 V..." */, 0) for jj = 0; jj < NROW2; jj++ { speedtest1_numbername(tls, uint32(jj), bp+32 /* &zNum[0] */, int32(unsafe.Sizeof([2000]int8{}))) sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, jj) @@ -4407,8 +4403,8 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */ // Note: Of the queries, only half actually update a row. This property // was copied over from speed4p.test, where it was probably introduced // inadvertantly. - speedtest1_begin_test(tls, 190, ts+20881 /* "speed4p-trigger2" */, 0) - speedtest1_prepare(tls, ts+20898 /* "UPDATE t4 SET i ..." */, 0) + speedtest1_begin_test(tls, 190, ts+20812 /* "speed4p-trigger2" */, 0) + speedtest1_prepare(tls, ts+20829 /* "UPDATE t4 SET i ..." */, 0) for jj = 1; jj <= (NROW2 * 2); jj = jj + (2) { speedtest1_numbername(tls, (uint32(jj * 2)), bp+32 /* &zNum[0] */, int32(unsafe.Sizeof([2000]int8{}))) sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (jj * 2)) @@ -4419,14 +4415,14 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */ speedtest1_end_test(tls) // Note: Same again. - speedtest1_begin_test(tls, 200, ts+20944 /* "speed4p-trigger3" */, 0) - speedtest1_prepare(tls, ts+20961 /* "DELETE FROM t4 W..." */, 0) + speedtest1_begin_test(tls, 200, ts+20875 /* "speed4p-trigger3" */, 0) + speedtest1_prepare(tls, ts+20892 /* "DELETE FROM t4 W..." */, 0) for jj = 1; jj <= (NROW2 * 2); jj = jj + (2) { sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (jj * 2)) speedtest1_run(tls) } speedtest1_end_test(tls) - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) // The following block contains the same tests as the above block that // tests triggers, with one crucial difference: no triggers are defined. @@ -4434,9 +4430,9 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */ // is the amount of time taken to compile and execute the trigger programs. speedtest1_exec(tls, - ts+20993 /* "DROP TABLE t4;DR..." */, 0) - speedtest1_begin_test(tls, 210, ts+21098 /* "speed4p-notrigge..." */, 0) - speedtest1_prepare(tls, ts+20845 /* "INSERT INTO t4 V..." */, 0) + ts+20924 /* "DROP TABLE t4;DR..." */, 0) + speedtest1_begin_test(tls, 210, ts+21029 /* "speed4p-notrigge..." */, 0) + speedtest1_prepare(tls, ts+20776 /* "INSERT INTO t4 V..." */, 0) for jj = 0; jj < NROW2; jj++ { speedtest1_numbername(tls, uint32(jj), bp+32 /* &zNum[0] */, int32(unsafe.Sizeof([2000]int8{}))) sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, jj) @@ -4444,8 +4440,8 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */ speedtest1_run(tls) } speedtest1_end_test(tls) - speedtest1_begin_test(tls, 210, ts+21117 /* "speed4p-notrigge..." */, 0) - speedtest1_prepare(tls, ts+20898 /* "UPDATE t4 SET i ..." */, 0) + speedtest1_begin_test(tls, 210, ts+21048 /* "speed4p-notrigge..." */, 0) + speedtest1_prepare(tls, ts+20829 /* "UPDATE t4 SET i ..." */, 0) for jj = 1; jj <= (NROW2 * 2); jj = jj + (2) { speedtest1_numbername(tls, (uint32(jj * 2)), bp+32 /* &zNum[0] */, int32(unsafe.Sizeof([2000]int8{}))) sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (jj * 2)) @@ -4454,14 +4450,14 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */ speedtest1_run(tls) } speedtest1_end_test(tls) - speedtest1_begin_test(tls, 220, ts+21136 /* "speed4p-notrigge..." */, 0) - speedtest1_prepare(tls, ts+20961 /* "DELETE FROM t4 W..." */, 0) + speedtest1_begin_test(tls, 220, ts+21067 /* "speed4p-notrigge..." */, 0) + speedtest1_prepare(tls, ts+20892 /* "DELETE FROM t4 W..." */, 0) for jj = 1; jj <= (NROW2 * 2); jj = jj + (2) { sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (jj * 2)) speedtest1_run(tls) } speedtest1_end_test(tls) - speedtest1_exec(tls, ts+2732 /* "COMMIT" */, 0) + speedtest1_exec(tls, ts+2663 /* "COMMIT" */, 0) } // A testset used for debugging speedtest1 itself. @@ -4481,7 +4477,7 @@ func testset_debug1(tls *crt.TLS) { /* speedtest1.c:1912:6: */ x1 = swizzle(tls, i, n) x2 = swizzle(tls, x1, n) speedtest1_numbername(tls, x1, bp+32 /* &zNum[0] */, int32(unsafe.Sizeof([2000]int8{}))) - crt.Xprintf(tls, ts+21155 /* "%5d %5d %5d %s\n" */, crt.VaList(bp, i, x1, x2, bp+32 /* &zNum[0] */)) + crt.Xprintf(tls, ts+21086 /* "%5d %5d %5d %s\n" */, crt.VaList(bp, i, x1, x2, bp+32 /* &zNum[0] */)) } } @@ -4531,8 +4527,8 @@ func displayLinuxIoStats(tls *crt.TLS, out uintptr) { /* speedtest1.c:1933:13: * var in uintptr // var z [200]int8 at bp+24, 200 - sqlite3.Xsqlite3_snprintf(tls, int32(unsafe.Sizeof([200]int8{})), bp+24 /* &z[0] */, ts+21171 /* "/proc/%d/io" */, crt.VaList(bp, crt.Xgetpid(tls))) - in = crt.Xfopen(tls, bp+24 /* &z[0] */, ts+21183 /* "rb" */) + sqlite3.Xsqlite3_snprintf(tls, int32(unsafe.Sizeof([200]int8{})), bp+24 /* &z[0] */, ts+21102 /* "/proc/%d/io" */, crt.VaList(bp, crt.Xgetpid(tls))) + in = crt.Xfopen(tls, bp+24 /* &z[0] */, ts+21114 /* "rb" */) if in == uintptr(0) { return } @@ -4544,7 +4540,7 @@ func displayLinuxIoStats(tls *crt.TLS, out uintptr) { /* speedtest1.c:1933:13: * }{}))); i++ { var n int32 = int32(crt.Xstrlen(tls, aTrans[i].zPattern)) if crt.Xstrncmp(tls, aTrans[i].zPattern, bp+24 /* &z[0] */, uint64(n)) == 0 { - crt.Xfprintf(tls, out, ts+21186 /* "-- %-28s %s" */, crt.VaList(bp+8, aTrans[i].zDesc, (bp+24 /* &z */ +uintptr(n)))) + crt.Xfprintf(tls, out, ts+21117 /* "-- %-28s %s" */, crt.VaList(bp+8, aTrans[i].zDesc, (bp+24 /* &z */ +uintptr(n)))) break } } @@ -4556,20 +4552,20 @@ var aTrans = [7]struct { zPattern uintptr zDesc uintptr }{ - {zPattern: ts + 21198 /* "rchar: " */, zDesc: ts + 21206 /* "Bytes received b..." */}, - {zPattern: ts + 21232 /* "wchar: " */, zDesc: ts + 21240 /* "Bytes sent to wr..." */}, - {zPattern: ts + 21263 /* "syscr: " */, zDesc: ts + 21271 /* "Read() system ca..." */}, - {zPattern: ts + 21292 /* "syscw: " */, zDesc: ts + 21300 /* "Write() system c..." */}, - {zPattern: ts + 21322 /* "read_bytes: " */, zDesc: ts + 21335 /* "Bytes rcvd from ..." */}, - {zPattern: ts + 21360 /* "write_bytes: " */, zDesc: ts + 21374 /* "Bytes sent to st..." */}, - {zPattern: ts + 21397 /* "cancelled_write_..." */, zDesc: ts + 21421 /* "Cancelled write ..." */}, + {zPattern: ts + 21129 /* "rchar: " */, zDesc: ts + 21137 /* "Bytes received b..." */}, + {zPattern: ts + 21163 /* "wchar: " */, zDesc: ts + 21171 /* "Bytes sent to wr..." */}, + {zPattern: ts + 21194 /* "syscr: " */, zDesc: ts + 21202 /* "Read() system ca..." */}, + {zPattern: ts + 21223 /* "syscw: " */, zDesc: ts + 21231 /* "Write() system c..." */}, + {zPattern: ts + 21253 /* "read_bytes: " */, zDesc: ts + 21266 /* "Bytes rcvd from ..." */}, + {zPattern: ts + 21291 /* "write_bytes: " */, zDesc: ts + 21305 /* "Bytes sent to st..." */}, + {zPattern: ts + 21328 /* "cancelled_write_..." */, zDesc: ts + 21352 /* "Cancelled write ..." */}, } /* speedtest1.c:1943:7 */ func xCompileOptions(tls *crt.TLS, pCtx uintptr, nVal int32, azVal uintptr, azCol uintptr) int32 { /* speedtest1.c:1969:12: */ bp := tls.Alloc(8) defer tls.Free(8) - crt.Xprintf(tls, ts+21444 /* "-- Compile optio..." */, crt.VaList(bp, *(*uintptr)(unsafe.Pointer(azVal + uintptr(0)*8)))) + crt.Xprintf(tls, ts+21375 /* "-- Compile optio..." */, crt.VaList(bp, *(*uintptr)(unsafe.Pointer(azVal + uintptr(0)*8)))) return 0 } @@ -4595,7 +4591,7 @@ func main1(tls *crt.TLS, argc int32, argv uintptr) int32 { /* speedtest1.c:1974: var showStats int32 = 0 // True for --stats var nThread int32 = 0 // --threads value var mmapSize int32 = 0 // How big of a memory map to use - var zTSet uintptr = ts + 21467 /* "main" */ // Which --testset torun + var zTSet uintptr = ts + 21398 /* "main" */ // Which --testset torun var doTrace int32 = 0 // True for --trace var zEncoding uintptr = uintptr(0) // --utf16be or --utf16le var zDbName uintptr = uintptr(0) // Name of the test database @@ -4611,13 +4607,13 @@ func main1(tls *crt.TLS, argc int32, argv uintptr) int32 { /* speedtest1.c:1974: var rc int32 // API return code // Display the version of SQLite being tested - crt.Xprintf(tls, ts+21472, /* "-- Speedtest1 fo..." */ + crt.Xprintf(tls, ts+21403, /* "-- Speedtest1 fo..." */ crt.VaList(bp, sqlite3.Xsqlite3_libversion(tls), sqlite3.Xsqlite3_sourceid(tls))) // Process command-line arguments g.zWR = ts + 1988 /* "" */ g.zNN = ts + 1988 /* "" */ - g.zPK = ts + 21507 /* "UNIQUE" */ + g.zPK = ts + 21438 /* "UNIQUE" */ g.szTest = 100 g.nRepeat = 1 for i = 1; i < argc; i++ { @@ -4626,137 +4622,137 @@ func main1(tls *crt.TLS, argc int32, argv uintptr) int32 { /* speedtest1.c:1974: for ok := true; ok; ok = (int32(*(*int8)(unsafe.Pointer(z + uintptr(0)))) == '-') { z++ } - if crt.Xstrcmp(tls, z, ts+21514 /* "autovacuum" */) == 0 { + if crt.Xstrcmp(tls, z, ts+21445 /* "autovacuum" */) == 0 { doAutovac = 1 - } else if crt.Xstrcmp(tls, z, ts+21525 /* "cachesize" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21456 /* "cachesize" */) == 0 { if i >= (argc - 1) { - fatal_error(tls, ts+21535 /* "missing argument..." */, crt.VaList(bp+16, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) + fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+16, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) } i++ cacheSize = integerValue(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8))) - } else if crt.Xstrcmp(tls, z, ts+21559 /* "exclusive" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21490 /* "exclusive" */) == 0 { doExclusive = 1 - } else if crt.Xstrcmp(tls, z, ts+21569 /* "explain" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21500 /* "explain" */) == 0 { g.bSqlOnly = 1 g.bExplain = 1 - } else if crt.Xstrcmp(tls, z, ts+21577 /* "heap" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21508 /* "heap" */) == 0 { if i >= (argc - 2) { - fatal_error(tls, ts+21582 /* "missing argument..." */, crt.VaList(bp+24, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) + fatal_error(tls, ts+21513 /* "missing argument..." */, crt.VaList(bp+24, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) } nHeap = integerValue(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr((i+1))*8))) mnHeap = integerValue(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr((i+2))*8))) i = i + (2) - } else if crt.Xstrcmp(tls, z, ts+21607 /* "incrvacuum" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21538 /* "incrvacuum" */) == 0 { doIncrvac = 1 - } else if crt.Xstrcmp(tls, z, ts+21618 /* "journal" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21549 /* "journal" */) == 0 { if i >= (argc - 1) { - fatal_error(tls, ts+21535 /* "missing argument..." */, crt.VaList(bp+32, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) + fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+32, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) } zJMode = *(*uintptr)(unsafe.Pointer(argv + uintptr(crt.PreIncInt32(&i, 1))*8)) - } else if crt.Xstrcmp(tls, z, ts+21626 /* "key" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21557 /* "key" */) == 0 { if i >= (argc - 1) { - fatal_error(tls, ts+21535 /* "missing argument..." */, crt.VaList(bp+40, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) + fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+40, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) } zKey = *(*uintptr)(unsafe.Pointer(argv + uintptr(crt.PreIncInt32(&i, 1))*8)) - } else if crt.Xstrcmp(tls, z, ts+21630 /* "lookaside" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21561 /* "lookaside" */) == 0 { if i >= (argc - 2) { - fatal_error(tls, ts+21582 /* "missing argument..." */, crt.VaList(bp+48, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) + fatal_error(tls, ts+21513 /* "missing argument..." */, crt.VaList(bp+48, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) } nLook = integerValue(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr((i+1))*8))) szLook = integerValue(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr((i+2))*8))) i = i + (2) - } else if crt.Xstrcmp(tls, z, ts+21640 /* "multithread" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21571 /* "multithread" */) == 0 { sqlite3.Xsqlite3_config(tls, 2, 0) - } else if crt.Xstrcmp(tls, z, ts+21652 /* "nomemstat" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21583 /* "nomemstat" */) == 0 { sqlite3.Xsqlite3_config(tls, 9, crt.VaList(bp+56, 0)) - } else if crt.Xstrcmp(tls, z, ts+21662 /* "mmap" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21593 /* "mmap" */) == 0 { if i >= (argc - 1) { - fatal_error(tls, ts+21535 /* "missing argument..." */, crt.VaList(bp+64, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) + fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+64, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) } mmapSize = integerValue(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr(crt.PreIncInt32(&i, 1))*8))) - } else if crt.Xstrcmp(tls, z, ts+21667 /* "nosync" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21598 /* "nosync" */) == 0 { noSync = 1 - } else if crt.Xstrcmp(tls, z, ts+21674 /* "notnull" */) == 0 { - g.zNN = ts + 21682 /* "NOT NULL" */ - } else if crt.Xstrcmp(tls, z, ts+21691 /* "pagesize" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21605 /* "notnull" */) == 0 { + g.zNN = ts + 21613 /* "NOT NULL" */ + } else if crt.Xstrcmp(tls, z, ts+21622 /* "pagesize" */) == 0 { if i >= (argc - 1) { - fatal_error(tls, ts+21535 /* "missing argument..." */, crt.VaList(bp+72, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) + fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+72, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) } pageSize = integerValue(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr(crt.PreIncInt32(&i, 1))*8))) - } else if crt.Xstrcmp(tls, z, ts+21700 /* "pcache" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21631 /* "pcache" */) == 0 { if i >= (argc - 2) { - fatal_error(tls, ts+21582 /* "missing argument..." */, crt.VaList(bp+80, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) + fatal_error(tls, ts+21513 /* "missing argument..." */, crt.VaList(bp+80, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) } nPCache = integerValue(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr((i+1))*8))) szPCache = integerValue(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr((i+2))*8))) doPCache = 1 i = i + (2) - } else if crt.Xstrcmp(tls, z, ts+21707 /* "primarykey" */) == 0 { - g.zPK = ts + 21718 /* "PRIMARY KEY" */ - } else if crt.Xstrcmp(tls, z, ts+21730 /* "repeat" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21638 /* "primarykey" */) == 0 { + g.zPK = ts + 21649 /* "PRIMARY KEY" */ + } else if crt.Xstrcmp(tls, z, ts+21661 /* "repeat" */) == 0 { if i >= (argc - 1) { - fatal_error(tls, ts+21582 /* "missing argument..." */, crt.VaList(bp+88, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) + fatal_error(tls, ts+21513 /* "missing argument..." */, crt.VaList(bp+88, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) } g.nRepeat = integerValue(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr((i+1))*8))) i = i + (1) - } else if crt.Xstrcmp(tls, z, ts+21737 /* "reprepare" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21668 /* "reprepare" */) == 0 { g.bReprepare = 1 - } else if crt.Xstrcmp(tls, z, ts+21747 /* "serialized" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21678 /* "serialized" */) == 0 { sqlite3.Xsqlite3_config(tls, 3, 0) - } else if crt.Xstrcmp(tls, z, ts+21758 /* "singlethread" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21689 /* "singlethread" */) == 0 { sqlite3.Xsqlite3_config(tls, 1, 0) - } else if crt.Xstrcmp(tls, z, ts+21771 /* "sqlonly" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21702 /* "sqlonly" */) == 0 { g.bSqlOnly = 1 - } else if crt.Xstrcmp(tls, z, ts+21779 /* "shrink-memory" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21710 /* "shrink-memory" */) == 0 { g.bMemShrink = 1 - } else if crt.Xstrcmp(tls, z, ts+21793 /* "size" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21724 /* "size" */) == 0 { if i >= (argc - 1) { - fatal_error(tls, ts+21535 /* "missing argument..." */, crt.VaList(bp+96, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) + fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+96, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) } g.szTest = integerValue(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr(crt.PreIncInt32(&i, 1))*8))) - } else if crt.Xstrcmp(tls, z, ts+21798 /* "stats" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21729 /* "stats" */) == 0 { showStats = 1 - } else if crt.Xstrcmp(tls, z, ts+21804 /* "temp" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21735 /* "temp" */) == 0 { if i >= (argc - 1) { - fatal_error(tls, ts+21535 /* "missing argument..." */, crt.VaList(bp+104, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) + fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+104, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) } i++ if ((int32(*(*int8)(unsafe.Pointer(*(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)) + uintptr(0)))) < '0') || (int32(*(*int8)(unsafe.Pointer(*(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)) + uintptr(0)))) > '9')) || (int32(*(*int8)(unsafe.Pointer(*(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)) + uintptr(1)))) != 0) { - fatal_error(tls, ts+21809 /* "argument to --te..." */, 0) + fatal_error(tls, ts+21740 /* "argument to --te..." */, 0) } g.eTemp = (int32(*(*int8)(unsafe.Pointer(*(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)) + uintptr(0)))) - '0') - } else if crt.Xstrcmp(tls, z, ts+21862 /* "testset" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21793 /* "testset" */) == 0 { if i >= (argc - 1) { - fatal_error(tls, ts+21535 /* "missing argument..." */, crt.VaList(bp+112, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) + fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+112, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) } zTSet = *(*uintptr)(unsafe.Pointer(argv + uintptr(crt.PreIncInt32(&i, 1))*8)) - } else if crt.Xstrcmp(tls, z, ts+21870 /* "trace" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21801 /* "trace" */) == 0 { doTrace = 1 - } else if crt.Xstrcmp(tls, z, ts+21876 /* "threads" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21807 /* "threads" */) == 0 { if i >= (argc - 1) { - fatal_error(tls, ts+21535 /* "missing argument..." */, crt.VaList(bp+120, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) + fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+120, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)))) } nThread = integerValue(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr(crt.PreIncInt32(&i, 1))*8))) - } else if crt.Xstrcmp(tls, z, ts+21884 /* "utf16le" */) == 0 { - zEncoding = ts + 21884 /* "utf16le" */ - } else if crt.Xstrcmp(tls, z, ts+21892 /* "utf16be" */) == 0 { - zEncoding = ts + 21892 /* "utf16be" */ - } else if crt.Xstrcmp(tls, z, ts+21900 /* "verify" */) == 0 { + } else if crt.Xstrcmp(tls, z, ts+21815 /* "utf16le" */) == 0 { + zEncoding = ts + 21815 /* "utf16le" */ + } else if crt.Xstrcmp(tls, z, ts+21823 /* "utf16be" */) == 0 { + zEncoding = ts + 21823 /* "utf16be" */ + } else if crt.Xstrcmp(tls, z, ts+21831 /* "verify" */) == 0 { g.bVerify = 1 - } else if crt.Xstrcmp(tls, z, ts+21907 /* "without-rowid" */) == 0 { - g.zWR = ts + 5741 /* "WITHOUT ROWID" */ - g.zPK = ts + 21718 /* "PRIMARY KEY" */ - } else if (crt.Xstrcmp(tls, z, ts+21921 /* "help" */) == 0) || (crt.Xstrcmp(tls, z, ts+21926 /* "?" */) == 0) { + } else if crt.Xstrcmp(tls, z, ts+21838 /* "without-rowid" */) == 0 { + g.zWR = ts + 5672 /* "WITHOUT ROWID" */ + g.zPK = ts + 21649 /* "PRIMARY KEY" */ + } else if (crt.Xstrcmp(tls, z, ts+21852 /* "help" */) == 0) || (crt.Xstrcmp(tls, z, ts+21857 /* "?" */) == 0) { crt.Xprintf(tls, uintptr(unsafe.Pointer(&zHelp)), crt.VaList(bp+128, *(*uintptr)(unsafe.Pointer(argv + uintptr(0)*8)))) crt.Xexit(tls, 0) } else { - fatal_error(tls, ts+21928, /* "unknown option: ..." */ + fatal_error(tls, ts+21859, /* "unknown option: ..." */ crt.VaList(bp+136, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)), *(*uintptr)(unsafe.Pointer(argv + uintptr(0)*8)))) } } else if zDbName == uintptr(0) { zDbName = *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)) } else { - fatal_error(tls, ts+21969, /* "surplus argument..." */ + fatal_error(tls, ts+21900, /* "surplus argument..." */ crt.VaList(bp+152, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)), *(*uintptr)(unsafe.Pointer(argv + uintptr(0)*8)))) } } @@ -4766,24 +4762,24 @@ func main1(tls *crt.TLS, argc int32, argv uintptr) int32 { /* speedtest1.c:1974: if nHeap > 0 { pHeap = crt.Xmalloc(tls, uint64(nHeap)) if pHeap == uintptr(0) { - fatal_error(tls, ts+22012 /* "cannot allocate ..." */, crt.VaList(bp+168, nHeap)) + fatal_error(tls, ts+21943 /* "cannot allocate ..." */, crt.VaList(bp+168, nHeap)) } rc = sqlite3.Xsqlite3_config(tls, 8, crt.VaList(bp+176, pHeap, nHeap, mnHeap)) if rc != 0 { - fatal_error(tls, ts+22042 /* "heap configurati..." */, crt.VaList(bp+200, rc)) + fatal_error(tls, ts+21973 /* "heap configurati..." */, crt.VaList(bp+200, rc)) } } if doPCache != 0 { if (nPCache > 0) && (szPCache > 0) { pPCache = crt.Xmalloc(tls, (uint64(sqlite3_int64(nPCache) * sqlite3_int64(szPCache)))) if pPCache == uintptr(0) { - fatal_error(tls, ts+22073, /* "cannot allocate ..." */ + fatal_error(tls, ts+22004, /* "cannot allocate ..." */ crt.VaList(bp+208, (sqlite3_int64(nPCache)*sqlite3_int64(szPCache)))) } } rc = sqlite3.Xsqlite3_config(tls, 7, crt.VaList(bp+216, pPCache, szPCache, nPCache)) if rc != 0 { - fatal_error(tls, ts+22107 /* "pcache configura..." */, crt.VaList(bp+240, rc)) + fatal_error(tls, ts+22038 /* "pcache configura..." */, crt.VaList(bp+240, rc)) } } if nLook >= 0 { @@ -4793,18 +4789,18 @@ func main1(tls *crt.TLS, argc int32, argv uintptr) int32 { /* speedtest1.c:1974: // Open the database and the input file if sqlite3.Xsqlite3_open(tls, zDbName, (uintptr(unsafe.Pointer(&g)) /* &.db */)) != 0 { - fatal_error(tls, ts+22140 /* "Cannot open data..." */, crt.VaList(bp+264, zDbName)) + fatal_error(tls, ts+22071 /* "Cannot open data..." */, crt.VaList(bp+264, zDbName)) } if (nLook > 0) && (szLook > 0) { pLook = crt.Xmalloc(tls, (uint64(nLook * szLook))) rc = sqlite3.Xsqlite3_db_config(tls, g.db, 1001, crt.VaList(bp+272, pLook, szLook, nLook)) if rc != 0 { - fatal_error(tls, ts+22171 /* "lookaside config..." */, crt.VaList(bp+296, rc)) + fatal_error(tls, ts+22102 /* "lookaside config..." */, crt.VaList(bp+296, rc)) } } // Set database connection options - sqlite3.Xsqlite3_create_function(tls, g.db, ts+22207 /* "random" */, 0, 1, uintptr(0), *(*uintptr)(unsafe.Pointer(&struct { + sqlite3.Xsqlite3_create_function(tls, g.db, ts+22138 /* "random" */, 0, 1, uintptr(0), *(*uintptr)(unsafe.Pointer(&struct { f func(*crt.TLS, uintptr, int32, uintptr) }{randomFunc})), uintptr(0), uintptr(0)) if doTrace != 0 { @@ -4813,63 +4809,63 @@ func main1(tls *crt.TLS, argc int32, argv uintptr) int32 { /* speedtest1.c:1974: }{traceCallback})), uintptr(0)) } if mmapSize > 0 { - speedtest1_exec(tls, ts+22214 /* "PRAGMA mmap_size..." */, crt.VaList(bp+304, mmapSize)) + speedtest1_exec(tls, ts+22145 /* "PRAGMA mmap_size..." */, crt.VaList(bp+304, mmapSize)) } - speedtest1_exec(tls, ts+22234 /* "PRAGMA threads=%..." */, crt.VaList(bp+312, nThread)) + speedtest1_exec(tls, ts+22165 /* "PRAGMA threads=%..." */, crt.VaList(bp+312, nThread)) if zKey != 0 { - speedtest1_exec(tls, ts+22252 /* "PRAGMA key('%s')" */, crt.VaList(bp+320, zKey)) + speedtest1_exec(tls, ts+22183 /* "PRAGMA key('%s')" */, crt.VaList(bp+320, zKey)) } if zEncoding != 0 { - speedtest1_exec(tls, ts+22269 /* "PRAGMA encoding=..." */, crt.VaList(bp+328, zEncoding)) + speedtest1_exec(tls, ts+22200 /* "PRAGMA encoding=..." */, crt.VaList(bp+328, zEncoding)) } if doAutovac != 0 { - speedtest1_exec(tls, ts+22288 /* "PRAGMA auto_vacu..." */, 0) + speedtest1_exec(tls, ts+22219 /* "PRAGMA auto_vacu..." */, 0) } else if doIncrvac != 0 { - speedtest1_exec(tls, ts+22312 /* "PRAGMA auto_vacu..." */, 0) + speedtest1_exec(tls, ts+22243 /* "PRAGMA auto_vacu..." */, 0) } if pageSize != 0 { - speedtest1_exec(tls, ts+22343 /* "PRAGMA page_size..." */, crt.VaList(bp+336, pageSize)) + speedtest1_exec(tls, ts+22274 /* "PRAGMA page_size..." */, crt.VaList(bp+336, pageSize)) } if cacheSize != 0 { - speedtest1_exec(tls, ts+22363 /* "PRAGMA cache_siz..." */, crt.VaList(bp+344, cacheSize)) + speedtest1_exec(tls, ts+22294 /* "PRAGMA cache_siz..." */, crt.VaList(bp+344, cacheSize)) } if noSync != 0 { - speedtest1_exec(tls, ts+22384 /* "PRAGMA synchrono..." */, 0) + speedtest1_exec(tls, ts+22315 /* "PRAGMA synchrono..." */, 0) } if doExclusive != 0 { - speedtest1_exec(tls, ts+22407 /* "PRAGMA locking_m..." */, 0) + speedtest1_exec(tls, ts+22338 /* "PRAGMA locking_m..." */, 0) } if zJMode != 0 { - speedtest1_exec(tls, ts+22437 /* "PRAGMA journal_m..." */, crt.VaList(bp+352, zJMode)) + speedtest1_exec(tls, ts+22368 /* "PRAGMA journal_m..." */, crt.VaList(bp+352, zJMode)) } if g.bExplain != 0 { - crt.Xprintf(tls, ts+22460 /* ".explain\n.echo o..." */, 0) + crt.Xprintf(tls, ts+22391 /* ".explain\n.echo o..." */, 0) } - if crt.Xstrcmp(tls, zTSet, ts+21467 /* "main" */) == 0 { + if crt.Xstrcmp(tls, zTSet, ts+21398 /* "main" */) == 0 { testset_main(tls) - } else if crt.Xstrcmp(tls, zTSet, ts+22479 /* "debug1" */) == 0 { + } else if crt.Xstrcmp(tls, zTSet, ts+22410 /* "debug1" */) == 0 { testset_debug1(tls) - } else if crt.Xstrcmp(tls, zTSet, ts+22486 /* "orm" */) == 0 { + } else if crt.Xstrcmp(tls, zTSet, ts+22417 /* "orm" */) == 0 { testset_orm(tls) - } else if crt.Xstrcmp(tls, zTSet, ts+22490 /* "cte" */) == 0 { + } else if crt.Xstrcmp(tls, zTSet, ts+22421 /* "cte" */) == 0 { testset_cte(tls) - } else if crt.Xstrcmp(tls, zTSet, ts+22494 /* "fp" */) == 0 { + } else if crt.Xstrcmp(tls, zTSet, ts+22425 /* "fp" */) == 0 { testset_fp(tls) - } else if crt.Xstrcmp(tls, zTSet, ts+22497 /* "trigger" */) == 0 { + } else if crt.Xstrcmp(tls, zTSet, ts+22428 /* "trigger" */) == 0 { testset_trigger(tls) - } else if crt.Xstrcmp(tls, zTSet, ts+22505 /* "rtree" */) == 0 { + } else if crt.Xstrcmp(tls, zTSet, ts+22436 /* "rtree" */) == 0 { fatal_error(tls, - ts+22511 /* "compile with -DS..." */, 0) + ts+22442 /* "compile with -DS..." */, 0) } else { fatal_error(tls, - ts+22574, /* "unknown testset:..." */ + ts+22505, /* "unknown testset:..." */ crt.VaList(bp+360, zTSet)) } speedtest1_final(tls) if showStats != 0 { - sqlite3.Xsqlite3_exec(tls, g.db, ts+22643 /* "PRAGMA compile_o..." */, *(*uintptr)(unsafe.Pointer(&struct { + sqlite3.Xsqlite3_exec(tls, g.db, ts+22574 /* "PRAGMA compile_o..." */, *(*uintptr)(unsafe.Pointer(&struct { f func(*crt.TLS, uintptr, int32, uintptr, uintptr) int32 }{xCompileOptions})), uintptr(0), uintptr(0)) } @@ -4878,25 +4874,25 @@ func main1(tls *crt.TLS, argc int32, argv uintptr) int32 { /* speedtest1.c:1974: // have been finalized if showStats != 0 { sqlite3.Xsqlite3_db_status(tls, g.db, 0, bp+520 /* &iCur */, bp+524 /* &iHi */, 0) - crt.Xprintf(tls, ts+22666 /* "-- Lookaside Slo..." */, crt.VaList(bp+368, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)), *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) + crt.Xprintf(tls, ts+22597 /* "-- Lookaside Slo..." */, crt.VaList(bp+368, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)), *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) sqlite3.Xsqlite3_db_status(tls, g.db, 4, bp+520 /* &iCur */, bp+524 /* &iHi */, 0) - crt.Xprintf(tls, ts+22711 /* "-- Successful lo..." */, crt.VaList(bp+384, *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) + crt.Xprintf(tls, ts+22642 /* "-- Successful lo..." */, crt.VaList(bp+384, *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) sqlite3.Xsqlite3_db_status(tls, g.db, 5, bp+520 /* &iCur */, bp+524 /* &iHi */, 0) - crt.Xprintf(tls, ts+22747 /* "-- Lookaside siz..." */, crt.VaList(bp+392, *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) + crt.Xprintf(tls, ts+22678 /* "-- Lookaside siz..." */, crt.VaList(bp+392, *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) sqlite3.Xsqlite3_db_status(tls, g.db, 6, bp+520 /* &iCur */, bp+524 /* &iHi */, 0) - crt.Xprintf(tls, ts+22783 /* "-- Lookaside OOM..." */, crt.VaList(bp+400, *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) + crt.Xprintf(tls, ts+22714 /* "-- Lookaside OOM..." */, crt.VaList(bp+400, *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) sqlite3.Xsqlite3_db_status(tls, g.db, 1, bp+520 /* &iCur */, bp+524 /* &iHi */, 0) - crt.Xprintf(tls, ts+22819 /* "-- Pager Heap Us..." */, crt.VaList(bp+408, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)))) + crt.Xprintf(tls, ts+22750 /* "-- Pager Heap Us..." */, crt.VaList(bp+408, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)))) sqlite3.Xsqlite3_db_status(tls, g.db, 7, bp+520 /* &iCur */, bp+524 /* &iHi */, 1) - crt.Xprintf(tls, ts+22861 /* "-- Page cache hi..." */, crt.VaList(bp+416, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)))) + crt.Xprintf(tls, ts+22792 /* "-- Page cache hi..." */, crt.VaList(bp+416, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)))) sqlite3.Xsqlite3_db_status(tls, g.db, 8, bp+520 /* &iCur */, bp+524 /* &iHi */, 1) - crt.Xprintf(tls, ts+22897 /* "-- Page cache mi..." */, crt.VaList(bp+424, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)))) + crt.Xprintf(tls, ts+22828 /* "-- Page cache mi..." */, crt.VaList(bp+424, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)))) sqlite3.Xsqlite3_db_status(tls, g.db, 9, bp+520 /* &iCur */, bp+524 /* &iHi */, 1) - crt.Xprintf(tls, ts+22933 /* "-- Page cache wr..." */, crt.VaList(bp+432, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)))) + crt.Xprintf(tls, ts+22864 /* "-- Page cache wr..." */, crt.VaList(bp+432, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)))) sqlite3.Xsqlite3_db_status(tls, g.db, 2, bp+520 /* &iCur */, bp+524 /* &iHi */, 0) - crt.Xprintf(tls, ts+22969 /* "-- Schema Heap U..." */, crt.VaList(bp+440, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)))) + crt.Xprintf(tls, ts+22900 /* "-- Schema Heap U..." */, crt.VaList(bp+440, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)))) sqlite3.Xsqlite3_db_status(tls, g.db, 3, bp+520 /* &iCur */, bp+524 /* &iHi */, 0) - crt.Xprintf(tls, ts+23011 /* "-- Statement Hea..." */, crt.VaList(bp+448, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)))) + crt.Xprintf(tls, ts+22942 /* "-- Statement Hea..." */, crt.VaList(bp+448, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)))) } sqlite3.Xsqlite3_close(tls, g.db) @@ -4905,15 +4901,15 @@ func main1(tls *crt.TLS, argc int32, argv uintptr) int32 { /* speedtest1.c:1974: // has closed. Memory usage should be zero at this point. if showStats != 0 { sqlite3.Xsqlite3_status(tls, 0, bp+520 /* &iCur */, bp+524 /* &iHi */, 0) - crt.Xprintf(tls, ts+23053 /* "-- Memory Used (..." */, crt.VaList(bp+456, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)), *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) + crt.Xprintf(tls, ts+22984 /* "-- Memory Used (..." */, crt.VaList(bp+456, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)), *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) sqlite3.Xsqlite3_status(tls, 9, bp+520 /* &iCur */, bp+524 /* &iHi */, 0) - crt.Xprintf(tls, ts+23098 /* "-- Outstanding A..." */, crt.VaList(bp+472, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)), *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) + crt.Xprintf(tls, ts+23029 /* "-- Outstanding A..." */, crt.VaList(bp+472, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)), *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) sqlite3.Xsqlite3_status(tls, 2, bp+520 /* &iCur */, bp+524 /* &iHi */, 0) - crt.Xprintf(tls, ts+23143 /* "-- Pcache Overfl..." */, crt.VaList(bp+488, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)), *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) + crt.Xprintf(tls, ts+23074 /* "-- Pcache Overfl..." */, crt.VaList(bp+488, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */)), *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) sqlite3.Xsqlite3_status(tls, 5, bp+520 /* &iCur */, bp+524 /* &iHi */, 0) - crt.Xprintf(tls, ts+23188 /* "-- Largest Alloc..." */, crt.VaList(bp+504, *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) + crt.Xprintf(tls, ts+23119 /* "-- Largest Alloc..." */, crt.VaList(bp+504, *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) sqlite3.Xsqlite3_status(tls, 7, bp+520 /* &iCur */, bp+524 /* &iHi */, 0) - crt.Xprintf(tls, ts+23230 /* "-- Largest Pcach..." */, crt.VaList(bp+512, *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) + crt.Xprintf(tls, ts+23161 /* "-- Largest Pcach..." */, crt.VaList(bp+512, *(*int32)(unsafe.Pointer(bp + 524 /* iHi */)))) } if showStats != 0 { @@ -4927,5 +4923,5 @@ func main1(tls *crt.TLS, argc int32, argv uintptr) int32 { /* speedtest1.c:1974: return 0 } -var ts1 = "Usage: %s [--options] DATABASE\nOptions:\n --autovacuum Enable AUTOVACUUM mode\n --cachesize N Set the cache size to N\n --exclusive Enable locking_mode=EXCLUSIVE\n --explain Like --sqlonly but with added EXPLAIN keywords\n --heap SZ MIN Memory allocator uses SZ bytes & min allocation MIN\n --incrvacuum Enable incremenatal vacuum mode\n --journal M Set the journal_mode to M\n --key KEY Set the encryption key to KEY\n --lookaside N SZ Configure lookaside for N slots of SZ bytes each\n --mmap SZ MMAP the first SZ bytes of the database file\n --multithread Set multithreaded mode\n --nomemstat Disable memory statistics\n --nosync Set PRAGMA synchronous=OFF\n --notnull Add NOT NULL constraints to table columns\n --pagesize N Set the page size to N\n --pcache N SZ Configure N pages of pagecache each of size SZ bytes\n --primarykey Use PRIMARY KEY instead of UNIQUE where appropriate\n --repeat N Repeat each SELECT N times (default: 1)\n --reprepare Reprepare each statement upon every invocation\n --serialized Set serialized threading mode\n --singlethread Set single-threaded mode - disables all mutexing\n --sqlonly No-op. Only show the SQL that would have been run.\n --shrink-memory Invoke sqlite3_db_release_memory() frequently.\n --size N Relative test size. Default=100\n --stats Show statistics at the end\n --temp N N from 0 to 9. 0: no temp table. 9: all temp tables\n --testset T Run test-set T (main, cte, rtree, orm, fp, debug)\n --trace Turn on SQL tracing\n --threads N Use up to N threads for sorting\n --utf16be Set text encoding to UTF-16BE\n --utf16le Set text encoding to UTF-16LE\n --verify Run additional verification steps.\n --without-rowid Use WITHOUT ROWID where appropriate\n\x00 TEMP\x00\x00parameter too large - max 2147483648\x00KiB\x00MiB\x00GiB\x00KB\x00MB\x00GB\x00K\x00M\x00G\x00 billion\x00 million\x00 thousand\x00%s hundred\x00%s\x00zero\x00one\x00two\x00three\x00four\x00five\x00six\x00seven\x00eight\x00nine\x00ten\x00eleven\x00twelve\x00thirteen\x00fourteen\x00fifteen\x00sixteen\x00seventeen\x00eighteen\x00nineteen\x00twenty\x00thirty\x00forty\x00fifty\x00sixty\x00seventy\x00eighty\x00ninety\x00.......................................................................\x00/* %4d - %s%.*s */\n\x00%4d - %s%.*s \x00%4d.%03ds\n\x00 TOTAL%.*s %4d.%03ds\n\x00EXPLAIN \x00%.*s;\n\x00CREATE *\x00DROP *\x00ALTER *\x00SQL error: %s\n%s\n\x00exec error: %s\n\x00SQL error: %s\n\x00g.pStmt\x00testdata/sqlite-src-3320300/test/speedtest1.c\x00nil\x00speedtest1_run\x00%d INSERTs into table with no index\x00BEGIN\x00CREATE%s TABLE t1(a INTEGER %s, b INTEGER %s, c TEXT %s);\x00INSERT INTO t1 VALUES(?1,?2,?3); -- %d times\x00COMMIT\x00%d ordered INSERTS with one index/PK\x00CREATE%s TABLE t2(a INTEGER %s %s, b INTEGER %s, c TEXT %s) %s\x00INSERT INTO t2 VALUES(?1,?2,?3); -- %d times\x00%d unordered INSERTS with one index/PK\x00CREATE%s TABLE t3(a INTEGER %s %s, b INTEGER %s, c TEXT %s) %s\x00INSERT INTO t3 VALUES(?1,?2,?3); -- %d times\x00%d SELECTS, numeric BETWEEN, unindexed\x00SELECT count(*), avg(b), sum(length(c)), group_concat(c) FROM t1\n WHERE b BETWEEN ?1 AND ?2; -- %d times\x00%d SELECTS, LIKE, unindexed\x00SELECT count(*), avg(b), sum(length(c)), group_concat(c) FROM t1\n WHERE c LIKE ?1; -- %d times\x00%d SELECTS w/ORDER BY, unindexed\x00SELECT a, b, c FROM t1 WHERE c LIKE ?1\n ORDER BY a; -- %d times\x00%d SELECTS w/ORDER BY and LIMIT, unindexed\x00SELECT a, b, c FROM t1 WHERE c LIKE ?1\n ORDER BY a LIMIT 10; -- %d times\x00CREATE INDEX five times\x00BEGIN;\x00CREATE UNIQUE INDEX t1b ON t1(b);\x00CREATE INDEX t1c ON t1(c);\x00CREATE UNIQUE INDEX t2b ON t2(b);\x00CREATE INDEX t2c ON t2(c DESC);\x00CREATE INDEX t3bc ON t3(b,c);\x00COMMIT;\x00%d SELECTS, numeric BETWEEN, indexed\x00SELECT count(*), avg(b), sum(length(c)), group_concat(a) FROM t1\n WHERE b BETWEEN ?1 AND ?2; -- %d times\x00%d SELECTS, numeric BETWEEN, PK\x00SELECT count(*), avg(b), sum(length(c)), group_concat(a) FROM t2\n WHERE a BETWEEN ?1 AND ?2; -- %d times\x00%d SELECTS, text BETWEEN, indexed\x00SELECT count(*), avg(b), sum(length(c)), group_concat(a) FROM t1\n WHERE c BETWEEN ?1 AND (?1||'~'); -- %d times\x00%d INSERTS with three indexes\x00CREATE%s TABLE t4(\n a INTEGER %s %s,\n b INTEGER %s,\n c TEXT %s\n) %s\x00CREATE INDEX t4b ON t4(b)\x00CREATE INDEX t4c ON t4(c)\x00INSERT INTO t4 SELECT * FROM t1\x00DELETE and REFILL one table\x00DELETE FROM t2;\x00INSERT INTO t2 SELECT * FROM t1;\x00VACUUM\x00ALTER TABLE ADD COLUMN, and query\x00ALTER TABLE t2 ADD COLUMN d DEFAULT 123\x00SELECT sum(d) FROM t2\x00%d UPDATES, numeric BETWEEN, indexed\x00UPDATE t2 SET d=b*2 WHERE b BETWEEN ?1 AND ?2; -- %d times\x00%d UPDATES of individual rows\x00UPDATE t2 SET d=b*3 WHERE a=?1; -- %d times\x00One big UPDATE of the whole %d-row table\x00UPDATE t2 SET d=b*4\x00Query added column after filling\x00%d DELETEs, numeric BETWEEN, indexed\x00DELETE FROM t2 WHERE b BETWEEN ?1 AND ?2; -- %d times\x00%d DELETEs of individual rows\x00DELETE FROM t3 WHERE a=?1; -- %d times\x00Refill two %d-row tables using REPLACE\x00REPLACE INTO t2(a,b,c) SELECT a,b,c FROM t1\x00REPLACE INTO t3(a,b,c) SELECT a,b,c FROM t1\x00Refill a %d-row table using (b&1)==(a&1)\x00INSERT INTO t2(a,b,c)\n SELECT a,b,c FROM t1 WHERE (b&1)==(a&1);\x00INSERT INTO t2(a,b,c)\n SELECT a,b,c FROM t1 WHERE (b&1)<>(a&1);\x00%d four-ways joins\x00SELECT t1.c FROM t1, t2, t3, t4\n WHERE t4.a BETWEEN ?1 AND ?2\n AND t3.a=t4.b\n AND t2.a=t3.b\n AND t1.c=t2.c\x00subquery in result set\x00SELECT sum(a), max(c),\n avg((SELECT a FROM t2 WHERE 5+t2.b=t1.b) AND rowid<?1), max(c)\n FROM t1 WHERE rowid<?1;\x00%d REPLACE ops on an IPK\x00CREATE%s TABLE t5(a INTEGER PRIMARY KEY, b %s);\x00REPLACE INTO t5 VALUES(?1,?2); -- %d times\x00%d SELECTS on an IPK\x00SELECT b FROM t5 WHERE a=?1; -- %d times\x00%d REPLACE on TEXT PK\x00CREATE%s TABLE t6(a TEXT PRIMARY KEY, b %s)%s;\x00WITHOUT ROWID\x00REPLACE INTO t6 VALUES(?1,?2); -- %d times\x00%d SELECTS on a TEXT PK\x00SELECT b FROM t6 WHERE a=?1; -- %d times\x00%d SELECT DISTINCT\x00SELECT DISTINCT b FROM t5;\x00SELECT DISTINCT b FROM t6;\x00PRAGMA integrity_check\x00ANALYZE\x00Sudoku with recursive 'digits'\x00WITH RECURSIVE\n input(sud) AS (VALUES(?1)),\n digits(z,lp) AS (\n VALUES('1', 1)\n UNION ALL\n SELECT CAST(lp+1 AS TEXT), lp+1 FROM digits WHERE lp<9\n ),\n x(s, ind) AS (\n SELECT sud, instr(sud, '.') FROM input\n UNION ALL\n SELECT\n substr(s, 1, ind-1) || z || substr(s, ind+1),\n instr( substr(s, 1, ind-1) || z || substr(s, ind+1), '.' )\n FROM x, digits AS z\n WHERE ind>0\n AND NOT EXISTS (\n SELECT 1\n FROM digits AS lp\n WHERE z.z = substr(s, ((ind-1)/9)*9 + lp, 1)\n OR z.z = substr(s, ((ind-1)%%9) + (lp-1)*9 + 1, 1)\n OR z.z = substr(s, (((ind-1)/3) %% 3) * 3\n + ((ind-1)/27) * 27 + lp\n + ((lp-1) / 3) * 6, 1)\n )\n )\nSELECT s FROM x WHERE ind=0;\x00Sudoku with VALUES 'digits'\x00WITH RECURSIVE\n input(sud) AS (VALUES(?1)),\n digits(z,lp) AS (VALUES('1',1),('2',2),('3',3),('4',4),('5',5),\n ('6',6),('7',7),('8',8),('9',9)),\n x(s, ind) AS (\n SELECT sud, instr(sud, '.') FROM input\n UNION ALL\n SELECT\n substr(s, 1, ind-1) || z || substr(s, ind+1),\n instr( substr(s, 1, ind-1) || z || substr(s, ind+1), '.' )\n FROM x, digits AS z\n WHERE ind>0\n AND NOT EXISTS (\n SELECT 1\n FROM digits AS lp\n WHERE z.z = substr(s, ((ind-1)/9)*9 + lp, 1)\n OR z.z = substr(s, ((ind-1)%%9) + (lp-1)*9 + 1, 1)\n OR z.z = substr(s, (((ind-1)/3) %% 3) * 3\n + ((ind-1)/27) * 27 + lp\n + ((lp-1) / 3) * 6, 1)\n )\n )\nSELECT s FROM x WHERE ind=0;\x00Mandelbrot Set with spacing=%f\x00WITH RECURSIVE \n xaxis(x) AS (VALUES(-2.0) UNION ALL SELECT x+?1 FROM xaxis WHERE x<1.2),\n yaxis(y) AS (VALUES(-1.0) UNION ALL SELECT y+?2 FROM yaxis WHERE y<1.0),\n m(iter, cx, cy, x, y) AS (\n SELECT 0, x, y, 0.0, 0.0 FROM xaxis, yaxis\n UNION ALL\n SELECT iter+1, cx, cy, x*x-y*y + cx, 2.0*x*y + cy FROM m \n WHERE (x*x + y*y) < 4.0 AND iter<28\n ),\n m2(iter, cx, cy) AS (\n SELECT max(iter), cx, cy FROM m GROUP BY cx, cy\n ),\n a(t) AS (\n SELECT group_concat( substr(' .+*#', 1+min(iter/7,4), 1), '') \n FROM m2 GROUP BY cy\n )\nSELECT group_concat(rtrim(t),x'0a') FROM a;\x00EXCEPT operator on %d-element tables\x00WITH RECURSIVE \n t1(x) AS (VALUES(2) UNION ALL SELECT x+2 FROM t1 WHERE x<%d),\n t2(y) AS (VALUES(3) UNION ALL SELECT y+3 FROM t2 WHERE y<%d)\nSELECT count(x), avg(x) FROM (\n SELECT x FROM t1 EXCEPT SELECT y FROM t2 ORDER BY 1\n);\x00534...9..67.195....98....6.8...6...34..8.3..1....2...6.6....28....419..5...28..79\x0053....9..6..195....98....6.8...6...34..8.3..1....2...6.6....28....419..5....8..79\x0053.......6..195....98....6.8...6...34..8.3..1....2...6.6....28....419..5....8..79\x00%d.%de%d\x00Fill a table with %d FP values\x00CREATE%s TABLE t1(a REAL %s, b REAL %s);\x00INSERT INTO t1 VALUES(?1,?2); -- %d times\x00%d range queries\x00SELECT sum(b) FROM t1 WHERE a BETWEEN ?1 AND ?2\x00CREATE INDEX three times\x00CREATE INDEX t1a ON t1(a);\x00CREATE INDEX t1b ON t1(b);\x00CREATE INDEX t1ab ON t1(a,b);\x00%d indexed range queries\x00%d calls to round()\x00SELECT sum(round(a,2)+round(b,4)) FROM t1;\x00%d printf() calls\x00WITH c(fmt) AS (VALUES('%%g'),('%%e'),('%%!g'),('%%.20f'))SELECT sum(printf(fmt,a)) FROM t1, c\x00Fill %d rows\x00BEGIN;CREATE TABLE ZLOOKSLIKECOREDATA ( ZPK INTEGER PRIMARY KEY, ZTERMFITTINGHOUSINGCOMMAND INTEGER, ZBRIEFGOBYDODGERHEIGHT BLOB, ZCAPABLETRIPDOORALMOND BLOB, ZDEPOSITPAIRCOLLEGECOMET INTEGER, ZFRAMEENTERSIMPLEMOUTH INTEGER, ZHOPEFULGATEHOLECHALK INTEGER, ZSLEEPYUSERGRANDBOWL TIMESTAMP, ZDEWPEACHCAREERCELERY INTEGER, ZHANGERLITHIUMDINNERMEET VARCHAR, ZCLUBRELEASELIZARDADVICE VARCHAR, ZCHARGECLICKHUMANEHIRE INTEGER, ZFINGERDUEPIZZAOPTION TIMESTAMP, ZFLYINGDOCTORTABLEMELODY BLOB, ZLONGFINLEAVEIMAGEOIL TIMESTAMP, ZFAMILYVISUALOWNERMATTER BLOB, ZGOLDYOUNGINITIALNOSE FLOAT, ZCAUSESALAMITERMCYAN BLOB, ZSPREADMOTORBISCUITBACON FLOAT, ZGIFTICEFISHGLUEHAIR INTEGER, ZNOTICEPEARPOLICYJUICE TIMESTAMP, ZBANKBUFFALORECOVERORBIT TIMESTAMP, ZLONGDIETESSAYNATURE FLOAT, ZACTIONRANGEELEGANTNEUTRON BLOB, ZCADETBRIGHTPLANETBANK TIMESTAMP, ZAIRFORGIVEHEADFROG BLOB, ZSHARKJUSTFRUITMOVIE VARCHAR, ZFARMERMORNINGMIRRORCONCERN BLOB, ZWOODPOETRYCOBBLERBENCH VARCHAR, ZHAFNIUMSCRIPTSALADMOTOR INTEGER, ZPROBLEMCLUBPOPOVERJELLY FLOAT, ZEIGHTLEADERWORKERMOST TIMESTAMP, ZGLASSRESERVEBARIUMMEAL BLOB, ZCLAMBITARUGULAFAJITA BLOB, ZDECADEJOYOUSWAVEHABIT FLOAT, ZCOMPANYSUMMERFIBERELF INTEGER, ZTREATTESTQUILLCHARGE TIMESTAMP, ZBROWBALANCEKEYCHOWDER FLOAT, ZPEACHCOPPERDINNERLAKE FLOAT, ZDRYWALLBEYONDBROWNBOWL VARCHAR, ZBELLYCRASHITEMLACK BLOB, ZTENNISCYCLEBILLOFFICER INTEGER, ZMALLEQUIPTHANKSGLUE FLOAT, ZMISSREPLYHUMANLIVING INTEGER, ZKIWIVISUALPRIDEAPPLE VARCHAR, ZWISHHITSKINMOTOR BLOB, ZCALMRACCOONPROGRAMDEBIT VARCHAR, ZSHINYASSISTLIVINGCRAB VARCHAR, ZRESOLVEWRISTWRAPAPPLE VARCHAR, ZAPPEALSIMPLESECONDHOUSING BLOB, ZCORNERANCHORTAPEDIVER TIMESTAMP, ZMEMORYREQUESTSOURCEBIG VARCHAR, ZTRYFACTKEEPMILK TIMESTAMP, ZDIVERPAINTLEATHEREASY INTEGER, ZSORTMISTYQUOTECABBAGE BLOB, ZTUNEGASBUFFALOCAPITAL BLOB, ZFILLSTOPLAWJOYFUL FLOAT, ZSTEELCAREFULPLATENUMBER FLOAT, ZGIVEVIVIDDIVINEMEANING INTEGER, ZTREATPACKFUTURECONVERT VARCHAR, ZCALMLYGEMFINISHEFFECT INTEGER, ZCABBAGESOCKEASEMINUTE BLOB, ZPLANETFAMILYPUREMEMORY TIMESTAMP, ZMERRYCRACKTRAINLEADER BLOB, ZMINORWAYPAPERCLASSY TIMESTAMP, ZEAGLELINEMINEMAIL VARCHAR, ZRESORTYARDGREENLET TIMESTAMP, ZYARDOREGANOVIVIDJEWEL TIMESTAMP, ZPURECAKEVIVIDNEATLY FLOAT, ZASKCONTACTMONITORFUN TIMESTAMP, ZMOVEWHOGAMMAINCH VARCHAR, ZLETTUCEBIRDMEETDEBATE TIMESTAMP, ZGENENATURALHEARINGKITE VARCHAR, ZMUFFINDRYERDRAWFORTUNE FLOAT, ZGRAYSURVEYWIRELOVE FLOAT, ZPLIERSPRINTASKOREGANO INTEGER, ZTRAVELDRIVERCONTESTLILY INTEGER, ZHUMORSPICESANDKIDNEY TIMESTAMP, ZARSENICSAMPLEWAITMUON INTEGER, ZLACEADDRESSGROUNDCAREFUL FLOAT, ZBAMBOOMESSWASABIEVENING BLOB, ZONERELEASEAVERAGENURSE INTEGER, ZRADIANTWHENTRYCARD TIMESTAMP, ZREWARDINSIDEMANGOINTENSE FLOAT, ZNEATSTEWPARTIRON TIMESTAMP, ZOUTSIDEPEAHENCOUNTICE TIMESTAMP, ZCREAMEVENINGLIPBRANCH FLOAT, ZWHALEMATHAVOCADOCOPPER FLOAT, ZLIFEUSELEAFYBELL FLOAT, ZWEALTHLINENGLEEFULDAY VARCHAR, ZFACEINVITETALKGOLD BLOB, ZWESTAMOUNTAFFECTHEARING INTEGER, ZDELAYOUTCOMEHORNAGENCY INTEGER, ZBIGTHINKCONVERTECONOMY BLOB, ZBASEGOUDAREGULARFORGIVE TIMESTAMP, ZPATTERNCLORINEGRANDCOLBY TIMESTAMP, ZCYANBASEFEEDADROIT INTEGER, ZCARRYFLOORMINNOWDRAGON TIMESTAMP, ZIMAGEPENCILOTHERBOTTOM FLOAT, ZXENONFLIGHTPALEAPPLE TIMESTAMP, ZHERRINGJOKEFEATUREHOPEFUL FLOAT, ZCAPYEARLYRIVETBRUSH FLOAT, ZAGEREEDFROGBASKET VARCHAR, ZUSUALBODYHALIBUTDIAMOND VARCHAR, ZFOOTTAPWORDENTRY VARCHAR, ZDISHKEEPBLESTMONITOR FLOAT, ZBROADABLESOLIDCASUAL INTEGER, ZSQUAREGLEEFULCHILDLIGHT INTEGER, ZHOLIDAYHEADPONYDETAIL INTEGER, ZGENERALRESORTSKYOPEN TIMESTAMP, ZGLADSPRAYKIDNEYGUPPY VARCHAR, ZSWIMHEAVYMENTIONKIND BLOB, ZMESSYSULFURDREAMFESTIVE BLOB, ZSKYSKYCLASSICBRIEF VARCHAR, ZDILLASKHOKILEMON FLOAT, ZJUNIORSHOWPRESSNOVA FLOAT, ZSIZETOEAWARDFRESH TIMESTAMP, ZKEYFAILAPRICOTMETAL VARCHAR, ZHANDYREPAIRPROTONAIRPORT VARCHAR, ZPOSTPROTEINHANDLEACTOR BLOB);\x00INSERT INTO ZLOOKSLIKECOREDATA(ZPK,ZAIRFORGIVEHEADFROG,ZGIFTICEFISHGLUEHAIR,ZDELAYOUTCOMEHORNAGENCY,ZSLEEPYUSERGRANDBOWL,ZGLASSRESERVEBARIUMMEAL,ZBRIEFGOBYDODGERHEIGHT,ZBAMBOOMESSWASABIEVENING,ZFARMERMORNINGMIRRORCONCERN,ZTREATPACKFUTURECONVERT,ZCAUSESALAMITERMCYAN,ZCALMRACCOONPROGRAMDEBIT,ZHOLIDAYHEADPONYDETAIL,ZWOODPOETRYCOBBLERBENCH,ZHAFNIUMSCRIPTSALADMOTOR,ZUSUALBODYHALIBUTDIAMOND,ZOUTSIDEPEAHENCOUNTICE,ZDIVERPAINTLEATHEREASY,ZWESTAMOUNTAFFECTHEARING,ZSIZETOEAWARDFRESH,ZDEWPEACHCAREERCELERY,ZSTEELCAREFULPLATENUMBER,ZCYANBASEFEEDADROIT,ZCALMLYGEMFINISHEFFECT,ZHANDYREPAIRPROTONAIRPORT,ZGENENATURALHEARINGKITE,ZBROADABLESOLIDCASUAL,ZPOSTPROTEINHANDLEACTOR,ZLACEADDRESSGROUNDCAREFUL,ZIMAGEPENCILOTHERBOTTOM,ZPROBLEMCLUBPOPOVERJELLY,ZPATTERNCLORINEGRANDCOLBY,ZNEATSTEWPARTIRON,ZAPPEALSIMPLESECONDHOUSING,ZMOVEWHOGAMMAINCH,ZTENNISCYCLEBILLOFFICER,ZSHARKJUSTFRUITMOVIE,ZKEYFAILAPRICOTMETAL,ZCOMPANYSUMMERFIBERELF,ZTERMFITTINGHOUSINGCOMMAND,ZRESORTYARDGREENLET,ZCABBAGESOCKEASEMINUTE,ZSQUAREGLEEFULCHILDLIGHT,ZONERELEASEAVERAGENURSE,ZBIGTHINKCONVERTECONOMY,ZPLIERSPRINTASKOREGANO,ZDECADEJOYOUSWAVEHABIT,ZDRYWALLBEYONDBROWNBOWL,ZCLUBRELEASELIZARDADVICE,ZWHALEMATHAVOCADOCOPPER,ZBELLYCRASHITEMLACK,ZLETTUCEBIRDMEETDEBATE,ZCAPABLETRIPDOORALMOND,ZRADIANTWHENTRYCARD,ZCAPYEARLYRIVETBRUSH,ZAGEREEDFROGBASKET,ZSWIMHEAVYMENTIONKIND,ZTRAVELDRIVERCONTESTLILY,ZGLADSPRAYKIDNEYGUPPY,ZBANKBUFFALORECOVERORBIT,ZFINGERDUEPIZZAOPTION,ZCLAMBITARUGULAFAJITA,ZLONGFINLEAVEIMAGEOIL,ZLONGDIETESSAYNATURE,ZJUNIORSHOWPRESSNOVA,ZHOPEFULGATEHOLECHALK,ZDEPOSITPAIRCOLLEGECOMET,ZWEALTHLINENGLEEFULDAY,ZFILLSTOPLAWJOYFUL,ZTUNEGASBUFFALOCAPITAL,ZGRAYSURVEYWIRELOVE,ZCORNERANCHORTAPEDIVER,ZREWARDINSIDEMANGOINTENSE,ZCADETBRIGHTPLANETBANK,ZPLANETFAMILYPUREMEMORY,ZTREATTESTQUILLCHARGE,ZCREAMEVENINGLIPBRANCH,ZSKYSKYCLASSICBRIEF,ZARSENICSAMPLEWAITMUON,ZBROWBALANCEKEYCHOWDER,ZFLYINGDOCTORTABLEMELODY,ZHANGERLITHIUMDINNERMEET,ZNOTICEPEARPOLICYJUICE,ZSHINYASSISTLIVINGCRAB,ZLIFEUSELEAFYBELL,ZFACEINVITETALKGOLD,ZGENERALRESORTSKYOPEN,ZPURECAKEVIVIDNEATLY,ZKIWIVISUALPRIDEAPPLE,ZMESSYSULFURDREAMFESTIVE,ZCHARGECLICKHUMANEHIRE,ZHERRINGJOKEFEATUREHOPEFUL,ZYARDOREGANOVIVIDJEWEL,ZFOOTTAPWORDENTRY,ZWISHHITSKINMOTOR,ZBASEGOUDAREGULARFORGIVE,ZMUFFINDRYERDRAWFORTUNE,ZACTIONRANGEELEGANTNEUTRON,ZTRYFACTKEEPMILK,ZPEACHCOPPERDINNERLAKE,ZFRAMEENTERSIMPLEMOUTH,ZMERRYCRACKTRAINLEADER,ZMEMORYREQUESTSOURCEBIG,ZCARRYFLOORMINNOWDRAGON,ZMINORWAYPAPERCLASSY,ZDILLASKHOKILEMON,ZRESOLVEWRISTWRAPAPPLE,ZASKCONTACTMONITORFUN,ZGIVEVIVIDDIVINEMEANING,ZEIGHTLEADERWORKERMOST,ZMISSREPLYHUMANLIVING,ZXENONFLIGHTPALEAPPLE,ZSORTMISTYQUOTECABBAGE,ZEAGLELINEMINEMAIL,ZFAMILYVISUALOWNERMATTER,ZSPREADMOTORBISCUITBACON,ZDISHKEEPBLESTMONITOR,ZMALLEQUIPTHANKSGLUE,ZGOLDYOUNGINITIALNOSE,ZHUMORSPICESANDKIDNEY)VALUES(?1,?26,?20,?93,?8,?33,?3,?81,?28,?60,?18,?47,?109,?29,?30,?104,?86,?54,?92,?117,?9,?58,?97,?61,?119,?73,?107,?120,?80,?99,?31,?96,?85,?50,?71,?42,?27,?118,?36,?2,?67,?62,?108,?82,?94,?76,?35,?40,?11,?88,?41,?72,?4,?83,?102,?103,?112,?77,?111,?22,?13,?34,?15,?23,?116,?7,?5,?90,?57,?56,?75,?51,?84,?25,?63,?37,?87,?114,?79,?38,?14,?10,?21,?48,?89,?91,?110,?69,?45,?113,?12,?101,?68,?105,?46,?95,?74,?24,?53,?39,?6,?64,?52,?98,?65,?115,?49,?70,?59,?32,?44,?100,?55,?66,?16,?19,?106,?43,?17,?78);\x00Query %d rows by rowid\x00SELECT ZCYANBASEFEEDADROIT,ZJUNIORSHOWPRESSNOVA,ZCAUSESALAMITERMCYAN,ZHOPEFULGATEHOLECHALK,ZHUMORSPICESANDKIDNEY,ZSWIMHEAVYMENTIONKIND,ZMOVEWHOGAMMAINCH,ZAPPEALSIMPLESECONDHOUSING,ZHAFNIUMSCRIPTSALADMOTOR,ZNEATSTEWPARTIRON,ZLONGFINLEAVEIMAGEOIL,ZDEWPEACHCAREERCELERY,ZXENONFLIGHTPALEAPPLE,ZCALMRACCOONPROGRAMDEBIT,ZUSUALBODYHALIBUTDIAMOND,ZTRYFACTKEEPMILK,ZWEALTHLINENGLEEFULDAY,ZLONGDIETESSAYNATURE,ZLIFEUSELEAFYBELL,ZTREATPACKFUTURECONVERT,ZMEMORYREQUESTSOURCEBIG,ZYARDOREGANOVIVIDJEWEL,ZDEPOSITPAIRCOLLEGECOMET,ZSLEEPYUSERGRANDBOWL,ZBRIEFGOBYDODGERHEIGHT,ZCLUBRELEASELIZARDADVICE,ZCAPABLETRIPDOORALMOND,ZDRYWALLBEYONDBROWNBOWL,ZASKCONTACTMONITORFUN,ZKIWIVISUALPRIDEAPPLE,ZNOTICEPEARPOLICYJUICE,ZPEACHCOPPERDINNERLAKE,ZSTEELCAREFULPLATENUMBER,ZGLADSPRAYKIDNEYGUPPY,ZCOMPANYSUMMERFIBERELF,ZTENNISCYCLEBILLOFFICER,ZIMAGEPENCILOTHERBOTTOM,ZWESTAMOUNTAFFECTHEARING,ZDIVERPAINTLEATHEREASY,ZSKYSKYCLASSICBRIEF,ZMESSYSULFURDREAMFESTIVE,ZMERRYCRACKTRAINLEADER,ZBROADABLESOLIDCASUAL,ZGLASSRESERVEBARIUMMEAL,ZTUNEGASBUFFALOCAPITAL,ZBANKBUFFALORECOVERORBIT,ZTREATTESTQUILLCHARGE,ZBAMBOOMESSWASABIEVENING,ZREWARDINSIDEMANGOINTENSE,ZEAGLELINEMINEMAIL,ZCALMLYGEMFINISHEFFECT,ZKEYFAILAPRICOTMETAL,ZFINGERDUEPIZZAOPTION,ZCADETBRIGHTPLANETBANK,ZGOLDYOUNGINITIALNOSE,ZMISSREPLYHUMANLIVING,ZEIGHTLEADERWORKERMOST,ZFRAMEENTERSIMPLEMOUTH,ZBIGTHINKCONVERTECONOMY,ZFACEINVITETALKGOLD,ZPOSTPROTEINHANDLEACTOR,ZHERRINGJOKEFEATUREHOPEFUL,ZCABBAGESOCKEASEMINUTE,ZMUFFINDRYERDRAWFORTUNE,ZPROBLEMCLUBPOPOVERJELLY,ZGIVEVIVIDDIVINEMEANING,ZGENENATURALHEARINGKITE,ZGENERALRESORTSKYOPEN,ZLETTUCEBIRDMEETDEBATE,ZBASEGOUDAREGULARFORGIVE,ZCHARGECLICKHUMANEHIRE,ZPLANETFAMILYPUREMEMORY,ZMINORWAYPAPERCLASSY,ZCAPYEARLYRIVETBRUSH,ZSIZETOEAWARDFRESH,ZARSENICSAMPLEWAITMUON,ZSQUAREGLEEFULCHILDLIGHT,ZSHINYASSISTLIVINGCRAB,ZCORNERANCHORTAPEDIVER,ZDECADEJOYOUSWAVEHABIT,ZTRAVELDRIVERCONTESTLILY,ZFLYINGDOCTORTABLEMELODY,ZSHARKJUSTFRUITMOVIE,ZFAMILYVISUALOWNERMATTER,ZFARMERMORNINGMIRRORCONCERN,ZGIFTICEFISHGLUEHAIR,ZOUTSIDEPEAHENCOUNTICE,ZSPREADMOTORBISCUITBACON,ZWISHHITSKINMOTOR,ZHOLIDAYHEADPONYDETAIL,ZWOODPOETRYCOBBLERBENCH,ZAIRFORGIVEHEADFROG,ZBROWBALANCEKEYCHOWDER,ZDISHKEEPBLESTMONITOR,ZCLAMBITARUGULAFAJITA,ZPLIERSPRINTASKOREGANO,ZRADIANTWHENTRYCARD,ZDELAYOUTCOMEHORNAGENCY,ZPURECAKEVIVIDNEATLY,ZPATTERNCLORINEGRANDCOLBY,ZHANDYREPAIRPROTONAIRPORT,ZAGEREEDFROGBASKET,ZSORTMISTYQUOTECABBAGE,ZFOOTTAPWORDENTRY,ZRESOLVEWRISTWRAPAPPLE,ZDILLASKHOKILEMON,ZFILLSTOPLAWJOYFUL,ZACTIONRANGEELEGANTNEUTRON,ZRESORTYARDGREENLET,ZCREAMEVENINGLIPBRANCH,ZWHALEMATHAVOCADOCOPPER,ZGRAYSURVEYWIRELOVE,ZBELLYCRASHITEMLACK,ZHANGERLITHIUMDINNERMEET,ZCARRYFLOORMINNOWDRAGON,ZMALLEQUIPTHANKSGLUE,ZTERMFITTINGHOUSINGCOMMAND,ZONERELEASEAVERAGENURSE,ZLACEADDRESSGROUNDCAREFUL FROM ZLOOKSLIKECOREDATA WHERE ZPK=?1;\x00IBBIIITIVVITBTBFBFITTFBTBVBVIFTBBFITFFVBIFIVBVVVBTVTIBBFFIVIBTBTVTTFTVTVFFIITIFBITFTTFFFVBIIBTTITFTFFVVVFIIITVBBVFFTVVB\x00BEGIN;CREATE TABLE t1(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT);CREATE TABLE t2(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT);CREATE TABLE t3(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT);CREATE VIEW v1 AS SELECT rowid, i, t FROM t1;CREATE VIEW v2 AS SELECT rowid, i, t FROM t2;CREATE VIEW v3 AS SELECT rowid, i, t FROM t3;\x00INSERT INTO t%d VALUES(NULL,?1,?2)\x00CREATE INDEX i1 ON t1(t);CREATE INDEX i2 ON t2(t);CREATE INDEX i3 ON t3(t);COMMIT;\x00speed4p-join1\x00SELECT * FROM t1, t2, t3 WHERE t1.oid = t2.oid AND t2.oid = t3.oid\x00speed4p-join2\x00SELECT * FROM t1, t2, t3 WHERE t1.t = t2.t AND t2.t = t3.t\x00speed4p-view1\x00SELECT * FROM v%d WHERE rowid = ?\x00speed4p-table1\x00SELECT * FROM t%d WHERE rowid = ?\x00speed4p-subselect1\x00SELECT (SELECT t FROM t1 WHERE rowid = ?1),(SELECT t FROM t2 WHERE rowid = ?1),(SELECT t FROM t3 WHERE rowid = ?1)\x00speed4p-rowid-update\x00UPDATE t1 SET i=i+1 WHERE rowid=?1\x00CREATE TABLE t5(t TEXT PRIMARY KEY, i INTEGER);\x00speed4p-insert-ignore\x00INSERT OR IGNORE INTO t5 SELECT t, i FROM t1\x00CREATE TABLE log(op TEXT, r INTEGER, i INTEGER, t TEXT);CREATE TABLE t4(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT);CREATE TRIGGER t4_trigger1 AFTER INSERT ON t4 BEGIN INSERT INTO log VALUES('INSERT INTO t4', new.rowid, new.i, new.t);END;CREATE TRIGGER t4_trigger2 AFTER UPDATE ON t4 BEGIN INSERT INTO log VALUES('UPDATE OF t4', new.rowid, new.i, new.t);END;CREATE TRIGGER t4_trigger3 AFTER DELETE ON t4 BEGIN INSERT INTO log VALUES('DELETE OF t4', old.rowid, old.i, old.t);END;BEGIN;\x00speed4p-trigger1\x00INSERT INTO t4 VALUES(NULL, ?1, ?2)\x00speed4p-trigger2\x00UPDATE t4 SET i = ?1, t = ?2 WHERE rowid = ?3\x00speed4p-trigger3\x00DELETE FROM t4 WHERE rowid = ?1\x00DROP TABLE t4;DROP TABLE log;VACUUM;CREATE TABLE t4(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT);BEGIN;\x00speed4p-notrigger1\x00speed4p-notrigger2\x00speed4p-notrigger3\x00%5d %5d %5d %s\n\x00/proc/%d/io\x00rb\x00-- %-28s %s\x00rchar: \x00Bytes received by read():\x00wchar: \x00Bytes sent to write():\x00syscr: \x00Read() system calls:\x00syscw: \x00Write() system calls:\x00read_bytes: \x00Bytes rcvd from storage:\x00write_bytes: \x00Bytes sent to storage:\x00cancelled_write_bytes: \x00Cancelled write bytes:\x00-- Compile option: %s\n\x00main\x00-- Speedtest1 for SQLite %s %.50s\n\x00UNIQUE\x00autovacuum\x00cachesize\x00missing argument on %s\n\x00exclusive\x00explain\x00heap\x00missing arguments on %s\n\x00incrvacuum\x00journal\x00key\x00lookaside\x00multithread\x00nomemstat\x00mmap\x00nosync\x00notnull\x00NOT NULL\x00pagesize\x00pcache\x00primarykey\x00PRIMARY KEY\x00repeat\x00reprepare\x00serialized\x00singlethread\x00sqlonly\x00shrink-memory\x00size\x00stats\x00temp\x00argument to --temp should be integer between 0 and 9\x00testset\x00trace\x00threads\x00utf16le\x00utf16be\x00verify\x00without-rowid\x00help\x00?\x00unknown option: %s\nUse \"%s -?\" for help\n\x00surplus argument: %s\nUse \"%s -?\" for help\n\x00cannot allocate %d-byte heap\n\x00heap configuration failed: %d\n\x00cannot allocate %lld-byte pcache\n\x00pcache configuration failed: %d\n\x00Cannot open database file: %s\n\x00lookaside configuration failed: %d\n\x00random\x00PRAGMA mmap_size=%d\x00PRAGMA threads=%d\x00PRAGMA key('%s')\x00PRAGMA encoding=%s\x00PRAGMA auto_vacuum=FULL\x00PRAGMA auto_vacuum=INCREMENTAL\x00PRAGMA page_size=%d\x00PRAGMA cache_size=%d\x00PRAGMA synchronous=OFF\x00PRAGMA locking_mode=EXCLUSIVE\x00PRAGMA journal_mode=%s\x00.explain\n.echo on\n\x00debug1\x00orm\x00cte\x00fp\x00trigger\x00rtree\x00compile with -DSQLITE_ENABLE_RTREE to enable the R-Tree tests\n\x00unknown testset: \"%s\"\nChoices: cte debug1 fp main orm rtree trigger\n\x00PRAGMA compile_options\x00-- Lookaside Slots Used: %d (max %d)\n\x00-- Successful lookasides: %d\n\x00-- Lookaside size faults: %d\n\x00-- Lookaside OOM faults: %d\n\x00-- Pager Heap Usage: %d bytes\n\x00-- Page cache hits: %d\n\x00-- Page cache misses: %d\n\x00-- Page cache writes: %d\n\x00-- Schema Heap Usage: %d bytes\n\x00-- Statement Heap Usage: %d bytes\n\x00-- Memory Used (bytes): %d (max %d)\n\x00-- Outstanding Allocations: %d (max %d)\n\x00-- Pcache Overflow Bytes: %d (max %d)\n\x00-- Largest Allocation: %d bytes\n\x00-- Largest Pcache Allocation: %d bytes\n\x00" +var ts1 = "Usage: %s [--options] DATABASE\nOptions:\n --autovacuum Enable AUTOVACUUM mode\n --cachesize N Set the cache size to N\n --exclusive Enable locking_mode=EXCLUSIVE\n --explain Like --sqlonly but with added EXPLAIN keywords\n --heap SZ MIN Memory allocator uses SZ bytes & min allocation MIN\n --incrvacuum Enable incremenatal vacuum mode\n --journal M Set the journal_mode to M\n --key KEY Set the encryption key to KEY\n --lookaside N SZ Configure lookaside for N slots of SZ bytes each\n --mmap SZ MMAP the first SZ bytes of the database file\n --multithread Set multithreaded mode\n --nomemstat Disable memory statistics\n --nosync Set PRAGMA synchronous=OFF\n --notnull Add NOT NULL constraints to table columns\n --pagesize N Set the page size to N\n --pcache N SZ Configure N pages of pagecache each of size SZ bytes\n --primarykey Use PRIMARY KEY instead of UNIQUE where appropriate\n --repeat N Repeat each SELECT N times (default: 1)\n --reprepare Reprepare each statement upon every invocation\n --serialized Set serialized threading mode\n --singlethread Set single-threaded mode - disables all mutexing\n --sqlonly No-op. Only show the SQL that would have been run.\n --shrink-memory Invoke sqlite3_db_release_memory() frequently.\n --size N Relative test size. Default=100\n --stats Show statistics at the end\n --temp N N from 0 to 9. 0: no temp table. 9: all temp tables\n --testset T Run test-set T (main, cte, rtree, orm, fp, debug)\n --trace Turn on SQL tracing\n --threads N Use up to N threads for sorting\n --utf16be Set text encoding to UTF-16BE\n --utf16le Set text encoding to UTF-16LE\n --verify Run additional verification steps.\n --without-rowid Use WITHOUT ROWID where appropriate\n\x00 TEMP\x00\x00parameter too large - max 2147483648\x00KiB\x00MiB\x00GiB\x00KB\x00MB\x00GB\x00K\x00M\x00G\x00 billion\x00 million\x00 thousand\x00%s hundred\x00%s\x00zero\x00one\x00two\x00three\x00four\x00five\x00six\x00seven\x00eight\x00nine\x00ten\x00eleven\x00twelve\x00thirteen\x00fourteen\x00fifteen\x00sixteen\x00seventeen\x00eighteen\x00nineteen\x00twenty\x00thirty\x00forty\x00fifty\x00sixty\x00seventy\x00eighty\x00ninety\x00.......................................................................\x00/* %4d - %s%.*s */\n\x00%4d - %s%.*s \x00%4d.%03ds\n\x00 TOTAL%.*s %4d.%03ds\n\x00EXPLAIN \x00%.*s;\n\x00CREATE *\x00DROP *\x00ALTER *\x00SQL error: %s\n%s\n\x00exec error: %s\n\x00SQL error: %s\n\x00nil\x00%d INSERTs into table with no index\x00BEGIN\x00CREATE%s TABLE t1(a INTEGER %s, b INTEGER %s, c TEXT %s);\x00INSERT INTO t1 VALUES(?1,?2,?3); -- %d times\x00COMMIT\x00%d ordered INSERTS with one index/PK\x00CREATE%s TABLE t2(a INTEGER %s %s, b INTEGER %s, c TEXT %s) %s\x00INSERT INTO t2 VALUES(?1,?2,?3); -- %d times\x00%d unordered INSERTS with one index/PK\x00CREATE%s TABLE t3(a INTEGER %s %s, b INTEGER %s, c TEXT %s) %s\x00INSERT INTO t3 VALUES(?1,?2,?3); -- %d times\x00%d SELECTS, numeric BETWEEN, unindexed\x00SELECT count(*), avg(b), sum(length(c)), group_concat(c) FROM t1\n WHERE b BETWEEN ?1 AND ?2; -- %d times\x00%d SELECTS, LIKE, unindexed\x00SELECT count(*), avg(b), sum(length(c)), group_concat(c) FROM t1\n WHERE c LIKE ?1; -- %d times\x00%d SELECTS w/ORDER BY, unindexed\x00SELECT a, b, c FROM t1 WHERE c LIKE ?1\n ORDER BY a; -- %d times\x00%d SELECTS w/ORDER BY and LIMIT, unindexed\x00SELECT a, b, c FROM t1 WHERE c LIKE ?1\n ORDER BY a LIMIT 10; -- %d times\x00CREATE INDEX five times\x00BEGIN;\x00CREATE UNIQUE INDEX t1b ON t1(b);\x00CREATE INDEX t1c ON t1(c);\x00CREATE UNIQUE INDEX t2b ON t2(b);\x00CREATE INDEX t2c ON t2(c DESC);\x00CREATE INDEX t3bc ON t3(b,c);\x00COMMIT;\x00%d SELECTS, numeric BETWEEN, indexed\x00SELECT count(*), avg(b), sum(length(c)), group_concat(a) FROM t1\n WHERE b BETWEEN ?1 AND ?2; -- %d times\x00%d SELECTS, numeric BETWEEN, PK\x00SELECT count(*), avg(b), sum(length(c)), group_concat(a) FROM t2\n WHERE a BETWEEN ?1 AND ?2; -- %d times\x00%d SELECTS, text BETWEEN, indexed\x00SELECT count(*), avg(b), sum(length(c)), group_concat(a) FROM t1\n WHERE c BETWEEN ?1 AND (?1||'~'); -- %d times\x00%d INSERTS with three indexes\x00CREATE%s TABLE t4(\n a INTEGER %s %s,\n b INTEGER %s,\n c TEXT %s\n) %s\x00CREATE INDEX t4b ON t4(b)\x00CREATE INDEX t4c ON t4(c)\x00INSERT INTO t4 SELECT * FROM t1\x00DELETE and REFILL one table\x00DELETE FROM t2;\x00INSERT INTO t2 SELECT * FROM t1;\x00VACUUM\x00ALTER TABLE ADD COLUMN, and query\x00ALTER TABLE t2 ADD COLUMN d DEFAULT 123\x00SELECT sum(d) FROM t2\x00%d UPDATES, numeric BETWEEN, indexed\x00UPDATE t2 SET d=b*2 WHERE b BETWEEN ?1 AND ?2; -- %d times\x00%d UPDATES of individual rows\x00UPDATE t2 SET d=b*3 WHERE a=?1; -- %d times\x00One big UPDATE of the whole %d-row table\x00UPDATE t2 SET d=b*4\x00Query added column after filling\x00%d DELETEs, numeric BETWEEN, indexed\x00DELETE FROM t2 WHERE b BETWEEN ?1 AND ?2; -- %d times\x00%d DELETEs of individual rows\x00DELETE FROM t3 WHERE a=?1; -- %d times\x00Refill two %d-row tables using REPLACE\x00REPLACE INTO t2(a,b,c) SELECT a,b,c FROM t1\x00REPLACE INTO t3(a,b,c) SELECT a,b,c FROM t1\x00Refill a %d-row table using (b&1)==(a&1)\x00INSERT INTO t2(a,b,c)\n SELECT a,b,c FROM t1 WHERE (b&1)==(a&1);\x00INSERT INTO t2(a,b,c)\n SELECT a,b,c FROM t1 WHERE (b&1)<>(a&1);\x00%d four-ways joins\x00SELECT t1.c FROM t1, t2, t3, t4\n WHERE t4.a BETWEEN ?1 AND ?2\n AND t3.a=t4.b\n AND t2.a=t3.b\n AND t1.c=t2.c\x00subquery in result set\x00SELECT sum(a), max(c),\n avg((SELECT a FROM t2 WHERE 5+t2.b=t1.b) AND rowid<?1), max(c)\n FROM t1 WHERE rowid<?1;\x00%d REPLACE ops on an IPK\x00CREATE%s TABLE t5(a INTEGER PRIMARY KEY, b %s);\x00REPLACE INTO t5 VALUES(?1,?2); -- %d times\x00%d SELECTS on an IPK\x00SELECT b FROM t5 WHERE a=?1; -- %d times\x00%d REPLACE on TEXT PK\x00CREATE%s TABLE t6(a TEXT PRIMARY KEY, b %s)%s;\x00WITHOUT ROWID\x00REPLACE INTO t6 VALUES(?1,?2); -- %d times\x00%d SELECTS on a TEXT PK\x00SELECT b FROM t6 WHERE a=?1; -- %d times\x00%d SELECT DISTINCT\x00SELECT DISTINCT b FROM t5;\x00SELECT DISTINCT b FROM t6;\x00PRAGMA integrity_check\x00ANALYZE\x00Sudoku with recursive 'digits'\x00WITH RECURSIVE\n input(sud) AS (VALUES(?1)),\n digits(z,lp) AS (\n VALUES('1', 1)\n UNION ALL\n SELECT CAST(lp+1 AS TEXT), lp+1 FROM digits WHERE lp<9\n ),\n x(s, ind) AS (\n SELECT sud, instr(sud, '.') FROM input\n UNION ALL\n SELECT\n substr(s, 1, ind-1) || z || substr(s, ind+1),\n instr( substr(s, 1, ind-1) || z || substr(s, ind+1), '.' )\n FROM x, digits AS z\n WHERE ind>0\n AND NOT EXISTS (\n SELECT 1\n FROM digits AS lp\n WHERE z.z = substr(s, ((ind-1)/9)*9 + lp, 1)\n OR z.z = substr(s, ((ind-1)%%9) + (lp-1)*9 + 1, 1)\n OR z.z = substr(s, (((ind-1)/3) %% 3) * 3\n + ((ind-1)/27) * 27 + lp\n + ((lp-1) / 3) * 6, 1)\n )\n )\nSELECT s FROM x WHERE ind=0;\x00Sudoku with VALUES 'digits'\x00WITH RECURSIVE\n input(sud) AS (VALUES(?1)),\n digits(z,lp) AS (VALUES('1',1),('2',2),('3',3),('4',4),('5',5),\n ('6',6),('7',7),('8',8),('9',9)),\n x(s, ind) AS (\n SELECT sud, instr(sud, '.') FROM input\n UNION ALL\n SELECT\n substr(s, 1, ind-1) || z || substr(s, ind+1),\n instr( substr(s, 1, ind-1) || z || substr(s, ind+1), '.' )\n FROM x, digits AS z\n WHERE ind>0\n AND NOT EXISTS (\n SELECT 1\n FROM digits AS lp\n WHERE z.z = substr(s, ((ind-1)/9)*9 + lp, 1)\n OR z.z = substr(s, ((ind-1)%%9) + (lp-1)*9 + 1, 1)\n OR z.z = substr(s, (((ind-1)/3) %% 3) * 3\n + ((ind-1)/27) * 27 + lp\n + ((lp-1) / 3) * 6, 1)\n )\n )\nSELECT s FROM x WHERE ind=0;\x00Mandelbrot Set with spacing=%f\x00WITH RECURSIVE \n xaxis(x) AS (VALUES(-2.0) UNION ALL SELECT x+?1 FROM xaxis WHERE x<1.2),\n yaxis(y) AS (VALUES(-1.0) UNION ALL SELECT y+?2 FROM yaxis WHERE y<1.0),\n m(iter, cx, cy, x, y) AS (\n SELECT 0, x, y, 0.0, 0.0 FROM xaxis, yaxis\n UNION ALL\n SELECT iter+1, cx, cy, x*x-y*y + cx, 2.0*x*y + cy FROM m \n WHERE (x*x + y*y) < 4.0 AND iter<28\n ),\n m2(iter, cx, cy) AS (\n SELECT max(iter), cx, cy FROM m GROUP BY cx, cy\n ),\n a(t) AS (\n SELECT group_concat( substr(' .+*#', 1+min(iter/7,4), 1), '') \n FROM m2 GROUP BY cy\n )\nSELECT group_concat(rtrim(t),x'0a') FROM a;\x00EXCEPT operator on %d-element tables\x00WITH RECURSIVE \n t1(x) AS (VALUES(2) UNION ALL SELECT x+2 FROM t1 WHERE x<%d),\n t2(y) AS (VALUES(3) UNION ALL SELECT y+3 FROM t2 WHERE y<%d)\nSELECT count(x), avg(x) FROM (\n SELECT x FROM t1 EXCEPT SELECT y FROM t2 ORDER BY 1\n);\x00534...9..67.195....98....6.8...6...34..8.3..1....2...6.6....28....419..5...28..79\x0053....9..6..195....98....6.8...6...34..8.3..1....2...6.6....28....419..5....8..79\x0053.......6..195....98....6.8...6...34..8.3..1....2...6.6....28....419..5....8..79\x00%d.%de%d\x00Fill a table with %d FP values\x00CREATE%s TABLE t1(a REAL %s, b REAL %s);\x00INSERT INTO t1 VALUES(?1,?2); -- %d times\x00%d range queries\x00SELECT sum(b) FROM t1 WHERE a BETWEEN ?1 AND ?2\x00CREATE INDEX three times\x00CREATE INDEX t1a ON t1(a);\x00CREATE INDEX t1b ON t1(b);\x00CREATE INDEX t1ab ON t1(a,b);\x00%d indexed range queries\x00%d calls to round()\x00SELECT sum(round(a,2)+round(b,4)) FROM t1;\x00%d printf() calls\x00WITH c(fmt) AS (VALUES('%%g'),('%%e'),('%%!g'),('%%.20f'))SELECT sum(printf(fmt,a)) FROM t1, c\x00Fill %d rows\x00BEGIN;CREATE TABLE ZLOOKSLIKECOREDATA ( ZPK INTEGER PRIMARY KEY, ZTERMFITTINGHOUSINGCOMMAND INTEGER, ZBRIEFGOBYDODGERHEIGHT BLOB, ZCAPABLETRIPDOORALMOND BLOB, ZDEPOSITPAIRCOLLEGECOMET INTEGER, ZFRAMEENTERSIMPLEMOUTH INTEGER, ZHOPEFULGATEHOLECHALK INTEGER, ZSLEEPYUSERGRANDBOWL TIMESTAMP, ZDEWPEACHCAREERCELERY INTEGER, ZHANGERLITHIUMDINNERMEET VARCHAR, ZCLUBRELEASELIZARDADVICE VARCHAR, ZCHARGECLICKHUMANEHIRE INTEGER, ZFINGERDUEPIZZAOPTION TIMESTAMP, ZFLYINGDOCTORTABLEMELODY BLOB, ZLONGFINLEAVEIMAGEOIL TIMESTAMP, ZFAMILYVISUALOWNERMATTER BLOB, ZGOLDYOUNGINITIALNOSE FLOAT, ZCAUSESALAMITERMCYAN BLOB, ZSPREADMOTORBISCUITBACON FLOAT, ZGIFTICEFISHGLUEHAIR INTEGER, ZNOTICEPEARPOLICYJUICE TIMESTAMP, ZBANKBUFFALORECOVERORBIT TIMESTAMP, ZLONGDIETESSAYNATURE FLOAT, ZACTIONRANGEELEGANTNEUTRON BLOB, ZCADETBRIGHTPLANETBANK TIMESTAMP, ZAIRFORGIVEHEADFROG BLOB, ZSHARKJUSTFRUITMOVIE VARCHAR, ZFARMERMORNINGMIRRORCONCERN BLOB, ZWOODPOETRYCOBBLERBENCH VARCHAR, ZHAFNIUMSCRIPTSALADMOTOR INTEGER, ZPROBLEMCLUBPOPOVERJELLY FLOAT, ZEIGHTLEADERWORKERMOST TIMESTAMP, ZGLASSRESERVEBARIUMMEAL BLOB, ZCLAMBITARUGULAFAJITA BLOB, ZDECADEJOYOUSWAVEHABIT FLOAT, ZCOMPANYSUMMERFIBERELF INTEGER, ZTREATTESTQUILLCHARGE TIMESTAMP, ZBROWBALANCEKEYCHOWDER FLOAT, ZPEACHCOPPERDINNERLAKE FLOAT, ZDRYWALLBEYONDBROWNBOWL VARCHAR, ZBELLYCRASHITEMLACK BLOB, ZTENNISCYCLEBILLOFFICER INTEGER, ZMALLEQUIPTHANKSGLUE FLOAT, ZMISSREPLYHUMANLIVING INTEGER, ZKIWIVISUALPRIDEAPPLE VARCHAR, ZWISHHITSKINMOTOR BLOB, ZCALMRACCOONPROGRAMDEBIT VARCHAR, ZSHINYASSISTLIVINGCRAB VARCHAR, ZRESOLVEWRISTWRAPAPPLE VARCHAR, ZAPPEALSIMPLESECONDHOUSING BLOB, ZCORNERANCHORTAPEDIVER TIMESTAMP, ZMEMORYREQUESTSOURCEBIG VARCHAR, ZTRYFACTKEEPMILK TIMESTAMP, ZDIVERPAINTLEATHEREASY INTEGER, ZSORTMISTYQUOTECABBAGE BLOB, ZTUNEGASBUFFALOCAPITAL BLOB, ZFILLSTOPLAWJOYFUL FLOAT, ZSTEELCAREFULPLATENUMBER FLOAT, ZGIVEVIVIDDIVINEMEANING INTEGER, ZTREATPACKFUTURECONVERT VARCHAR, ZCALMLYGEMFINISHEFFECT INTEGER, ZCABBAGESOCKEASEMINUTE BLOB, ZPLANETFAMILYPUREMEMORY TIMESTAMP, ZMERRYCRACKTRAINLEADER BLOB, ZMINORWAYPAPERCLASSY TIMESTAMP, ZEAGLELINEMINEMAIL VARCHAR, ZRESORTYARDGREENLET TIMESTAMP, ZYARDOREGANOVIVIDJEWEL TIMESTAMP, ZPURECAKEVIVIDNEATLY FLOAT, ZASKCONTACTMONITORFUN TIMESTAMP, ZMOVEWHOGAMMAINCH VARCHAR, ZLETTUCEBIRDMEETDEBATE TIMESTAMP, ZGENENATURALHEARINGKITE VARCHAR, ZMUFFINDRYERDRAWFORTUNE FLOAT, ZGRAYSURVEYWIRELOVE FLOAT, ZPLIERSPRINTASKOREGANO INTEGER, ZTRAVELDRIVERCONTESTLILY INTEGER, ZHUMORSPICESANDKIDNEY TIMESTAMP, ZARSENICSAMPLEWAITMUON INTEGER, ZLACEADDRESSGROUNDCAREFUL FLOAT, ZBAMBOOMESSWASABIEVENING BLOB, ZONERELEASEAVERAGENURSE INTEGER, ZRADIANTWHENTRYCARD TIMESTAMP, ZREWARDINSIDEMANGOINTENSE FLOAT, ZNEATSTEWPARTIRON TIMESTAMP, ZOUTSIDEPEAHENCOUNTICE TIMESTAMP, ZCREAMEVENINGLIPBRANCH FLOAT, ZWHALEMATHAVOCADOCOPPER FLOAT, ZLIFEUSELEAFYBELL FLOAT, ZWEALTHLINENGLEEFULDAY VARCHAR, ZFACEINVITETALKGOLD BLOB, ZWESTAMOUNTAFFECTHEARING INTEGER, ZDELAYOUTCOMEHORNAGENCY INTEGER, ZBIGTHINKCONVERTECONOMY BLOB, ZBASEGOUDAREGULARFORGIVE TIMESTAMP, ZPATTERNCLORINEGRANDCOLBY TIMESTAMP, ZCYANBASEFEEDADROIT INTEGER, ZCARRYFLOORMINNOWDRAGON TIMESTAMP, ZIMAGEPENCILOTHERBOTTOM FLOAT, ZXENONFLIGHTPALEAPPLE TIMESTAMP, ZHERRINGJOKEFEATUREHOPEFUL FLOAT, ZCAPYEARLYRIVETBRUSH FLOAT, ZAGEREEDFROGBASKET VARCHAR, ZUSUALBODYHALIBUTDIAMOND VARCHAR, ZFOOTTAPWORDENTRY VARCHAR, ZDISHKEEPBLESTMONITOR FLOAT, ZBROADABLESOLIDCASUAL INTEGER, ZSQUAREGLEEFULCHILDLIGHT INTEGER, ZHOLIDAYHEADPONYDETAIL INTEGER, ZGENERALRESORTSKYOPEN TIMESTAMP, ZGLADSPRAYKIDNEYGUPPY VARCHAR, ZSWIMHEAVYMENTIONKIND BLOB, ZMESSYSULFURDREAMFESTIVE BLOB, ZSKYSKYCLASSICBRIEF VARCHAR, ZDILLASKHOKILEMON FLOAT, ZJUNIORSHOWPRESSNOVA FLOAT, ZSIZETOEAWARDFRESH TIMESTAMP, ZKEYFAILAPRICOTMETAL VARCHAR, ZHANDYREPAIRPROTONAIRPORT VARCHAR, ZPOSTPROTEINHANDLEACTOR BLOB);\x00INSERT INTO ZLOOKSLIKECOREDATA(ZPK,ZAIRFORGIVEHEADFROG,ZGIFTICEFISHGLUEHAIR,ZDELAYOUTCOMEHORNAGENCY,ZSLEEPYUSERGRANDBOWL,ZGLASSRESERVEBARIUMMEAL,ZBRIEFGOBYDODGERHEIGHT,ZBAMBOOMESSWASABIEVENING,ZFARMERMORNINGMIRRORCONCERN,ZTREATPACKFUTURECONVERT,ZCAUSESALAMITERMCYAN,ZCALMRACCOONPROGRAMDEBIT,ZHOLIDAYHEADPONYDETAIL,ZWOODPOETRYCOBBLERBENCH,ZHAFNIUMSCRIPTSALADMOTOR,ZUSUALBODYHALIBUTDIAMOND,ZOUTSIDEPEAHENCOUNTICE,ZDIVERPAINTLEATHEREASY,ZWESTAMOUNTAFFECTHEARING,ZSIZETOEAWARDFRESH,ZDEWPEACHCAREERCELERY,ZSTEELCAREFULPLATENUMBER,ZCYANBASEFEEDADROIT,ZCALMLYGEMFINISHEFFECT,ZHANDYREPAIRPROTONAIRPORT,ZGENENATURALHEARINGKITE,ZBROADABLESOLIDCASUAL,ZPOSTPROTEINHANDLEACTOR,ZLACEADDRESSGROUNDCAREFUL,ZIMAGEPENCILOTHERBOTTOM,ZPROBLEMCLUBPOPOVERJELLY,ZPATTERNCLORINEGRANDCOLBY,ZNEATSTEWPARTIRON,ZAPPEALSIMPLESECONDHOUSING,ZMOVEWHOGAMMAINCH,ZTENNISCYCLEBILLOFFICER,ZSHARKJUSTFRUITMOVIE,ZKEYFAILAPRICOTMETAL,ZCOMPANYSUMMERFIBERELF,ZTERMFITTINGHOUSINGCOMMAND,ZRESORTYARDGREENLET,ZCABBAGESOCKEASEMINUTE,ZSQUAREGLEEFULCHILDLIGHT,ZONERELEASEAVERAGENURSE,ZBIGTHINKCONVERTECONOMY,ZPLIERSPRINTASKOREGANO,ZDECADEJOYOUSWAVEHABIT,ZDRYWALLBEYONDBROWNBOWL,ZCLUBRELEASELIZARDADVICE,ZWHALEMATHAVOCADOCOPPER,ZBELLYCRASHITEMLACK,ZLETTUCEBIRDMEETDEBATE,ZCAPABLETRIPDOORALMOND,ZRADIANTWHENTRYCARD,ZCAPYEARLYRIVETBRUSH,ZAGEREEDFROGBASKET,ZSWIMHEAVYMENTIONKIND,ZTRAVELDRIVERCONTESTLILY,ZGLADSPRAYKIDNEYGUPPY,ZBANKBUFFALORECOVERORBIT,ZFINGERDUEPIZZAOPTION,ZCLAMBITARUGULAFAJITA,ZLONGFINLEAVEIMAGEOIL,ZLONGDIETESSAYNATURE,ZJUNIORSHOWPRESSNOVA,ZHOPEFULGATEHOLECHALK,ZDEPOSITPAIRCOLLEGECOMET,ZWEALTHLINENGLEEFULDAY,ZFILLSTOPLAWJOYFUL,ZTUNEGASBUFFALOCAPITAL,ZGRAYSURVEYWIRELOVE,ZCORNERANCHORTAPEDIVER,ZREWARDINSIDEMANGOINTENSE,ZCADETBRIGHTPLANETBANK,ZPLANETFAMILYPUREMEMORY,ZTREATTESTQUILLCHARGE,ZCREAMEVENINGLIPBRANCH,ZSKYSKYCLASSICBRIEF,ZARSENICSAMPLEWAITMUON,ZBROWBALANCEKEYCHOWDER,ZFLYINGDOCTORTABLEMELODY,ZHANGERLITHIUMDINNERMEET,ZNOTICEPEARPOLICYJUICE,ZSHINYASSISTLIVINGCRAB,ZLIFEUSELEAFYBELL,ZFACEINVITETALKGOLD,ZGENERALRESORTSKYOPEN,ZPURECAKEVIVIDNEATLY,ZKIWIVISUALPRIDEAPPLE,ZMESSYSULFURDREAMFESTIVE,ZCHARGECLICKHUMANEHIRE,ZHERRINGJOKEFEATUREHOPEFUL,ZYARDOREGANOVIVIDJEWEL,ZFOOTTAPWORDENTRY,ZWISHHITSKINMOTOR,ZBASEGOUDAREGULARFORGIVE,ZMUFFINDRYERDRAWFORTUNE,ZACTIONRANGEELEGANTNEUTRON,ZTRYFACTKEEPMILK,ZPEACHCOPPERDINNERLAKE,ZFRAMEENTERSIMPLEMOUTH,ZMERRYCRACKTRAINLEADER,ZMEMORYREQUESTSOURCEBIG,ZCARRYFLOORMINNOWDRAGON,ZMINORWAYPAPERCLASSY,ZDILLASKHOKILEMON,ZRESOLVEWRISTWRAPAPPLE,ZASKCONTACTMONITORFUN,ZGIVEVIVIDDIVINEMEANING,ZEIGHTLEADERWORKERMOST,ZMISSREPLYHUMANLIVING,ZXENONFLIGHTPALEAPPLE,ZSORTMISTYQUOTECABBAGE,ZEAGLELINEMINEMAIL,ZFAMILYVISUALOWNERMATTER,ZSPREADMOTORBISCUITBACON,ZDISHKEEPBLESTMONITOR,ZMALLEQUIPTHANKSGLUE,ZGOLDYOUNGINITIALNOSE,ZHUMORSPICESANDKIDNEY)VALUES(?1,?26,?20,?93,?8,?33,?3,?81,?28,?60,?18,?47,?109,?29,?30,?104,?86,?54,?92,?117,?9,?58,?97,?61,?119,?73,?107,?120,?80,?99,?31,?96,?85,?50,?71,?42,?27,?118,?36,?2,?67,?62,?108,?82,?94,?76,?35,?40,?11,?88,?41,?72,?4,?83,?102,?103,?112,?77,?111,?22,?13,?34,?15,?23,?116,?7,?5,?90,?57,?56,?75,?51,?84,?25,?63,?37,?87,?114,?79,?38,?14,?10,?21,?48,?89,?91,?110,?69,?45,?113,?12,?101,?68,?105,?46,?95,?74,?24,?53,?39,?6,?64,?52,?98,?65,?115,?49,?70,?59,?32,?44,?100,?55,?66,?16,?19,?106,?43,?17,?78);\x00Query %d rows by rowid\x00SELECT ZCYANBASEFEEDADROIT,ZJUNIORSHOWPRESSNOVA,ZCAUSESALAMITERMCYAN,ZHOPEFULGATEHOLECHALK,ZHUMORSPICESANDKIDNEY,ZSWIMHEAVYMENTIONKIND,ZMOVEWHOGAMMAINCH,ZAPPEALSIMPLESECONDHOUSING,ZHAFNIUMSCRIPTSALADMOTOR,ZNEATSTEWPARTIRON,ZLONGFINLEAVEIMAGEOIL,ZDEWPEACHCAREERCELERY,ZXENONFLIGHTPALEAPPLE,ZCALMRACCOONPROGRAMDEBIT,ZUSUALBODYHALIBUTDIAMOND,ZTRYFACTKEEPMILK,ZWEALTHLINENGLEEFULDAY,ZLONGDIETESSAYNATURE,ZLIFEUSELEAFYBELL,ZTREATPACKFUTURECONVERT,ZMEMORYREQUESTSOURCEBIG,ZYARDOREGANOVIVIDJEWEL,ZDEPOSITPAIRCOLLEGECOMET,ZSLEEPYUSERGRANDBOWL,ZBRIEFGOBYDODGERHEIGHT,ZCLUBRELEASELIZARDADVICE,ZCAPABLETRIPDOORALMOND,ZDRYWALLBEYONDBROWNBOWL,ZASKCONTACTMONITORFUN,ZKIWIVISUALPRIDEAPPLE,ZNOTICEPEARPOLICYJUICE,ZPEACHCOPPERDINNERLAKE,ZSTEELCAREFULPLATENUMBER,ZGLADSPRAYKIDNEYGUPPY,ZCOMPANYSUMMERFIBERELF,ZTENNISCYCLEBILLOFFICER,ZIMAGEPENCILOTHERBOTTOM,ZWESTAMOUNTAFFECTHEARING,ZDIVERPAINTLEATHEREASY,ZSKYSKYCLASSICBRIEF,ZMESSYSULFURDREAMFESTIVE,ZMERRYCRACKTRAINLEADER,ZBROADABLESOLIDCASUAL,ZGLASSRESERVEBARIUMMEAL,ZTUNEGASBUFFALOCAPITAL,ZBANKBUFFALORECOVERORBIT,ZTREATTESTQUILLCHARGE,ZBAMBOOMESSWASABIEVENING,ZREWARDINSIDEMANGOINTENSE,ZEAGLELINEMINEMAIL,ZCALMLYGEMFINISHEFFECT,ZKEYFAILAPRICOTMETAL,ZFINGERDUEPIZZAOPTION,ZCADETBRIGHTPLANETBANK,ZGOLDYOUNGINITIALNOSE,ZMISSREPLYHUMANLIVING,ZEIGHTLEADERWORKERMOST,ZFRAMEENTERSIMPLEMOUTH,ZBIGTHINKCONVERTECONOMY,ZFACEINVITETALKGOLD,ZPOSTPROTEINHANDLEACTOR,ZHERRINGJOKEFEATUREHOPEFUL,ZCABBAGESOCKEASEMINUTE,ZMUFFINDRYERDRAWFORTUNE,ZPROBLEMCLUBPOPOVERJELLY,ZGIVEVIVIDDIVINEMEANING,ZGENENATURALHEARINGKITE,ZGENERALRESORTSKYOPEN,ZLETTUCEBIRDMEETDEBATE,ZBASEGOUDAREGULARFORGIVE,ZCHARGECLICKHUMANEHIRE,ZPLANETFAMILYPUREMEMORY,ZMINORWAYPAPERCLASSY,ZCAPYEARLYRIVETBRUSH,ZSIZETOEAWARDFRESH,ZARSENICSAMPLEWAITMUON,ZSQUAREGLEEFULCHILDLIGHT,ZSHINYASSISTLIVINGCRAB,ZCORNERANCHORTAPEDIVER,ZDECADEJOYOUSWAVEHABIT,ZTRAVELDRIVERCONTESTLILY,ZFLYINGDOCTORTABLEMELODY,ZSHARKJUSTFRUITMOVIE,ZFAMILYVISUALOWNERMATTER,ZFARMERMORNINGMIRRORCONCERN,ZGIFTICEFISHGLUEHAIR,ZOUTSIDEPEAHENCOUNTICE,ZSPREADMOTORBISCUITBACON,ZWISHHITSKINMOTOR,ZHOLIDAYHEADPONYDETAIL,ZWOODPOETRYCOBBLERBENCH,ZAIRFORGIVEHEADFROG,ZBROWBALANCEKEYCHOWDER,ZDISHKEEPBLESTMONITOR,ZCLAMBITARUGULAFAJITA,ZPLIERSPRINTASKOREGANO,ZRADIANTWHENTRYCARD,ZDELAYOUTCOMEHORNAGENCY,ZPURECAKEVIVIDNEATLY,ZPATTERNCLORINEGRANDCOLBY,ZHANDYREPAIRPROTONAIRPORT,ZAGEREEDFROGBASKET,ZSORTMISTYQUOTECABBAGE,ZFOOTTAPWORDENTRY,ZRESOLVEWRISTWRAPAPPLE,ZDILLASKHOKILEMON,ZFILLSTOPLAWJOYFUL,ZACTIONRANGEELEGANTNEUTRON,ZRESORTYARDGREENLET,ZCREAMEVENINGLIPBRANCH,ZWHALEMATHAVOCADOCOPPER,ZGRAYSURVEYWIRELOVE,ZBELLYCRASHITEMLACK,ZHANGERLITHIUMDINNERMEET,ZCARRYFLOORMINNOWDRAGON,ZMALLEQUIPTHANKSGLUE,ZTERMFITTINGHOUSINGCOMMAND,ZONERELEASEAVERAGENURSE,ZLACEADDRESSGROUNDCAREFUL FROM ZLOOKSLIKECOREDATA WHERE ZPK=?1;\x00IBBIIITIVVITBTBFBFITTFBTBVBVIFTBBFITFFVBIFIVBVVVBTVTIBBFFIVIBTBTVTTFTVTVFFIITIFBITFTTFFFVBIIBTTITFTFFVVVFIIITVBBVFFTVVB\x00BEGIN;CREATE TABLE t1(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT);CREATE TABLE t2(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT);CREATE TABLE t3(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT);CREATE VIEW v1 AS SELECT rowid, i, t FROM t1;CREATE VIEW v2 AS SELECT rowid, i, t FROM t2;CREATE VIEW v3 AS SELECT rowid, i, t FROM t3;\x00INSERT INTO t%d VALUES(NULL,?1,?2)\x00CREATE INDEX i1 ON t1(t);CREATE INDEX i2 ON t2(t);CREATE INDEX i3 ON t3(t);COMMIT;\x00speed4p-join1\x00SELECT * FROM t1, t2, t3 WHERE t1.oid = t2.oid AND t2.oid = t3.oid\x00speed4p-join2\x00SELECT * FROM t1, t2, t3 WHERE t1.t = t2.t AND t2.t = t3.t\x00speed4p-view1\x00SELECT * FROM v%d WHERE rowid = ?\x00speed4p-table1\x00SELECT * FROM t%d WHERE rowid = ?\x00speed4p-subselect1\x00SELECT (SELECT t FROM t1 WHERE rowid = ?1),(SELECT t FROM t2 WHERE rowid = ?1),(SELECT t FROM t3 WHERE rowid = ?1)\x00speed4p-rowid-update\x00UPDATE t1 SET i=i+1 WHERE rowid=?1\x00CREATE TABLE t5(t TEXT PRIMARY KEY, i INTEGER);\x00speed4p-insert-ignore\x00INSERT OR IGNORE INTO t5 SELECT t, i FROM t1\x00CREATE TABLE log(op TEXT, r INTEGER, i INTEGER, t TEXT);CREATE TABLE t4(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT);CREATE TRIGGER t4_trigger1 AFTER INSERT ON t4 BEGIN INSERT INTO log VALUES('INSERT INTO t4', new.rowid, new.i, new.t);END;CREATE TRIGGER t4_trigger2 AFTER UPDATE ON t4 BEGIN INSERT INTO log VALUES('UPDATE OF t4', new.rowid, new.i, new.t);END;CREATE TRIGGER t4_trigger3 AFTER DELETE ON t4 BEGIN INSERT INTO log VALUES('DELETE OF t4', old.rowid, old.i, old.t);END;BEGIN;\x00speed4p-trigger1\x00INSERT INTO t4 VALUES(NULL, ?1, ?2)\x00speed4p-trigger2\x00UPDATE t4 SET i = ?1, t = ?2 WHERE rowid = ?3\x00speed4p-trigger3\x00DELETE FROM t4 WHERE rowid = ?1\x00DROP TABLE t4;DROP TABLE log;VACUUM;CREATE TABLE t4(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT);BEGIN;\x00speed4p-notrigger1\x00speed4p-notrigger2\x00speed4p-notrigger3\x00%5d %5d %5d %s\n\x00/proc/%d/io\x00rb\x00-- %-28s %s\x00rchar: \x00Bytes received by read():\x00wchar: \x00Bytes sent to write():\x00syscr: \x00Read() system calls:\x00syscw: \x00Write() system calls:\x00read_bytes: \x00Bytes rcvd from storage:\x00write_bytes: \x00Bytes sent to storage:\x00cancelled_write_bytes: \x00Cancelled write bytes:\x00-- Compile option: %s\n\x00main\x00-- Speedtest1 for SQLite %s %.50s\n\x00UNIQUE\x00autovacuum\x00cachesize\x00missing argument on %s\n\x00exclusive\x00explain\x00heap\x00missing arguments on %s\n\x00incrvacuum\x00journal\x00key\x00lookaside\x00multithread\x00nomemstat\x00mmap\x00nosync\x00notnull\x00NOT NULL\x00pagesize\x00pcache\x00primarykey\x00PRIMARY KEY\x00repeat\x00reprepare\x00serialized\x00singlethread\x00sqlonly\x00shrink-memory\x00size\x00stats\x00temp\x00argument to --temp should be integer between 0 and 9\x00testset\x00trace\x00threads\x00utf16le\x00utf16be\x00verify\x00without-rowid\x00help\x00?\x00unknown option: %s\nUse \"%s -?\" for help\n\x00surplus argument: %s\nUse \"%s -?\" for help\n\x00cannot allocate %d-byte heap\n\x00heap configuration failed: %d\n\x00cannot allocate %lld-byte pcache\n\x00pcache configuration failed: %d\n\x00Cannot open database file: %s\n\x00lookaside configuration failed: %d\n\x00random\x00PRAGMA mmap_size=%d\x00PRAGMA threads=%d\x00PRAGMA key('%s')\x00PRAGMA encoding=%s\x00PRAGMA auto_vacuum=FULL\x00PRAGMA auto_vacuum=INCREMENTAL\x00PRAGMA page_size=%d\x00PRAGMA cache_size=%d\x00PRAGMA synchronous=OFF\x00PRAGMA locking_mode=EXCLUSIVE\x00PRAGMA journal_mode=%s\x00.explain\n.echo on\n\x00debug1\x00orm\x00cte\x00fp\x00trigger\x00rtree\x00compile with -DSQLITE_ENABLE_RTREE to enable the R-Tree tests\n\x00unknown testset: \"%s\"\nChoices: cte debug1 fp main orm rtree trigger\n\x00PRAGMA compile_options\x00-- Lookaside Slots Used: %d (max %d)\n\x00-- Successful lookasides: %d\n\x00-- Lookaside size faults: %d\n\x00-- Lookaside OOM faults: %d\n\x00-- Pager Heap Usage: %d bytes\n\x00-- Page cache hits: %d\n\x00-- Page cache misses: %d\n\x00-- Page cache writes: %d\n\x00-- Schema Heap Usage: %d bytes\n\x00-- Statement Heap Usage: %d bytes\n\x00-- Memory Used (bytes): %d (max %d)\n\x00-- Outstanding Allocations: %d (max %d)\n\x00-- Pcache Overflow Bytes: %d (max %d)\n\x00-- Largest Allocation: %d bytes\n\x00-- Largest Pcache Allocation: %d bytes\n\x00" var ts = (*reflect.StringHeader)(unsafe.Pointer(&ts1)).Data |