← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/insert_update.result

  • Committer: Brian Aker
  • Date: 2010-04-05 23:46:43 UTC
  • Revision ID: brian@gaz-20100405234643-0he3xnj902rc70r8
Fixing tests to work with PBXT.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/insert_update.result
52
52
SELECT *, VALUES(a) FROM t1;
53
53
a       b       c       VALUES(a)
54
54
1       2       10      NULL
 
55
2       1       11      NULL
55
56
3       4       127     NULL
56
57
5       0       30      NULL
57
58
8       9       60      NULL
58
 
2       1       11      NULL
59
59
explain extended SELECT *, VALUES(a) FROM t1;
60
60
id      select_type     table   type    possible_keys   key     key_len ref     rows    filtered        Extra
61
61
1       SIMPLE  t1      ALL     NULL    NULL    NULL    NULL    5       100.00  
163
163
SELECT *, VALUES(a) FROM t1;
164
164
a       b       c       VALUES(a)
165
165
1       2       10      NULL
 
166
2       1       11      NULL
166
167
3       4       127     NULL
167
168
5       0       30      NULL
168
169
8       9       60      NULL
169
 
2       1       11      NULL
170
170
DROP TABLE t1;
171
171
DROP TABLE t2;
172
172
create table t1 (a int not null unique);