Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Enhanced to verify that the correct number of rows is returned from each query. See SQLite Forum post 115a6fedd9. |
|---|---|
| Timelines: | family | ancestors | trunk |
| Files: | files | file ages | folders |
| SHA1: |
c5ec0e8e41a8106c9f564c498b58d8c2 |
| User & Date: | drh 2024-11-15 00:01:36 |
Context
|
2024-11-15
| ||
| 00:01 | Enhanced to verify that the correct number of rows is returned from each query. See SQLite Forum post 115a6fedd9. Leaf check-in: c5ec0e8e41 user: drh tags: trunk | |
|
2024-10-18
| ||
| 16:23 | Update the built-in SQLite to the latest 3.47.0 beta. check-in: 7dda571435 user: drh tags: trunk | |
Changes
Changes to src/sqllogictest.c.
| ︙ | ︙ | |||
669 670 671 672 673 674 675 |
/* Compare subsequent lines of the script against the results
** from the query. Report an error if any differences are found.
*/
if( hashThreshold==0 || nResult<=hashThreshold ){
for(i=0; i<nResult && sScript.zLine[0]; nextLine(&sScript), i++){
if( strcmp(sScript.zLine, azResult[i])!=0 ){
| | | < > > > > > > > > > > | 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 |
/* Compare subsequent lines of the script against the results
** from the query. Report an error if any differences are found.
*/
if( hashThreshold==0 || nResult<=hashThreshold ){
for(i=0; i<nResult && sScript.zLine[0]; nextLine(&sScript), i++){
if( strcmp(sScript.zLine, azResult[i])!=0 ){
fprintf(stdout,"%s:%d: wrong result - expected [%s] got [%s]\n",
zScriptFile, sScript.nLine, sScript.zLine, azResult[i]);
nErr++;
}
}
if( i<nResult ){
fprintf(stdout,"%s:%d: too many result rows - expected %d got %d\n",
zScriptFile, sScript.nLine, i, nResult);
nErr++;
}else if( sScript.zLine[0] ){
do{ nextLine(&sScript); i++; }while( sScript.zLine[0] );
fprintf(stdout,"%s:%d: too few result rows - expected %d got %d\n",
zScriptFile, sScript.nLine, i, nResult);
nErr++;
}
}else{
if( strcmp(sScript.zLine, zHash)!=0 ){
fprintf(stderr, "%s:%d: wrong result hash\n",
zScriptFile, sScript.nLine);
nErr++;
}
|
| ︙ | ︙ |
Changes to test/evidence/slt_lang_aggfunc.test.
| ︙ | ︙ | |||
471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 | INSERT INTO t1 VALUES(1<<63,'true'); statement ok INSERT INTO t1 VALUES(1<<63,'true'); statement ok INSERT INTO t1 VALUES(-1,'true'); query R nosort SELECT sum(x) FROM t1 ---- query R nosort SELECT sum(DISTINCT x) FROM t1 ---- | > | > > | 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 | INSERT INTO t1 VALUES(1<<63,'true'); statement ok INSERT INTO t1 VALUES(1<<63,'true'); statement ok INSERT INTO t1 VALUES(-1,'true'); DROP INDEX t1i1; query R nosort SELECT sum(x) FROM t1 ---- query R nosort SELECT sum(DISTINCT x) FROM t1 ---- -9223372036854776000.000 # TBD-EVIDENCE-OF: R-19553-64528 Total() never throws an integer overflow. query R nosort SELECT total(x) FROM t1 ---- -18446744073709550000.000 query R nosort SELECT total(DISTINCT x) FROM t1 ---- -9223372036854776000.000 |
Changes to test/index/commute/10/slt_good_10.test.
| ︙ | ︙ | |||
26506 26507 26508 26509 26510 26511 26512 | query I rowsort label-4220 SELECT pk FROM tab3 WHERE ((60.6 < col4 AND 32 > col3 AND ((53 > col0) OR 54 > col0))) ---- query I rowsort label-4220 SELECT pk FROM tab4 WHERE ((col4 > 60.6 AND col3 < 32 AND ((col0 < 53) OR col0 < 54))) | > | 26506 26507 26508 26509 26510 26511 26512 26513 | query I rowsort label-4220 SELECT pk FROM tab3 WHERE ((60.6 < col4 AND 32 > col3 AND ((53 > col0) OR 54 > col0))) ---- query I rowsort label-4220 SELECT pk FROM tab4 WHERE ((col4 > 60.6 AND col3 < 32 AND ((col0 < 53) OR col0 < 54))) ---- |