xref: /sqlite-3.40.0/test/malloc4.test (revision eee4c8ca)
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