1# 2001 September 15 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. The 12# focus of this file is testing the sqlite_*_printf() interface. 13# 14# $Id: printf.test,v 1.21 2006/03/19 13:00:25 drh Exp $ 15 16set testdir [file dirname $argv0] 17source $testdir/tester.tcl 18 19set n 1 20foreach v {1 2 5 10 99 100 1000000 999999999 0 -1 -2 -5 -10 -99 -100 -9999999} { 21 set v32 [expr {$v&0xffffffff}] 22 do_test printf-1.$n.1 [subst { 23 sqlite3_mprintf_int {Three integers: %d %x %o} $v $v $v 24 }] [format {Three integers: %d %x %o} $v $v32 $v32] 25 do_test printf-1.$n.2 [subst { 26 sqlite3_mprintf_int {Three integers: (%6d) (%6x) (%6o)} $v $v $v 27 }] [format {Three integers: (%6d) (%6x) (%6o)} $v $v32 $v32] 28 do_test printf-1.$n.3 [subst { 29 sqlite3_mprintf_int {Three integers: (%-6d) (%-6x) (%-6o)} $v $v $v 30 }] [format {Three integers: (%-6d) (%-6x) (%-6o)} $v $v32 $v32] 31 do_test printf-1.$n.4 [subst { 32 sqlite3_mprintf_int {Three integers: (%+6d) (%+6x) (%+6o)} $v $v $v 33 }] [format {Three integers: (%+6d) (%+6x) (%+6o)} $v $v32 $v32] 34 do_test printf-1.$n.5 [subst { 35 sqlite3_mprintf_int {Three integers: (%06d) (%06x) (%06o)} $v $v $v 36 }] [format {Three integers: (%06d) (%06x) (%06o)} $v $v32 $v32] 37 do_test printf-1.$n.6 [subst { 38 sqlite3_mprintf_int {Three integers: (% 6d) (% 6x) (% 6o)} $v $v $v 39 }] [format {Three integers: (% 6d) (% 6x) (% 6o)} $v $v32 $v32] 40 do_test printf-1.$n.7 [subst { 41 sqlite3_mprintf_int {Three integers: (%#6d) (%#6x) (%#6o)} $v $v $v 42 }] [format {Three integers: (%#6d) (%#6x) (%#6o)} $v $v32 $v32] 43 incr n 44} 45 46 47if {$::tcl_platform(platform)!="windows"} { 48 49set m 1 50foreach {a b} {1 1 5 5 10 10 10 5} { 51 set n 1 52 foreach x {0.001 1.0e-20 1.0 0.0 100.0 9.99999 -0.00543 -1.0 -99.99999} { 53 do_test printf-2.$m.$n.1 [subst { 54 sqlite3_mprintf_double {A double: %*.*f} $a $b $x 55 }] [format {A double: %*.*f} $a $b $x] 56 do_test printf-2.$m.$n.2 [subst { 57 sqlite3_mprintf_double {A double: %*.*e} $a $b $x 58 }] [format {A double: %*.*e} $a $b $x] 59 do_test printf-2.$m.$n.3 [subst { 60 sqlite3_mprintf_double {A double: %*.*g} $a $b $x 61 }] [format {A double: %*.*g} $a $b $x] 62 do_test printf-2.$m.$n.4 [subst { 63 sqlite3_mprintf_double {A double: %d %d %g} $a $b $x 64 }] [format {A double: %d %d %g} $a $b $x] 65 do_test printf-2.$m.$n.5 [subst { 66 sqlite3_mprintf_double {A double: %d %d %#g} $a $b $x 67 }] [format {A double: %d %d %#g} $a $b $x] 68 do_test printf-2.$m.$n.6 [subst { 69 sqlite3_mprintf_double {A double: %d %d %010g} $a $b $x 70 }] [format {A double: %d %d %010g} $a $b $x] 71 incr n 72 } 73 incr m 74} 75 76} ;# endif not windows 77 78do_test printf-3.1 { 79 sqlite3_mprintf_str {A String: (%*.*s)} 10 10 {This is the string} 80} [format {A String: (%*.*s)} 10 10 {This is the string}] 81do_test printf-3.2 { 82 sqlite3_mprintf_str {A String: (%*.*s)} 10 5 {This is the string} 83} [format {A String: (%*.*s)} 10 5 {This is the string}] 84do_test printf-3.3 { 85 sqlite3_mprintf_str {A String: (%*.*s)} -10 5 {This is the string} 86} [format {A String: (%*.*s)} -10 5 {This is the string}] 87do_test printf-3.4 { 88 sqlite3_mprintf_str {%d %d A String: (%s)} 1 2 {This is the string} 89} [format {%d %d A String: (%s)} 1 2 {This is the string}] 90do_test printf-3.5 { 91 sqlite3_mprintf_str {%d %d A String: (%30s)} 1 2 {This is the string} 92} [format {%d %d A String: (%30s)} 1 2 {This is the string}] 93do_test printf-3.6 { 94 sqlite3_mprintf_str {%d %d A String: (%-30s)} 1 2 {This is the string} 95} [format {%d %d A String: (%-30s)} 1 2 {This is the string}] 96 97do_test printf-4.1 { 98 sqlite3_mprintf_str {%d %d A quoted string: '%q'} 1 2 {Hi Y'all} 99} {1 2 A quoted string: 'Hi Y''all'} 100do_test printf-4.2 { 101 sqlite3_mprintf_str {%d %d A NULL pointer in %%q: '%q'} 1 2 102} {1 2 A NULL pointer in %q: '(NULL)'} 103do_test printf-4.3 { 104 sqlite3_mprintf_str {%d %d A quoted string: %Q} 1 2 {Hi Y'all} 105} {1 2 A quoted string: 'Hi Y''all'} 106do_test printf-4.4 { 107 sqlite3_mprintf_str {%d %d A NULL pointer in %%Q: %Q} 1 2 108} {1 2 A NULL pointer in %Q: NULL} 109 110do_test printf-5.1 { 111 set x [sqlite3_mprintf_str {%d %d %100000s} 0 0 {Hello}] 112 string length $x 113} {344} 114do_test printf-5.2 { 115 sqlite3_mprintf_str {%d %d (%-10.10s) %} -9 -10 {HelloHelloHello} 116} {-9 -10 (HelloHello) %} 117 118do_test printf-6.1 { 119 sqlite3_mprintf_z_test , one two three four five six 120} {,one,two,three,four,five,six} 121 122 123do_test printf-7.1 { 124 sqlite3_mprintf_scaled {A double: %g} 1.0e307 1.0 125} {A double: 1e+307} 126do_test printf-7.2 { 127 sqlite3_mprintf_scaled {A double: %g} 1.0e307 10.0 128} {A double: 1e+308} 129do_test printf-7.3 { 130 sqlite3_mprintf_scaled {A double: %g} 1.0e307 100.0 131} {A double: NaN} 132 133do_test printf-8.1 { 134 sqlite3_mprintf_int {%u %u %u} 0x7fffffff 0x80000000 0xffffffff 135} {2147483647 2147483648 4294967295} 136do_test printf-8.2 { 137 sqlite3_mprintf_int {%lu %lu %lu} 0x7fffffff 0x80000000 0xffffffff 138} {2147483647 2147483648 4294967295} 139do_test printf-8.3 { 140 sqlite3_mprintf_int64 {%llu %llu %llu} 2147483647 2147483648 4294967296 141} {2147483647 2147483648 4294967296} 142do_test printf-8.4 { 143 sqlite3_mprintf_int64 {%lld %lld %lld} 2147483647 2147483648 4294967296 144} {2147483647 2147483648 4294967296} 145do_test printf-8.5 { 146 sqlite3_mprintf_int64 {%llx %llx %llx} 2147483647 2147483648 4294967296 147} {7fffffff 80000000 100000000} 148do_test printf-8.6 { 149 sqlite3_mprintf_int64 {%llx %llo %lld} -1 -1 -1 150} {ffffffffffffffff 1777777777777777777777 -1} 151 152do_test printf-9.1 { 153 sqlite3_mprintf_int {%*.*c} 4 4 65 154} {AAAA} 155do_test printf-9.2 { 156 sqlite3_mprintf_int {%*.*c} -4 1 66 157} {B } 158do_test printf-9.3 { 159 sqlite3_mprintf_int {%*.*c} 4 1 67 160} { C} 161do_test printf-9.4 { 162 sqlite3_mprintf_int {%d %d %c} 4 1 67 163} {4 1 C} 164set ten { } 165set fifty $ten$ten$ten$ten$ten 166do_test printf-9.5 { 167 sqlite3_mprintf_int {%d %*c} 1 -201 67 168} "1 C$fifty$fifty$fifty$fifty" 169do_test printf-9.6 { 170 sqlite3_mprintf_int {hi%12345.12346yhello} 0 0 0 171} {hi} 172 173# Ticket #812 174# 175do_test printf-10.1 { 176 sqlite3_mprintf_stronly %s {} 177} {} 178 179# Ticket #831 180# 181do_test printf-10.2 { 182 sqlite3_mprintf_stronly %q {} 183} {} 184 185# Ticket #1340: Test for loss of precision on large positive exponents 186# 187do_test printf-10.3 { 188 sqlite3_mprintf_double {%d %d %f} 1 1 1e300 189} {1 1 1000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.000000} 190 191# The non-standard '!' flag on a 'g' conversion forces a decimal point 192# and at least one digit on either side of the decimal point. 193# 194do_test printf-11.1 { 195 sqlite3_mprintf_double {%d %d %!g} 1 1 1 196} {1 1 1.0} 197do_test printf-11.2 { 198 sqlite3_mprintf_double {%d %d %!g} 1 1 123 199} {1 1 123.0} 200do_test printf-11.3 { 201 sqlite3_mprintf_double {%d %d %!g} 1 1 12.3 202} {1 1 12.3} 203do_test printf-11.4 { 204 sqlite3_mprintf_double {%d %d %!g} 1 1 0.123 205} {1 1 0.123} 206do_test printf-11.5 { 207 sqlite3_mprintf_double {%d %d %!.15g} 1 1 1 208} {1 1 1.0} 209do_test printf-11.6 { 210 sqlite3_mprintf_double {%d %d %!.15g} 1 1 1e10 211} {1 1 10000000000.0} 212do_test printf-11.7 { 213 sqlite3_mprintf_double {%d %d %!.15g} 1 1 1e300 214} {1 1 1.0e+300} 215 216# Additional tests for coverage 217# 218do_test printf-12.1 { 219 sqlite3_mprintf_double {%d %d %.2000g} 1 1 1.0 220} {1 1 1} 221 222# Floating point boundary cases 223# 224do_test printf-13.1 { 225 sqlite3_mprintf_hexdouble %.20f 4024000000000000 226} {10.00000000000000000000} 227do_test printf-13.2 { 228 sqlite3_mprintf_hexdouble %.20f 4197d78400000000 229} {100000000.00000000000000000000} 230do_test printf-13.3 { 231 sqlite3_mprintf_hexdouble %.20f 4693b8b5b5056e17 232} {100000000000000000000000000000000.00000000000000000000} 233 234do_test printf-14.1 { 235 sqlite3_mprintf_str {abc-%y-123} 0 0 {not used} 236} {abc-} 237do_test printf-14.2 { 238 sqlite3_mprintf_n_test {xyzzy} 239} 5 240 241 242finish_test 243