Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(551)

Unified Diff: third_party/sqlite/sqlite-src-3080704/test/trace2.test

Issue 2363173002: [sqlite] Remove obsolete reference version 3.8.7.4. (Closed)
Patch Set: Created 4 years, 3 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View side-by-side diff with in-line comments
Download patch
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
« no previous file with comments | « third_party/sqlite/sqlite-src-3080704/test/trace.test ('k') | third_party/sqlite/sqlite-src-3080704/test/trans.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698