diff options
| author | bernard <[email protected]> | 2017-11-02 13:50:42 +0800 |
|---|---|---|
| committer | bernard <[email protected]> | 2017-11-02 13:50:42 +0800 |
| commit | b2057f506a09e2adef81fc77efd697d16ae14bec (patch) | |
| tree | 3affefabfe376a0ec1b3ac4a5eef957c1dd58dc8 /components/external/SQLite-3.8.1/test/func3.test | |
| parent | 23582c8129228b4961ad35319cfd2d270039345f (diff) | |
[External] Remove external from RT-Thread
Diffstat (limited to 'components/external/SQLite-3.8.1/test/func3.test')
| -rw-r--r-- | components/external/SQLite-3.8.1/test/func3.test | 156 |
1 files changed, 0 insertions, 156 deletions
diff --git a/components/external/SQLite-3.8.1/test/func3.test b/components/external/SQLite-3.8.1/test/func3.test deleted file mode 100644 index 2a2b7be4f4..0000000000 --- a/components/external/SQLite-3.8.1/test/func3.test +++ /dev/null @@ -1,156 +0,0 @@ -# 2010 August 27 -# -# The author disclaims copyright to this source code. In place of -# a legal notice, here is a blessing: -# -# May you do good and not evil. -# May you find forgiveness for yourself and forgive others. -# May you share freely, never taking more than you give. -# -#*********************************************************************** -# This file implements regression tests for SQLite library. The -# focus of this file is testing that destructor functions associated -# with functions created using sqlite3_create_function_v2() is -# correctly invoked. -# -set testdir [file dirname $argv0] -source $testdir/tester.tcl - - -ifcapable utf16 { - do_test func3-1.1 { - set destroyed 0 - proc destroy {} { set ::destroyed 1 } - sqlite3_create_function_v2 db f2 -1 any -func f2 -destroy destroy - set destroyed - } 0 - do_test func3-1.2 { - sqlite3_create_function_v2 db f2 -1 utf8 -func f2 - set destroyed - } 0 - do_test func3-1.3 { - sqlite3_create_function_v2 db f2 -1 utf16le -func f2 - set destroyed - } 0 - do_test func3-1.4 { - sqlite3_create_function_v2 db f2 -1 utf16be -func f2 - set destroyed - } 1 -} - -do_test func3-2.1 { - set destroyed 0 - proc destroy {} { set ::destroyed 1 } - sqlite3_create_function_v2 db f3 -1 utf8 -func f3 -destroy destroy - set destroyed -} 0 -do_test func3-2.2 { - sqlite3_create_function_v2 db f3 -1 utf8 -func f3 - set destroyed -} 1 - -do_test func3-3.1 { - set destroyed 0 - proc destroy {} { set ::destroyed 1 } - sqlite3_create_function_v2 db f3 -1 any -func f3 -destroy destroy - set destroyed -} 0 -do_test func3-3.2 { - db close - set destroyed -} 1 - -sqlite3 db test.db -do_test func3-4.1 { - set destroyed 0 - set rc [catch { - sqlite3_create_function_v2 db f3 -1 any -func f3 -step f3 -destroy destroy - } msg] - list $rc $msg -} {1 SQLITE_MISUSE} -do_test func3-4.2 { set destroyed } 1 - -# EVIDENCE-OF: R-41921-05214 The likelihood(X,Y) function returns -# argument X unchanged. -# -do_execsql_test func3-5.1 { - SELECT likelihood(9223372036854775807, 0.5); -} {9223372036854775807} -do_execsql_test func3-5.2 { - SELECT likelihood(-9223372036854775808, 0.5); -} {-9223372036854775808} -do_execsql_test func3-5.3 { - SELECT likelihood(14.125, 0.5); -} {14.125} -do_execsql_test func3-5.4 { - SELECT likelihood(NULL, 0.5); -} {{}} -do_execsql_test func3-5.5 { - SELECT likelihood('test-string', 0.5); -} {test-string} -do_execsql_test func3-5.6 { - SELECT quote(likelihood(x'010203000405', 0.5)); -} {X'010203000405'} - -# EVIDENCE-OF: R-44133-61651 The value Y in likelihood(X,Y) must be a -# floating point constant between 0.0 and 1.0, inclusive. -# -do_execsql_test func3-5.7 { - SELECT likelihood(123, 1.0), likelihood(456, 0.0); -} {123 456} -do_test func3-5.8 { - catchsql { - SELECT likelihood(123, 1.000001); - } -} {1 {second argument to likelihood() must be a constant between 0.0 and 1.0}} -do_test func3-5.9 { - catchsql { - SELECT likelihood(123, -0.000001); - } -} {1 {second argument to likelihood() must be a constant between 0.0 and 1.0}} -do_test func3-5.10 { - catchsql { - SELECT likelihood(123, 0.5+0.3); - } -} {1 {second argument to likelihood() must be a constant between 0.0 and 1.0}} - -# EVIDENCE-OF: R-28535-44631 The likelihood(X) function is a no-op that -# the code generator optimizes away so that it consumes no CPU cycles -# during run-time (that is, during calls to sqlite3_step()). -# -do_test func3-5.20 { - db eval {EXPLAIN SELECT likelihood(min(1.0+'2.0',4*11), 0.5)} -} [db eval {EXPLAIN SELECT min(1.0+'2.0',4*11)}] - - -# EVIDENCE-OF: R-11152-23456 The unlikely(X) function returns the -# argument X unchanged. -# -do_execsql_test func3-5.30 { - SELECT unlikely(9223372036854775807); -} {9223372036854775807} -do_execsql_test func3-5.31 { - SELECT unlikely(-9223372036854775808); -} {-9223372036854775808} -do_execsql_test func3-5.32 { - SELECT unlikely(14.125); -} {14.125} -do_execsql_test func3-5.33 { - SELECT unlikely(NULL); -} {{}} -do_execsql_test func3-5.34 { - SELECT unlikely('test-string'); -} {test-string} -do_execsql_test func3-5.35 { - SELECT quote(unlikely(x'010203000405')); -} {X'010203000405'} - -# EVIDENCE-OF: R-22887-63324 The unlikely(X) function is a no-op that -# the code generator optimizes away so that it consumes no CPU cycles at -# run-time (that is, during calls to sqlite3_step()). -# -do_test func3-5.40 { - db eval {EXPLAIN SELECT unlikely(min(1.0+'2.0',4*11))} -} [db eval {EXPLAIN SELECT min(1.0+'2.0',4*11)}] - -finish_test |
