~ubuntu-branches/ubuntu/hardy/sqlite3/hardy

« back to all changes in this revision

Viewing changes to test/where.test

Committer: Bazaar Package Importer
Author(s): Matthias Klose
Date: 2007-07-23 14:35:04 UTC
mfrom: (1.1.10 upstream)
Revision ID: james.westby@ubuntu.com-20070723143504-v52h2illx871jas3

Tags: 3.4.1-0ubuntu1

https://launchpad.net/bugs/127223

New upstream release. Closes LP: #127223.

files added:
ext/fts2/README.tokenizers

ext/fts2/fts2_icu.c

ext/fts2/fts2_tokenizer.c

src/sqliteLimit.h

test/collate8.test

test/fts2o.test

test/fts2token.test

test/minmax2.test

test/pragma2.test

test/tkt2450.test

test/vtabA.test

test/vtab_alter.test

files removed:
src/limits.h

files modified:
Makefile.in

Makefile.linux-gcc

VERSION

debian/changelog

ext/fts1/fts1.c

ext/fts2/fts2.c

ext/fts2/fts2.h

ext/fts2/fts2_hash.c

ext/fts2/fts2_tokenizer.h

ext/fts2/fts2_tokenizer1.c

ext/fts2/mkfts2amal.tcl

ext/icu/README.txt

ext/icu/icu.c

main.mk

src/alter.c

src/analyze.c

src/btree.c

src/build.c

src/expr.c

src/func.c

src/insert.c

src/loadext.c

src/main.c

src/os.h

src/os_os2.c

src/os_unix.c

src/pager.c

src/parse.y

src/pragma.c

src/prepare.c

src/printf.c

src/select.c

src/shell.c

src/sqlite.h.in

src/sqlite3ext.h

src/sqliteInt.h

src/tclsqlite.c

src/test1.c

src/test8.c

src/test_schema.c

src/test_tclvar.c

src/tokenize.c

src/update.c

src/util.c

src/vdbe.c

src/vdbeInt.h

src/vdbeapi.c

src/vdbeaux.c

src/vdbeblob.c

src/vdbemem.c

src/vtab.c

test/btree.test

test/capi3.test

test/capi3c.test

test/expr.test

test/incrblob.test

test/incrvacuum.test

test/misc7.test

test/select3.test

test/tclsqlite.test

test/trans.test

test/types3.test

test/vacuum2.test

test/vtab1.test

test/vtab5.test

test/where.test

tool/lemon.c

tool/mksqlite3c.tcl

tool/mksqlite3internalh.tcl

www/changes.tcl

www/datatype3.tcl

www/faq.tcl

www/index.tcl

www/lang.tcl

www/mkapidoc.tcl

www/pragma.tcl

www/support.tcl

www/tclsqlite.tcl

Show diffs side-by-side

added added

removed removed

test/where.test

# This file implements regression tests for SQLite library. The

# focus of this file is testing the use of indices in WHERE clases.

# $Id: where.test,v 1.42 2007/05/14 11:34:47 drh Exp $

# $Id: where.test,v 1.43 2007/06/25 16:29:34 danielk1977 Exp $

set testdir [file dirname $argv0]

source $testdir/tester.tcl

1137

}

1138

} {4/4 4/1 1/4 1/1 sort}

1139

1140

# Ticket #2445.

1141

1142

# There was a crash that could occur when a where clause contains an

1143

# alias for an expression in the result set, and that expression retrieves

1144

# a column of the second or subsequent table in a join.

1145

1146

do_test where-15.1 {

1147

execsql {

1148

CREATE TEMP TABLE t1 (a, b, c, d, e);

1149

CREATE TEMP TABLE t2 (f);

1150

SELECT t1.e AS alias FROM t2, t1 WHERE alias = 1 ;

1151

}

1152

} {}

1140

1153

1141

1154

integrity_check {where-99.0}

1142

1155

Older »