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

Unified Diff: third_party/sqlite/sqlite-src-3080704/test/collate8.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/collate8.test
diff --git a/third_party/sqlite/sqlite-src-3080704/test/collate8.test b/third_party/sqlite/sqlite-src-3080704/test/collate8.test
deleted file mode 100644
index 60a89162dddd6a569273b1430ab19a40dc5e60e8..0000000000000000000000000000000000000000
--- a/third_party/sqlite/sqlite-src-3080704/test/collate8.test
+++ /dev/null
@@ -1,125 +0,0 @@
-#
-# 2007 June 20
-#
-# 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 script is making sure collations pass through the
-# unary + operator.
-#
-# $Id: collate8.test,v 1.2 2008/08/25 12:14:09 drh Exp $
-
-set testdir [file dirname $argv0]
-source $testdir/tester.tcl
-
-do_test collate8-1.1 {
- execsql {
- CREATE TABLE t1(a TEXT COLLATE nocase);
- INSERT INTO t1 VALUES('aaa');
- INSERT INTO t1 VALUES('BBB');
- INSERT INTO t1 VALUES('ccc');
- INSERT INTO t1 VALUES('DDD');
- SELECT a FROM t1 ORDER BY a;
- }
-} {aaa BBB ccc DDD}
-do_test collate8-1.2 {
- execsql {
- SELECT rowid FROM t1 WHERE a<'ccc' ORDER BY 1
- }
-} {1 2}
-do_test collate8-1.3 {
- execsql {
- SELECT rowid FROM t1 WHERE a<'ccc' COLLATE binary ORDER BY 1
- }
-} {1 2 4}
-do_test collate8-1.4 {
- execsql {
- SELECT rowid FROM t1 WHERE +a<'ccc' ORDER BY 1
- }
-} {1 2}
-do_test collate8-1.5 {
- execsql {
- SELECT a FROM t1 ORDER BY +a
- }
-} {aaa BBB ccc DDD}
-do_test collate8-1.11 {
- execsql {
- SELECT a AS x FROM t1 ORDER BY "x";
- }
-} {aaa BBB ccc DDD}
-do_test collate8-1.12 {
- execsql {
- SELECT a AS x FROM t1 WHERE x<'ccc' ORDER BY 1
- }
-} {aaa BBB}
-do_test collate8-1.13 {
- execsql {
- SELECT a AS x FROM t1 WHERE x<'ccc' COLLATE binary ORDER BY [x]
- }
-} {aaa BBB DDD}
-do_test collate8-1.14 {
- execsql {
- SELECT a AS x FROM t1 WHERE +x<'ccc' ORDER BY 1
- }
-} {aaa BBB}
-do_test collate8-1.15 {
- execsql {
- SELECT a AS x FROM t1 ORDER BY +x
- }
-} {aaa BBB ccc DDD}
-
-
-# When a result-set column is aliased into a WHERE clause, make sure the
-# collating sequence logic works correctly.
-#
-do_test collate8-2.1 {
- execsql {
- CREATE TABLE t2(a);
- INSERT INTO t2 VALUES('abc');
- INSERT INTO t2 VALUES('ABC');
- SELECT a AS x FROM t2 WHERE x='abc';
- }
-} {abc}
-do_test collate8-2.2 {
- execsql {
- SELECT a AS x FROM t2 WHERE x='abc' COLLATE nocase;
- }
-} {abc ABC}
-do_test collate8-2.3 {
- execsql {
- SELECT a AS x FROM t2 WHERE (x COLLATE nocase)='abc';
- }
-} {abc ABC}
-do_test collate8-2.4 {
- execsql {
- SELECT a COLLATE nocase AS x FROM t2 WHERE x='abc';
- }
-} {abc ABC}
-do_test collate8-2.5 {
- execsql {
- SELECT a COLLATE nocase AS x FROM t2 WHERE (x COLLATE binary)='abc';
- }
-} {abc}
-do_test collate8-2.6 {
- execsql {
- SELECT a COLLATE nocase AS x FROM t2 WHERE x='abc' COLLATE binary;
- }
-} {abc ABC}
-do_test collate8-2.7 {
- execsql {
- SELECT * FROM t2 WHERE (a COLLATE nocase)='abc' COLLATE binary;
- }
-} {abc ABC}
-do_test collate8-2.8 {
- execsql {
- SELECT a COLLATE nocase AS x FROM t2 WHERE 'abc'=x COLLATE binary;
- }
-} {abc}
-
-finish_test
« no previous file with comments | « third_party/sqlite/sqlite-src-3080704/test/collate7.test ('k') | third_party/sqlite/sqlite-src-3080704/test/collate9.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698