aboutsummaryrefslogtreecommitdiff
path: root/speedtest1/main_linux_amd64.go
diff options
context:
space:
mode:
authorJan Mercl <0xjnml@gmail.com>2020-08-26 23:31:54 +0200
committerJan Mercl <0xjnml@gmail.com>2020-08-26 23:31:54 +0200
commite662a135d139be00d9539517df0976318adbdfa1 (patch)
treea3f39f3ad0b653020dbd24f23ca5e32ac86fce3b /speedtest1/main_linux_amd64.go
parent43c865ce5d35eb463e4a05f65e8e388364480711 (diff)
release 1.4.0v1.4.0
Diffstat (limited to 'speedtest1/main_linux_amd64.go')
-rw-r--r--speedtest1/main_linux_amd64.go1544
1 files changed, 1005 insertions, 539 deletions
diff --git a/speedtest1/main_linux_amd64.go b/speedtest1/main_linux_amd64.go
index 5e7a901..37334c1 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 -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.
+// Code generated by 'ccgo speedtest1/main_linux_amd64.go testdata/sqlite-src-3330000/test/speedtest1.c -Itestdata/sqlite-amalgamation-3330000 -l modernc.org/sqlite/lib -DNDEBUG -DHAVE_USLEEP -DLONGDOUBLE_TYPE=double -DSQLITE_CORE -DSQLITE_DEFAULT_MEMSTATUS=0 -DSQLITE_DEFAULT_PAGE_SIZE=1024 -DSQLITE_ENABLE_BYTECODE_VTAB -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_DBSTAT_VTAB -DSQLITE_ENABLE_DESERIALIZE -DSQLITE_ENABLE_EXPLAIN_COMMENTS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_GEOPOLY -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_MEMORY_MANAGEMENT -DSQLITE_ENABLE_OFFSET_SQL_FUNC -DSQLITE_ENABLE_PREUPDATE_HOOK -DSQLITE_ENABLE_RBU -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_SNAPSHOT -DSQLITE_ENABLE_STAT4 -DSQLITE_ENABLE_STMTVTAB -DSQLITE_ENABLE_UNLOCK_NOTIFY -DSQLITE_HAVE_ZLIB=1 -DSQLITE_LIKE_DOESNT_MATCH_BLOBS -DSQLITE_MUTEX_APPDEF=1 -DSQLITE_MUTEX_NOOP -DSQLITE_OS_UNIX=1 -DSQLITE_SOUNDEX -DSQLITE_TEMP_STORE=1 -DSQLITE_TEST -DSQLITE_THREADSAFE=1 -ccgo-long-double-is-double', DO NOT EDIT.
package main
@@ -7,7 +7,7 @@ import (
"reflect"
"unsafe"
- "modernc.org/crt/v3"
+ "modernc.org/libc"
"modernc.org/sqlite/lib"
)
@@ -15,7 +15,7 @@ var _ = math.Pi
var _ reflect.Kind
var _ unsafe.Pointer
-func main() { crt.Start(main1) }
+func main() { libc.Start(main1) }
// Copyright (C) 1991-2018 Free Software Foundation, Inc.
// This file is part of the GNU C Library.
@@ -531,7 +531,7 @@ type wchar_t = int32 /* <builtin>:15:24 */
// A program for performance testing.
//
// The available command-line options are described below:
-var zHelp = *(*[1982]int8)(unsafe.Pointer(ts /* "Usage: %s [--opt..." */)) /* speedtest1.c:6:19 */
+var zHelp = *(*[2146]int8)(unsafe.Pointer(ts /* "Usage: %s [--opt..." */)) /* speedtest1.c:6:19 */
// Define the standard macros for the user,
// if this invocation was from the user program.
@@ -612,6 +612,7 @@ type sqlite3_callback = uintptr /* sqlite3.h:338:13 */
// in the 4th parameter to the [sqlite3_vfs.xOpen] method.
// Reserved: 0x00F00000
+// Legacy compatibility:
// CAPI3REF: Device Characteristics
//
@@ -722,6 +723,7 @@ type sqlite3_file1 = struct{ pMethods uintptr }
// in the 4th parameter to the [sqlite3_vfs.xOpen] method.
// Reserved: 0x00F00000
+// Legacy compatibility:
// CAPI3REF: Device Characteristics
//
@@ -795,7 +797,7 @@ type sqlite3_file1 = struct{ pMethods uintptr }
// for their own use. The pMethods entry is a pointer to an
// [sqlite3_io_methods] object that defines methods for performing
// I/O operations on the open file.
-type sqlite3_file = sqlite3_file1 /* sqlite3.h:680:29 */
+type sqlite3_file = sqlite3_file1 /* sqlite3.h:683:29 */
type sqlite3_io_methods1 = struct {
iVersion int32
xClose uintptr
@@ -910,7 +912,7 @@ type sqlite3_io_methods1 = struct {
// fails to zero-fill short reads might seem to work. However,
// failure to zero-fill short reads will eventually lead to
// database corruption.
-type sqlite3_io_methods = sqlite3_io_methods1 /* sqlite3.h:779:35 */
+type sqlite3_io_methods = sqlite3_io_methods1 /* sqlite3.h:782:35 */
// CAPI3REF: OS Interface Object
//
@@ -986,7 +988,7 @@ type sqlite3_io_methods = sqlite3_io_methods1 /* sqlite3.h:779:35 */
// <li> [SQLITE_OPEN_TEMP_JOURNAL]
// <li> [SQLITE_OPEN_TRANSIENT_DB]
// <li> [SQLITE_OPEN_SUBJOURNAL]
-// <li> [SQLITE_OPEN_MASTER_JOURNAL]
+// <li> [SQLITE_OPEN_SUPER_JOURNAL]
// <li> [SQLITE_OPEN_WAL]
// </ul>)^
//
@@ -1178,7 +1180,7 @@ type sqlite3_vfs1 = struct {
// <li> [SQLITE_OPEN_TEMP_JOURNAL]
// <li> [SQLITE_OPEN_TRANSIENT_DB]
// <li> [SQLITE_OPEN_SUBJOURNAL]
-// <li> [SQLITE_OPEN_MASTER_JOURNAL]
+// <li> [SQLITE_OPEN_SUPER_JOURNAL]
// <li> [SQLITE_OPEN_WAL]
// </ul>)^
//
@@ -1271,8 +1273,8 @@ type sqlite3_vfs1 = struct {
// or all of these interfaces to be NULL or for their behavior to change
// from one release to the next. Applications must not attempt to access
// any of these methods if the iVersion of the VFS is less than 3.
-type sqlite3_vfs = sqlite3_vfs1 /* sqlite3.h:1364:28 */
-type sqlite3_syscall_ptr = uintptr /* sqlite3.h:1365:14 */
+type sqlite3_vfs = sqlite3_vfs1 /* sqlite3.h:1367:28 */
+type sqlite3_syscall_ptr = uintptr /* sqlite3.h:1368:14 */
// CAPI3REF: Memory Allocation Routines
//
@@ -1322,7 +1324,7 @@ type sqlite3_syscall_ptr = uintptr /* sqlite3.h:1365:14 */
// by xInit. The pAppData pointer is used as the only parameter to
// xInit and xShutdown.
//
-// SQLite holds the [SQLITE_MUTEX_STATIC_MASTER] mutex when it invokes
+// SQLite holds the [SQLITE_MUTEX_STATIC_MAIN] mutex when it invokes
// the xInit method, so the xInit method need not be threadsafe. The
// xShutdown method is only called from [sqlite3_shutdown()] so it does
// not need to be threadsafe either. For all other methods, SQLite
@@ -1394,7 +1396,7 @@ type sqlite3_mem_methods1 = struct {
// by xInit. The pAppData pointer is used as the only parameter to
// xInit and xShutdown.
//
-// SQLite holds the [SQLITE_MUTEX_STATIC_MASTER] mutex when it invokes
+// SQLite holds the [SQLITE_MUTEX_STATIC_MAIN] mutex when it invokes
// the xInit method, so the xInit method need not be threadsafe. The
// xShutdown method is only called from [sqlite3_shutdown()] so it does
// not need to be threadsafe either. For all other methods, SQLite
@@ -1407,7 +1409,7 @@ type sqlite3_mem_methods1 = struct {
//
// SQLite will never invoke xInit() more than once without an intervening
// call to xShutdown().
-type sqlite3_mem_methods = sqlite3_mem_methods1 /* sqlite3.h:1662:36 */
+type sqlite3_mem_methods = sqlite3_mem_methods1 /* sqlite3.h:1665:36 */
// CAPI3REF: Constants Defining Special Destructor Behavior
//
@@ -1421,7 +1423,7 @@ type sqlite3_mem_methods = sqlite3_mem_methods1 /* sqlite3.h:1662:36 */
//
// The typedef is necessary to work around problems in certain
// C++ compilers.
-type sqlite3_destructor_type = uintptr /* sqlite3.h:5619:14 */
+type sqlite3_destructor_type = uintptr /* sqlite3.h:5621:14 */
// The interface to the virtual-table mechanism is currently considered
// to be experimental. The interface might change in incompatible ways.
@@ -1445,7 +1447,7 @@ type sqlite3_vtab1 = struct {
// interface fixed, support it indefinitely, and remove this comment.
// Structures used by the virtual table interface
-type sqlite3_vtab = sqlite3_vtab1 /* sqlite3.h:6687:29 */
+type sqlite3_vtab = sqlite3_vtab1 /* sqlite3.h:6689:29 */
type sqlite3_index_info1 = struct {
nConstraint int32
aConstraint uintptr
@@ -1462,10 +1464,10 @@ type sqlite3_index_info1 = struct {
colUsed sqlite3_uint64
}
-type sqlite3_index_info = sqlite3_index_info1 /* sqlite3.h:6688:35 */
+type sqlite3_index_info = sqlite3_index_info1 /* sqlite3.h:6690:35 */
type sqlite3_vtab_cursor1 = struct{ pVtab uintptr }
-type sqlite3_vtab_cursor = sqlite3_vtab_cursor1 /* sqlite3.h:6689:36 */
+type sqlite3_vtab_cursor = sqlite3_vtab_cursor1 /* sqlite3.h:6691:36 */
type sqlite3_module1 = struct {
iVersion int32
xCreate uintptr
@@ -1493,7 +1495,7 @@ type sqlite3_module1 = struct {
xShadowName uintptr
}
-type sqlite3_module = sqlite3_module1 /* sqlite3.h:6690:31 */
+type sqlite3_module = sqlite3_module1 /* sqlite3.h:6692:31 */
// CAPI3REF: Virtual Table Indexing Information
// KEYWORDS: sqlite3_index_info
@@ -1952,7 +1954,7 @@ type sqlite3_mutex_methods1 = struct {
// called, but only if the prior call to xMutexInit returned SQLITE_OK.
// If xMutexInit fails in any way, it is expected to clean up after itself
// prior to returning.
-type sqlite3_mutex_methods = sqlite3_mutex_methods1 /* sqlite3.h:7522:38 */
+type sqlite3_mutex_methods = sqlite3_mutex_methods1 /* sqlite3.h:7524:38 */
// CAPI3REF: Custom Page Cache Object
//
@@ -1975,7 +1977,7 @@ type sqlite3_pcache_page1 = struct {
// of this object as parameters or as their return value.
//
// See [sqlite3_pcache_methods2] for additional information.
-type sqlite3_pcache_page = sqlite3_pcache_page1 /* sqlite3.h:8271:36 */
+type sqlite3_pcache_page = sqlite3_pcache_page1 /* sqlite3.h:8277:36 */
// CAPI3REF: Application Defined Page Cache.
// KEYWORDS: {page cache}
@@ -2307,7 +2309,7 @@ type sqlite3_pcache_methods21 = struct {
// free up as much of heap memory as possible. The page cache implementation
// is not obligated to free any memory, but well-behaved implementations should
// do their best.
-type sqlite3_pcache_methods2 = sqlite3_pcache_methods21 /* sqlite3.h:8436:40 */
+type sqlite3_pcache_methods2 = sqlite3_pcache_methods21 /* sqlite3.h:8442:40 */
// This is the obsolete pcache_methods object that has now been replaced
// by sqlite3_pcache_methods2. This object is not used by SQLite. It is
@@ -2329,7 +2331,7 @@ type sqlite3_pcache_methods1 = struct {
// This is the obsolete pcache_methods object that has now been replaced
// by sqlite3_pcache_methods2. This object is not used by SQLite. It is
// retained in the header file for backwards compatibility only.
-type sqlite3_pcache_methods = sqlite3_pcache_methods1 /* sqlite3.h:8459:39 */
+type sqlite3_pcache_methods = sqlite3_pcache_methods1 /* sqlite3.h:8465:39 */
// CAPI3REF: Database Snapshot
// KEYWORDS: {snapshot} {sqlite3_snapshot}
@@ -2369,7 +2371,7 @@ type sqlite3_snapshot1 = struct{ hidden [48]uint8 }
// version of the database file so that it is possible to later open a new read
// transaction that sees that historical version of the database rather than
// the most recent version.
-type sqlite3_snapshot = sqlite3_snapshot1 /* sqlite3.h:9508:3 */
+type sqlite3_snapshot = sqlite3_snapshot1 /* sqlite3.h:9514:3 */
// CAPI3REF: Flags for sqlite3_deserialize()
//
@@ -2449,7 +2451,7 @@ type sqlite3_rtree_geometry1 = struct {
//
//
-type sqlite3_rtree_geometry = sqlite3_rtree_geometry1 /* sqlite3.h:9833:39 */
+type sqlite3_rtree_geometry = sqlite3_rtree_geometry1 /* sqlite3.h:9839:39 */
type sqlite3_rtree_query_info1 = struct {
pContext uintptr
nParam int32
@@ -2469,11 +2471,11 @@ type sqlite3_rtree_query_info1 = struct {
apSqlParam uintptr
}
-type sqlite3_rtree_query_info = sqlite3_rtree_query_info1 /* sqlite3.h:9834:41 */
+type sqlite3_rtree_query_info = sqlite3_rtree_query_info1 /* sqlite3.h:9840:41 */
// The double-precision datatype used by RTree depends on the
// SQLITE_RTREE_INT_ONLY compile-time option.
-type sqlite3_rtree_dbl = float64 /* sqlite3.h:9842:18 */
+type sqlite3_rtree_dbl = float64 /* sqlite3.h:9848:18 */
// Allowed values for sqlite3_rtree_query.eWithin and .eParentWithin.
@@ -2560,22 +2562,22 @@ type Fts5ExtensionApi1 = struct {
// Virtual table implementations may overload SQL functions by implementing
// the sqlite3_module.xFindFunction() method.
-type Fts5ExtensionApi = Fts5ExtensionApi1 /* sqlite3.h:11628:33 */
+type Fts5ExtensionApi = Fts5ExtensionApi1 /* sqlite3.h:11634:33 */
type Fts5PhraseIter1 = struct {
a uintptr
b uintptr
}
-type Fts5PhraseIter = Fts5PhraseIter1 /* sqlite3.h:11630:31 */
+type Fts5PhraseIter = Fts5PhraseIter1 /* sqlite3.h:11636:31 */
-type fts5_extension_function = uintptr /* sqlite3.h:11632:14 */
+type fts5_extension_function = uintptr /* sqlite3.h:11638:14 */
type fts5_tokenizer1 = struct {
xCreate uintptr
xDelete uintptr
xTokenize uintptr
}
-type fts5_tokenizer = fts5_tokenizer1 /* sqlite3.h:12091:31 */
+type fts5_tokenizer = fts5_tokenizer1 /* sqlite3.h:12097:31 */
// Flags that may be passed as the third argument to xTokenize()
@@ -2608,7 +2610,7 @@ type fts5_api1 = struct {
// ************************************************************************
//
// FTS5 EXTENSION REGISTRATION API
-type fts5_api = fts5_api1 /* sqlite3.h:12127:25 */
+type fts5_api = fts5_api1 /* sqlite3.h:12133:25 */
// The tag name of this struct is _G_fpos_t to preserve historic
// C++ mangled names for functions taking fpos_t arguments.
@@ -3937,6 +3939,20 @@ type socklen_t = uint32 /* unistd.h:274:21 */
// Define some macros helping to catch buffer overflows.
+type u64 = sqlite3_uint64 /* speedtest1.c:66:24 */
+
+// State structure for a Hash hash in progress
+type HashContext1 = struct {
+ isInit uint8
+ i uint8
+ j uint8
+ s [256]uint8
+ r [32]uint8
+}
+
+// State structure for a Hash hash in progress
+type HashContext = HashContext1 /* speedtest1.c:71:28 */
+
// All global state is held in this structure
type Global = struct {
db uintptr
@@ -3952,42 +3968,105 @@ type Global = struct {
eTemp int32
szTest int32
nRepeat int32
+ doCheckpoint int32
zWR uintptr
zNN uintptr
zPK uintptr
x uint32
y uint32
+ nResByte u64
nResult int32
zResult [3000]int8
- _ [4]byte
+ hashFile uintptr
+ hash HashContext
+ _ [5]byte
}
-// Define some macros helping to catch buffer overflows.
-
// All global state is held in this structure
-var g Global /* speedtest1.c:85:3: */
+var g Global /* speedtest1.c:107:3: */
// Return " TEMP" or "", as appropriate for creating a table.
-func isTemp(tls *crt.TLS, N int32) uintptr { /* speedtest1.c:89:19: */
+func isTemp(tls *libc.TLS, N int32) uintptr { /* speedtest1.c:111:19: */
if g.eTemp >= N {
- return ts + 1982 /* " TEMP" */
+ return ts + 2146 /* " TEMP" */
}
- return ts + 1988 /* "" */
+ return ts + 2152 /* "" */
}
// Print an error message and exit
-func fatal_error(tls *crt.TLS, zMsg uintptr, va uintptr) { /* speedtest1.c:95:13: */
+func fatal_error(tls *libc.TLS, zMsg uintptr, va uintptr) { /* speedtest1.c:116:13: */
var ap va_list
_ = ap
ap = va
- crt.Xvfprintf(tls, crt.Xstderr, zMsg, ap)
+ libc.Xvfprintf(tls, libc.Xstderr, zMsg, ap)
_ = ap
- crt.Xexit(tls, 1)
+ libc.Xexit(tls, 1)
+}
+
+// ***************************************************************************
+//
+// Hash algorithm used to verify that compilation is not miscompiled
+// in such a was as to generate an incorrect result.
+
+// Initialize a new hash. iSize determines the size of the hash
+// in bits and should be one of 224, 256, 384, or 512. Or iSize
+// can be zero to use the default hash size of 256 bits.
+func HashInit(tls *libc.TLS) { /* speedtest1.c:135:13: */
+ var k uint32
+ g.hash.i = uint8(0)
+ g.hash.j = uint8(0)
+ for k = uint32(0); k < uint32(256); k++ {
+ *(*uint8)(unsafe.Pointer((uintptr(unsafe.Pointer(&g)) + 3128 /* &.hash */ + 3 /* &.s */) + uintptr(k))) = uint8(k)
+ }
}
+// Make consecutive calls to the HashUpdate function to add new content
+// to the hash
+func HashUpdate(tls *libc.TLS, aData uintptr, nData uint32) { /* speedtest1.c:146:13: */
+ var t uint8
+ var i uint8 = g.hash.i
+ var j uint8 = g.hash.j
+ var k uint32
+ if g.hashFile != 0 {
+ libc.Xfwrite(tls, aData, uint64(1), uint64(nData), g.hashFile)
+ }
+ for k = uint32(0); k < nData; k++ {
+ j = uint8(int32(j) + (int32(*(*uint8)(unsafe.Pointer((uintptr(unsafe.Pointer(&g)) + 3128 /* &.hash */ + 3 /* &.s */) + uintptr(i)))) + int32(*(*uint8)(unsafe.Pointer(aData + uintptr(k))))))
+ t = *(*uint8)(unsafe.Pointer((uintptr(unsafe.Pointer(&g)) + 3128 /* &.hash */ + 3 /* &.s */) + uintptr(j)))
+ *(*uint8)(unsafe.Pointer((uintptr(unsafe.Pointer(&g)) + 3128 /* &.hash */ + 3 /* &.s */) + uintptr(j))) = *(*uint8)(unsafe.Pointer((uintptr(unsafe.Pointer(&g)) + 3128 /* &.hash */ + 3 /* &.s */) + uintptr(i)))
+ *(*uint8)(unsafe.Pointer((uintptr(unsafe.Pointer(&g)) + 3128 /* &.hash */ + 3 /* &.s */) + uintptr(i))) = t
+ i++
+ }
+ g.hash.i = i
+ g.hash.j = j
+}
+
+// After all content has been added, invoke HashFinal() to compute
+// the final hash. The hash result is stored in g.hash.r[].
+func HashFinal(tls *libc.TLS) { /* speedtest1.c:170:13: */
+ var k uint32
+ var t uint8
+ var i uint8
+ var j uint8
+ i = g.hash.i
+ j = g.hash.j
+ for k = uint32(0); k < uint32(32); k++ {
+ i++
+ t = *(*uint8)(unsafe.Pointer((uintptr(unsafe.Pointer(&g)) + 3128 /* &.hash */ + 3 /* &.s */) + uintptr(i)))
+ j = uint8(int32(j) + (int32(t)))
+ *(*uint8)(unsafe.Pointer((uintptr(unsafe.Pointer(&g)) + 3128 /* &.hash */ + 3 /* &.s */) + uintptr(i))) = *(*uint8)(unsafe.Pointer((uintptr(unsafe.Pointer(&g)) + 3128 /* &.hash */ + 3 /* &.s */) + uintptr(j)))
+ *(*uint8)(unsafe.Pointer((uintptr(unsafe.Pointer(&g)) + 3128 /* &.hash */ + 3 /* &.s */) + uintptr(j))) = t
+ t = uint8(int32(t) + (int32(*(*uint8)(unsafe.Pointer((uintptr(unsafe.Pointer(&g)) + 3128 /* &.hash */ + 3 /* &.s */) + uintptr(i))))))
+ *(*uint8)(unsafe.Pointer((uintptr(unsafe.Pointer(&g)) + 3128 /* &.hash */ + 259 /* &.r */) + uintptr(k))) = *(*uint8)(unsafe.Pointer((uintptr(unsafe.Pointer(&g)) + 3128 /* &.hash */ + 3 /* &.s */) + uintptr(t)))
+ }
+}
+
+// End of the Hash hashing logic
+//
+
// Return the value of a hexadecimal digit. Return -1 if the input
// is not a hex digit.
-func hexDigitValue(tls *crt.TLS, c int8) int32 { /* speedtest1.c:107:12: */
+func hexDigitValue(tls *libc.TLS, c int8) int32 { /* speedtest1.c:194:12: */
if (int32(c) >= '0') && (int32(c) <= '9') {
return (int32(c) - '0')
}
@@ -4004,7 +4083,7 @@ func hexDigitValue(tls *crt.TLS, c int8) int32 { /* speedtest1.c:107:12: */
// SQLite
// Interpret zArg as an integer value, possibly with suffixes.
-func integerValue(tls *crt.TLS, zArg uintptr) int32 { /* speedtest1.c:123:12: */
+func integerValue(tls *libc.TLS, zArg uintptr) int32 { /* speedtest1.c:210:12: */
var v sqlite3_int64 = int64(0)
var i int32
var isNeg int32 = 0
@@ -4017,12 +4096,12 @@ func integerValue(tls *crt.TLS, zArg uintptr) int32 { /* speedtest1.c:123:12: */
if (int32(*(*int8)(unsafe.Pointer(zArg + uintptr(0)))) == '0') && (int32(*(*int8)(unsafe.Pointer(zArg + uintptr(1)))) == 'x') {
var x int32
zArg += uintptr(2)
- for (crt.AssignInt32(&x, hexDigitValue(tls, *(*int8)(unsafe.Pointer(zArg + uintptr(0)))))) >= 0 {
+ for (libc.AssignInt32(&x, hexDigitValue(tls, *(*int8)(unsafe.Pointer(zArg + uintptr(0)))))) >= 0 {
v = ((v << 4) + sqlite3_int64(x))
zArg++
}
} else {
- for (int32(*(*uint16)(unsafe.Pointer((*(*uintptr)(unsafe.Pointer(crt.X__ctype_b_loc(tls)))) + uintptr(int32(*(*int8)(unsafe.Pointer(zArg + uintptr(0)))))*2))) & int32(_ISdigit)) != 0 {
+ for (int32(*(*uint16)(unsafe.Pointer((*(*uintptr)(unsafe.Pointer(libc.X__ctype_b_loc(tls)))) + uintptr(int32(*(*int8)(unsafe.Pointer(zArg + uintptr(0)))))*2))) & int32(_ISdigit)) != 0 {
v = (((v * int64(10)) + sqlite3_int64(*(*int8)(unsafe.Pointer(zArg + uintptr(0))))) - int64('0'))
zArg++
}
@@ -4038,7 +4117,7 @@ func integerValue(tls *crt.TLS, zArg uintptr) int32 { /* speedtest1.c:123:12: */
}
}
if v > int64(0x7fffffff) {
- fatal_error(tls, ts+1989 /* "parameter too la..." */, 0)
+ fatal_error(tls, ts+2153 /* "parameter too la..." */, 0)
}
return func() int32 {
if isNeg != 0 {
@@ -4053,19 +4132,19 @@ var aMult = [9]struct {
iMult int32
_ [4]byte
}{
- {zSuffix: ts + 2026 /* "KiB" */, iMult: 1024},
- {zSuffix: ts + 2030 /* "MiB" */, iMult: (1024 * 1024)},
- {zSuffix: ts + 2034 /* "GiB" */, iMult: ((1024 * 1024) * 1024)},
- {zSuffix: ts + 2038 /* "KB" */, iMult: 1000},
- {zSuffix: ts + 2041 /* "MB" */, iMult: 1000000},
- {zSuffix: ts + 2044 /* "GB" */, iMult: 1000000000},
- {zSuffix: ts + 2047 /* "K" */, iMult: 1000},
- {zSuffix: ts + 2049 /* "M" */, iMult: 1000000},
- {zSuffix: ts + 2051 /* "G" */, iMult: 1000000000},
-} /* speedtest1.c:125:53 */
+ {zSuffix: ts + 2190 /* "KiB" */, iMult: 1024},
+ {zSuffix: ts + 2194 /* "MiB" */, iMult: (1024 * 1024)},
+ {zSuffix: ts + 2198 /* "GiB" */, iMult: ((1024 * 1024) * 1024)},
+ {zSuffix: ts + 2202 /* "KB" */, iMult: 1000},
+ {zSuffix: ts + 2205 /* "MB" */, iMult: 1000000},
+ {zSuffix: ts + 2208 /* "GB" */, iMult: 1000000000},
+ {zSuffix: ts + 2211 /* "K" */, iMult: 1000},
+ {zSuffix: ts + 2213 /* "M" */, iMult: 1000000},
+ {zSuffix: ts + 2215 /* "G" */, iMult: 1000000000},
+} /* speedtest1.c:212:53 */
// Return the current wall-clock time, in milliseconds
-func speedtest1_timestamp(tls *crt.TLS) sqlite3_int64 { /* speedtest1.c:168:15: */
+func speedtest1_timestamp(tls *libc.TLS) sqlite3_int64 { /* speedtest1.c:255:15: */
bp := tls.Alloc(16)
defer tls.Free(16)
@@ -4075,20 +4154,20 @@ func speedtest1_timestamp(tls *crt.TLS) sqlite3_int64 { /* speedtest1.c:168:15:
clockVfs = sqlite3.Xsqlite3_vfs_find(tls, uintptr(0))
}
if ((*sqlite3_vfs)(unsafe.Pointer(clockVfs)).iVersion >= 2) && ((*sqlite3_vfs)(unsafe.Pointer(clockVfs)).xCurrentTimeInt64 != uintptr(0)) {
- (*(*func(*crt.TLS, uintptr, uintptr) int32)(unsafe.Pointer((clockVfs + 136 /* &.xCurrentTimeInt64 */))))(tls, clockVfs, bp /* &t */)
+ (*(*func(*libc.TLS, uintptr, uintptr) int32)(unsafe.Pointer((clockVfs + 136 /* &.xCurrentTimeInt64 */))))(tls, clockVfs, bp /* &t */)
} else {
// var r float64 at bp+8, 8
- (*(*func(*crt.TLS, uintptr, uintptr) int32)(unsafe.Pointer((clockVfs + 120 /* &.xCurrentTime */))))(tls, clockVfs, bp+8 /* &r */)
+ (*(*func(*libc.TLS, uintptr, uintptr) int32)(unsafe.Pointer((clockVfs + 120 /* &.xCurrentTime */))))(tls, clockVfs, bp+8 /* &r */)
*(*sqlite3_int64)(unsafe.Pointer(bp /* t */)) = (sqlite3_int64(*(*float64)(unsafe.Pointer(bp + 8 /* r */)) * 86400000.0))
}
return *(*sqlite3_int64)(unsafe.Pointer(bp /* t */))
}
-var clockVfs uintptr = uintptr(0) /* speedtest1.c:172:22 */
+var clockVfs uintptr = uintptr(0) /* speedtest1.c:259:22 */
// Return a pseudo-random unsigned integer
-func speedtest1_random(tls *crt.TLS) uint32 { /* speedtest1.c:190:14: */
+func speedtest1_random(tls *libc.TLS) uint32 { /* speedtest1.c:277:14: */
g.x = ((g.x >> 1) ^ ((uint32(1) + ^(g.x & uint32(1))) & 0xd0000001))
g.y = ((g.y * uint32(1103515245)) + uint32(12345))
return (g.x ^ g.y)
@@ -4096,7 +4175,7 @@ func speedtest1_random(tls *crt.TLS) uint32 { /* speedtest1.c:190:14: */
// Map the value in within the range of 1...limit into another
// number in a way that is chatic and invertable.
-func swizzle(tls *crt.TLS, in uint32, limit uint32) uint32 { /* speedtest1.c:199:10: */
+func swizzle(tls *libc.TLS, in uint32, limit uint32) uint32 { /* speedtest1.c:286:10: */
var out uint32 = uint32(0)
for limit != 0 {
out = ((out << 1) | (in & uint32(1)))
@@ -4107,7 +4186,7 @@ func swizzle(tls *crt.TLS, in uint32, limit uint32) uint32 { /* speedtest1.c:199
}
// Round up a number so that it is a power of two minus one
-func roundup_allones(tls *crt.TLS, limit uint32) uint32 { /* speedtest1.c:211:10: */
+func roundup_allones(tls *libc.TLS, limit uint32) uint32 { /* speedtest1.c:298:10: */
var m uint32 = uint32(1)
for m < limit {
m = ((m << 1) + uint32(1))
@@ -4122,7 +4201,7 @@ func roundup_allones(tls *crt.TLS, limit uint32) uint32 { /* speedtest1.c:211:10
// Example:
//
// speedtest1_numbername(123) -> "one hundred twenty three"
-func speedtest1_numbername(tls *crt.TLS, n uint32, zOut uintptr, nOut int32) int32 { /* speedtest1.c:225:5: */
+func speedtest1_numbername(tls *libc.TLS, n uint32, zOut uintptr, nOut int32) int32 { /* speedtest1.c:312:5: */
bp := tls.Alloc(24)
defer tls.Free(24)
@@ -4130,88 +4209,88 @@ func speedtest1_numbername(tls *crt.TLS, n uint32, zOut uintptr, nOut int32) int
if n >= uint32(1000000000) {
i = i + (speedtest1_numbername(tls, (n / uint32(1000000000)), (zOut + uintptr(i)), (nOut - i)))
- sqlite3.Xsqlite3_snprintf(tls, (nOut - i), (zOut + uintptr(i)), ts+2053 /* " billion" */, 0)
- i = i + (int32(crt.Xstrlen(tls, (zOut + uintptr(i)))))
+ sqlite3.Xsqlite3_snprintf(tls, (nOut - i), (zOut + uintptr(i)), ts+2217 /* " billion" */, 0)
+ i = i + (int32(libc.Xstrlen(tls, (zOut + uintptr(i)))))
n = (n % uint32(1000000000))
}
if n >= uint32(1000000) {
if (i != 0) && (i < (nOut - 1)) {
- *(*int8)(unsafe.Pointer(zOut + uintptr(crt.PostIncInt32(&i, 1)))) = int8(' ')
+ *(*int8)(unsafe.Pointer(zOut + uintptr(libc.PostIncInt32(&i, 1)))) = int8(' ')
}
i = i + (speedtest1_numbername(tls, (n / uint32(1000000)), (zOut + uintptr(i)), (nOut - i)))
- sqlite3.Xsqlite3_snprintf(tls, (nOut - i), (zOut + uintptr(i)), ts+2062 /* " million" */, 0)
- i = i + (int32(crt.Xstrlen(tls, (zOut + uintptr(i)))))
+ sqlite3.Xsqlite3_snprintf(tls, (nOut - i), (zOut + uintptr(i)), ts+2226 /* " million" */, 0)
+ i = i + (int32(libc.Xstrlen(tls, (zOut + uintptr(i)))))
n = (n % uint32(1000000))
}
if n >= uint32(1000) {
if (i != 0) && (i < (nOut - 1)) {
- *(*int8)(unsafe.Pointer(zOut + uintptr(crt.PostIncInt32(&i, 1)))) = int8(' ')
+ *(*int8)(unsafe.Pointer(zOut + uintptr(libc.PostIncInt32(&i, 1)))) = int8(' ')
}
i = i + (speedtest1_numbername(tls, (n / uint32(1000)), (zOut + uintptr(i)), (nOut - i)))
- sqlite3.Xsqlite3_snprintf(tls, (nOut - i), (zOut + uintptr(i)), ts+2071 /* " thousand" */, 0)
- i = i + (int32(crt.Xstrlen(tls, (zOut + uintptr(i)))))
+ sqlite3.Xsqlite3_snprintf(tls, (nOut - i), (zOut + uintptr(i)), ts+2235 /* " thousand" */, 0)
+ i = i + (int32(libc.Xstrlen(tls, (zOut + uintptr(i)))))
n = (n % uint32(1000))
}
if n >= uint32(100) {
if (i != 0) && (i < (nOut - 1)) {
- *(*int8)(unsafe.Pointer(zOut + uintptr(crt.PostIncInt32(&i, 1)))) = int8(' ')
+ *(*int8)(unsafe.Pointer(zOut + uintptr(libc.PostIncInt32(&i, 1)))) = int8(' ')
}
- sqlite3.Xsqlite3_snprintf(tls, (nOut - i), (zOut + uintptr(i)), ts+2081 /* "%s hundred" */, crt.VaList(bp, ones[(n/uint32(100))]))
- i = i + (int32(crt.Xstrlen(tls, (zOut + uintptr(i)))))
+ sqlite3.Xsqlite3_snprintf(tls, (nOut - i), (zOut + uintptr(i)), ts+2245 /* "%s hundred" */, libc.VaList(bp, ones[(n/uint32(100))]))
+ i = i + (int32(libc.Xstrlen(tls, (zOut + uintptr(i)))))
n = (n % uint32(100))
}
if n >= uint32(20) {
if (i != 0) && (i < (nOut - 1)) {
- *(*int8)(unsafe.Pointer(zOut + uintptr(crt.PostIncInt32(&i, 1)))) = int8(' ')
+ *(*int8)(unsafe.Pointer(zOut + uintptr(libc.PostIncInt32(&i, 1)))) = int8(' ')
}
- sqlite3.Xsqlite3_snprintf(tls, (nOut - i), (zOut + uintptr(i)), ts+2092 /* "%s" */, crt.VaList(bp+8, tens[(n/uint32(10))]))
- i = i + (int32(crt.Xstrlen(tls, (zOut + uintptr(i)))))
+ sqlite3.Xsqlite3_snprintf(tls, (nOut - i), (zOut + uintptr(i)), ts+2256 /* "%s" */, libc.VaList(bp+8, tens[(n/uint32(10))]))
+ i = i + (int32(libc.Xstrlen(tls, (zOut + uintptr(i)))))
n = (n % uint32(10))
}
if n > uint32(0) {
if (i != 0) && (i < (nOut - 1)) {
- *(*int8)(unsafe.Pointer(zOut + uintptr(crt.PostIncInt32(&i, 1)))) = int8(' ')
+ *(*int8)(unsafe.Pointer(zOut + uintptr(libc.PostIncInt32(&i, 1)))) = int8(' ')
}
- sqlite3.Xsqlite3_snprintf(tls, (nOut - i), (zOut + uintptr(i)), ts+2092 /* "%s" */, crt.VaList(bp+16, ones[n]))
- i = i + (int32(crt.Xstrlen(tls, (zOut + uintptr(i)))))
+ sqlite3.Xsqlite3_snprintf(tls, (nOut - i), (zOut + uintptr(i)), ts+2256 /* "%s" */, libc.VaList(bp+16, ones[n]))
+ i = i + (int32(libc.Xstrlen(tls, (zOut + uintptr(i)))))
}
if i == 0 {
- sqlite3.Xsqlite3_snprintf(tls, (nOut - i), (zOut + uintptr(i)), ts+2095 /* "zero" */, 0)
- i = i + (int32(crt.Xstrlen(tls, (zOut + uintptr(i)))))
+ sqlite3.Xsqlite3_snprintf(tls, (nOut - i), (zOut + uintptr(i)), ts+2259 /* "zero" */, 0)
+ i = i + (int32(libc.Xstrlen(tls, (zOut + uintptr(i)))))
}
return i
}
-var ones = [20]uintptr{ts + 2095 /* "zero" */, ts + 2100 /* "one" */, ts + 2104 /* "two" */, ts + 2108 /* "three" */, ts + 2114 /* "four" */, ts + 2119, /* "five" */
- ts + 2124 /* "six" */, ts + 2128 /* "seven" */, ts + 2134 /* "eight" */, ts + 2140 /* "nine" */, ts + 2145 /* "ten" */, ts + 2149 /* "eleven" */, ts + 2156, /* "twelve" */
- ts + 2163 /* "thirteen" */, ts + 2172 /* "fourteen" */, ts + 2181 /* "fifteen" */, ts + 2189 /* "sixteen" */, ts + 2197, /* "seventeen" */
- ts + 2207 /* "eighteen" */, ts + 2216 /* "nineteen" */} /* speedtest1.c:226:21 */
-var tens = [10]uintptr{ts + 1988 /* "" */, ts + 2145 /* "ten" */, ts + 2225 /* "twenty" */, ts + 2232 /* "thirty" */, ts + 2239, /* "forty" */
- ts + 2245 /* "fifty" */, ts + 2251 /* "sixty" */, ts + 2257 /* "seventy" */, ts + 2265 /* "eighty" */, ts + 2272 /* "ninety" */} /* speedtest1.c:230:21 */
+var ones = [20]uintptr{ts + 2259 /* "zero" */, ts + 2264 /* "one" */, ts + 2268 /* "two" */, ts + 2272 /* "three" */, ts + 2278 /* "four" */, ts + 2283, /* "five" */
+ ts + 2288 /* "six" */, ts + 2292 /* "seven" */, ts + 2298 /* "eight" */, ts + 2304 /* "nine" */, ts + 2309 /* "ten" */, ts + 2313 /* "eleven" */, ts + 2320, /* "twelve" */
+ ts + 2327 /* "thirteen" */, ts + 2336 /* "fourteen" */, ts + 2345 /* "fifteen" */, ts + 2353 /* "sixteen" */, ts + 2361, /* "seventeen" */
+ ts + 2371 /* "eighteen" */, ts + 2380 /* "nineteen" */} /* speedtest1.c:313:21 */
+var tens = [10]uintptr{ts + 2152 /* "" */, ts + 2309 /* "ten" */, ts + 2389 /* "twenty" */, ts + 2396 /* "thirty" */, ts + 2403, /* "forty" */
+ ts + 2409 /* "fifty" */, ts + 2415 /* "sixty" */, ts + 2421 /* "seventy" */, ts + 2429 /* "eighty" */, ts + 2436 /* "ninety" */} /* speedtest1.c:317:21 */
// Start a new test case
-var zDots = *(*[72]int8)(unsafe.Pointer(ts + 2279 /* "..................." */)) /* speedtest1.c:281:19 */
-func speedtest1_begin_test(tls *crt.TLS, iTestNum int32, zTestName uintptr, va uintptr) { /* speedtest1.c:283:6: */
+var zDots = *(*[72]int8)(unsafe.Pointer(ts + 2443 /* "..................." */)) /* speedtest1.c:368:19 */
+func speedtest1_begin_test(tls *libc.TLS, iTestNum int32, zTestName uintptr, va uintptr) { /* speedtest1.c:370:6: */
bp := tls.Alloc(64)
defer tls.Free(64)
- var n int32 = int32(crt.Xstrlen(tls, zTestName))
+ var n int32 = int32(libc.Xstrlen(tls, zTestName))
var zName uintptr
var ap va_list
_ = ap
ap = va
zName = sqlite3.Xsqlite3_vmprintf(tls, zTestName, ap)
_ = ap
- n = int32(crt.Xstrlen(tls, zName))
+ n = int32(libc.Xstrlen(tls, zName))
if n > 60 {
*(*int8)(unsafe.Pointer(zName + uintptr(60))) = int8(0)
n = 60
}
if g.bSqlOnly != 0 {
- crt.Xprintf(tls, ts+2351 /* "/* %4d - %s%.*s ..." */, crt.VaList(bp, iTestNum, zName, (60-n), uintptr(unsafe.Pointer(&zDots))))
+ libc.Xprintf(tls, ts+2515 /* "/* %4d - %s%.*s ..." */, libc.VaList(bp, iTestNum, zName, (60-n), uintptr(unsafe.Pointer(&zDots))))
} else {
- crt.Xprintf(tls, ts+2371 /* "%4d - %s%.*s " */, crt.VaList(bp+32, iTestNum, zName, (60-n), uintptr(unsafe.Pointer(&zDots))))
- crt.Xfflush(tls, crt.Xstdout)
+ libc.Xprintf(tls, ts+2535 /* "%4d - %s%.*s " */, libc.VaList(bp+32, iTestNum, zName, (60-n), uintptr(unsafe.Pointer(&zDots))))
+ libc.Xfflush(tls, libc.Xstdout)
}
sqlite3.Xsqlite3_free(tls, zName)
g.nResult = 0
@@ -4221,14 +4300,17 @@ func speedtest1_begin_test(tls *crt.TLS, iTestNum int32, zTestName uintptr, va u
}
// Complete a test case
-func speedtest1_end_test(tls *crt.TLS) { /* speedtest1.c:309:6: */
+func speedtest1_end_test(tls *libc.TLS) { /* speedtest1.c:399:6: */
bp := tls.Alloc(16)
defer tls.Free(16)
var iElapseTime sqlite3_int64 = (speedtest1_timestamp(tls) - g.iStart)
+ if g.doCheckpoint != 0 {
+ speedtest1_exec(tls, ts+2549 /* "PRAGMA wal_check..." */, 0)
+ }
if !(g.bSqlOnly != 0) {
*(*sqlite3_int64)(unsafe.Pointer(uintptr(unsafe.Pointer(&g)) + 24 /* &.iTotal */)) += (iElapseTime)
- crt.Xprintf(tls, ts+2385 /* "%4d.%03ds\n" */, crt.VaList(bp, (int32(iElapseTime/int64(1000))), (int32(iElapseTime%int64(1000)))))
+ libc.Xprintf(tls, ts+2572 /* "%4d.%03ds\n" */, libc.VaList(bp, (int32(iElapseTime/int64(1000))), (int32(iElapseTime%int64(1000)))))
}
if g.pStmt != 0 {
sqlite3.Xsqlite3_finalize(tls, g.pStmt)
@@ -4237,47 +4319,60 @@ func speedtest1_end_test(tls *crt.TLS) { /* speedtest1.c:309:6: */
}
// Report end of testing
-func speedtest1_final(tls *crt.TLS) { /* speedtest1.c:322:6: */
- bp := tls.Alloc(32)
- defer tls.Free(32)
+func speedtest1_final(tls *libc.TLS) { /* speedtest1.c:413:6: */
+ bp := tls.Alloc(48)
+ defer tls.Free(48)
if !(g.bSqlOnly != 0) {
- crt.Xprintf(tls, ts+2396 /* " TOTAL%.*s..." */, crt.VaList(bp, (60-5), uintptr(unsafe.Pointer(&zDots)),
+ libc.Xprintf(tls, ts+2583 /* " TOTAL%.*s..." */, libc.VaList(bp, (60-5), uintptr(unsafe.Pointer(&zDots)),
(int32(g.iTotal/int64(1000))), (int32(g.iTotal%int64(1000)))))
}
+ if g.bVerify != 0 {
+ var i int32
+ libc.Xprintf(tls, ts+2611 /* "Verification Has..." */, libc.VaList(bp+32, g.nResByte))
+ HashUpdate(tls, ts+2636 /* "\n" */, uint32(1))
+ HashFinal(tls)
+ for i = 0; i < 24; i++ {
+ libc.Xprintf(tls, ts+2638 /* "%02x" */, libc.VaList(bp+40, int32(*(*uint8)(unsafe.Pointer((uintptr(unsafe.Pointer(&g)) + 3128 /* &.hash */ + 259 /* &.r */) + uintptr(i))))))
+ }
+ if (g.hashFile != 0) && (g.hashFile != libc.Xstdout) {
+ libc.Xfclose(tls, g.hashFile)
+ }
+ libc.Xprintf(tls, ts+2636 /* "\n" */, 0)
+ }
}
// Print an SQL statement to standard output
-func printSql(tls *crt.TLS, zSql uintptr) { /* speedtest1.c:330:13: */
+func printSql(tls *libc.TLS, zSql uintptr) { /* speedtest1.c:436:13: */
bp := tls.Alloc(32)
defer tls.Free(32)
- var n int32 = int32(crt.Xstrlen(tls, zSql))
- for (n > 0) && ((int32(*(*int8)(unsafe.Pointer(zSql + uintptr((n - 1))))) == ';') || ((int32(*(*uint16)(unsafe.Pointer((*(*uintptr)(unsafe.Pointer(crt.X__ctype_b_loc(tls)))) + uintptr(int32(uint8(*(*int8)(unsafe.Pointer(zSql + uintptr((n - 1)))))))*2))) & int32(_ISspace)) != 0)) {
+ var n int32 = int32(libc.Xstrlen(tls, zSql))
+ for (n > 0) && ((int32(*(*int8)(unsafe.Pointer(zSql + uintptr((n - 1))))) == ';') || ((int32(*(*uint16)(unsafe.Pointer((*(*uintptr)(unsafe.Pointer(libc.X__ctype_b_loc(tls)))) + uintptr(int32(uint8(*(*int8)(unsafe.Pointer(zSql + uintptr((n - 1)))))))*2))) & int32(_ISspace)) != 0)) {
n--
}
if g.bExplain != 0 {
- crt.Xprintf(tls, ts+2424 /* "EXPLAIN " */, 0)
+ libc.Xprintf(tls, ts+2643 /* "EXPLAIN " */, 0)
}
- crt.Xprintf(tls, ts+2433 /* "%.*s;\n" */, crt.VaList(bp, n, zSql))
+ libc.Xprintf(tls, ts+2652 /* "%.*s;\n" */, libc.VaList(bp, n, zSql))
if (g.bExplain != 0) &&
- (((sqlite3.Xsqlite3_strglob(tls, ts+2440 /* "CREATE *" */, zSql) == 0) ||
- (sqlite3.Xsqlite3_strglob(tls, ts+2449 /* "DROP *" */, zSql) == 0)) ||
- (sqlite3.Xsqlite3_strglob(tls, ts+2456 /* "ALTER *" */, zSql) == 0)) {
- crt.Xprintf(tls, ts+2433 /* "%.*s;\n" */, crt.VaList(bp+16, n, zSql))
+ (((sqlite3.Xsqlite3_strglob(tls, ts+2659 /* "CREATE *" */, zSql) == 0) ||
+ (sqlite3.Xsqlite3_strglob(tls, ts+2668 /* "DROP *" */, zSql) == 0)) ||
+ (sqlite3.Xsqlite3_strglob(tls, ts+2675 /* "ALTER *" */, zSql) == 0)) {
+ libc.Xprintf(tls, ts+2652 /* "%.*s;\n" */, libc.VaList(bp+16, n, zSql))
}
}
// Shrink memory used, if appropriate and if the SQLite version is capable
// of doing so.
-func speedtest1_shrink_memory(tls *crt.TLS) { /* speedtest1.c:350:6: */
+func speedtest1_shrink_memory(tls *libc.TLS) { /* speedtest1.c:456:6: */
if g.bMemShrink != 0 {
sqlite3.Xsqlite3_db_release_memory(tls, g.db)
}
}
// Run SQL
-func speedtest1_exec(tls *crt.TLS, zFormat uintptr, va uintptr) { /* speedtest1.c:357:6: */
+func speedtest1_exec(tls *libc.TLS, zFormat uintptr, va uintptr) { /* speedtest1.c:463:6: */
bp := tls.Alloc(32)
defer tls.Free(32)
@@ -4293,18 +4388,54 @@ func speedtest1_exec(tls *crt.TLS, zFormat uintptr, va uintptr) { /* speedtest1.
*(*uintptr)(unsafe.Pointer(bp + 24 /* zErrMsg */)) = uintptr(0)
var rc int32 = sqlite3.Xsqlite3_exec(tls, g.db, zSql, uintptr(0), uintptr(0), bp+24 /* &zErrMsg */)
if *(*uintptr)(unsafe.Pointer(bp + 24 /* zErrMsg */)) != 0 {
- fatal_error(tls, ts+2464 /* "SQL error: %s\n%s..." */, crt.VaList(bp, *(*uintptr)(unsafe.Pointer(bp + 24 /* zErrMsg */)), zSql))
+ fatal_error(tls, ts+2683 /* "SQL error: %s\n%s..." */, libc.VaList(bp, *(*uintptr)(unsafe.Pointer(bp + 24 /* zErrMsg */)), zSql))
}
if rc != 0 {
- fatal_error(tls, ts+2482 /* "exec error: %s\n" */, crt.VaList(bp+16, sqlite3.Xsqlite3_errmsg(tls, g.db)))
+ fatal_error(tls, ts+2701 /* "exec error: %s\n" */, libc.VaList(bp+16, sqlite3.Xsqlite3_errmsg(tls, g.db)))
+ }
+ }
+ sqlite3.Xsqlite3_free(tls, zSql)
+ speedtest1_shrink_memory(tls)
+}
+
+// Run SQL and return the first column of the first row as a string. The
+// returned string is obtained from sqlite_malloc() and must be freed by
+// the caller.
+func speedtest1_once(tls *libc.TLS, zFormat uintptr, va uintptr) uintptr { /* speedtest1.c:485:6: */
+ bp := tls.Alloc(24)
+ defer tls.Free(24)
+
+ var ap va_list
+ _ = ap
+ var zSql uintptr
+ // var pStmt uintptr at bp+16, 8
+
+ var zResult uintptr = uintptr(0)
+ ap = va
+ zSql = sqlite3.Xsqlite3_vmprintf(tls, zFormat, ap)
+ _ = ap
+ if g.bSqlOnly != 0 {
+ printSql(tls, zSql)
+ } else {
+ var rc int32 = sqlite3.Xsqlite3_prepare_v2(tls, g.db, zSql, -1, bp+16 /* &pStmt */, uintptr(0))
+ if rc != 0 {
+ fatal_error(tls, ts+2717 /* "SQL error: %s\n" */, libc.VaList(bp, sqlite3.Xsqlite3_errmsg(tls, g.db)))
}
+ if sqlite3.Xsqlite3_step(tls, *(*uintptr)(unsafe.Pointer(bp + 16 /* pStmt */))) == 100 {
+ var z uintptr = sqlite3.Xsqlite3_column_text(tls, *(*uintptr)(unsafe.Pointer(bp + 16 /* pStmt */)), 0)
+ if z != 0 {
+ zResult = sqlite3.Xsqlite3_mprintf(tls, ts+2256 /* "%s" */, libc.VaList(bp+8, z))
+ }
+ }
+ sqlite3.Xsqlite3_finalize(tls, *(*uintptr)(unsafe.Pointer(bp + 16 /* pStmt */)))
}
sqlite3.Xsqlite3_free(tls, zSql)
speedtest1_shrink_memory(tls)
+ return zResult
}
// Prepare an SQL statement
-func speedtest1_prepare(tls *crt.TLS, zFormat uintptr, va uintptr) { /* speedtest1.c:376:6: */
+func speedtest1_prepare(tls *libc.TLS, zFormat uintptr, va uintptr) { /* speedtest1.c:512:6: */
bp := tls.Alloc(8)
defer tls.Free(8)
@@ -4323,16 +4454,16 @@ func speedtest1_prepare(tls *crt.TLS, zFormat uintptr, va uintptr) { /* speedtes
}
rc = sqlite3.Xsqlite3_prepare_v2(tls, g.db, zSql, -1, (uintptr(unsafe.Pointer(&g)) + 8 /* &.pStmt */), uintptr(0))
if rc != 0 {
- fatal_error(tls, ts+2498 /* "SQL error: %s\n" */, crt.VaList(bp, sqlite3.Xsqlite3_errmsg(tls, g.db)))
+ fatal_error(tls, ts+2717 /* "SQL error: %s\n" */, libc.VaList(bp, sqlite3.Xsqlite3_errmsg(tls, g.db)))
}
}
sqlite3.Xsqlite3_free(tls, zSql)
}
// Run an SQL statement previously prepared
-func speedtest1_run(tls *crt.TLS) { /* speedtest1.c:396:6: */
- bp := tls.Alloc(8)
- defer tls.Free(8)
+func speedtest1_run(tls *libc.TLS) { /* speedtest1.c:532:6: */
+ bp := tls.Alloc(16)
+ defer tls.Free(16)
var i int32
var n int32
@@ -4347,24 +4478,57 @@ func speedtest1_run(tls *crt.TLS) { /* speedtest1.c:396:6: */
for i = 0; i < n; i++ {
var z uintptr = sqlite3.Xsqlite3_column_text(tls, g.pStmt, i)
if z == uintptr(0) {
- z = ts + 2513 /* "nil" */
+ z = ts + 2732 /* "nil" */
+ }
+ len = int32(libc.Xstrlen(tls, z))
+ if g.bVerify != 0 {
+ var eType int32 = sqlite3.Xsqlite3_column_type(tls, g.pStmt, i)
+ // var zPrefix [2]uint8 at bp, 2
+
+ *(*uint8)(unsafe.Pointer(bp /* &zPrefix[0] */ + uintptr(0))) = uint8('\n')
+ *(*uint8)(unsafe.Pointer(bp /* &zPrefix[0] */ + uintptr(1))) = uint8(*(*int8)(unsafe.Pointer(ts + 2736 /* "-IFTBN" */ + uintptr(eType))))
+ if g.nResByte != 0 {
+ HashUpdate(tls, bp /* &zPrefix[0] */, uint32(2))
+ } else {
+ HashUpdate(tls, (bp /* &zPrefix[0] */ + uintptr(1)), uint32(1))
+ }
+ if eType == 2 {
+ // Omit the value of floating-point results from the verification
+ // hash. The only thing we record is the fact that the result was
+ // a floating-point value.
+ *(*u64)(unsafe.Pointer(uintptr(unsafe.Pointer(&g)) + 104 /* &.nResByte */)) += (uint64(2))
+ } else if eType == 4 {
+ var nBlob int32 = sqlite3.Xsqlite3_column_bytes(tls, g.pStmt, i)
+ var iBlob int32
+ // var zChar [2]uint8 at bp+2, 2
+
+ var aBlob uintptr = sqlite3.Xsqlite3_column_blob(tls, g.pStmt, i)
+ for iBlob = 0; iBlob < nBlob; iBlob++ {
+ *(*uint8)(unsafe.Pointer(bp + 2 /* &zChar[0] */ + uintptr(0))) = uint8(*(*int8)(unsafe.Pointer(ts + 2743 /* "0123456789abcdef" */ + uintptr((int32(*(*uint8)(unsafe.Pointer(aBlob + uintptr(iBlob)))) >> 4)))))
+ *(*uint8)(unsafe.Pointer(bp + 2 /* &zChar[0] */ + uintptr(1))) = uint8(*(*int8)(unsafe.Pointer(ts + 2743 /* "0123456789abcdef" */ + uintptr((int32(*(*uint8)(unsafe.Pointer(aBlob + uintptr(iBlob)))) & 15)))))
+ HashUpdate(tls, bp+2 /* &zChar[0] */, uint32(2))
+ }
+ *(*u64)(unsafe.Pointer(uintptr(unsafe.Pointer(&g)) + 104 /* &.nResByte */)) += (u64((nBlob * 2) + 2))
+ } else {
+ HashUpdate(tls, z, uint32(len))
+ *(*u64)(unsafe.Pointer(uintptr(unsafe.Pointer(&g)) + 104 /* &.nResByte */)) += (u64(len + 2))
+ }
}
- len = int32(crt.Xstrlen(tls, z))
if (uint64(g.nResult + len)) < (uint64(unsafe.Sizeof([3000]int8{})) - uint64(2)) {
if g.nResult > 0 {
- *(*int8)(unsafe.Pointer((uintptr(unsafe.Pointer(&g)) + 108 /* &.zResult */) + uintptr(crt.PostIncInt32(&g.nResult, 1)))) = int8(' ')
+ *(*int8)(unsafe.Pointer((uintptr(unsafe.Pointer(&g)) + 116 /* &.zResult */) + uintptr(libc.PostIncInt32(&g.nResult, 1)))) = int8(' ')
}
- crt.Xmemcpy(tls, ((uintptr(unsafe.Pointer(&g)) + 108 /* &.zResult */) + uintptr(g.nResult)), z, (uint64(len + 1)))
- *(*int32)(unsafe.Pointer(uintptr(unsafe.Pointer(&g)) + 104 /* &.nResult */)) += (len)
+ libc.Xmemcpy(tls, ((uintptr(unsafe.Pointer(&g)) + 116 /* &.zResult */) + uintptr(g.nResult)), z, (uint64(len + 1)))
+ *(*int32)(unsafe.Pointer(uintptr(unsafe.Pointer(&g)) + 112 /* &.nResult */)) += (len)
}
}
}
if g.bReprepare != 0 {
- // var pNew uintptr at bp, 8
+ // var pNew uintptr at bp+8, 8
- sqlite3.Xsqlite3_prepare_v2(tls, g.db, sqlite3.Xsqlite3_sql(tls, g.pStmt), -1, bp /* &pNew */, uintptr(0))
+ sqlite3.Xsqlite3_prepare_v2(tls, g.db, sqlite3.Xsqlite3_sql(tls, g.pStmt), -1, bp+8 /* &pNew */, uintptr(0))
sqlite3.Xsqlite3_finalize(tls, g.pStmt)
- g.pStmt = *(*uintptr)(unsafe.Pointer(bp /* pNew */))
+ g.pStmt = *(*uintptr)(unsafe.Pointer(bp + 8 /* pNew */))
} else {
sqlite3.Xsqlite3_reset(tls, g.pStmt)
}
@@ -4372,25 +4536,25 @@ func speedtest1_run(tls *crt.TLS) { /* speedtest1.c:396:6: */
}
// The sqlite3_trace() callback function
-func traceCallback(tls *crt.TLS, NotUsed uintptr, zSql uintptr) { /* speedtest1.c:430:13: */
+func traceCallback(tls *libc.TLS, NotUsed uintptr, zSql uintptr) { /* speedtest1.c:599:13: */
bp := tls.Alloc(16)
defer tls.Free(16)
- var n int32 = int32(crt.Xstrlen(tls, zSql))
- for (n > 0) && ((int32(*(*int8)(unsafe.Pointer(zSql + uintptr((n - 1))))) == ';') || ((int32(*(*uint16)(unsafe.Pointer((*(*uintptr)(unsafe.Pointer(crt.X__ctype_b_loc(tls)))) + uintptr(int32(uint8(*(*int8)(unsafe.Pointer(zSql + uintptr((n - 1)))))))*2))) & int32(_ISspace)) != 0)) {
+ var n int32 = int32(libc.Xstrlen(tls, zSql))
+ for (n > 0) && ((int32(*(*int8)(unsafe.Pointer(zSql + uintptr((n - 1))))) == ';') || ((int32(*(*uint16)(unsafe.Pointer((*(*uintptr)(unsafe.Pointer(libc.X__ctype_b_loc(tls)))) + uintptr(int32(uint8(*(*int8)(unsafe.Pointer(zSql + uintptr((n - 1)))))))*2))) & int32(_ISspace)) != 0)) {
n--
}
- crt.Xfprintf(tls, crt.Xstderr, ts+2433 /* "%.*s;\n" */, crt.VaList(bp, n, zSql))
+ libc.Xfprintf(tls, libc.Xstderr, ts+2652 /* "%.*s;\n" */, libc.VaList(bp, n, zSql))
}
// Substitute random() function that gives the same random
// sequence on each run, for repeatability.
-func randomFunc(tls *crt.TLS, context uintptr, NotUsed int32, NotUsed2 uintptr) { /* speedtest1.c:439:13: */
+func randomFunc(tls *libc.TLS, context uintptr, NotUsed int32, NotUsed2 uintptr) { /* speedtest1.c:608:13: */
sqlite3.Xsqlite3_result_int64(tls, context, sqlite3_int64(speedtest1_random(tls)))
}
// Estimate the square root of an integer
-func est_square_root(tls *crt.TLS, x int32) int32 { /* speedtest1.c:448:12: */
+func est_square_root(tls *libc.TLS, x int32) int32 { /* speedtest1.c:617:12: */
var y0 int32 = (x / 2)
var y1 int32
var n int32
@@ -4405,7 +4569,7 @@ func est_square_root(tls *crt.TLS, x int32) int32 { /* speedtest1.c:448:12: */
}
// The main and default testset
-func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */
+func testset_main(tls *libc.TLS) { /* speedtest1.c:694:6: */
bp := tls.Alloc(2568)
defer tls.Free(2568)
@@ -4419,14 +4583,14 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */
// var zNum [2000]int8 at bp+568, 2000
// A number name
- sz = crt.AssignInt32(&n, (g.szTest * 500))
+ sz = libc.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+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+2617 /* "INSERT INTO t1 V..." */, crt.VaList(bp+40, n))
+ speedtest1_begin_test(tls, 100, ts+2760 /* "%d INSERTs into ..." */, libc.VaList(bp, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
+ speedtest1_exec(tls, ts+2802, /* "CREATE%s TABLE t..." */
+ libc.VaList(bp+8, isTemp(tls, 9), g.zNN, g.zNN, g.zNN))
+ speedtest1_prepare(tls, ts+2860 /* "INSERT INTO t1 V..." */, libc.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{})))
@@ -4435,16 +4599,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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
n = sz
- speedtest1_begin_test(tls, 110, ts+2670 /* "%d ordered INSER..." */, crt.VaList(bp+48, n))
- speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0)
+ speedtest1_begin_test(tls, 110, ts+2913 /* "%d ordered INSER..." */, libc.VaList(bp+48, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
speedtest1_exec(tls,
- 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+2770 /* "INSERT INTO t2 V..." */, crt.VaList(bp+104, n))
+ ts+2950, /* "CREATE%s TABLE t..." */
+ libc.VaList(bp+56, isTemp(tls, 5), g.zNN, g.zPK, g.zNN, g.zNN, g.zWR))
+ speedtest1_prepare(tls, ts+3013 /* "INSERT INTO t2 V..." */, libc.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{})))
@@ -4453,16 +4617,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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
n = sz
- speedtest1_begin_test(tls, 120, ts+2815 /* "%d unordered INS..." */, crt.VaList(bp+112, n))
- speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0)
+ speedtest1_begin_test(tls, 120, ts+3058 /* "%d unordered INS..." */, libc.VaList(bp+112, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
speedtest1_exec(tls,
- 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+2917 /* "INSERT INTO t3 V..." */, crt.VaList(bp+168, n))
+ ts+3097, /* "CREATE%s TABLE t..." */
+ libc.VaList(bp+120, isTemp(tls, 3), g.zNN, g.zPK, g.zNN, g.zNN, g.zWR))
+ speedtest1_prepare(tls, ts+3160 /* "INSERT INTO t3 V..." */, libc.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{})))
@@ -4471,15 +4635,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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
n = 25
- speedtest1_begin_test(tls, 130, ts+2962 /* "%d SELECTS, nume..." */, crt.VaList(bp+176, n))
- speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0)
+ speedtest1_begin_test(tls, 130, ts+3205 /* "%d SELECTS, nume..." */, libc.VaList(bp+176, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
speedtest1_prepare(tls,
- ts+3001 /* "SELECT count(*),..." */, crt.VaList(bp+184, n))
+ ts+3244 /* "SELECT count(*),..." */, libc.VaList(bp+184, n))
for i = 1; i <= n; i++ {
if ((i - 1) % g.nRepeat) == 0 {
x1 = (speedtest1_random(tls) % uint32(maxb))
@@ -4489,15 +4653,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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
n = 10
- speedtest1_begin_test(tls, 140, ts+3106 /* "%d SELECTS, LIKE..." */, crt.VaList(bp+192, n))
- speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0)
+ speedtest1_begin_test(tls, 140, ts+3349 /* "%d SELECTS, LIKE..." */, libc.VaList(bp+192, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
speedtest1_prepare(tls,
- ts+3134 /* "SELECT count(*),..." */, crt.VaList(bp+200, n))
+ ts+3377 /* "SELECT count(*),..." */, libc.VaList(bp+200, n))
for i = 1; i <= n; i++ {
if ((i - 1) % g.nRepeat) == 0 {
x1 = (speedtest1_random(tls) % uint32(maxb))
@@ -4509,15 +4673,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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
n = 10
- speedtest1_begin_test(tls, 142, ts+3229 /* "%d SELECTS w/ORD..." */, crt.VaList(bp+208, n))
- speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0)
+ speedtest1_begin_test(tls, 142, ts+3472 /* "%d SELECTS w/ORD..." */, libc.VaList(bp+208, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
speedtest1_prepare(tls,
- ts+3262 /* "SELECT a, b, c F..." */, crt.VaList(bp+216, n))
+ ts+3505 /* "SELECT a, b, c F..." */, libc.VaList(bp+216, n))
for i = 1; i <= n; i++ {
if ((i - 1) % g.nRepeat) == 0 {
x1 = (speedtest1_random(tls) % uint32(maxb))
@@ -4529,15 +4693,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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
n = 10 // g.szTest/5;
- speedtest1_begin_test(tls, 145, ts+3326 /* "%d SELECTS w/ORD..." */, crt.VaList(bp+224, n))
- speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0)
+ speedtest1_begin_test(tls, 145, ts+3569 /* "%d SELECTS w/ORD..." */, libc.VaList(bp+224, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
speedtest1_prepare(tls,
- ts+3369 /* "SELECT a, b, c F..." */, crt.VaList(bp+232, n))
+ ts+3612 /* "SELECT a, b, c F..." */, libc.VaList(bp+232, n))
for i = 1; i <= n; i++ {
if ((i - 1) % g.nRepeat) == 0 {
x1 = (speedtest1_random(tls) % uint32(maxb))
@@ -4549,25 +4713,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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
- 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_begin_test(tls, 150, ts+3685 /* "CREATE INDEX fiv..." */, 0)
+ speedtest1_exec(tls, ts+3709 /* "BEGIN;" */, 0)
+ speedtest1_exec(tls, ts+3716 /* "CREATE UNIQUE IN..." */, 0)
+ speedtest1_exec(tls, ts+3750 /* "CREATE INDEX t1c..." */, 0)
+ speedtest1_exec(tls, ts+3777 /* "CREATE UNIQUE IN..." */, 0)
+ speedtest1_exec(tls, ts+3811 /* "CREATE INDEX t2c..." */, 0)
+ speedtest1_exec(tls, ts+3843 /* "CREATE INDEX t3b..." */, 0)
+ speedtest1_exec(tls, ts+3873 /* "COMMIT;" */, 0)
speedtest1_end_test(tls)
n = (sz / 5)
- speedtest1_begin_test(tls, 160, ts+3638 /* "%d SELECTS, nume..." */, crt.VaList(bp+240, n))
- speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0)
+ speedtest1_begin_test(tls, 160, ts+3881 /* "%d SELECTS, nume..." */, libc.VaList(bp+240, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
speedtest1_prepare(tls,
- ts+3675 /* "SELECT count(*),..." */, crt.VaList(bp+248, n))
+ ts+3918 /* "SELECT count(*),..." */, libc.VaList(bp+248, n))
for i = 1; i <= n; i++ {
if ((i - 1) % g.nRepeat) == 0 {
x1 = (speedtest1_random(tls) % uint32(maxb))
@@ -4577,15 +4741,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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
n = (sz / 5)
- speedtest1_begin_test(tls, 161, ts+3780 /* "%d SELECTS, nume..." */, crt.VaList(bp+256, n))
- speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0)
+ speedtest1_begin_test(tls, 161, ts+4023 /* "%d SELECTS, nume..." */, libc.VaList(bp+256, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
speedtest1_prepare(tls,
- ts+3812 /* "SELECT count(*),..." */, crt.VaList(bp+264, n))
+ ts+4055 /* "SELECT count(*),..." */, libc.VaList(bp+264, n))
for i = 1; i <= n; i++ {
if ((i - 1) % g.nRepeat) == 0 {
x1 = (speedtest1_random(tls) % uint32(maxb))
@@ -4595,15 +4759,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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
n = (sz / 5)
- speedtest1_begin_test(tls, 170, ts+3917 /* "%d SELECTS, text..." */, crt.VaList(bp+272, n))
- speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0)
+ speedtest1_begin_test(tls, 170, ts+4160 /* "%d SELECTS, text..." */, libc.VaList(bp+272, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
speedtest1_prepare(tls,
- ts+3951 /* "SELECT count(*),..." */, crt.VaList(bp+280, n))
+ ts+4194 /* "SELECT count(*),..." */, libc.VaList(bp+280, n))
for i = 1; i <= n; i++ {
if ((i - 1) % g.nRepeat) == 0 {
x1 = swizzle(tls, uint32(i), uint32(maxb))
@@ -4612,42 +4776,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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
n = sz
- speedtest1_begin_test(tls, 180, ts+4063 /* "%d INSERTS with ..." */, crt.VaList(bp+288, n))
- speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0)
+ speedtest1_begin_test(tls, 180, ts+4306 /* "%d INSERTS with ..." */, libc.VaList(bp+288, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
speedtest1_exec(tls,
- 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+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)
+ ts+4336, /* "CREATE%s TABLE t..." */
+ libc.VaList(bp+296, isTemp(tls, 1), g.zNN, g.zPK, g.zNN, g.zNN, g.zWR))
+ speedtest1_exec(tls, ts+4407 /* "CREATE INDEX t4b..." */, 0)
+ speedtest1_exec(tls, ts+4433 /* "CREATE INDEX t4c..." */, 0)
+ speedtest1_exec(tls, ts+4459 /* "INSERT INTO t4 S..." */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
n = sz
- 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_begin_test(tls, 190, ts+4491 /* "DELETE and REFIL..." */, libc.VaList(bp+344, n))
+ speedtest1_exec(tls, ts+4519 /* "DELETE FROM t2;" */, 0)
+ speedtest1_exec(tls, ts+4535 /* "INSERT INTO t2 S..." */, 0)
speedtest1_end_test(tls)
- speedtest1_begin_test(tls, 200, ts+4325 /* "VACUUM" */, 0)
- speedtest1_exec(tls, ts+4325 /* "VACUUM" */, 0)
+ speedtest1_begin_test(tls, 200, ts+4568 /* "VACUUM" */, 0)
+ speedtest1_exec(tls, ts+4568 /* "VACUUM" */, 0)
speedtest1_end_test(tls)
- 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_begin_test(tls, 210, ts+4575 /* "ALTER TABLE ADD ..." */, 0)
+ speedtest1_exec(tls, ts+4609 /* "ALTER TABLE t2 A..." */, 0)
+ speedtest1_exec(tls, ts+4649 /* "SELECT sum(d) FR..." */, 0)
speedtest1_end_test(tls)
n = (sz / 5)
- speedtest1_begin_test(tls, 230, ts+4428 /* "%d UPDATES, nume..." */, crt.VaList(bp+352, n))
- speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0)
+ speedtest1_begin_test(tls, 230, ts+4671 /* "%d UPDATES, nume..." */, libc.VaList(bp+352, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
speedtest1_prepare(tls,
- ts+4465 /* "UPDATE t2 SET d=..." */, crt.VaList(bp+360, n))
+ ts+4708 /* "UPDATE t2 SET d=..." */, libc.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)
@@ -4655,35 +4819,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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
n = sz
- speedtest1_begin_test(tls, 240, ts+4524 /* "%d UPDATES of in..." */, crt.VaList(bp+368, n))
- speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0)
+ speedtest1_begin_test(tls, 240, ts+4767 /* "%d UPDATES of in..." */, libc.VaList(bp+368, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
speedtest1_prepare(tls,
- ts+4554 /* "UPDATE t2 SET d=..." */, crt.VaList(bp+376, n))
+ ts+4797 /* "UPDATE t2 SET d=..." */, libc.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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
- 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_begin_test(tls, 250, ts+4841 /* "One big UPDATE o..." */, libc.VaList(bp+384, sz))
+ speedtest1_exec(tls, ts+4882 /* "UPDATE t2 SET d=..." */, 0)
speedtest1_end_test(tls)
- speedtest1_begin_test(tls, 260, ts+4659 /* "Query added colu..." */, 0)
- speedtest1_exec(tls, ts+4406 /* "SELECT sum(d) FR..." */, 0)
+ speedtest1_begin_test(tls, 260, ts+4902 /* "Query added colu..." */, 0)
+ speedtest1_exec(tls, ts+4649 /* "SELECT sum(d) FR..." */, 0)
speedtest1_end_test(tls)
n = (sz / 5)
- speedtest1_begin_test(tls, 270, ts+4692 /* "%d DELETEs, nume..." */, crt.VaList(bp+392, n))
- speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0)
+ speedtest1_begin_test(tls, 270, ts+4935 /* "%d DELETEs, nume..." */, libc.VaList(bp+392, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
speedtest1_prepare(tls,
- ts+4729 /* "DELETE FROM t2 W..." */, crt.VaList(bp+400, n))
+ ts+4972 /* "DELETE FROM t2 W..." */, libc.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)
@@ -4691,41 +4855,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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
n = sz
- speedtest1_begin_test(tls, 280, ts+4783 /* "%d DELETEs of in..." */, crt.VaList(bp+408, n))
- speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0)
+ speedtest1_begin_test(tls, 280, ts+5026 /* "%d DELETEs of in..." */, libc.VaList(bp+408, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
speedtest1_prepare(tls,
- ts+4813 /* "DELETE FROM t3 W..." */, crt.VaList(bp+416, n))
+ ts+5056 /* "DELETE FROM t3 W..." */, libc.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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
- 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_begin_test(tls, 290, ts+5095 /* "Refill two %d-ro..." */, libc.VaList(bp+424, sz))
+ speedtest1_exec(tls, ts+5134 /* "REPLACE INTO t2(..." */, 0)
+ speedtest1_exec(tls, ts+5178 /* "REPLACE INTO t3(..." */, 0)
speedtest1_end_test(tls)
- 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_begin_test(tls, 300, ts+5222 /* "Refill a %d-row ..." */, libc.VaList(bp+432, sz))
+ speedtest1_exec(tls, ts+4519 /* "DELETE FROM t2;" */, 0)
speedtest1_exec(tls,
- ts+5020 /* "INSERT INTO t2(a..." */, 0)
+ ts+5263 /* "INSERT INTO t2(a..." */, 0)
speedtest1_exec(tls,
- ts+5085 /* "INSERT INTO t2(a..." */, 0)
+ ts+5328 /* "INSERT INTO t2(a..." */, 0)
speedtest1_end_test(tls)
n = (sz / 5)
- speedtest1_begin_test(tls, 310, ts+5150 /* "%d four-ways joi..." */, crt.VaList(bp+440, n))
- speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0)
+ speedtest1_begin_test(tls, 310, ts+5393 /* "%d four-ways joi..." */, libc.VaList(bp+440, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
speedtest1_prepare(tls,
- ts+5169 /* "SELECT t1.c FROM..." */, 0)
+ ts+5412 /* "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))
@@ -4733,25 +4897,25 @@ 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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
- speedtest1_begin_test(tls, 320, ts+5282 /* "subquery in resu..." */, crt.VaList(bp+448, n))
+ speedtest1_begin_test(tls, 320, ts+5525 /* "subquery in resu..." */, libc.VaList(bp+448, n))
speedtest1_prepare(tls,
- ts+5305 /* "SELECT sum(a), m..." */, 0)
+ ts+5548 /* "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)
- sz = crt.AssignInt32(&n, (g.szTest * 700))
+ sz = libc.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+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+5496 /* "REPLACE INTO t5 ..." */, crt.VaList(bp+480, n))
+ speedtest1_begin_test(tls, 400, ts+5666 /* "%d REPLACE ops o..." */, libc.VaList(bp+456, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
+ speedtest1_exec(tls, ts+5691, /* "CREATE%s TABLE t..." */
+ libc.VaList(bp+464, isTemp(tls, 9), g.zNN))
+ speedtest1_prepare(tls, ts+5739 /* "REPLACE INTO t5 ..." */, libc.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{})))
@@ -4759,10 +4923,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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
- 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))
+ speedtest1_begin_test(tls, 410, ts+5783 /* "%d SELECTS on an..." */, libc.VaList(bp+488, n))
+ speedtest1_prepare(tls, ts+5804 /* "SELECT b FROM t5..." */, libc.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)))
@@ -4770,20 +4934,20 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */
}
speedtest1_end_test(tls)
- sz = crt.AssignInt32(&n, (g.szTest * 700))
+ sz = libc.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+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,
+ speedtest1_begin_test(tls, 500, ts+5846 /* "%d REPLACE on TE..." */, libc.VaList(bp+504, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
+ speedtest1_exec(tls, ts+5868, /* "CREATE%s TABLE t..." */
+ libc.VaList(bp+512, isTemp(tls, 9), g.zNN,
func() uintptr {
if sqlite3.Xsqlite3_libversion_number(tls) >= 3008002 {
- return ts + 5672 /* "WITHOUT ROWID" */
+ return ts + 5915 /* "WITHOUT ROWID" */
}
- return ts + 1988 /* "" */
+ return ts + 2152 /* "" */
}()))
- speedtest1_prepare(tls, ts+5686 /* "REPLACE INTO t6 ..." */, crt.VaList(bp+536, n))
+ speedtest1_prepare(tls, ts+5929 /* "REPLACE INTO t6 ..." */, libc.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{})))
@@ -4791,10 +4955,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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
- 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))
+ speedtest1_begin_test(tls, 510, ts+5973 /* "%d SELECTS on a ..." */, libc.VaList(bp+544, n))
+ speedtest1_prepare(tls, ts+5997 /* "SELECT b FROM t6..." */, libc.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{})))
@@ -4802,23 +4966,23 @@ func testset_main(tls *crt.TLS) { /* speedtest1.c:525:6: */
speedtest1_run(tls)
}
speedtest1_end_test(tls)
- 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_begin_test(tls, 520, ts+6039 /* "%d SELECT DISTIN..." */, libc.VaList(bp+560, n))
+ speedtest1_exec(tls, ts+6058 /* "SELECT DISTINCT ..." */, 0)
+ speedtest1_exec(tls, ts+6085 /* "SELECT DISTINCT ..." */, 0)
speedtest1_end_test(tls)
- speedtest1_begin_test(tls, 980, ts+5869 /* "PRAGMA integrity..." */, 0)
- speedtest1_exec(tls, ts+5869 /* "PRAGMA integrity..." */, 0)
+ speedtest1_begin_test(tls, 980, ts+6112 /* "PRAGMA integrity..." */, 0)
+ speedtest1_exec(tls, ts+6112 /* "PRAGMA integrity..." */, 0)
speedtest1_end_test(tls)
- speedtest1_begin_test(tls, 990, ts+5892 /* "ANALYZE" */, 0)
- speedtest1_exec(tls, ts+5892 /* "ANALYZE" */, 0)
+ speedtest1_begin_test(tls, 990, ts+6135 /* "ANALYZE" */, 0)
+ speedtest1_exec(tls, ts+6135 /* "ANALYZE" */, 0)
speedtest1_end_test(tls)
}
// A testset for common table expressions. This exercises code
// for views, subqueries, co-routines, etc.
-func testset_cte(tls *crt.TLS) { /* speedtest1.c:975:6: */
+func testset_cte(tls *libc.TLS) { /* speedtest1.c:1144:6: */
bp := tls.Alloc(32)
defer tls.Free(32)
@@ -4833,38 +4997,38 @@ func testset_cte(tls *crt.TLS) { /* speedtest1.c:975:6: */
} else {
zPuz = azPuzzle[2]
}
- speedtest1_begin_test(tls, 100, ts+5900 /* "Sudoku with recu..." */, 0)
+ speedtest1_begin_test(tls, 100, ts+6143 /* "Sudoku with recu..." */, 0)
speedtest1_prepare(tls,
- ts+5931 /* "WITH RECURSIVE\n ..." */, 0)
+ ts+6174 /* "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+6735 /* "Sudoku with VALU..." */, 0)
+ speedtest1_begin_test(tls, 200, ts+6978 /* "Sudoku with VALU..." */, 0)
speedtest1_prepare(tls,
- ts+6763 /* "WITH RECURSIVE\n ..." */, 0)
+ ts+7006 /* "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+7575 /* "Mandelbrot Set w..." */, crt.VaList(bp, rSpacing))
+ speedtest1_begin_test(tls, 300, ts+7818 /* "Mandelbrot Set w..." */, libc.VaList(bp, rSpacing))
speedtest1_prepare(tls,
- ts+7606 /* "WITH RECURSIVE \n..." */, 0)
+ ts+7849 /* "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+8202 /* "EXCEPT operator ..." */, crt.VaList(bp+8, nElem))
+ speedtest1_begin_test(tls, 400, ts+8445 /* "EXCEPT operator ..." */, libc.VaList(bp+8, nElem))
speedtest1_prepare(tls,
- ts+8239, /* "WITH RECURSIVE \n..." */
- crt.VaList(bp+16, nElem, nElem))
+ ts+8482, /* "WITH RECURSIVE \n..." */
+ libc.VaList(bp+16, nElem, nElem))
speedtest1_run(tls)
speedtest1_end_test(tls)
}
@@ -4872,19 +5036,19 @@ func testset_cte(tls *crt.TLS) { /* speedtest1.c:975:6: */
var azPuzzle = [3]uintptr{
// Easy
- ts + 8470, /* "534...9..67.195...." */
+ ts + 8713, /* "534...9..67.195...." */
// Medium
- ts + 8552, /* "53....9..6..195...." */
+ ts + 8795, /* "53....9..6..195...." */
// Hard
- ts + 8634, /* "53.......6..195...." */
-} /* speedtest1.c:976:21 */
+ ts + 8877, /* "53.......6..195...." */
+} /* speedtest1.c:1145:21 */
// Compute a pseudo-random floating point ascii number.
-func speedtest1_random_ascii_fp(tls *crt.TLS, zFP uintptr) { /* speedtest1.c:1128:6: */
+func speedtest1_random_ascii_fp(tls *libc.TLS, zFP uintptr) { /* speedtest1.c:1297:6: */
bp := tls.Alloc(24)
defer tls.Free(24)
@@ -4896,11 +5060,11 @@ 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+8716 /* "%d.%de%d" */, crt.VaList(bp, y, z, (x%200)))
+ sqlite3.Xsqlite3_snprintf(tls, 100, zFP, ts+8959 /* "%d.%de%d" */, libc.VaList(bp, y, z, (x%200)))
}
// A testset for floating-point numbers.
-func testset_fp(tls *crt.TLS) { /* speedtest1.c:1141:6: */
+func testset_fp(tls *libc.TLS) { /* speedtest1.c:1310:6: */
bp := tls.Alloc(272)
defer tls.Free(272)
@@ -4911,11 +5075,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+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+8797 /* "INSERT INTO t1 V..." */, crt.VaList(bp+32, n))
+ speedtest1_begin_test(tls, 100, ts+8968 /* "Fill a table wit..." */, libc.VaList(bp, (n*2)))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
+ speedtest1_exec(tls, ts+8999, /* "CREATE%s TABLE t..." */
+ libc.VaList(bp+8, isTemp(tls, 1), g.zNN, g.zNN))
+ speedtest1_prepare(tls, ts+9040 /* "INSERT INTO t1 V..." */, libc.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] */)
@@ -4923,12 +5087,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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
n = ((g.szTest / 25) + 2)
- 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)
+ speedtest1_begin_test(tls, 110, ts+9082 /* "%d range queries" */, libc.VaList(bp+40, n))
+ speedtest1_prepare(tls, ts+9099 /* "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] */)
@@ -4938,17 +5102,17 @@ func testset_fp(tls *crt.TLS) { /* speedtest1.c:1141:6: */
}
speedtest1_end_test(tls)
- 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_begin_test(tls, 120, ts+9147 /* "CREATE INDEX thr..." */, 0)
+ speedtest1_exec(tls, ts+3709 /* "BEGIN;" */, 0)
+ speedtest1_exec(tls, ts+9172 /* "CREATE INDEX t1a..." */, 0)
+ speedtest1_exec(tls, ts+9199 /* "CREATE INDEX t1b..." */, 0)
+ speedtest1_exec(tls, ts+9226 /* "CREATE INDEX t1a..." */, 0)
+ speedtest1_exec(tls, ts+3873 /* "COMMIT;" */, 0)
speedtest1_end_test(tls)
n = ((g.szTest / 3) + 2)
- 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)
+ speedtest1_begin_test(tls, 130, ts+9256 /* "%d indexed range..." */, libc.VaList(bp+48, n))
+ speedtest1_prepare(tls, ts+9099 /* "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] */)
@@ -4959,20 +5123,253 @@ func testset_fp(tls *crt.TLS) { /* speedtest1.c:1141:6: */
speedtest1_end_test(tls)
n = (g.szTest * 5000)
- 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_begin_test(tls, 140, ts+9281 /* "%d calls to roun..." */, libc.VaList(bp+56, n))
+ speedtest1_exec(tls, ts+9301 /* "SELECT sum(round..." */, 0)
speedtest1_end_test(tls)
- speedtest1_begin_test(tls, 150, ts+9101 /* "%d printf() call..." */, crt.VaList(bp+64, (n*4)))
+ speedtest1_begin_test(tls, 150, ts+9344 /* "%d printf() call..." */, libc.VaList(bp+64, (n*4)))
speedtest1_exec(tls,
- ts+9119 /* "WITH c(fmt) AS (..." */, 0)
+ ts+9362 /* "WITH c(fmt) AS (..." */, 0)
+ speedtest1_end_test(tls)
+}
+
+// Generate two numbers between 1 and mx. The first number is less than
+// the second. Usually the numbers are near each other but can sometimes
+// be far apart.
+func twoCoords(tls *libc.TLS, p1 int32, p2 int32, mx uint32, pX0 uintptr, pX1 uintptr) { /* speedtest1.c:1383:13: */
+ var d uint32
+ var x0 uint32
+ var x1 uint32
+ var span uint32
+
+ span = ((mx / uint32(100)) + uint32(1))
+ if (speedtest1_random(tls) % uint32(3)) == uint32(0) {
+ span = span * (uint32(p1))
+ }
+ if (speedtest1_random(tls) % uint32(p2)) == uint32(0) {
+ span = (mx / uint32(2))
+ }
+ d = ((speedtest1_random(tls) % span) + uint32(1))
+ x0 = ((speedtest1_random(tls) % (mx - d)) + uint32(1))
+ x1 = (x0 + d)
+ *(*uint32)(unsafe.Pointer(pX0)) = x0
+ *(*uint32)(unsafe.Pointer(pX1)) = x1
+}
+
+// The following routine is an R-Tree geometry callback. It returns
+// true if the object overlaps a slice on the Y coordinate between the
+// two values given as arguments. In other words
+//
+// SELECT count(*) FROM rt1 WHERE id MATCH xslice(10,20);
+//
+// Is the same as saying:
+//
+// SELECT count(*) FROM rt1 WHERE y1>=10 AND y0<=20;
+func xsliceGeometryCallback(tls *libc.TLS, p uintptr, nCoord int32, aCoord uintptr, pRes uintptr) int32 { /* speedtest1.c:1412:12: */
+ *(*int32)(unsafe.Pointer(pRes)) = (libc.Bool32((*(*float64)(unsafe.Pointer(aCoord + uintptr(3)*8)) >= *(*sqlite3_rtree_dbl)(unsafe.Pointer((*sqlite3_rtree_geometry)(unsafe.Pointer(p)).aParam + uintptr(0)*8))) && (*(*float64)(unsafe.Pointer(aCoord + uintptr(2)*8)) <= *(*sqlite3_rtree_dbl)(unsafe.Pointer((*sqlite3_rtree_geometry)(unsafe.Pointer(p)).aParam + uintptr(1)*8)))))
+ return 0
+}
+
+// A testset for the R-Tree virtual table
+func testset_rtree(tls *libc.TLS, p1 int32, p2 int32) { /* speedtest1.c:1427:6: */
+ bp := tls.Alloc(224)
+ defer tls.Free(224)
+
+ var i uint32
+ var n uint32
+ var mxCoord uint32
+ // var x0 uint32 at bp+200, 4
+
+ // var x1 uint32 at bp+204, 4
+
+ // var y0 uint32 at bp+208, 4
+
+ // var y1 uint32 at bp+212, 4
+
+ // var z0 uint32 at bp+216, 4
+
+ // var z1 uint32 at bp+220, 4
+
+ var iStep uint32
+ var mxRowid uint32
+ var aCheck uintptr = sqlite3.Xsqlite3_malloc(tls, (int32((uint64(unsafe.Sizeof(int32(0))) * uint64(g.szTest)) * uint64(500))))
+
+ mxCoord = uint32(15000)
+ mxRowid = libc.AssignUint32(&n, (uint32(g.szTest * 500)))
+ speedtest1_begin_test(tls, 100, ts+9457 /* "%d INSERTs into ..." */, libc.VaList(bp, n))
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
+ speedtest1_exec(tls, ts+9483 /* "CREATE VIRTUAL T..." */, 0)
+ speedtest1_prepare(tls,
+ ts+9542 /* "INSERT INTO rt1(..." */, 0)
+ for i = uint32(1); i <= n; i++ {
+ twoCoords(tls, p1, p2, mxCoord, bp+200 /* &x0 */, bp+204 /* &x1 */)
+ twoCoords(tls, p1, p2, mxCoord, bp+208 /* &y0 */, bp+212 /* &y1 */)
+ twoCoords(tls, p1, p2, mxCoord, bp+216 /* &z0 */, bp+220 /* &z1 */)
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, int32(i))
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 2, int32(*(*uint32)(unsafe.Pointer(bp + 200 /* x0 */))))
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 3, int32(*(*uint32)(unsafe.Pointer(bp + 204 /* x1 */))))
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 4, int32(*(*uint32)(unsafe.Pointer(bp + 208 /* y0 */))))
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 5, int32(*(*uint32)(unsafe.Pointer(bp + 212 /* y1 */))))
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 6, int32(*(*uint32)(unsafe.Pointer(bp + 216 /* z0 */))))
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 7, int32(*(*uint32)(unsafe.Pointer(bp + 220 /* z1 */))))
+ speedtest1_run(tls)
+ }
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
+ speedtest1_end_test(tls)
+
+ speedtest1_begin_test(tls, 101, ts+9608 /* "Copy from rtree ..." */, 0)
+ speedtest1_exec(tls, ts+9643 /* "CREATE TABLE t1(..." */, 0)
+ speedtest1_exec(tls, ts+9701 /* "INSERT INTO t1 S..." */, 0)
+ speedtest1_end_test(tls)
+
+ n = (uint32(g.szTest * 200))
+ speedtest1_begin_test(tls, 110, ts+9734 /* "%d one-dimension..." */, libc.VaList(bp+8, n))
+ speedtest1_prepare(tls, ts+9777 /* "SELECT count(*) ..." */, 0)
+ iStep = (mxCoord / n)
+ for i = uint32(0); i < n; i++ {
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (int32(i * iStep)))
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 2, (int32((i + uint32(1)) * iStep)))
+ speedtest1_run(tls)
+ *(*int32)(unsafe.Pointer(aCheck + uintptr(i)*4)) = libc.Xatoi(tls, uintptr(unsafe.Pointer(&g))+116 /* &.zResult */)
+ }
+ speedtest1_end_test(tls)
+
+ if g.bVerify != 0 {
+ n = (uint32(g.szTest * 200))
+ speedtest1_begin_test(tls, 111, ts+9826 /* "Verify result fr..." */, 0)
+ speedtest1_prepare(tls, ts+9873 /* "SELECT count(*) ..." */, 0)
+ iStep = (mxCoord / n)
+ for i = uint32(0); i < n; i++ {
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (int32(i * iStep)))
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 2, (int32((i + uint32(1)) * iStep)))
+ speedtest1_run(tls)
+ if *(*int32)(unsafe.Pointer(aCheck + uintptr(i)*4)) != libc.Xatoi(tls, uintptr(unsafe.Pointer(&g))+116 /* &.zResult */) {
+ fatal_error(tls, ts+9921, /* "Count disagree s..." */
+ libc.VaList(bp+16, i, (i*iStep), ((i+uint32(1))*iStep), *(*int32)(unsafe.Pointer(aCheck + uintptr(i)*4)), libc.Xatoi(tls, uintptr(unsafe.Pointer(&g))+116 /* &.zResult */)))
+ }
+ }
+ speedtest1_end_test(tls)
+ }
+
+ n = (uint32(g.szTest * 200))
+ speedtest1_begin_test(tls, 120, ts+9963 /* "%d one-dimension..." */, libc.VaList(bp+56, n))
+ speedtest1_prepare(tls, ts+10004 /* "SELECT count(*) ..." */, 0)
+ iStep = (mxCoord / n)
+ for i = uint32(0); i < n; i++ {
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (int32(i * iStep)))
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 2, (int32((i + uint32(1)) * iStep)))
+ speedtest1_run(tls)
+ *(*int32)(unsafe.Pointer(aCheck + uintptr(i)*4)) = libc.Xatoi(tls, uintptr(unsafe.Pointer(&g))+116 /* &.zResult */)
+ }
+ speedtest1_end_test(tls)
+
+ if g.bVerify != 0 {
+ n = (uint32(g.szTest * 200))
+ speedtest1_begin_test(tls, 121, ts+10053 /* "Verify result fr..." */, 0)
+ speedtest1_prepare(tls, ts+10098 /* "SELECT count(*) ..." */, 0)
+ iStep = (mxCoord / n)
+ for i = uint32(0); i < n; i++ {
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (int32(i * iStep)))
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 2, (int32((i + uint32(1)) * iStep)))
+ speedtest1_run(tls)
+ if *(*int32)(unsafe.Pointer(aCheck + uintptr(i)*4)) != libc.Xatoi(tls, uintptr(unsafe.Pointer(&g))+116 /* &.zResult */) {
+ fatal_error(tls, ts+9921, /* "Count disagree s..." */
+ libc.VaList(bp+64, i, (i*iStep), ((i+uint32(1))*iStep), *(*int32)(unsafe.Pointer(aCheck + uintptr(i)*4)), libc.Xatoi(tls, uintptr(unsafe.Pointer(&g))+116 /* &.zResult */)))
+ }
+ }
+ speedtest1_end_test(tls)
+ }
+
+ n = (uint32(g.szTest * 200))
+ speedtest1_begin_test(tls, 125, ts+10146 /* "%d custom geomet..." */, libc.VaList(bp+104, n))
+ sqlite3.Xsqlite3_rtree_geometry_callback(tls, g.db, ts+10182 /* "xslice" */, *(*uintptr)(unsafe.Pointer(&struct {
+ f func(*libc.TLS, uintptr, int32, uintptr, uintptr) int32
+ }{xsliceGeometryCallback})), uintptr(0))
+ speedtest1_prepare(tls, ts+10189 /* "SELECT count(*) ..." */, 0)
+ iStep = (mxCoord / n)
+ for i = uint32(0); i < n; i++ {
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (int32(i * iStep)))
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 2, (int32((i + uint32(1)) * iStep)))
+ speedtest1_run(tls)
+ if *(*int32)(unsafe.Pointer(aCheck + uintptr(i)*4)) != libc.Xatoi(tls, uintptr(unsafe.Pointer(&g))+116 /* &.zResult */) {
+ fatal_error(tls, ts+9921, /* "Count disagree s..." */
+ libc.VaList(bp+112, i, (i*iStep), ((i+uint32(1))*iStep), *(*int32)(unsafe.Pointer(aCheck + uintptr(i)*4)), libc.Xatoi(tls, uintptr(unsafe.Pointer(&g))+116 /* &.zResult */)))
+ }
+ }
+ speedtest1_end_test(tls)
+
+ n = (uint32(g.szTest * 400))
+ speedtest1_begin_test(tls, 130, ts+10243 /* "%d three-dimensi..." */, libc.VaList(bp+152, n))
+ speedtest1_prepare(tls,
+ ts+10286 /* "SELECT count(*) ..." */, 0)
+ iStep = (mxCoord / n)
+ for i = uint32(0); i < n; i++ {
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (int32(i * iStep)))
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 2, (int32((i + uint32(1)) * iStep)))
+ speedtest1_run(tls)
+ *(*int32)(unsafe.Pointer(aCheck + uintptr(i)*4)) = libc.Xatoi(tls, uintptr(unsafe.Pointer(&g))+116 /* &.zResult */)
+ }
+ speedtest1_end_test(tls)
+
+ n = (uint32(g.szTest * 500))
+ speedtest1_begin_test(tls, 140, ts+10379 /* "%d rowid queries" */, libc.VaList(bp+160, n))
+ speedtest1_prepare(tls, ts+10396 /* "SELECT * FROM rt..." */, 0)
+ for i = uint32(1); i <= n; i++ {
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, int32(i))
+ speedtest1_run(tls)
+ }
+ speedtest1_end_test(tls)
+
+ n = (uint32(g.szTest * 50))
+ speedtest1_begin_test(tls, 150, ts+10426 /* "%d UPDATEs using..." */, libc.VaList(bp+168, n))
+ speedtest1_prepare(tls, ts+10449 /* "UPDATE rt1 SET x..." */, 0)
+ for i = uint32(1); i <= n; i++ {
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (int32(((i * uint32(251)) % mxRowid) + uint32(1))))
+ speedtest1_run(tls)
+ }
+ speedtest1_end_test(tls)
+
+ n = (uint32(g.szTest * 5))
+ speedtest1_begin_test(tls, 155, ts+10497 /* "%d UPDATEs using..." */, libc.VaList(bp+176, n))
+ speedtest1_prepare(tls,
+ ts+10538 /* "UPDATE rt1 SET x..." */, 0)
+ iStep = (mxCoord / n)
+ for i = uint32(0); i < n; i++ {
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (int32(i * iStep)))
+ speedtest1_run(tls)
+ *(*int32)(unsafe.Pointer(aCheck + uintptr(i)*4)) = libc.Xatoi(tls, uintptr(unsafe.Pointer(&g))+116 /* &.zResult */)
+ }
+ speedtest1_end_test(tls)
+
+ n = (uint32(g.szTest * 50))
+ speedtest1_begin_test(tls, 160, ts+10600 /* "%d DELETEs using..." */, libc.VaList(bp+184, n))
+ speedtest1_prepare(tls, ts+10623 /* "DELETE FROM rt1 ..." */, 0)
+ for i = uint32(1); i <= n; i++ {
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (int32(((i * uint32(257)) % mxRowid) + uint32(1))))
+ speedtest1_run(tls)
+ }
+ speedtest1_end_test(tls)
+
+ n = (uint32(g.szTest * 5))
+ speedtest1_begin_test(tls, 165, ts+10651 /* "%d DELETEs using..." */, libc.VaList(bp+192, n))
+ speedtest1_prepare(tls, ts+10692 /* "DELETE FROM rt1 ..." */, 0)
+ iStep = (mxCoord / n)
+ for i = uint32(0); i < n; i++ {
+ sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (int32(i * iStep)))
+ speedtest1_run(tls)
+ *(*int32)(unsafe.Pointer(aCheck + uintptr(i)*4)) = libc.Xatoi(tls, uintptr(unsafe.Pointer(&g))+116 /* &.zResult */)
+ }
+ speedtest1_end_test(tls)
+
+ speedtest1_begin_test(tls, 170, ts+10734 /* "Restore deleted ..." */, 0)
+ speedtest1_exec(tls, ts+10781 /* "INSERT OR IGNORE..." */, 0)
speedtest1_end_test(tls)
}
// A testset that does key/value storage on tables with many columns.
// This is the kind of workload generated by ORMs such as CoreData.
-func testset_orm(tls *crt.TLS) { /* speedtest1.c:1443:6: */
+func testset_orm(tls *libc.TLS) { /* speedtest1.c:1612:6: */
bp := tls.Alloc(2016)
defer tls.Free(2016)
@@ -4984,18 +5381,18 @@ func testset_orm(tls *crt.TLS) { /* speedtest1.c:1443:6: */
var len uint32
// var zNum [2000]int8 at bp+16, 2000
- nRow = crt.AssignUint32(&n, (uint32(g.szTest * 250)))
- speedtest1_begin_test(tls, 100, ts+9214 /* "Fill %d rows" */, crt.VaList(bp, n))
+ nRow = libc.AssignUint32(&n, (uint32(g.szTest * 250)))
+ speedtest1_begin_test(tls, 100, ts+10824 /* "Fill %d rows" */, libc.VaList(bp, n))
speedtest1_exec(tls,
- ts+9227 /* "BEGIN;CREATE TAB..." */, 0)
+ ts+10837 /* "BEGIN;CREATE TAB..." */, 0)
speedtest1_prepare(tls,
- ts+13127 /* "INSERT INTO ZLOO..." */, 0)
+ ts+14737 /* "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{})))
- len = uint32(int32(crt.Xstrlen(tls, bp+16 /* &zNum[0] */)))
+ len = uint32(int32(libc.Xstrlen(tls, bp+16 /* &zNum[0] */)))
sqlite3.Xsqlite3_bind_int(tls, g.pStmt, 1, (int32(i ^ uint32(0xf))))
for j = uint32(0); zType[j] != 0; j++ {
switch int32(zType[j]) {
@@ -5017,14 +5414,14 @@ func testset_orm(tls *crt.TLS) { /* speedtest1.c:1443:6: */
}
speedtest1_run(tls)
}
- speedtest1_exec(tls, ts+3630 /* "COMMIT;" */, 0)
+ speedtest1_exec(tls, ts+3873 /* "COMMIT;" */, 0)
speedtest1_end_test(tls)
n = (uint32(g.szTest * 250))
- speedtest1_begin_test(tls, 110, ts+16371 /* "Query %d rows by..." */, crt.VaList(bp+8, n))
+ speedtest1_begin_test(tls, 110, ts+17981 /* "Query %d rows by..." */, libc.VaList(bp+8, n))
speedtest1_prepare(tls,
- ts+16394 /* "SELECT ZCYANBASE..." */, 0)
+ ts+18004 /* "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))
@@ -5033,10 +5430,10 @@ func testset_orm(tls *crt.TLS) { /* speedtest1.c:1443:6: */
speedtest1_end_test(tls)
}
-var zType = *(*[120]int8)(unsafe.Pointer(ts + 19147 /* "IBBIIITIVVITBTBF..." */)) /* speedtest1.c:1448:21 */
+var zType = *(*[120]int8)(unsafe.Pointer(ts + 20757 /* "IBBIIITIVVITBTBF..." */)) /* speedtest1.c:1617:21 */
//
-func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */
+func testset_trigger(tls *libc.TLS) { /* speedtest1.c:1879:6: */
bp := tls.Alloc(2032)
defer tls.Free(2032)
@@ -5050,9 +5447,9 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */
speedtest1_exec(tls,
- ts+19267 /* "BEGIN;CREATE TAB..." */, 0)
+ ts+20877 /* "BEGIN;CREATE TAB..." */, 0)
for jj = 1; jj <= 3; jj++ {
- speedtest1_prepare(tls, ts+19595 /* "INSERT INTO t%d ..." */, crt.VaList(bp, jj))
+ speedtest1_prepare(tls, ts+21205 /* "INSERT INTO t%d ..." */, libc.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{})))
@@ -5063,23 +5460,23 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */
}
speedtest1_exec(tls,
- ts+19630 /* "CREATE INDEX i1 ..." */, 0)
+ ts+21240 /* "CREATE INDEX i1 ..." */, 0)
- speedtest1_begin_test(tls, 100, ts+19713 /* "speed4p-join1" */, 0)
+ speedtest1_begin_test(tls, 100, ts+21323 /* "speed4p-join1" */, 0)
speedtest1_prepare(tls,
- ts+19727 /* "SELECT * FROM t1..." */, 0)
+ ts+21337 /* "SELECT * FROM t1..." */, 0)
speedtest1_run(tls)
speedtest1_end_test(tls)
- speedtest1_begin_test(tls, 110, ts+19794 /* "speed4p-join2" */, 0)
+ speedtest1_begin_test(tls, 110, ts+21404 /* "speed4p-join2" */, 0)
speedtest1_prepare(tls,
- ts+19808 /* "SELECT * FROM t1..." */, 0)
+ ts+21418 /* "SELECT * FROM t1..." */, 0)
speedtest1_run(tls)
speedtest1_end_test(tls)
- speedtest1_begin_test(tls, 120, ts+19867 /* "speed4p-view1" */, 0)
+ speedtest1_begin_test(tls, 120, ts+21477 /* "speed4p-view1" */, 0)
for jj = 1; jj <= 3; jj++ {
- speedtest1_prepare(tls, ts+19881 /* "SELECT * FROM v%..." */, crt.VaList(bp+8, jj))
+ speedtest1_prepare(tls, ts+21491 /* "SELECT * FROM v%..." */, libc.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)
@@ -5087,9 +5484,9 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */
}
speedtest1_end_test(tls)
- speedtest1_begin_test(tls, 130, ts+19915 /* "speed4p-table1" */, 0)
+ speedtest1_begin_test(tls, 130, ts+21525 /* "speed4p-table1" */, 0)
for jj = 1; jj <= 3; jj++ {
- speedtest1_prepare(tls, ts+19930 /* "SELECT * FROM t%..." */, crt.VaList(bp+16, jj))
+ speedtest1_prepare(tls, ts+21540 /* "SELECT * FROM t%..." */, libc.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)
@@ -5097,9 +5494,9 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */
}
speedtest1_end_test(tls)
- speedtest1_begin_test(tls, 140, ts+19915 /* "speed4p-table1" */, 0)
+ speedtest1_begin_test(tls, 140, ts+21525 /* "speed4p-table1" */, 0)
for jj = 1; jj <= 3; jj++ {
- speedtest1_prepare(tls, ts+19930 /* "SELECT * FROM t%..." */, crt.VaList(bp+24, jj))
+ speedtest1_prepare(tls, ts+21540 /* "SELECT * FROM t%..." */, libc.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)
@@ -5107,37 +5504,37 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */
}
speedtest1_end_test(tls)
- speedtest1_begin_test(tls, 150, ts+19964 /* "speed4p-subselec..." */, 0)
+ speedtest1_begin_test(tls, 150, ts+21574 /* "speed4p-subselec..." */, 0)
speedtest1_prepare(tls,
- ts+19983 /* "SELECT (SELECT t..." */, 0)
+ ts+21593 /* "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+20098 /* "speed4p-rowid-up..." */, 0)
- speedtest1_exec(tls, ts+2553 /* "BEGIN" */, 0)
- speedtest1_prepare(tls, ts+20119 /* "UPDATE t1 SET i=..." */, 0)
+ speedtest1_begin_test(tls, 160, ts+21708 /* "speed4p-rowid-up..." */, 0)
+ speedtest1_exec(tls, ts+2796 /* "BEGIN" */, 0)
+ speedtest1_prepare(tls, ts+21729 /* "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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
speedtest1_end_test(tls)
- 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_exec(tls, ts+21764 /* "CREATE TABLE t5(..." */, 0)
+ speedtest1_begin_test(tls, 170, ts+21812 /* "speed4p-insert-i..." */, 0)
+ speedtest1_exec(tls, ts+21834 /* "INSERT OR IGNORE..." */, 0)
speedtest1_end_test(tls)
speedtest1_exec(tls,
- ts+20269 /* "CREATE TABLE log..." */, 0)
+ ts+21879 /* "CREATE TABLE log..." */, 0)
- speedtest1_begin_test(tls, 180, ts+20759 /* "speed4p-trigger1" */, 0)
- speedtest1_prepare(tls, ts+20776 /* "INSERT INTO t4 V..." */, 0)
+ speedtest1_begin_test(tls, 180, ts+22369 /* "speed4p-trigger1" */, 0)
+ speedtest1_prepare(tls, ts+22386 /* "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)
@@ -5149,8 +5546,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+20812 /* "speed4p-trigger2" */, 0)
- speedtest1_prepare(tls, ts+20829 /* "UPDATE t4 SET i ..." */, 0)
+ speedtest1_begin_test(tls, 190, ts+22422 /* "speed4p-trigger2" */, 0)
+ speedtest1_prepare(tls, ts+22439 /* "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))
@@ -5161,14 +5558,14 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */
speedtest1_end_test(tls)
// Note: Same again.
- speedtest1_begin_test(tls, 200, ts+20875 /* "speed4p-trigger3" */, 0)
- speedtest1_prepare(tls, ts+20892 /* "DELETE FROM t4 W..." */, 0)
+ speedtest1_begin_test(tls, 200, ts+22485 /* "speed4p-trigger3" */, 0)
+ speedtest1_prepare(tls, ts+22502 /* "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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
// The following block contains the same tests as the above block that
// tests triggers, with one crucial difference: no triggers are defined.
@@ -5176,9 +5573,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+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)
+ ts+22534 /* "DROP TABLE t4;DR..." */, 0)
+ speedtest1_begin_test(tls, 210, ts+22639 /* "speed4p-notrigge..." */, 0)
+ speedtest1_prepare(tls, ts+22386 /* "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)
@@ -5186,8 +5583,8 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */
speedtest1_run(tls)
}
speedtest1_end_test(tls)
- speedtest1_begin_test(tls, 210, ts+21048 /* "speed4p-notrigge..." */, 0)
- speedtest1_prepare(tls, ts+20829 /* "UPDATE t4 SET i ..." */, 0)
+ speedtest1_begin_test(tls, 210, ts+22658 /* "speed4p-notrigge..." */, 0)
+ speedtest1_prepare(tls, ts+22439 /* "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))
@@ -5196,18 +5593,18 @@ func testset_trigger(tls *crt.TLS) { /* speedtest1.c:1710:6: */
speedtest1_run(tls)
}
speedtest1_end_test(tls)
- speedtest1_begin_test(tls, 220, ts+21067 /* "speed4p-notrigge..." */, 0)
- speedtest1_prepare(tls, ts+20892 /* "DELETE FROM t4 W..." */, 0)
+ speedtest1_begin_test(tls, 220, ts+22677 /* "speed4p-notrigge..." */, 0)
+ speedtest1_prepare(tls, ts+22502 /* "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+2663 /* "COMMIT" */, 0)
+ speedtest1_exec(tls, ts+2906 /* "COMMIT" */, 0)
}
// A testset used for debugging speedtest1 itself.
-func testset_debug1(tls *crt.TLS) { /* speedtest1.c:1912:6: */
+func testset_debug1(tls *libc.TLS) { /* speedtest1.c:2081:6: */
bp := tls.Alloc(2032)
defer tls.Free(2032)
@@ -5223,7 +5620,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+21086 /* "%5d %5d %5d %s\n" */, crt.VaList(bp, i, x1, x2, bp+32 /* &zNum[0] */))
+ libc.Xprintf(tls, ts+22696 /* "%5d %5d %5d %s\n" */, libc.VaList(bp, i, x1, x2, bp+32 /* &zNum[0] */))
}
}
@@ -5266,58 +5663,58 @@ func testset_debug1(tls *crt.TLS) { /* speedtest1.c:1912:6: */
// POSIX Standard: 2.10 Symbolic Constants <unistd.h>
// Attempt to display I/O stats on Linux using /proc/PID/io
-func displayLinuxIoStats(tls *crt.TLS, out uintptr) { /* speedtest1.c:1933:13: */
+func displayLinuxIoStats(tls *libc.TLS, out uintptr) { /* speedtest1.c:2102:13: */
bp := tls.Alloc(224)
defer tls.Free(224)
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+21102 /* "/proc/%d/io" */, crt.VaList(bp, crt.Xgetpid(tls)))
- in = crt.Xfopen(tls, bp+24 /* &z[0] */, ts+21114 /* "rb" */)
+ sqlite3.Xsqlite3_snprintf(tls, int32(unsafe.Sizeof([200]int8{})), bp+24 /* &z[0] */, ts+22712 /* "/proc/%d/io" */, libc.VaList(bp, libc.Xgetpid(tls)))
+ in = libc.Xfopen(tls, bp+24 /* &z[0] */, ts+22724 /* "rb" */)
if in == uintptr(0) {
return
}
- for crt.Xfgets(tls, bp+24 /* &z[0] */, int32(unsafe.Sizeof([200]int8{})), in) != uintptr(0) {
+ for libc.Xfgets(tls, bp+24 /* &z[0] */, int32(unsafe.Sizeof([200]int8{})), in) != uintptr(0) {
var i int32
for i = 0; uint64(i) < (uint64(unsafe.Sizeof(aTrans)) / uint64(unsafe.Sizeof(struct {
zPattern uintptr
zDesc uintptr
}{}))); 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+21117 /* "-- %-28s %s" */, crt.VaList(bp+8, aTrans[i].zDesc, (bp+24 /* &z */ +uintptr(n))))
+ var n int32 = int32(libc.Xstrlen(tls, aTrans[i].zPattern))
+ if libc.Xstrncmp(tls, aTrans[i].zPattern, bp+24 /* &z[0] */, uint64(n)) == 0 {
+ libc.Xfprintf(tls, out, ts+22727 /* "-- %-28s %s" */, libc.VaList(bp+8, aTrans[i].zDesc, (bp+24 /* &z */ +uintptr(n))))
break
}
}
}
- crt.Xfclose(tls, in)
+ libc.Xfclose(tls, in)
}
var aTrans = [7]struct {
zPattern uintptr
zDesc uintptr
}{
- {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: */
+ {zPattern: ts + 22739 /* "rchar: " */, zDesc: ts + 22747 /* "Bytes received b..." */},
+ {zPattern: ts + 22773 /* "wchar: " */, zDesc: ts + 22781 /* "Bytes sent to wr..." */},
+ {zPattern: ts + 22804 /* "syscr: " */, zDesc: ts + 22812 /* "Read() system ca..." */},
+ {zPattern: ts + 22833 /* "syscw: " */, zDesc: ts + 22841 /* "Write() system c..." */},
+ {zPattern: ts + 22863 /* "read_bytes: " */, zDesc: ts + 22876 /* "Bytes rcvd from ..." */},
+ {zPattern: ts + 22901 /* "write_bytes: " */, zDesc: ts + 22915 /* "Bytes sent to st..." */},
+ {zPattern: ts + 22938 /* "cancelled_write_..." */, zDesc: ts + 22962 /* "Cancelled write ..." */},
+} /* speedtest1.c:2112:7 */
+
+func xCompileOptions(tls *libc.TLS, pCtx uintptr, nVal int32, azVal uintptr, azCol uintptr) int32 { /* speedtest1.c:2138:12: */
bp := tls.Alloc(8)
defer tls.Free(8)
- crt.Xprintf(tls, ts+21375 /* "-- Compile optio..." */, crt.VaList(bp, *(*uintptr)(unsafe.Pointer(azVal + uintptr(0)*8))))
+ libc.Xprintf(tls, ts+22985 /* "-- Compile optio..." */, libc.VaList(bp, *(*uintptr)(unsafe.Pointer(azVal + uintptr(0)*8))))
return 0
}
-func main1(tls *crt.TLS, argc int32, argv uintptr) int32 { /* speedtest1.c:1974:5: */
- bp := tls.Alloc(528)
- defer tls.Free(528)
+func main1(tls *libc.TLS, argc int32, argv uintptr) int32 { /* speedtest1.c:2143:5: */
+ bp := tls.Alloc(568)
+ defer tls.Free(568)
var doAutovac int32 = 0 // True for --autovacuum
var cacheSize int32 = 0 // Desired cache size. 0 means default
@@ -5337,7 +5734,8 @@ 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 + 21398 /* "main" */ // Which --testset torun
+ var memDb int32 = 0 // --memdb. Use an in-memory database
+ var zTSet uintptr = ts + 23008 /* "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
@@ -5345,21 +5743,21 @@ func main1(tls *crt.TLS, argc int32, argv uintptr) int32 { /* speedtest1.c:1974:
var pHeap uintptr = uintptr(0) // Allocated heap space
var pLook uintptr = uintptr(0) // Allocated lookaside space
var pPCache uintptr = uintptr(0) // Allocated storage for pcache
- // var iCur int32 at bp+520, 4
+ // var iCur int32 at bp+560, 4
- // var iHi int32 at bp+524, 4
+ // var iHi int32 at bp+564, 4
// Stats values, current and "highwater"
var i int32 // Loop counter
var rc int32 // API return code
// Display the version of SQLite being tested
- crt.Xprintf(tls, ts+21403, /* "-- Speedtest1 fo..." */
- crt.VaList(bp, sqlite3.Xsqlite3_libversion(tls), sqlite3.Xsqlite3_sourceid(tls)))
+ libc.Xprintf(tls, ts+23013, /* "-- Speedtest1 fo..." */
+ libc.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 + 21438 /* "UNIQUE" */
+ g.zWR = ts + 2152 /* "" */
+ g.zNN = ts + 2152 /* "" */
+ g.zPK = ts + 23048 /* "UNIQUE" */
g.szTest = 100
g.nRepeat = 1
for i = 1; i < argc; i++ {
@@ -5368,277 +5766,345 @@ 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+21445 /* "autovacuum" */) == 0 {
+ if libc.Xstrcmp(tls, z, ts+23055 /* "autovacuum" */) == 0 {
doAutovac = 1
- } else if crt.Xstrcmp(tls, z, ts+21456 /* "cachesize" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23066 /* "cachesize" */) == 0 {
if i >= (argc - 1) {
- fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+16, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8))))
+ fatal_error(tls, ts+23076 /* "missing argument..." */, libc.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+21490 /* "exclusive" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23100 /* "exclusive" */) == 0 {
doExclusive = 1
- } else if crt.Xstrcmp(tls, z, ts+21500 /* "explain" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23110 /* "checkpoint" */) == 0 {
+ g.doCheckpoint = 1
+ } else if libc.Xstrcmp(tls, z, ts+23121 /* "explain" */) == 0 {
g.bSqlOnly = 1
g.bExplain = 1
- } else if crt.Xstrcmp(tls, z, ts+21508 /* "heap" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23129 /* "heap" */) == 0 {
if i >= (argc - 2) {
- fatal_error(tls, ts+21513 /* "missing argument..." */, crt.VaList(bp+24, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8))))
+ fatal_error(tls, ts+23134 /* "missing argument..." */, libc.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+21538 /* "incrvacuum" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23159 /* "incrvacuum" */) == 0 {
doIncrvac = 1
- } else if crt.Xstrcmp(tls, z, ts+21549 /* "journal" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23170 /* "journal" */) == 0 {
if i >= (argc - 1) {
- fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+32, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8))))
+ fatal_error(tls, ts+23076 /* "missing argument..." */, libc.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+21557 /* "key" */) == 0 {
+ zJMode = *(*uintptr)(unsafe.Pointer(argv + uintptr(libc.PreIncInt32(&i, 1))*8))
+ } else if libc.Xstrcmp(tls, z, ts+23178 /* "key" */) == 0 {
if i >= (argc - 1) {
- fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+40, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8))))
+ fatal_error(tls, ts+23076 /* "missing argument..." */, libc.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+21561 /* "lookaside" */) == 0 {
+ zKey = *(*uintptr)(unsafe.Pointer(argv + uintptr(libc.PreIncInt32(&i, 1))*8))
+ } else if libc.Xstrcmp(tls, z, ts+23182 /* "lookaside" */) == 0 {
if i >= (argc - 2) {
- fatal_error(tls, ts+21513 /* "missing argument..." */, crt.VaList(bp+48, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8))))
+ fatal_error(tls, ts+23134 /* "missing argument..." */, libc.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+21571 /* "multithread" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23192 /* "memdb" */) == 0 {
+ memDb = 1
+ } else if libc.Xstrcmp(tls, z, ts+23198 /* "multithread" */) == 0 {
sqlite3.Xsqlite3_config(tls, 2, 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+21593 /* "mmap" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23210 /* "nomemstat" */) == 0 {
+ sqlite3.Xsqlite3_config(tls, 9, libc.VaList(bp+56, 0))
+ } else if libc.Xstrcmp(tls, z, ts+23220 /* "mmap" */) == 0 {
if i >= (argc - 1) {
- fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+64, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8))))
+ fatal_error(tls, ts+23076 /* "missing argument..." */, libc.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+21598 /* "nosync" */) == 0 {
+ mmapSize = integerValue(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr(libc.PreIncInt32(&i, 1))*8)))
+ } else if libc.Xstrcmp(tls, z, ts+23225 /* "nosync" */) == 0 {
noSync = 1
- } 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 {
+ } else if libc.Xstrcmp(tls, z, ts+23232 /* "notnull" */) == 0 {
+ g.zNN = ts + 23240 /* "NOT NULL" */
+ } else if libc.Xstrcmp(tls, z, ts+23249 /* "output" */) == 0 {
+ if i >= (argc - 1) {
+ fatal_error(tls, ts+23076 /* "missing argument..." */, libc.VaList(bp+72, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8))))
+ }
+ i++
+ if libc.Xstrcmp(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)), ts+23256 /* "-" */) == 0 {
+ g.hashFile = libc.Xstdout
+ } else {
+ g.hashFile = libc.Xfopen(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)), ts+23258 /* "wb" */)
+ if g.hashFile == uintptr(0) {
+ fatal_error(tls, ts+23261 /* "cannot open \"%s\"..." */, libc.VaList(bp+80, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8))))
+ }
+ }
+ } else if libc.Xstrcmp(tls, z, ts+23291 /* "pagesize" */) == 0 {
if i >= (argc - 1) {
- fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+72, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8))))
+ fatal_error(tls, ts+23076 /* "missing argument..." */, libc.VaList(bp+88, *(*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+21631 /* "pcache" */) == 0 {
+ pageSize = integerValue(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr(libc.PreIncInt32(&i, 1))*8)))
+ } else if libc.Xstrcmp(tls, z, ts+23300 /* "pcache" */) == 0 {
if i >= (argc - 2) {
- fatal_error(tls, ts+21513 /* "missing argument..." */, crt.VaList(bp+80, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8))))
+ fatal_error(tls, ts+23134 /* "missing argument..." */, libc.VaList(bp+96, *(*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+21638 /* "primarykey" */) == 0 {
- g.zPK = ts + 21649 /* "PRIMARY KEY" */
- } else if crt.Xstrcmp(tls, z, ts+21661 /* "repeat" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23307 /* "primarykey" */) == 0 {
+ g.zPK = ts + 23318 /* "PRIMARY KEY" */
+ } else if libc.Xstrcmp(tls, z, ts+23330 /* "repeat" */) == 0 {
if i >= (argc - 1) {
- fatal_error(tls, ts+21513 /* "missing argument..." */, crt.VaList(bp+88, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8))))
+ fatal_error(tls, ts+23134 /* "missing argument..." */, libc.VaList(bp+104, *(*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+21668 /* "reprepare" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23337 /* "reprepare" */) == 0 {
g.bReprepare = 1
- } else if crt.Xstrcmp(tls, z, ts+21678 /* "serialized" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23347 /* "serialized" */) == 0 {
sqlite3.Xsqlite3_config(tls, 3, 0)
- } else if crt.Xstrcmp(tls, z, ts+21689 /* "singlethread" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23358 /* "singlethread" */) == 0 {
sqlite3.Xsqlite3_config(tls, 1, 0)
- } else if crt.Xstrcmp(tls, z, ts+21702 /* "sqlonly" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23371 /* "sqlonly" */) == 0 {
g.bSqlOnly = 1
- } else if crt.Xstrcmp(tls, z, ts+21710 /* "shrink-memory" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23379 /* "shrink-memory" */) == 0 {
g.bMemShrink = 1
- } else if crt.Xstrcmp(tls, z, ts+21724 /* "size" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23393 /* "size" */) == 0 {
if i >= (argc - 1) {
- fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+96, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8))))
+ fatal_error(tls, ts+23076 /* "missing argument..." */, libc.VaList(bp+112, *(*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+21729 /* "stats" */) == 0 {
+ g.szTest = integerValue(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr(libc.PreIncInt32(&i, 1))*8)))
+ } else if libc.Xstrcmp(tls, z, ts+23398 /* "stats" */) == 0 {
showStats = 1
- } else if crt.Xstrcmp(tls, z, ts+21735 /* "temp" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23404 /* "temp" */) == 0 {
if i >= (argc - 1) {
- fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+104, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8))))
+ fatal_error(tls, ts+23076 /* "missing argument..." */, libc.VaList(bp+120, *(*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+21740 /* "argument to --te..." */, 0)
+ fatal_error(tls, ts+23409 /* "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+21793 /* "testset" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23462 /* "testset" */) == 0 {
if i >= (argc - 1) {
- fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+112, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8))))
+ fatal_error(tls, ts+23076 /* "missing argument..." */, libc.VaList(bp+128, *(*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+21801 /* "trace" */) == 0 {
+ zTSet = *(*uintptr)(unsafe.Pointer(argv + uintptr(libc.PreIncInt32(&i, 1))*8))
+ } else if libc.Xstrcmp(tls, z, ts+23470 /* "trace" */) == 0 {
doTrace = 1
- } else if crt.Xstrcmp(tls, z, ts+21807 /* "threads" */) == 0 {
+ } else if libc.Xstrcmp(tls, z, ts+23476 /* "threads" */) == 0 {
if i >= (argc - 1) {
- fatal_error(tls, ts+21466 /* "missing argument..." */, crt.VaList(bp+120, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8))))
+ fatal_error(tls, ts+23076 /* "missing argument..." */, libc.VaList(bp+136, *(*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+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 {
+ nThread = integerValue(tls, *(*uintptr)(unsafe.Pointer(argv + uintptr(libc.PreIncInt32(&i, 1))*8)))
+ } else if libc.Xstrcmp(tls, z, ts+23484 /* "utf16le" */) == 0 {
+ zEncoding = ts + 23484 /* "utf16le" */
+ } else if libc.Xstrcmp(tls, z, ts+23492 /* "utf16be" */) == 0 {
+ zEncoding = ts + 23492 /* "utf16be" */
+ } else if libc.Xstrcmp(tls, z, ts+23500 /* "verify" */) == 0 {
g.bVerify = 1
- } 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)
+ HashInit(tls)
+ } else if libc.Xstrcmp(tls, z, ts+23507 /* "without-rowid" */) == 0 {
+ g.zWR = ts + 5915 /* "WITHOUT ROWID" */
+ g.zPK = ts + 23318 /* "PRIMARY KEY" */
+ } else if (libc.Xstrcmp(tls, z, ts+23521 /* "help" */) == 0) || (libc.Xstrcmp(tls, z, ts+23526 /* "?" */) == 0) {
+ libc.Xprintf(tls, uintptr(unsafe.Pointer(&zHelp)), libc.VaList(bp+144, *(*uintptr)(unsafe.Pointer(argv + uintptr(0)*8))))
+ libc.Xexit(tls, 0)
} else {
- 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))))
+ fatal_error(tls, ts+23528, /* "unknown option: ..." */
+ libc.VaList(bp+152, *(*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+21900, /* "surplus argument..." */
- crt.VaList(bp+152, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)), *(*uintptr)(unsafe.Pointer(argv + uintptr(0)*8))))
+ fatal_error(tls, ts+23569, /* "surplus argument..." */
+ libc.VaList(bp+168, *(*uintptr)(unsafe.Pointer(argv + uintptr(i)*8)), *(*uintptr)(unsafe.Pointer(argv + uintptr(0)*8))))
}
}
if zDbName != uintptr(0) {
- crt.Xunlink(tls, zDbName)
+ libc.Xunlink(tls, zDbName)
}
if nHeap > 0 {
- pHeap = crt.Xmalloc(tls, uint64(nHeap))
+ pHeap = libc.Xmalloc(tls, uint64(nHeap))
if pHeap == uintptr(0) {
- fatal_error(tls, ts+21943 /* "cannot allocate ..." */, crt.VaList(bp+168, nHeap))
+ fatal_error(tls, ts+23612 /* "cannot allocate ..." */, libc.VaList(bp+184, nHeap))
}
- rc = sqlite3.Xsqlite3_config(tls, 8, crt.VaList(bp+176, pHeap, nHeap, mnHeap))
+ rc = sqlite3.Xsqlite3_config(tls, 8, libc.VaList(bp+192, pHeap, nHeap, mnHeap))
if rc != 0 {
- fatal_error(tls, ts+21973 /* "heap configurati..." */, crt.VaList(bp+200, rc))
+ fatal_error(tls, ts+23642 /* "heap configurati..." */, libc.VaList(bp+216, rc))
}
}
if doPCache != 0 {
if (nPCache > 0) && (szPCache > 0) {
- pPCache = crt.Xmalloc(tls, (uint64(sqlite3_int64(nPCache) * sqlite3_int64(szPCache))))
+ pPCache = libc.Xmalloc(tls, (uint64(sqlite3_int64(nPCache) * sqlite3_int64(szPCache))))
if pPCache == uintptr(0) {
- fatal_error(tls, ts+22004, /* "cannot allocate ..." */
- crt.VaList(bp+208, (sqlite3_int64(nPCache)*sqlite3_int64(szPCache))))
+ fatal_error(tls, ts+23673, /* "cannot allocate ..." */
+ libc.VaList(bp+224, (sqlite3_int64(nPCache)*sqlite3_int64(szPCache))))
}
}
- rc = sqlite3.Xsqlite3_config(tls, 7, crt.VaList(bp+216, pPCache, szPCache, nPCache))
+ rc = sqlite3.Xsqlite3_config(tls, 7, libc.VaList(bp+232, pPCache, szPCache, nPCache))
if rc != 0 {
- fatal_error(tls, ts+22038 /* "pcache configura..." */, crt.VaList(bp+240, rc))
+ fatal_error(tls, ts+23707 /* "pcache configura..." */, libc.VaList(bp+256, rc))
}
}
if nLook >= 0 {
- sqlite3.Xsqlite3_config(tls, 13, crt.VaList(bp+248, 0, 0))
+ sqlite3.Xsqlite3_config(tls, 13, libc.VaList(bp+264, 0, 0))
}
sqlite3.Xsqlite3_initialize(tls)
// Open the database and the input file
- if sqlite3.Xsqlite3_open(tls, zDbName, (uintptr(unsafe.Pointer(&g)) /* &.db */)) != 0 {
- fatal_error(tls, ts+22071 /* "Cannot open data..." */, crt.VaList(bp+264, zDbName))
+ if sqlite3.Xsqlite3_open(tls, func() uintptr {
+ if memDb != 0 {
+ return ts + 23740 /* ":memory:" */
+ }
+ return zDbName
+ }(), (uintptr(unsafe.Pointer(&g)) /* &.db */)) != 0 {
+ fatal_error(tls, ts+23749 /* "Cannot open data..." */, libc.VaList(bp+280, 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))
+ pLook = libc.Xmalloc(tls, (uint64(nLook * szLook)))
+ rc = sqlite3.Xsqlite3_db_config(tls, g.db, 1001, libc.VaList(bp+288, pLook, szLook, nLook))
if rc != 0 {
- fatal_error(tls, ts+22102 /* "lookaside config..." */, crt.VaList(bp+296, rc))
+ fatal_error(tls, ts+23780 /* "lookaside config..." */, libc.VaList(bp+312, rc))
}
}
// Set database connection options
- 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)
+ sqlite3.Xsqlite3_create_function(tls, g.db, ts+23816 /* "random" */, 0, 1, uintptr(0), *(*uintptr)(unsafe.Pointer(&struct {
+ f func(*libc.TLS, uintptr, int32, uintptr)
}{randomFunc})), uintptr(0), uintptr(0))
if doTrace != 0 {
sqlite3.Xsqlite3_trace(tls, g.db, *(*uintptr)(unsafe.Pointer(&struct {
- f func(*crt.TLS, uintptr, uintptr)
+ f func(*libc.TLS, uintptr, uintptr)
}{traceCallback})), uintptr(0))
}
+ if memDb > 0 {
+ speedtest1_exec(tls, ts+23823 /* "PRAGMA temp_stor..." */, 0)
+ }
if mmapSize > 0 {
- speedtest1_exec(tls, ts+22145 /* "PRAGMA mmap_size..." */, crt.VaList(bp+304, mmapSize))
+ speedtest1_exec(tls, ts+23848 /* "PRAGMA mmap_size..." */, libc.VaList(bp+320, mmapSize))
}
- speedtest1_exec(tls, ts+22165 /* "PRAGMA threads=%..." */, crt.VaList(bp+312, nThread))
+ speedtest1_exec(tls, ts+23868 /* "PRAGMA threads=%..." */, libc.VaList(bp+328, nThread))
if zKey != 0 {
- speedtest1_exec(tls, ts+22183 /* "PRAGMA key('%s')" */, crt.VaList(bp+320, zKey))
+ speedtest1_exec(tls, ts+23886 /* "PRAGMA key('%s')" */, libc.VaList(bp+336, zKey))
}
if zEncoding != 0 {
- speedtest1_exec(tls, ts+22200 /* "PRAGMA encoding=..." */, crt.VaList(bp+328, zEncoding))
+ speedtest1_exec(tls, ts+23903 /* "PRAGMA encoding=..." */, libc.VaList(bp+344, zEncoding))
}
if doAutovac != 0 {
- speedtest1_exec(tls, ts+22219 /* "PRAGMA auto_vacu..." */, 0)
+ speedtest1_exec(tls, ts+23922 /* "PRAGMA auto_vacu..." */, 0)
} else if doIncrvac != 0 {
- speedtest1_exec(tls, ts+22243 /* "PRAGMA auto_vacu..." */, 0)
+ speedtest1_exec(tls, ts+23946 /* "PRAGMA auto_vacu..." */, 0)
}
if pageSize != 0 {
- speedtest1_exec(tls, ts+22274 /* "PRAGMA page_size..." */, crt.VaList(bp+336, pageSize))
+ speedtest1_exec(tls, ts+23977 /* "PRAGMA page_size..." */, libc.VaList(bp+352, pageSize))
}
if cacheSize != 0 {
- speedtest1_exec(tls, ts+22294 /* "PRAGMA cache_siz..." */, crt.VaList(bp+344, cacheSize))
+ speedtest1_exec(tls, ts+23997 /* "PRAGMA cache_siz..." */, libc.VaList(bp+360, cacheSize))
}
if noSync != 0 {
- speedtest1_exec(tls, ts+22315 /* "PRAGMA synchrono..." */, 0)
+ speedtest1_exec(tls, ts+24018 /* "PRAGMA synchrono..." */, 0)
}
if doExclusive != 0 {
- speedtest1_exec(tls, ts+22338 /* "PRAGMA locking_m..." */, 0)
+ speedtest1_exec(tls, ts+24041 /* "PRAGMA locking_m..." */, 0)
}
if zJMode != 0 {
- speedtest1_exec(tls, ts+22368 /* "PRAGMA journal_m..." */, crt.VaList(bp+352, zJMode))
+ speedtest1_exec(tls, ts+24071 /* "PRAGMA journal_m..." */, libc.VaList(bp+368, zJMode))
}
if g.bExplain != 0 {
- crt.Xprintf(tls, ts+22391 /* ".explain\n.echo o..." */, 0)
+ libc.Xprintf(tls, ts+24094 /* ".explain\n.echo o..." */, 0)
}
- if crt.Xstrcmp(tls, zTSet, ts+21398 /* "main" */) == 0 {
- testset_main(tls)
- } else if crt.Xstrcmp(tls, zTSet, ts+22410 /* "debug1" */) == 0 {
- testset_debug1(tls)
- } else if crt.Xstrcmp(tls, zTSet, ts+22417 /* "orm" */) == 0 {
- testset_orm(tls)
- } else if crt.Xstrcmp(tls, zTSet, ts+22421 /* "cte" */) == 0 {
- testset_cte(tls)
- } else if crt.Xstrcmp(tls, zTSet, ts+22425 /* "fp" */) == 0 {
- testset_fp(tls)
- } else if crt.Xstrcmp(tls, zTSet, ts+22428 /* "trigger" */) == 0 {
- testset_trigger(tls)
- } else if crt.Xstrcmp(tls, zTSet, ts+22436 /* "rtree" */) == 0 {
- fatal_error(tls,
- ts+22442 /* "compile with -DS..." */, 0)
- } else {
- fatal_error(tls,
- ts+22505, /* "unknown testset:..." */
- crt.VaList(bp+360, zTSet))
+ for ok1 := true; ok1; ok1 = *(*int8)(unsafe.Pointer(zTSet + uintptr(0))) != 0 {
+ var zThisTest uintptr = zTSet
+ var zComma uintptr = libc.Xstrchr(tls, zThisTest, ',')
+ if zComma != 0 {
+ *(*int8)(unsafe.Pointer(zComma)) = int8(0)
+ zTSet = (zComma + uintptr(1))
+ } else {
+ zTSet = ts + 2152 /* "" */
+ }
+ if (g.iTotal > int64(0)) || (zComma != uintptr(0)) {
+ libc.Xprintf(tls, ts+24113 /* " Begin tes..." */, libc.VaList(bp+376, zThisTest))
+ }
+ if libc.Xstrcmp(tls, zThisTest, ts+23008 /* "main" */) == 0 {
+ testset_main(tls)
+ } else if libc.Xstrcmp(tls, zThisTest, ts+24140 /* "debug1" */) == 0 {
+ testset_debug1(tls)
+ } else if libc.Xstrcmp(tls, zThisTest, ts+24147 /* "orm" */) == 0 {
+ testset_orm(tls)
+ } else if libc.Xstrcmp(tls, zThisTest, ts+24151 /* "cte" */) == 0 {
+ testset_cte(tls)
+ } else if libc.Xstrcmp(tls, zThisTest, ts+24155 /* "fp" */) == 0 {
+ testset_fp(tls)
+ } else if libc.Xstrcmp(tls, zThisTest, ts+24158 /* "trigger" */) == 0 {
+ testset_trigger(tls)
+ } else if libc.Xstrcmp(tls, zThisTest, ts+24166 /* "rtree" */) == 0 {
+ testset_rtree(tls, 6, 147)
+ } else {
+ fatal_error(tls,
+ ts+24172, /* "unknown testset:..." */
+ libc.VaList(bp+384, zThisTest))
+ }
+ if *(*int8)(unsafe.Pointer(zTSet + uintptr(0))) != 0 {
+ var zSql uintptr
+ var zObj uintptr
+ speedtest1_begin_test(tls, 999, ts+24241 /* "Reset the databa..." */, 0)
+ for 1 != 0 {
+ zObj = speedtest1_once(tls,
+
+ ts+24260 /* "SELECT name FROM..." */, 0)
+ if zObj == uintptr(0) {
+ break
+ }
+ zSql = sqlite3.Xsqlite3_mprintf(tls, ts+24330 /* "DROP TABLE main...." */, libc.VaList(bp+392, zObj))
+ speedtest1_exec(tls, zSql, 0)
+ sqlite3.Xsqlite3_free(tls, zSql)
+ sqlite3.Xsqlite3_free(tls, zObj)
+ }
+ for 1 != 0 {
+ zObj = speedtest1_once(tls,
+
+ ts+24351 /* "SELECT name FROM..." */, 0)
+ if zObj == uintptr(0) {
+ break
+ }
+ zSql = sqlite3.Xsqlite3_mprintf(tls, ts+24330 /* "DROP TABLE main...." */, libc.VaList(bp+400, zObj))
+ speedtest1_exec(tls, zSql, 0)
+ sqlite3.Xsqlite3_free(tls, zSql)
+ sqlite3.Xsqlite3_free(tls, zObj)
+ }
+ speedtest1_end_test(tls)
+ }
}
speedtest1_final(tls)
if showStats != 0 {
- sqlite3.Xsqlite3_exec(tls, g.db, ts+22574 /* "PRAGMA compile_o..." */, *(*uintptr)(unsafe.Pointer(&struct {
- f func(*crt.TLS, uintptr, int32, uintptr, uintptr) int32
+ sqlite3.Xsqlite3_exec(tls, g.db, ts+24421 /* "PRAGMA compile_o..." */, *(*uintptr)(unsafe.Pointer(&struct {
+ f func(*libc.TLS, uintptr, int32, uintptr, uintptr) int32
}{xCompileOptions})), uintptr(0), uintptr(0))
}
// Database connection statistics printed after both prepared statements
// 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+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+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+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+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+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+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+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+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+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+22942 /* "-- Statement Hea..." */, crt.VaList(bp+448, *(*int32)(unsafe.Pointer(bp + 520 /* iCur */))))
+ sqlite3.Xsqlite3_db_status(tls, g.db, 0, bp+560 /* &iCur */, bp+564 /* &iHi */, 0)
+ libc.Xprintf(tls, ts+24444 /* "-- Lookaside Slo..." */, libc.VaList(bp+408, *(*int32)(unsafe.Pointer(bp + 560 /* iCur */)), *(*int32)(unsafe.Pointer(bp + 564 /* iHi */))))
+ sqlite3.Xsqlite3_db_status(tls, g.db, 4, bp+560 /* &iCur */, bp+564 /* &iHi */, 0)
+ libc.Xprintf(tls, ts+24489 /* "-- Successful lo..." */, libc.VaList(bp+424, *(*int32)(unsafe.Pointer(bp + 564 /* iHi */))))
+ sqlite3.Xsqlite3_db_status(tls, g.db, 5, bp+560 /* &iCur */, bp+564 /* &iHi */, 0)
+ libc.Xprintf(tls, ts+24525 /* "-- Lookaside siz..." */, libc.VaList(bp+432, *(*int32)(unsafe.Pointer(bp + 564 /* iHi */))))
+ sqlite3.Xsqlite3_db_status(tls, g.db, 6, bp+560 /* &iCur */, bp+564 /* &iHi */, 0)
+ libc.Xprintf(tls, ts+24561 /* "-- Lookaside OOM..." */, libc.VaList(bp+440, *(*int32)(unsafe.Pointer(bp + 564 /* iHi */))))
+ sqlite3.Xsqlite3_db_status(tls, g.db, 1, bp+560 /* &iCur */, bp+564 /* &iHi */, 0)
+ libc.Xprintf(tls, ts+24597 /* "-- Pager Heap Us..." */, libc.VaList(bp+448, *(*int32)(unsafe.Pointer(bp + 560 /* iCur */))))
+ sqlite3.Xsqlite3_db_status(tls, g.db, 7, bp+560 /* &iCur */, bp+564 /* &iHi */, 1)
+ libc.Xprintf(tls, ts+24639 /* "-- Page cache hi..." */, libc.VaList(bp+456, *(*int32)(unsafe.Pointer(bp + 560 /* iCur */))))
+ sqlite3.Xsqlite3_db_status(tls, g.db, 8, bp+560 /* &iCur */, bp+564 /* &iHi */, 1)
+ libc.Xprintf(tls, ts+24675 /* "-- Page cache mi..." */, libc.VaList(bp+464, *(*int32)(unsafe.Pointer(bp + 560 /* iCur */))))
+ sqlite3.Xsqlite3_db_status(tls, g.db, 9, bp+560 /* &iCur */, bp+564 /* &iHi */, 1)
+ libc.Xprintf(tls, ts+24711 /* "-- Page cache wr..." */, libc.VaList(bp+472, *(*int32)(unsafe.Pointer(bp + 560 /* iCur */))))
+ sqlite3.Xsqlite3_db_status(tls, g.db, 2, bp+560 /* &iCur */, bp+564 /* &iHi */, 0)
+ libc.Xprintf(tls, ts+24747 /* "-- Schema Heap U..." */, libc.VaList(bp+480, *(*int32)(unsafe.Pointer(bp + 560 /* iCur */))))
+ sqlite3.Xsqlite3_db_status(tls, g.db, 3, bp+560 /* &iCur */, bp+564 /* &iHi */, 0)
+ libc.Xprintf(tls, ts+24789 /* "-- Statement Hea..." */, libc.VaList(bp+488, *(*int32)(unsafe.Pointer(bp + 560 /* iCur */))))
}
sqlite3.Xsqlite3_close(tls, g.db)
@@ -5646,28 +6112,28 @@ func main1(tls *crt.TLS, argc int32, argv uintptr) int32 { /* speedtest1.c:1974:
// Global memory usage statistics printed after the database connection
// 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+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+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+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+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+23161 /* "-- Largest Pcach..." */, crt.VaList(bp+512, *(*int32)(unsafe.Pointer(bp + 524 /* iHi */))))
+ sqlite3.Xsqlite3_status(tls, 0, bp+560 /* &iCur */, bp+564 /* &iHi */, 0)
+ libc.Xprintf(tls, ts+24831 /* "-- Memory Used (..." */, libc.VaList(bp+496, *(*int32)(unsafe.Pointer(bp + 560 /* iCur */)), *(*int32)(unsafe.Pointer(bp + 564 /* iHi */))))
+ sqlite3.Xsqlite3_status(tls, 9, bp+560 /* &iCur */, bp+564 /* &iHi */, 0)
+ libc.Xprintf(tls, ts+24876 /* "-- Outstanding A..." */, libc.VaList(bp+512, *(*int32)(unsafe.Pointer(bp + 560 /* iCur */)), *(*int32)(unsafe.Pointer(bp + 564 /* iHi */))))
+ sqlite3.Xsqlite3_status(tls, 2, bp+560 /* &iCur */, bp+564 /* &iHi */, 0)
+ libc.Xprintf(tls, ts+24921 /* "-- Pcache Overfl..." */, libc.VaList(bp+528, *(*int32)(unsafe.Pointer(bp + 560 /* iCur */)), *(*int32)(unsafe.Pointer(bp + 564 /* iHi */))))
+ sqlite3.Xsqlite3_status(tls, 5, bp+560 /* &iCur */, bp+564 /* &iHi */, 0)
+ libc.Xprintf(tls, ts+24966 /* "-- Largest Alloc..." */, libc.VaList(bp+544, *(*int32)(unsafe.Pointer(bp + 564 /* iHi */))))
+ sqlite3.Xsqlite3_status(tls, 7, bp+560 /* &iCur */, bp+564 /* &iHi */, 0)
+ libc.Xprintf(tls, ts+25008 /* "-- Largest Pcach..." */, libc.VaList(bp+552, *(*int32)(unsafe.Pointer(bp + 564 /* iHi */))))
}
if showStats != 0 {
- displayLinuxIoStats(tls, crt.Xstdout)
+ displayLinuxIoStats(tls, libc.Xstdout)
}
// Release memory
- crt.Xfree(tls, pLook)
- crt.Xfree(tls, pPCache)
- crt.Xfree(tls, pHeap)
+ libc.Xfree(tls, pLook)
+ libc.Xfree(tls, pPCache)
+ libc.Xfree(tls, pHeap)
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\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 ts1 = "Usage: %s [--options] DATABASE\nOptions:\n --autovacuum Enable AUTOVACUUM mode\n --cachesize N Set the cache size to N\n --checkpoint Run PRAGMA wal_checkpoint after each test case\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 --memdb Use an in-memory database\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 --output FILE Store SQL output in FILE\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 \x00PRAGMA wal_checkpoint;\x00%4d.%03ds\n\x00 TOTAL%.*s %4d.%03ds\n\x00Verification Hash: %llu \x00\n\x00%02x\x00EXPLAIN \x00%.*s;\n\x00CREATE *\x00DROP *\x00ALTER *\x00SQL error: %s\n%s\n\x00exec error: %s\n\x00SQL error: %s\n\x00nil\x00-IFTBN\x000123456789abcdef\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\x00%d INSERTs into an r-tree\x00CREATE VIRTUAL TABLE rt1 USING rtree(id,x0,x1,y0,y1,z0,z1)\x00INSERT INTO rt1(id,x0,x1,y0,y1,z0,z1)VALUES(?1,?2,?3,?4,?5,?6,?7)\x00Copy from rtree to a regular table\x00CREATE TABLE t1(id INTEGER PRIMARY KEY,x0,x1,y0,y1,z0,z1)\x00INSERT INTO t1 SELECT * FROM rt1\x00%d one-dimensional intersect slice queries\x00SELECT count(*) FROM rt1 WHERE x0>=?1 AND x1<=?2\x00Verify result from 1-D intersect slice queries\x00SELECT count(*) FROM t1 WHERE x0>=?1 AND x1<=?2\x00Count disagree step %d: %d..%d. %d vs %d\x00%d one-dimensional overlap slice queries\x00SELECT count(*) FROM rt1 WHERE y1>=?1 AND y0<=?2\x00Verify result from 1-D overlap slice queries\x00SELECT count(*) FROM t1 WHERE y1>=?1 AND y0<=?2\x00%d custom geometry callback queries\x00xslice\x00SELECT count(*) FROM rt1 WHERE id MATCH xslice(?1,?2)\x00%d three-dimensional intersect box queries\x00SELECT count(*) FROM rt1 WHERE x1>=?1 AND x0<=?2 AND y1>=?1 AND y0<=?2 AND z1>=?1 AND z0<=?2\x00%d rowid queries\x00SELECT * FROM rt1 WHERE id=?1\x00%d UPDATEs using rowid\x00UPDATE rt1 SET x0=x0+100, x1=x1+100 WHERE id=?1\x00%d UPDATEs using one-dimensional overlap\x00UPDATE rt1 SET x0=x0-100, x1=x1-100 WHERE y1>=?1 AND y0<=?1+5\x00%d DELETEs using rowid\x00DELETE FROM rt1 WHERE id=?1\x00%d DELETEs using one-dimensional overlap\x00DELETE FROM rt1 WHERE y1>=?1 AND y0<=?1+5\x00Restore deleted entries using INSERT OR IGNORE\x00INSERT OR IGNORE INTO rt1 SELECT * FROM t1\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 %.48s\n\x00UNIQUE\x00autovacuum\x00cachesize\x00missing argument on %s\n\x00exclusive\x00checkpoint\x00explain\x00heap\x00missing arguments on %s\n\x00incrvacuum\x00journal\x00key\x00lookaside\x00memdb\x00multithread\x00nomemstat\x00mmap\x00nosync\x00notnull\x00NOT NULL\x00output\x00-\x00wb\x00cannot open \"%s\" for writing\n\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\x00:memory:\x00Cannot open database file: %s\n\x00lookaside configuration failed: %d\n\x00random\x00PRAGMA temp_store=memory\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\x00 Begin testset \"%s\"\n\x00debug1\x00orm\x00cte\x00fp\x00trigger\x00rtree\x00unknown testset: \"%s\"\nChoices: cte debug1 fp main orm rtree trigger\n\x00Reset the database\x00SELECT name FROM main.sqlite_master WHERE sql LIKE 'CREATE %%TABLE%%'\x00DROP TABLE main.\"%w\"\x00SELECT name FROM temp.sqlite_master WHERE sql LIKE 'CREATE %%TABLE%%'\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