~ubuntu-branches/ubuntu/maverick/sqlite3/maverick-updates

« back to all changes in this revision

Viewing changes to test/limit.test

• browse files at revision 5
• compare with another revision
• download diff
• download tarball
• view history from revision 5

Show diffs side-by-side

added

removed

test/limit.test

12

12

# focus of this file is testing the LIMIT ... OFFSET ... clause

13

13

#  of SELECT statements.

14

14

#

15

 

# $Id: limit.test,v 1.30 2006/06/20 11:01:09 danielk1977 Exp $

 

15

# $Id: limit.test,v 1.31 2008/01/16 18:20:42 danielk1977 Exp $

16

16

 

17

17

set testdir [file dirname $argv0]

18

18

source $testdir/tester.tcl

24

24

  BEGIN;

25

25

}

26

26

for {set i 1} {$i<=32} {incr i} {

27

 

  for {set j 0} {pow(2,$j)<$i} {incr j} {}

 

27

  for {set j 0} {(1<<$j)<$i} {incr j} {}

28

28

  execsql "INSERT INTO t1 VALUES([expr {32-$i}],[expr {10-$j}])"

29

29

}

30

30

execsql {

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1