Index: third_party/sqlite/sqlite-src-3080704/test/trace2.test |
diff --git a/third_party/sqlite/sqlite-src-3080704/test/trace2.test b/third_party/sqlite/sqlite-src-3080704/test/trace2.test |
deleted file mode 100644 |
index 562c70c538aabade24644247ffa66361cf8b1309..0000000000000000000000000000000000000000 |
--- a/third_party/sqlite/sqlite-src-3080704/test/trace2.test |
+++ /dev/null |
@@ -1,155 +0,0 @@ |
-# 2011 Jan 21 |
-# |
-# 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. |
-# |
-# This file implements tests for the "sqlite3_trace()" API. Specifically, |
-# it tests the special handling of nested SQL statements (those executed |
-# by virtual table or user function callbacks). These statements are treated |
-# differently in two respects: |
-# |
-# 1. Each line of the statement is prefixed with "-- " to turn it into |
-# an SQL comment. |
-# |
-# 2. Parameter expansion is not performed. |
-# |
- |
-set testdir [file dirname $argv0] |
-source $testdir/tester.tcl |
-ifcapable !trace { finish_test ; return } |
-set ::testprefix trace2 |
- |
-proc sql {zSql} { db one $zSql } |
-proc trace {zSql} { lappend ::trace $zSql } |
- |
-db func sql sql |
-db trace trace |
- |
-proc do_trace_test {tn sql expected} { |
- # Test that the list of string passed to the trace callback when $sql |
- # is executed is equivalent to the list of strings in $expected. |
- # |
- set ::trace [list] |
- execsql $sql |
- uplevel do_test $tn [list {set ::trace}] [list [list {*}$expected]] |
-} |
- |
-proc do_trace_select_test {tn sql expected} { |
- |
- uplevel [list do_trace_test ${tn}.a $sql $expected] |
- |
- # Now execute each SQL statement passed to the trace callback in the |
- # block above. Check that this causes the same set of strings to be |
- # passed to the trace callback again. i.e. that executing the output |
- # of the trace callback is equivalent to the SQL script in $sql. |
- # |
- set sqllist $::trace |
- set ::trace [list] |
- foreach item $sqllist { execsql $item } |
- uplevel do_test $tn.b [list {set ::trace}] [list $sqllist] |
-} |
- |
-do_trace_select_test 1.1 { |
- SELECT 1, 2, 3; |
-} { |
- "SELECT 1, 2, 3;" |
-} |
- |
-do_trace_select_test 1.2 { |
- SELECT sql('SELECT 1, 2, 3'); |
-} { |
- "SELECT sql('SELECT 1, 2, 3');" |
- "-- SELECT 1, 2, 3" |
-} |
- |
-do_trace_select_test 1.3 { |
- SELECT sql('SELECT 1, |
- 2, |
- 3' |
- ); |
-} { |
- "SELECT sql('SELECT 1, |
- 2, |
- 3' |
- );" |
- "-- SELECT 1, |
--- 2, |
--- 3" |
-} |
- |
-do_trace_select_test 1.4 { |
- SELECT sql('SELECT 1, |
- |
- |
- 3' |
- ); |
-} { |
- "SELECT sql('SELECT 1, |
- |
- |
- 3' |
- );" |
- "-- SELECT 1, |
--- |
--- |
--- 3" |
-} |
- |
-do_trace_select_test 1.5 { |
- SELECT $var, sql('SELECT 1, |
- $var, |
- 3' |
- ); |
-} { |
- "SELECT NULL, sql('SELECT 1, |
- $var, |
- 3' |
- );" |
- "-- SELECT 1, |
--- $var, |
--- 3" |
-} |
- |
-ifcapable fts3 { |
- do_execsql_test 2.1 { |
- CREATE VIRTUAL TABLE x1 USING fts4; |
- INSERT INTO x1 VALUES('Cloudy, with a high near 16'); |
- INSERT INTO x1 VALUES('Wind chill values as low as -13'); |
- } |
- |
- do_trace_test 2.2 { |
- INSERT INTO x1 VALUES('North northwest wind between 8 and 14 mph'); |
- } { |
- "INSERT INTO x1 VALUES('North northwest wind between 8 and 14 mph');" |
- "-- DELETE FROM 'main'.'x1_segdir' WHERE level = ?" |
- "-- INSERT INTO 'main'.'x1_content' VALUES(?,(?))" |
- "-- REPLACE INTO 'main'.'x1_docsize' VALUES(?,?)" |
- "-- SELECT value FROM 'main'.'x1_stat' WHERE id=?" |
- "-- REPLACE INTO 'main'.'x1_stat' VALUES(?,?)" |
- "-- SELECT (SELECT max(idx) FROM 'main'.'x1_segdir' WHERE level = ?) + 1" |
- "-- SELECT coalesce((SELECT max(blockid) FROM 'main'.'x1_segments') + 1, 1)" |
- "-- REPLACE INTO 'main'.'x1_segdir' VALUES(?,?,?,?,?,?)" |
- "-- SELECT level, idx, end_block FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ? ORDER BY level DESC, idx ASC" |
- } |
- |
- do_trace_test 2.3 { |
- INSERT INTO x1(x1) VALUES('optimize'); |
- } { |
- "INSERT INTO x1(x1) VALUES('optimize');" |
- "-- SELECT DISTINCT level / (1024 * ?) FROM 'main'.'x1_segdir'" |
- "-- SELECT idx, start_block, leaves_end_block, end_block, root FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ?ORDER BY level DESC, idx ASC" |
- "-- SELECT max(level) FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ?" |
- "-- SELECT coalesce((SELECT max(blockid) FROM 'main'.'x1_segments') + 1, 1)" |
- "-- DELETE FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ?" |
- "-- REPLACE INTO 'main'.'x1_segdir' VALUES(?,?,?,?,?,?)" |
- } |
-} |
- |
-finish_test |