AryaWu/sqlite

1# 2002 May 242#3# The author disclaims copyright to this source code.  In place of4# a legal notice, here is a blessing:5#6#    May you do good and not evil.7#    May you find forgiveness for yourself and forgive others.8#    May you share freely, never taking more than you give.9#10#***********************************************************************11# This file implements regression tests for SQLite library.12#13# This file implements tests for joins, including outer joins, where14# there are a large number of tables involved in the join.15#16# $Id: join3.test,v 1.4 2005/01/19 23:24:51 drh Exp $17 18set testdir [file dirname $argv0]19source $testdir/tester.tcl20 21# An unrestricted join22#23catch {unset ::result}24set result {}25for {set N 1} {$N<=$bitmask_size} {incr N} {26  lappend result $N27  do_test join3-1.$N {28    execsql "CREATE TABLE t${N}(x);"29    execsql "INSERT INTO t$N VALUES($N)"30    set sql "SELECT * FROM t1"31    for {set i 2} {$i<=$N} {incr i} {append sql ", t$i"}32    execsql $sql33  } $result34}35 36# Joins with a comparison37#38set result {}39for {set N 1} {$N<=$bitmask_size} {incr N} {40  lappend result $N41  do_test join3-2.$N {42    set sql "SELECT * FROM t1"43    for {set i 2} {$i<=$N} {incr i} {append sql ", t$i"}44    set sep WHERE45    for {set i 1} {$i<$N} {incr i} {46      append sql " $sep t[expr {$i+1}].x==t$i.x+1"47      set sep AND48    }49    execsql $sql50  } $result51}52 53# Error of too many tables in the join54#55do_test join3-3.1 {56  set sql "SELECT * FROM t1 AS t0, t1"57  for {set i 2} {$i<=$bitmask_size} {incr i} {append sql ", t$i"}58  catchsql $sql59} [list 1 "at most $bitmask_size tables in a join"]60 61 62finish_test63