Lines Matching refs:g
116 } g; variable
121 return g.eTemp>=N ? " TEMP" : ""; in isTemp()
146 g.hash.i = 0; in HashInit()
147 g.hash.j = 0; in HashInit()
148 for(k=0; k<256; k++) g.hash.s[k] = k; in HashInit()
160 unsigned char i = g.hash.i; in HashUpdate()
161 unsigned char j = g.hash.j; in HashUpdate()
163 if( g.hashFile ) fwrite(aData, 1, nData, g.hashFile); in HashUpdate()
165 j += g.hash.s[i] + aData[k]; in HashUpdate()
166 t = g.hash.s[j]; in HashUpdate()
167 g.hash.s[j] = g.hash.s[i]; in HashUpdate()
168 g.hash.s[i] = t; in HashUpdate()
171 g.hash.i = i; in HashUpdate()
172 g.hash.j = j; in HashUpdate()
182 i = g.hash.i; in HashFinal()
183 j = g.hash.j; in HashFinal()
186 t = g.hash.s[i]; in HashFinal()
188 g.hash.s[i] = g.hash.s[j]; in HashFinal()
189 g.hash.s[j] = t; in HashFinal()
190 t += g.hash.s[i]; in HashFinal()
191 g.hash.r[k] = g.hash.s[t]; in HashFinal()
287 g.x = (g.x>>1) ^ ((1+~(g.x&1)) & 0xd0000001); in speedtest1_random()
288 g.y = g.y*1103515245 + 12345; in speedtest1_random()
289 return g.x ^ g.y; in speedtest1_random()
393 if( g.pScript ){ in speedtest1_begin_test()
394 fprintf(g.pScript,"-- begin test %d %.*s\n", iTestNumber, n, zName) in speedtest1_begin_test()
398 if( g.bSqlOnly ){ in speedtest1_begin_test()
405 g.nResult = 0; in speedtest1_begin_test()
406 g.iStart = speedtest1_timestamp(); in speedtest1_begin_test()
407 g.x = 0xad131d0b; in speedtest1_begin_test()
408 g.y = 0x44f9eac8; in speedtest1_begin_test()
416 sqlite3_int64 iElapseTime = speedtest1_timestamp() - g.iStart; in speedtest1_end_test()
417 if( g.doCheckpoint ) speedtest1_exec("PRAGMA wal_checkpoint;"); in speedtest1_end_test()
419 if( g.pScript ){ in speedtest1_end_test()
420 fprintf(g.pScript,"-- end test %d\n", iTestNumber); in speedtest1_end_test()
422 if( !g.bSqlOnly ){ in speedtest1_end_test()
423 g.iTotal += iElapseTime; in speedtest1_end_test()
426 if( g.pStmt ){ in speedtest1_end_test()
427 sqlite3_finalize(g.pStmt); in speedtest1_end_test()
428 g.pStmt = 0; in speedtest1_end_test()
435 if( !g.bSqlOnly ){ in speedtest1_final()
437 (int)(g.iTotal/1000), (int)(g.iTotal%1000)); in speedtest1_final()
439 if( g.bVerify ){ in speedtest1_final()
443 printf("Verification Hash: %llu ", g.nResByte); in speedtest1_final()
448 printf("%02x", g.hash.r[i]); in speedtest1_final()
450 if( g.hashFile && g.hashFile!=stdout ) fclose(g.hashFile); in speedtest1_final()
460 if( g.bExplain ) printf("EXPLAIN "); in printSql()
462 if( g.bExplain in printSql()
479 if( g.bMemShrink ) sqlite3_db_release_memory(g.db); in speedtest1_shrink_memory()
490 if( g.bSqlOnly ){ in speedtest1_exec()
495 if( g.pScript ){ in speedtest1_exec()
496 fprintf(g.pScript,"%s;\n",zSql); in speedtest1_exec()
498 rc = sqlite3_exec(g.db, zSql, 0, 0, &zErrMsg); in speedtest1_exec()
500 if( rc!=SQLITE_OK ) fatal_error("exec error: %s\n", sqlite3_errmsg(g.db)); in speedtest1_exec()
518 if( g.bSqlOnly ){ in speedtest1_once()
521 int rc = sqlite3_prepare_v2(g.db, zSql, -1, &pStmt, 0); in speedtest1_once()
523 fatal_error("SQL error: %s\n", sqlite3_errmsg(g.db)); in speedtest1_once()
525 if( g.pScript ){ in speedtest1_once()
527 fprintf(g.pScript,"%s\n",z); in speedtest1_once()
548 if( g.bSqlOnly ){ in speedtest1_prepare()
552 if( g.pStmt ) sqlite3_finalize(g.pStmt); in speedtest1_prepare()
553 rc = sqlite3_prepare_v2(g.db, zSql, -1, &g.pStmt, 0); in speedtest1_prepare()
555 fatal_error("SQL error: %s\n", sqlite3_errmsg(g.db)); in speedtest1_prepare()
564 if( g.bSqlOnly ) return; in speedtest1_run()
565 assert( g.pStmt ); in speedtest1_run()
566 g.nResult = 0; in speedtest1_run()
567 if( g.pScript ){ in speedtest1_run()
568 char *z = sqlite3_expanded_sql(g.pStmt); in speedtest1_run()
569 fprintf(g.pScript,"%s\n",z); in speedtest1_run()
572 while( sqlite3_step(g.pStmt)==SQLITE_ROW ){ in speedtest1_run()
573 n = sqlite3_column_count(g.pStmt); in speedtest1_run()
575 const char *z = (const char*)sqlite3_column_text(g.pStmt, i); in speedtest1_run()
579 if( g.bVerify ){ in speedtest1_run()
580 int eType = sqlite3_column_type(g.pStmt, i); in speedtest1_run()
584 if( g.nResByte ){ in speedtest1_run()
593 g.nResByte += 2; in speedtest1_run()
595 int nBlob = sqlite3_column_bytes(g.pStmt, i); in speedtest1_run()
598 const unsigned char *aBlob = sqlite3_column_blob(g.pStmt, i); in speedtest1_run()
604 g.nResByte += nBlob*2 + 2; in speedtest1_run()
607 g.nResByte += len + 2; in speedtest1_run()
611 if( g.nResult+len<sizeof(g.zResult)-2 ){ in speedtest1_run()
612 if( g.nResult>0 ) g.zResult[g.nResult++] = ' '; in speedtest1_run()
613 memcpy(g.zResult + g.nResult, z, len+1); in speedtest1_run()
614 g.nResult += len; in speedtest1_run()
619 if( g.bReprepare ){ in speedtest1_run()
621 sqlite3_prepare_v2(g.db, sqlite3_sql(g.pStmt), -1, &pNew, 0); in speedtest1_run()
622 sqlite3_finalize(g.pStmt); in speedtest1_run()
623 g.pStmt = pNew; in speedtest1_run()
627 sqlite3_reset(g.pStmt); in speedtest1_run()
738 sz = n = g.szTest*500; in testset_main()
744 isTemp(9), g.zNN, g.zNN, g.zNN); in testset_main()
749 sqlite3_bind_int64(g.pStmt, 1, (sqlite3_int64)x1); in testset_main()
750 sqlite3_bind_int(g.pStmt, 2, i); in testset_main()
751 sqlite3_bind_text(g.pStmt, 3, zNum, -1, SQLITE_STATIC); in testset_main()
763 isTemp(5), g.zNN, g.zPK, g.zNN, g.zNN, g.zWR); in testset_main()
768 sqlite3_bind_int(g.pStmt, 1, i); in testset_main()
769 sqlite3_bind_int64(g.pStmt, 2, (sqlite3_int64)x1); in testset_main()
770 sqlite3_bind_text(g.pStmt, 3, zNum, -1, SQLITE_STATIC); in testset_main()
782 isTemp(3), g.zNN, g.zPK, g.zNN, g.zNN, g.zWR); in testset_main()
787 sqlite3_bind_int(g.pStmt, 2, i); in testset_main()
788 sqlite3_bind_int64(g.pStmt, 1, (sqlite3_int64)x1); in testset_main()
789 sqlite3_bind_text(g.pStmt, 3, zNum, -1, SQLITE_STATIC); in testset_main()
796 sqlite3_create_function(g.db, "group_concat", 1, SQLITE_UTF8, 0, in testset_main()
808 if( (i-1)%g.nRepeat==0 ){ in testset_main()
812 sqlite3_bind_int(g.pStmt, 1, x1); in testset_main()
813 sqlite3_bind_int(g.pStmt, 2, x2); in testset_main()
828 if( (i-1)%g.nRepeat==0 ){ in testset_main()
835 sqlite3_bind_text(g.pStmt, 1, zNum, len+1, SQLITE_STATIC); in testset_main()
850 if( (i-1)%g.nRepeat==0 ){ in testset_main()
857 sqlite3_bind_text(g.pStmt, 1, zNum, len+1, SQLITE_STATIC); in testset_main()
871 if( (i-1)%g.nRepeat==0 ){ in testset_main()
878 sqlite3_bind_text(g.pStmt, 1, zNum, len+1, SQLITE_STATIC); in testset_main()
904 if( (i-1)%g.nRepeat==0 ){ in testset_main()
908 sqlite3_bind_int(g.pStmt, 1, x1); in testset_main()
909 sqlite3_bind_int(g.pStmt, 2, x2); in testset_main()
924 if( (i-1)%g.nRepeat==0 ){ in testset_main()
928 sqlite3_bind_int(g.pStmt, 1, x1); in testset_main()
929 sqlite3_bind_int(g.pStmt, 2, x2); in testset_main()
944 if( (i-1)%g.nRepeat==0 ){ in testset_main()
948 sqlite3_bind_text(g.pStmt, 1, zNum, len, SQLITE_STATIC); in testset_main()
963 isTemp(1), g.zNN, g.zPK, g.zNN, g.zNN, g.zWR); in testset_main()
997 sqlite3_bind_int(g.pStmt, 1, x1); in testset_main()
998 sqlite3_bind_int(g.pStmt, 2, x2); in testset_main()
1013 sqlite3_bind_int(g.pStmt, 1, x1); in testset_main()
1039 sqlite3_bind_int(g.pStmt, 1, x1); in testset_main()
1040 sqlite3_bind_int(g.pStmt, 2, x2); in testset_main()
1055 sqlite3_bind_int(g.pStmt, 1, x1); in testset_main()
1089 sqlite3_bind_int(g.pStmt, 1, x1); in testset_main()
1090 sqlite3_bind_int(g.pStmt, 2, x2); in testset_main()
1102 sqlite3_bind_int(g.pStmt, 1, est_square_root(g.szTest)*50); in testset_main()
1106 sz = n = g.szTest*700; in testset_main()
1112 isTemp(9), g.zNN); in testset_main()
1117 sqlite3_bind_int(g.pStmt, 1, (sqlite3_int64)x1); in testset_main()
1118 sqlite3_bind_text(g.pStmt, 2, zNum, -1, SQLITE_STATIC); in testset_main()
1124 if( g.doBigTransactions ){ in testset_main()
1136 sqlite3_bind_int(g.pStmt, 1, (sqlite3_int64)x1); in testset_main()
1139 if( g.doBigTransactions ){ in testset_main()
1144 sz = n = g.szTest*700; in testset_main()
1150 isTemp(9), g.zNN, in testset_main()
1156 sqlite3_bind_int(g.pStmt, 2, i); in testset_main()
1157 sqlite3_bind_text(g.pStmt, 1, zNum, -1, SQLITE_STATIC); in testset_main()
1163 if( g.doBigTransactions ){ in testset_main()
1171 sqlite3_bind_text(g.pStmt, 1, zNum, -1, SQLITE_STATIC); in testset_main()
1174 if( g.doBigTransactions ){ in testset_main()
1237 if( g.szTest<25 ){ in testset_cte()
1239 }else if( g.szTest<70 ){ in testset_cte()
1273 sqlite3_bind_text(g.pStmt, 1, zPuz, -1, SQLITE_STATIC); in testset_cte()
1303 sqlite3_bind_text(g.pStmt, 1, zPuz, -1, SQLITE_STATIC); in testset_cte()
1307 rSpacing = 5.0/g.szTest; in testset_cte()
1328 sqlite3_bind_double(g.pStmt, 1, rSpacing*.05); in testset_cte()
1329 sqlite3_bind_double(g.pStmt, 2, rSpacing); in testset_cte()
1333 nElem = 10000*g.szTest; in testset_cte()
1370 n = g.szTest*5000; in testset_fp()
1374 isTemp(1), g.zNN, g.zNN); in testset_fp()
1379 sqlite3_bind_text(g.pStmt, 1, zFP1, -1, SQLITE_STATIC); in testset_fp()
1380 sqlite3_bind_text(g.pStmt, 2, zFP2, -1, SQLITE_STATIC); in testset_fp()
1386 n = g.szTest/25 + 2; in testset_fp()
1392 sqlite3_bind_text(g.pStmt, 1, zFP1, -1, SQLITE_STATIC); in testset_fp()
1393 sqlite3_bind_text(g.pStmt, 2, zFP2, -1, SQLITE_STATIC); in testset_fp()
1406 n = g.szTest/3 + 2; in testset_fp()
1412 sqlite3_bind_text(g.pStmt, 1, zFP1, -1, SQLITE_STATIC); in testset_fp()
1413 sqlite3_bind_text(g.pStmt, 2, zFP2, -1, SQLITE_STATIC); in testset_fp()
1418 n = g.szTest*5000; in testset_fp()
1487 int *aCheck = sqlite3_malloc( sizeof(int)*g.szTest*500 ); in testset_rtree()
1490 mxRowid = n = g.szTest*500; in testset_rtree()
1500 sqlite3_bind_int(g.pStmt, 1, i); in testset_rtree()
1501 sqlite3_bind_int(g.pStmt, 2, x0); in testset_rtree()
1502 sqlite3_bind_int(g.pStmt, 3, x1); in testset_rtree()
1503 sqlite3_bind_int(g.pStmt, 4, y0); in testset_rtree()
1504 sqlite3_bind_int(g.pStmt, 5, y1); in testset_rtree()
1505 sqlite3_bind_int(g.pStmt, 6, z0); in testset_rtree()
1506 sqlite3_bind_int(g.pStmt, 7, z1); in testset_rtree()
1517 n = g.szTest*200; in testset_rtree()
1522 sqlite3_bind_int(g.pStmt, 1, i*iStep); in testset_rtree()
1523 sqlite3_bind_int(g.pStmt, 2, (i+1)*iStep); in testset_rtree()
1525 aCheck[i] = atoi(g.zResult); in testset_rtree()
1529 if( g.bVerify ){ in testset_rtree()
1530 n = g.szTest*200; in testset_rtree()
1535 sqlite3_bind_int(g.pStmt, 1, i*iStep); in testset_rtree()
1536 sqlite3_bind_int(g.pStmt, 2, (i+1)*iStep); in testset_rtree()
1538 if( aCheck[i]!=atoi(g.zResult) ){ in testset_rtree()
1540 i, i*iStep, (i+1)*iStep, aCheck[i], atoi(g.zResult)); in testset_rtree()
1546 n = g.szTest*200; in testset_rtree()
1551 sqlite3_bind_int(g.pStmt, 1, i*iStep); in testset_rtree()
1552 sqlite3_bind_int(g.pStmt, 2, (i+1)*iStep); in testset_rtree()
1554 aCheck[i] = atoi(g.zResult); in testset_rtree()
1558 if( g.bVerify ){ in testset_rtree()
1559 n = g.szTest*200; in testset_rtree()
1564 sqlite3_bind_int(g.pStmt, 1, i*iStep); in testset_rtree()
1565 sqlite3_bind_int(g.pStmt, 2, (i+1)*iStep); in testset_rtree()
1567 if( aCheck[i]!=atoi(g.zResult) ){ in testset_rtree()
1569 i, i*iStep, (i+1)*iStep, aCheck[i], atoi(g.zResult)); in testset_rtree()
1576 n = g.szTest*200; in testset_rtree()
1578 sqlite3_rtree_geometry_callback(g.db, "xslice", xsliceGeometryCallback, 0); in testset_rtree()
1582 sqlite3_bind_int(g.pStmt, 1, i*iStep); in testset_rtree()
1583 sqlite3_bind_int(g.pStmt, 2, (i+1)*iStep); in testset_rtree()
1585 if( aCheck[i]!=atoi(g.zResult) ){ in testset_rtree()
1587 i, i*iStep, (i+1)*iStep, aCheck[i], atoi(g.zResult)); in testset_rtree()
1592 n = g.szTest*400; in testset_rtree()
1598 sqlite3_bind_int(g.pStmt, 1, i*iStep); in testset_rtree()
1599 sqlite3_bind_int(g.pStmt, 2, (i+1)*iStep); in testset_rtree()
1601 aCheck[i] = atoi(g.zResult); in testset_rtree()
1605 n = g.szTest*500; in testset_rtree()
1609 sqlite3_bind_int(g.pStmt, 1, i); in testset_rtree()
1614 n = g.szTest*50; in testset_rtree()
1618 sqlite3_bind_int(g.pStmt, 1, (i*251)%mxRowid + 1); in testset_rtree()
1623 n = g.szTest*5; in testset_rtree()
1629 sqlite3_bind_int(g.pStmt, 1, i*iStep); in testset_rtree()
1631 aCheck[i] = atoi(g.zResult); in testset_rtree()
1635 n = g.szTest*50; in testset_rtree()
1639 sqlite3_bind_int(g.pStmt, 1, (i*257)%mxRowid + 1); in testset_rtree()
1645 n = g.szTest*5; in testset_rtree()
1650 sqlite3_bind_int(g.pStmt, 1, i*iStep); in testset_rtree()
1652 aCheck[i] = atoi(g.zResult); in testset_rtree()
1675 nRow = n = g.szTest*250; in testset_orm()
1856 sqlite3_bind_int(g.pStmt, 1, i^0xf); in testset_orm()
1861 sqlite3_bind_int64(g.pStmt, j+2, x1); in testset_orm()
1864 sqlite3_bind_double(g.pStmt, j+2, (double)x1); in testset_orm()
1868 sqlite3_bind_text64(g.pStmt, j+2, zNum, len, in testset_orm()
1878 n = g.szTest*250; in testset_orm()
1925 sqlite3_bind_int(g.pStmt, 1, x1); in testset_orm()
1937 const int NROW = 500*g.szTest; in testset_trigger()
1938 const int NROW2 = 100*g.szTest; in testset_trigger()
1954 sqlite3_bind_int(g.pStmt, 1, x1); in testset_trigger()
1955 sqlite3_bind_text(g.pStmt, 2, zNum, -1, SQLITE_STATIC); in testset_trigger()
1984 sqlite3_bind_int(g.pStmt, 1, ii*3); in testset_trigger()
1994 sqlite3_bind_int(g.pStmt, 1, ii*3); in testset_trigger()
2004 sqlite3_bind_int(g.pStmt, 1, ii*3); in testset_trigger()
2017 sqlite3_bind_int(g.pStmt, 1, jj*3); in testset_trigger()
2026 sqlite3_bind_int(g.pStmt, 1, jj); in testset_trigger()
2056 sqlite3_bind_int(g.pStmt, 1, jj); in testset_trigger()
2057 sqlite3_bind_text(g.pStmt, 2, zNum, -1, SQLITE_STATIC); in testset_trigger()
2071 sqlite3_bind_int(g.pStmt, 1, jj*2); in testset_trigger()
2072 sqlite3_bind_text(g.pStmt, 2, zNum, -1, SQLITE_STATIC); in testset_trigger()
2073 sqlite3_bind_int(g.pStmt, 3, jj); in testset_trigger()
2084 sqlite3_bind_int(g.pStmt, 1, jj*2); in testset_trigger()
2107 sqlite3_bind_int(g.pStmt, 1, jj); in testset_trigger()
2108 sqlite3_bind_text(g.pStmt, 2, zNum, -1, SQLITE_STATIC); in testset_trigger()
2116 sqlite3_bind_int(g.pStmt, 1, jj*2); in testset_trigger()
2117 sqlite3_bind_text(g.pStmt, 2, zNum, -1, SQLITE_STATIC); in testset_trigger()
2118 sqlite3_bind_int(g.pStmt, 3, jj); in testset_trigger()
2125 sqlite3_bind_int(g.pStmt, 1, jj*2); in testset_trigger()
2140 n = g.szTest; in testset_debug1()
2235 memset(&g, 0, sizeof(g)); in main()
2250 g.zWR = ""; in main()
2251 g.zNN = ""; in main()
2252 g.zPK = "UNIQUE"; in main()
2253 g.szTest = 100; in main()
2254 g.nRepeat = 1; in main()
2262 g.doBigTransactions = 1; in main()
2269 g.doCheckpoint = 1; in main()
2271 g.bSqlOnly = 1; in main()
2272 g.bExplain = 1; in main()
2309 g.zNN = "NOT NULL"; in main()
2318 g.hashFile = stdout; in main()
2320 g.hashFile = fopen(argv[i], "wb"); in main()
2321 if( g.hashFile==0 ){ in main()
2336 g.zPK = "PRIMARY KEY"; in main()
2339 g.nRepeat = integerValue(argv[++i]); in main()
2341 g.bReprepare = 1; in main()
2350 if( g.pScript ) fclose(g.pScript); in main()
2351 g.pScript = fopen(argv[++i], "wb"); in main()
2352 if( g.pScript==0 ){ in main()
2356 g.bSqlOnly = 1; in main()
2358 g.bMemShrink = 1; in main()
2361 g.szTest = integerValue(argv[++i]); in main()
2370 g.eTemp = argv[i][0] - '0'; in main()
2384 g.bVerify = 1; in main()
2393 g.nReserve = atoi(argv[++i]); in main()
2395 if( strstr(g.zWR,"WITHOUT")!=0 ){ in main()
2397 }else if( strstr(g.zWR,"STRICT")!=0 ){ in main()
2398 g.zWR = "WITHOUT ROWID,STRICT"; in main()
2400 g.zWR = "WITHOUT ROWID"; in main()
2402 g.zPK = "PRIMARY KEY"; in main()
2404 if( strstr(g.zWR,"STRICT")!=0 ){ in main()
2406 }else if( strstr(g.zWR,"WITHOUT")!=0 ){ in main()
2407 g.zWR = "WITHOUT ROWID,STRICT"; in main()
2409 g.zWR = "STRICT"; in main()
2463 if( sqlite3_open_v2(memDb ? ":memory:" : zDbName, &g.db, in main()
2470 rc = sqlite3_db_config(g.db, SQLITE_DBCONFIG_LOOKASIDE,pLook,szLook,nLook); in main()
2474 if( g.nReserve>0 ){ in main()
2475 sqlite3_file_control(g.db, 0, SQLITE_FCNTL_RESERVE_BYTES, &g.nReserve); in main()
2479 sqlite3_create_function(g.db, "random", 0, SQLITE_UTF8, 0, randomFunc, 0, 0); in main()
2481 if( doTrace ) sqlite3_trace(g.db, traceCallback, 0); in main()
2515 if( g.bExplain ) printf(".explain\n.echo on\n"); in main()
2525 if( g.iTotal>0 || zComma!=0 ){ in main()
2581 sqlite3_exec(g.db, "PRAGMA compile_options", xCompileOptions, 0, 0); in main()
2588 sqlite3_db_status(g.db, SQLITE_DBSTATUS_LOOKASIDE_USED, &iCur, &iHi, 0); in main()
2590 sqlite3_db_status(g.db, SQLITE_DBSTATUS_LOOKASIDE_HIT, &iCur, &iHi, 0); in main()
2592 sqlite3_db_status(g.db, SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE, &iCur,&iHi,0); in main()
2594 sqlite3_db_status(g.db, SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL, &iCur,&iHi,0); in main()
2596 sqlite3_db_status(g.db, SQLITE_DBSTATUS_CACHE_USED, &iCur, &iHi, 0); in main()
2598 sqlite3_db_status(g.db, SQLITE_DBSTATUS_CACHE_HIT, &iCur, &iHi, 1); in main()
2600 sqlite3_db_status(g.db, SQLITE_DBSTATUS_CACHE_MISS, &iCur, &iHi, 1); in main()
2603 sqlite3_db_status(g.db, SQLITE_DBSTATUS_CACHE_WRITE, &iCur, &iHi, 1); in main()
2606 sqlite3_db_status(g.db, SQLITE_DBSTATUS_SCHEMA_USED, &iCur, &iHi, 0); in main()
2608 sqlite3_db_status(g.db, SQLITE_DBSTATUS_STMT_USED, &iCur, &iHi, 0); in main()
2613 sqlite3_close(g.db); in main()
2639 if( g.pScript ){ in main()
2640 fclose(g.pScript); in main()