persistentstorage/sqlite3api/TEST/TclScript/misc6.test
changeset 0 08ec8eefde2f
equal deleted inserted replaced
-1:000000000000 0:08ec8eefde2f
       
     1 # 2006 September 4
       
     2 #
       
     3 # The author disclaims copyright to this source code.  In place of
       
     4 # a legal notice, here is a blessing:
       
     5 #
       
     6 #    May you do good and not evil.
       
     7 #    May you find forgiveness for yourself and forgive others.
       
     8 #    May you share freely, never taking more than you give.
       
     9 #
       
    10 #***********************************************************************
       
    11 # This file implements regression tests for SQLite library.
       
    12 #
       
    13 # This file implements tests to make sure sqlite3_value_text()
       
    14 # always returns a null-terminated string.
       
    15 #
       
    16 # $Id: misc6.test,v 1.3 2007/04/23 23:56:32 drh Exp $
       
    17 
       
    18 set testdir [file dirname $argv0]
       
    19 source $testdir/tester.tcl
       
    20 
       
    21 do_test misc6-1.1 {
       
    22   set DB [sqlite3_connection_pointer db]
       
    23   sqlite3_create_function $DB
       
    24   set STMT [sqlite3_prepare $DB {SELECT hex8(?)} -1 DUMMY]
       
    25   set sqlite_static_bind_value {0123456789}
       
    26   set sqlite_static_bind_nbyte 5
       
    27   sqlite_bind $STMT 1 {} static-nbytes
       
    28   sqlite3_step $STMT
       
    29 } SQLITE_ROW
       
    30 do_test misc6-1.2 {
       
    31   sqlite3_column_text $STMT 0
       
    32 } {3031323334}
       
    33 ifcapable utf16 {
       
    34   do_test misc6-1.3 {
       
    35     sqlite3_finalize $STMT
       
    36     set STMT [sqlite3_prepare $DB {SELECT hex16(?)} -1 DUMMY]
       
    37     set sqlite_static_bind_value {0123456789}
       
    38     set sqlite_static_bind_nbyte 5
       
    39     sqlite_bind $STMT 1 {} static-nbytes
       
    40     sqlite3_step $STMT
       
    41   } SQLITE_ROW
       
    42   do_test misc6-1.4 {
       
    43     sqlite3_column_text $STMT 0
       
    44   } {00300031003200330034}
       
    45 }
       
    46 sqlite3_finalize $STMT
       
    47 
       
    48 finish_test