Lines Matching refs:blob

13 # $Id: blob.test,v 1.8 2009/04/28 18:00:27 drh Exp $
23 proc bin_to_hex {blob} {
25   binary scan $blob \c* bytes
31 # Simplest possible case. Specify a blob literal
32 do_test blob-1.0 {
33   set blob [execsql {SELECT X'01020304';}]
34   bin_to_hex [lindex $blob 0]
36 do_test blob-1.1 {
37   set blob [execsql {SELECT x'ABCDEF';}]
38   bin_to_hex [lindex $blob 0]
40 do_test blob-1.2 {
41   set blob [execsql {SELECT x'';}]
42   bin_to_hex [lindex $blob 0]
44 do_test blob-1.3 {
45   set blob [execsql {SELECT x'abcdEF12';}]
46   bin_to_hex [lindex $blob 0]
48 do_test blob-1.3.2 {
49   set blob [execsql {SELECT x'0123456789abcdefABCDEF';}]
50   bin_to_hex [lindex $blob 0]
53 # Try some syntax errors in blob literals.
54 do_test blob-1.4 {
57 do_test blob-1.5 {
60 do_test blob-1.6 {
63 do_test blob-1.7 {
66 do_test blob-1.8 {
69 do_test blob-1.9 {
72 do_test blob-1.10 {
75 do_test blob-1.11 {
78 do_test blob-1.12 {
81 do_test blob-1.13 {
86 # Insert a blob into a table and retrieve it.
87 do_test blob-2.0 {
99 # An index on a blob column
100 do_test blob-2.1 {
109 do_test blob-2.2 {
115 do_test blob-2.3 {
121 do_test blob-2.4 {
128 # Try to bind a blob value to a prepared statement.
129 do_test blob-3.0 {
136 do_test blob-3.1 {
140 do_test blob-3.2 {