← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/limit_offset.result

  • Committer: Monty Taylor
  • Date: 2009-04-14 19:16:51 UTC
  • mto: (997.2.5 mordred)
  • mto: This revision was merged to the branch mainline in revision 994.
  • Revision ID: mordred@inaugust.com-20090414191651-ltbww6hpqks8k7qk
Clarified instructions in README.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/limit_offset.result
1
 
CREATE TABLE t1 (a int primary key auto_increment);
2
 
insert into t1 values (),(),(),(),(),(),(),(),(),();
3
 
insert into t1 values (),(),(),(),(),(),(),(),(),();
4
 
SELECT a FROM t1 ORDER BY a LIMIT 10 OFFSET 1;
5
 
a
6
 
2
7
 
3
8
 
4
9
 
5
10
 
6
11
 
7
12
 
8
13
 
9
14
 
10
15
 
11
16
 
SELECT a FROM t1 ORDER BY a LIMIT 10 OFFSET 10;
17
 
a
18
 
11
19
 
12
20
 
13
21
 
14
22
 
15
23
 
16
24
 
17
25
 
18
26
 
19
27
 
20
28
 
SELECT a FROM t1 ORDER BY a LIMIT 2 OFFSET 14;
29
 
a
30
 
15
31
 
16
32
 
DROP TABLE t1;