Debian Codegraph @

test/loadext.test

raw
1 # 2006 July 14
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 script is extension loading.
13 #
14 # $Id: loadext.test,v 1.17 2009/03/20 09:09:37 danielk1977 Exp $
15
16 set testdir [file dirname $argv0]
17 source $testdir/tester.tcl
18
19 ifcapable !load_ext {
20 finish_test
21 return
22 }
23
24 # The name of the test extension varies by operating system.
25 #
26 if {$::tcl_platform(platform) eq "windows"} {
27 set testextension ./testloadext.dll
28 } else {
29 set testextension ./libtestloadext.so
30 }
31 set gcc_shared "-shared -fPIC"
32 if {$::tcl_platform(os) eq "Darwin"} {
33 set gcc_shared -dynamiclib
34 }
35
36 # The error messages tested by this file are operating system dependent
37 # (because they are returned by sqlite3OsDlError()). For now, they only
38 # work with UNIX (and probably only certain kinds of UNIX).
39 #
40 # When a shared-object cannot be opened because it does not exist, the
41 # format of the message returned is:
42 #
43 # [format $dlerror_nosuchfile <shared-object-name>]
44 #
45 # When a shared-object cannot be opened because it consists of the 4
46 # characters "blah" only, we expect the error message to be:
47 #
48 # [format $dlerror_notadll <shared-object-name>]
49 #
50 # When a symbol cannot be found within an open shared-object, the error
51 # message should be:
52 #
53 # [format $dlerror_nosymbol <shared-object-name> <symbol-name>]
54 #
55 # The exact error messages are not important. The important bit is
56 # that SQLite is correctly copying the message from xDlError().
57 #
58 set dlerror_nosuchfile \
59 {%s: cannot open shared object file: No such file or directory}
60 set dlerror_notadll {%s: file too short}
61 set dlerror_nosymbol {%s: undefined symbol: %s}
62
63 if {$::tcl_platform(os) eq "Darwin"} {
64 set dlerror_nosuchfile {dlopen.%s, 10.: .*image.*found.*}
65 set dlerror_notadll {dlopen.%1$s, 10.: .*image.*found.*}
66 set dlerror_nosymbol {dlsym.XXX, %2$s.: symbol not found}
67 }
68
69 if {$::tcl_platform(os) eq "Windows NT"} {
70 set dlerror_nosuchfile {The specified module could not be found.*}
71 if {$::tcl_platform(platform) eq "unix"} {
72 set dlerror_notadll $dlerror_nosuchfile
73 } else {
74 set dlerror_notadll {%%1 is not a valid Win32 application.*}
75 }
76 set dlerror_nosymbol {The specified procedure could not be found.*}
77 }
78
79 # Make sure the test extension actually exists. If it does not
80 # exist, try to create it. If unable to create it, then skip this
81 # test file.
82 #
83 if {![file exists $testextension]} {
84 set srcdir [file dir $testdir]/src
85 set testextsrc $srcdir/test_loadext.c
86
87 set cmdline [concat exec gcc $gcc_shared]
88 lappend cmdline -Wall -I$srcdir -I. -I.. -g $testextsrc -o $testextension
89
90 if {[catch $cmdline msg]} {
91 puts "Skipping loadext tests: Test extension not built..."
92 puts $msg
93 finish_test
94 return
95 }
96 }
97
98 # Test that loading the extension produces the expected results - adding
99 # the half() function to the specified database handle.
100 #
101 do_test loadext-1.1 {
102 catchsql {
103 SELECT half(1.0);
104 }
105 } {1 {no such function: half}}
106 do_test loadext-1.2 {
107 db enable_load_extension 1
108 sqlite3_load_extension db $testextension testloadext_init
109 catchsql {
110 SELECT half(1.0);
111 }
112 } {0 0.5}
113
114 # Test that a second database connection (db2) can load the extension also.
115 #
116 do_test loadext-1.3 {
117 sqlite3 db2 test.db
118 sqlite3_db_config db2 SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION 1
119 catchsql {
120 SELECT half(1.0);
121 } db2
122 } {1 {no such function: half}}
123 do_test loadext-1.4 {
124 sqlite3_load_extension db2 $testextension testloadext_init
125 catchsql {
126 SELECT half(1.0);
127 } db2
128 } {0 0.5}
129
130 # Close the first database connection. Then check that the second database
131 # can still use the half() function without a problem.
132 #
133 do_test loadext-1.5 {
134 db close
135 catchsql {
136 SELECT half(1.0);
137 } db2
138 } {0 0.5}
139
140 db2 close
141 sqlite3 db test.db
142 sqlite3_enable_load_extension db 1
143
144 # Try to load an extension for which the file does not exist.
145 #
146 do_test loadext-2.1 {
147 forcedelete ${testextension}xx
148 set rc [catch {
149 sqlite3_load_extension db "${testextension}xx"
150 } msg]
151 list $rc $msg
152 } /[list 1 [format $dlerror_nosuchfile ${testextension}xx.*]]/
153
154 # Try to load an extension for which the file is not a shared object
155 #
156 do_test loadext-2.2 {
157 set fd [open "./notasharedlib.so" w]
158 puts $fd blah
159 close $fd
160 set fd [open "./notasharedlib.dll" w]
161 puts $fd blah
162 close $fd
163 set rc [catch {
164 sqlite3_load_extension db "./notasharedlib"
165 } msg]
166 list $rc $msg
167 } /[list 1 [format $dlerror_notadll ./notasharedlib.*]]/
168
169 # Try to load an extension for which the file is present but the
170 # entry point is not.
171 #
172 do_test loadext-2.3 {
173 set rc [catch {
174 sqlite3_load_extension db $testextension icecream
175 } msg]
176 if {$::tcl_platform(os) eq "Darwin"} {
177 regsub {0x[1234567890abcdefABCDEF]*} $msg XXX msg
178 }
179 list $rc $msg
180 } /[list 1 [format $dlerror_nosymbol $testextension icecream]]/
181
182 # Try to load an extension for which the entry point fails (returns non-zero)
183 #
184 do_test loadext-2.4 {
185 set rc [catch {
186 sqlite3_load_extension db $testextension testbrokenext_init
187 } msg]
188 list $rc $msg
189 } {1 {error during initialization: broken!}}
190
191 ############################################################################
192 # Tests for the load_extension() SQL function
193 #
194
195 db close
196 sqlite3 db test.db
197 sqlite3_enable_load_extension db 1
198 do_test loadext-3.1 {
199 catchsql {
200 SELECT half(5);
201 }
202 } {1 {no such function: half}}
203 do_test loadext-3.2 {
204 set res [catchsql {
205 SELECT load_extension($::testextension)
206 }]
207 if {$::tcl_platform(os) eq "Darwin"} {
208 regsub {0x[1234567890abcdefABCDEF]*} $res XXX res
209 }
210 set res
211 } /[list 1 [format $dlerror_nosymbol $testextension sqlite3_.*_init]]/
212 do_test loadext-3.3 {
213 catchsql {
214 SELECT load_extension($::testextension,'testloadext_init')
215 }
216 } {0 {{}}}
217 do_test loadext-3.4 {
218 catchsql {
219 SELECT half(5);
220 }
221 } {0 2.5}
222 do_test loadext-3.5 {
223 db eval {
224 SELECT sqlite3_status('MEMORY_USED') AS mused
225 } break
226 puts -nonewline " (memory_used=$mused) "
227 expr {$mused>0}
228 } {1}
229 do_test loadext-3.6 {
230 catchsql {
231 SELECT sqlite3_status('MEMORY_USED_X') AS mused
232 }
233 } {1 {unknown status property: MEMORY_USED_X}}
234 do_test loadext-3.7 {
235 catchsql {
236 SELECT sqlite3_status(4.53) AS mused
237 }
238 } {1 {unknown status type}}
239 do_test loadext-3.8 {
240 catchsql {
241 SELECT sqlite3_status(23) AS mused
242 }
243 } {1 {sqlite3_status(23,...) returns 21}}
244
245 # Ticket #1863
246 # Make sure the extension loading mechanism will not work unless it
247 # is explicitly enabled.
248 #
249 db close
250 sqlite3 db test.db
251 do_test loadext-4.1 {
252 catchsql {
253 SELECT load_extension($::testextension,'testloadext_init')
254 }
255 } {1 {not authorized}}
256 do_test loadext-4.2 {
257 sqlite3_enable_load_extension db 1
258 catchsql {
259 SELECT load_extension($::testextension,'testloadext_init')
260 }
261 } {0 {{}}}
262
263 # disable all extension loading
264 do_test loadext-4.3 {
265 sqlite3_enable_load_extension db 0
266 catchsql {
267 SELECT load_extension($::testextension,'testloadext_init')
268 }
269 } {1 {not authorized}}
270
271 # enable C-api extension loading only. Show that the SQL function
272 # still does not work.
273 do_test loadext-4.4 {
274 sqlite3_db_config db SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION 1
275 catchsql {
276 SELECT load_extension($::testextension,'testloadext_init')
277 }
278 } {1 {not authorized}}
279
280 source $testdir/malloc_common.tcl
281
282
283 # Malloc failure in sqlite3_auto_extension and sqlite3_load_extension
284 #
285 do_malloc_test loadext-5 -tclprep {
286 sqlite3_reset_auto_extension
287 } -tclbody {
288 if {[autoinstall_test_functions]==7} {error "out of memory"}
289 }
290
291 # On Windows, this malloc test must be skipped because the winDlOpen
292 # function itself can fail due to "out of memory" conditions.
293 #
294 if {$::tcl_platform(platform) ne "windows"} {
295 do_malloc_test loadext-6 -tclbody {
296 db enable_load_extension 1
297 sqlite3_load_extension db $::testextension testloadext_init
298 }
299 }
300
301 autoinstall_test_functions
302
303 finish_test