100fd957bSdanielk1977# 2005 November 30 200fd957bSdanielk1977# 300fd957bSdanielk1977# The author disclaims copyright to this source code. In place of 400fd957bSdanielk1977# a legal notice, here is a blessing: 500fd957bSdanielk1977# 600fd957bSdanielk1977# May you do good and not evil. 700fd957bSdanielk1977# May you find forgiveness for yourself and forgive others. 800fd957bSdanielk1977# May you share freely, never taking more than you give. 900fd957bSdanielk1977# 1000fd957bSdanielk1977#*********************************************************************** 1100fd957bSdanielk1977# 1200fd957bSdanielk1977# This file contains tests to ensure that the library handles malloc() failures 1300fd957bSdanielk1977# correctly. The emphasis in this file is on sqlite3_column_XXX() APIs. 1400fd957bSdanielk1977# 15*eee4c8caSdrh# $Id: malloc4.test,v 1.10 2008/02/18 22:24:58 drh Exp $ 1600fd957bSdanielk1977 1700fd957bSdanielk1977#--------------------------------------------------------------------------- 1800fd957bSdanielk1977# NOTES ON EXPECTED BEHAVIOUR 1900fd957bSdanielk1977# 202e588c75Sdanielk1977# [193] When a memory allocation failure occurs during sqlite3_column_name(), 212e588c75Sdanielk1977# sqlite3_column_name16(), sqlite3_column_decltype(), or 222e588c75Sdanielk1977# sqlite3_column_decltype16() the function shall return NULL. 232e588c75Sdanielk1977# 2400fd957bSdanielk1977#--------------------------------------------------------------------------- 2500fd957bSdanielk1977 2600fd957bSdanielk1977set testdir [file dirname $argv0] 2700fd957bSdanielk1977source $testdir/tester.tcl 28*eee4c8caSdrhsource $testdir/malloc_common.tcl 2900fd957bSdanielk1977 3000fd957bSdanielk1977# Only run these tests if memory debugging is turned on. 31*eee4c8caSdrhif {!$MEMDEBUG} { 325a3032b3Sdrh puts "Skipping malloc4 tests: not compiled with -DSQLITE_MEMDEBUG..." 3300fd957bSdanielk1977 finish_test 3400fd957bSdanielk1977 return 3500fd957bSdanielk1977} 3600fd957bSdanielk1977 37a1686c9aSdanielk1977ifcapable !utf16 { 38a1686c9aSdanielk1977 finish_test 39a1686c9aSdanielk1977 return 40a1686c9aSdanielk1977} 41a1686c9aSdanielk1977 4200fd957bSdanielk1977proc do_stmt_test {id sql} { 4300fd957bSdanielk1977 set ::sql $sql 4400fd957bSdanielk1977 set go 1 45744f5748Sdanielk1977 for {set n 0} {$go} {incr n} { 46ed138fb3Sdrh set testid "malloc4-$id.$n" 4700fd957bSdanielk1977 4800fd957bSdanielk1977 # Prepare the statement 4900fd957bSdanielk1977 do_test ${testid}.1 { 5000fd957bSdanielk1977 set ::STMT [sqlite3_prepare $::DB $sql -1 TAIL] 5100fd957bSdanielk1977 expr [string length $::STMT] > 0 5200fd957bSdanielk1977 } {1} 5300fd957bSdanielk1977 5400fd957bSdanielk1977 # Set the Nth malloc() to fail. 55744f5748Sdanielk1977 sqlite3_memdebug_fail $n -repeat 0 5600fd957bSdanielk1977 5700fd957bSdanielk1977 # Test malloc failure in the _name(), _name16(), decltype() and 5800fd957bSdanielk1977 # decltype16() APIs. Calls that occur after the malloc() failure should 5900fd957bSdanielk1977 # return NULL. No error is raised though. 602e588c75Sdanielk1977 # 612e588c75Sdanielk1977 # ${testid}.2.1 - Call _name() 622e588c75Sdanielk1977 # ${testid}.2.2 - Call _name16() 632e588c75Sdanielk1977 # ${testid}.2.3 - Call _name() 642e588c75Sdanielk1977 # ${testid}.2.4 - Check that the return values of the above three calls are 652e588c75Sdanielk1977 # consistent with each other and with the simulated 662e588c75Sdanielk1977 # malloc() failures. 672e588c75Sdanielk1977 # 682e588c75Sdanielk1977 # Because the code that implements the _decltype() and _decltype16() APIs 692e588c75Sdanielk1977 # is the same as the _name() and _name16() implementations, we don't worry 702e588c75Sdanielk1977 # about explicitly testing them. 712e588c75Sdanielk1977 # 7200fd957bSdanielk1977 do_test ${testid}.2.1 { 734a50aac5Sdrh set mf1 [expr [sqlite3_memdebug_pending] < 0] 7400fd957bSdanielk1977 set ::name8 [sqlite3_column_name $::STMT 0] 754a50aac5Sdrh set mf2 [expr [sqlite3_memdebug_pending] < 0] 7600fd957bSdanielk1977 expr {$mf1 == $mf2 || $::name8 == ""} 7700fd957bSdanielk1977 } {1} 7800fd957bSdanielk1977 do_test ${testid}.2.2 { 794a50aac5Sdrh set mf1 [expr [sqlite3_memdebug_pending] < 0] 8000fd957bSdanielk1977 set ::name16 [sqlite3_column_name16 $::STMT 0] 8100fd957bSdanielk1977 set ::name16 [encoding convertfrom unicode $::name16] 8200fd957bSdanielk1977 set ::name16 [string range $::name16 0 end-1] 834a50aac5Sdrh set mf2 [expr [sqlite3_memdebug_pending] < 0] 8400fd957bSdanielk1977 expr {$mf1 == $mf2 || $::name16 == ""} 8500fd957bSdanielk1977 } {1} 8600fd957bSdanielk1977 do_test ${testid}.2.3 { 874a50aac5Sdrh set mf1 [expr [sqlite3_memdebug_pending] < 0] 8800fd957bSdanielk1977 set ::name8_2 [sqlite3_column_name $::STMT 0] 894a50aac5Sdrh set mf2 [expr [sqlite3_memdebug_pending] < 0] 9000fd957bSdanielk1977 expr {$mf1 == $mf2 || $::name8_2 == ""} 9100fd957bSdanielk1977 } {1} 924a50aac5Sdrh set ::mallocFailed [expr [sqlite3_memdebug_pending] < 0] 9300fd957bSdanielk1977 do_test ${testid}.2.4 { 9400fd957bSdanielk1977 expr { 9500fd957bSdanielk1977 $::name8 == $::name8_2 && $::name16 == $::name8 && !$::mallocFailed || 9600fd957bSdanielk1977 $::name8 == $::name8_2 && $::name16 == "" && $::mallocFailed || 9700fd957bSdanielk1977 $::name8 == $::name16 && $::name8_2 == "" && $::mallocFailed || 9800fd957bSdanielk1977 $::name8_2 == $::name16 && $::name8 == "" && $::mallocFailed 9900fd957bSdanielk1977 } 10000fd957bSdanielk1977 } {1} 10100fd957bSdanielk1977 1022e588c75Sdanielk1977 # Step the statement so that we can call _text() and _text16(). Before 1032e588c75Sdanielk1977 # running sqlite3_step(), make sure that malloc() is not about to fail. 1042e588c75Sdanielk1977 # Memory allocation failures that occur within sqlite3_step() are tested 1052e588c75Sdanielk1977 # elsewhere. 106ed138fb3Sdrh set mf [sqlite3_memdebug_pending] 107ed138fb3Sdrh sqlite3_memdebug_fail -1 1082e588c75Sdanielk1977 do_test ${testid}.3 { 1092e588c75Sdanielk1977 sqlite3_step $::STMT 1102e588c75Sdanielk1977 } {SQLITE_ROW} 111ed138fb3Sdrh sqlite3_memdebug_fail $mf 1122e588c75Sdanielk1977 1132e588c75Sdanielk1977 # Test for malloc() failures within _text() and _text16(). 1142e588c75Sdanielk1977 # 1152e588c75Sdanielk1977 do_test ${testid}.4.1 { 1162e588c75Sdanielk1977 set ::text8 [sqlite3_column_text $::STMT 0] 1174a50aac5Sdrh set mf [expr [sqlite3_memdebug_pending] < 0 && !$::mallocFailed] 1182e588c75Sdanielk1977 expr {$mf==0 || $::text8 == ""} 1192e588c75Sdanielk1977 } {1} 1202e588c75Sdanielk1977 do_test ${testid}.4.2 { 1212e588c75Sdanielk1977 set ::text16 [sqlite3_column_text16 $::STMT 0] 1222e588c75Sdanielk1977 set ::text16 [encoding convertfrom unicode $::text16] 1232e588c75Sdanielk1977 set ::text16 [string range $::text16 0 end-1] 1244a50aac5Sdrh set mf [expr [sqlite3_memdebug_pending] < 0 && !$::mallocFailed] 1252e588c75Sdanielk1977 expr {$mf==0 || $::text16 == ""} 1262e588c75Sdanielk1977 } {1} 1272e588c75Sdanielk1977 do_test ${testid}.4.3 { 1282e588c75Sdanielk1977 set ::text8_2 [sqlite3_column_text $::STMT 0] 1294a50aac5Sdrh set mf [expr [sqlite3_memdebug_pending] < 0 && !$::mallocFailed] 1302e588c75Sdanielk1977 expr {$mf==0 || $::text8_2 == "" || ($::text16 == "" && $::text8 != "")} 1312e588c75Sdanielk1977 } {1} 1322e588c75Sdanielk1977 1332e588c75Sdanielk1977 # Test for malloc() failures within _int(), _int64() and _real(). The only 1342e588c75Sdanielk1977 # way this can occur is if the string has to be translated from UTF-16 to 1352e588c75Sdanielk1977 # UTF-8 before being converted to a numeric value. 1362e588c75Sdanielk1977 do_test ${testid}.4.4.1 { 137ed138fb3Sdrh set mf [sqlite3_memdebug_pending] 138ed138fb3Sdrh sqlite3_memdebug_fail -1 1392e588c75Sdanielk1977 sqlite3_column_text16 $::STMT 0 140ed138fb3Sdrh sqlite3_memdebug_fail $mf 1412e588c75Sdanielk1977 sqlite3_column_int $::STMT 0 1422e588c75Sdanielk1977 } {0} 1432e588c75Sdanielk1977 do_test ${testid}.4.5 { 144ed138fb3Sdrh set mf [sqlite3_memdebug_pending] 145ed138fb3Sdrh sqlite3_memdebug_fail -1 1462e588c75Sdanielk1977 sqlite3_column_text16 $::STMT 0 147ed138fb3Sdrh sqlite3_memdebug_fail $mf 1482e588c75Sdanielk1977 sqlite3_column_int64 $::STMT 0 1492e588c75Sdanielk1977 } {0} 1502e588c75Sdanielk1977 1512e588c75Sdanielk1977 do_test ${testid}.4.6 { 152ed138fb3Sdrh set mf [sqlite3_memdebug_pending] 153ed138fb3Sdrh sqlite3_memdebug_fail -1 1542e588c75Sdanielk1977 sqlite3_column_text16 $::STMT 0 155ed138fb3Sdrh sqlite3_memdebug_fail $mf 1562e588c75Sdanielk1977 sqlite3_column_double $::STMT 0 1572e588c75Sdanielk1977 } {0.0} 1582e588c75Sdanielk1977 1592e588c75Sdanielk1977 set mallocFailedAfterStep [expr \ 1604a50aac5Sdrh [sqlite3_memdebug_pending] < 0 && !$::mallocFailed 1612e588c75Sdanielk1977 ] 1622e588c75Sdanielk1977 163ed138fb3Sdrh sqlite3_memdebug_fail -1 1642e588c75Sdanielk1977 # Test that if a malloc() failed the next call to sqlite3_step() returns 1652e588c75Sdanielk1977 # SQLITE_ERROR. If malloc() did not fail, it should return SQLITE_DONE. 1662e588c75Sdanielk1977 # 1672e588c75Sdanielk1977 do_test ${testid}.5 { 1682e588c75Sdanielk1977 sqlite3_step $::STMT 1692e588c75Sdanielk1977 } [expr {$mallocFailedAfterStep ? "SQLITE_ERROR" : "SQLITE_DONE"}] 1702e588c75Sdanielk1977 1712e588c75Sdanielk1977 do_test ${testid}.6 { 1722e588c75Sdanielk1977 sqlite3_finalize $::STMT 1732e588c75Sdanielk1977 } [expr {$mallocFailedAfterStep ? "SQLITE_NOMEM" : "SQLITE_OK"}] 1742e588c75Sdanielk1977 1752e588c75Sdanielk1977 if {$::mallocFailed == 0 && $mallocFailedAfterStep == 0} { 176ed138fb3Sdrh sqlite3_memdebug_fail -1 17700fd957bSdanielk1977 set go 0 17800fd957bSdanielk1977 } 17900fd957bSdanielk1977 } 18000fd957bSdanielk1977} 18100fd957bSdanielk1977 18200fd957bSdanielk1977execsql { 18300fd957bSdanielk1977 CREATE TABLE tbl( 18400fd957bSdanielk1977 the_first_reasonably_long_column_name that_also_has_quite_a_lengthy_type 18500fd957bSdanielk1977 ); 1862e588c75Sdanielk1977 INSERT INTO tbl VALUES( 1872e588c75Sdanielk1977 'An extra long string. Far too long to be stored in NBFS bytes.' 1882e588c75Sdanielk1977 ); 18900fd957bSdanielk1977} 1902e588c75Sdanielk1977 19100fd957bSdanielk1977do_stmt_test 1 "SELECT * FROM tbl" 19200fd957bSdanielk1977 193ed138fb3Sdrhsqlite3_memdebug_fail -1 19400fd957bSdanielk1977finish_test 195