| Index: third_party/sqlite/sqlite-src-3080704/test/func3.test
|
| diff --git a/third_party/sqlite/sqlite-src-3080704/test/func3.test b/third_party/sqlite/sqlite-src-3080704/test/func3.test
|
| deleted file mode 100644
|
| index 3b1613b56c6d400fe317aa764d04908bb9ce953e..0000000000000000000000000000000000000000
|
| --- a/third_party/sqlite/sqlite-src-3080704/test/func3.test
|
| +++ /dev/null
|
| @@ -1,190 +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.39 {
|
| - db eval {EXPLAIN SELECT unlikely(min(1.0+'2.0',4*11))}
|
| -} [db eval {EXPLAIN SELECT min(1.0+'2.0',4*11)}]
|
| -
|
| -
|
| -# EVIDENCE-OF: R-23735-03107 The likely(X) function returns the argument
|
| -# X unchanged.
|
| -#
|
| -do_execsql_test func3-5.50 {
|
| - SELECT likely(9223372036854775807);
|
| -} {9223372036854775807}
|
| -do_execsql_test func3-5.51 {
|
| - SELECT likely(-9223372036854775808);
|
| -} {-9223372036854775808}
|
| -do_execsql_test func3-5.52 {
|
| - SELECT likely(14.125);
|
| -} {14.125}
|
| -do_execsql_test func3-5.53 {
|
| - SELECT likely(NULL);
|
| -} {{}}
|
| -do_execsql_test func3-5.54 {
|
| - SELECT likely('test-string');
|
| -} {test-string}
|
| -do_execsql_test func3-5.55 {
|
| - SELECT quote(likely(x'010203000405'));
|
| -} {X'010203000405'}
|
| -
|
| -# EVIDENCE-OF: R-43464-09689 The likely(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.59 {
|
| - db eval {EXPLAIN SELECT likely(min(1.0+'2.0',4*11))}
|
| -} [db eval {EXPLAIN SELECT min(1.0+'2.0',4*11)}]
|
| -
|
| -
|
| -
|
| -
|
| -finish_test
|
|
|