← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/small_tmp_table.result

  • Committer: Brian Aker
  • Date: 2010-02-07 01:33:54 UTC
  • Revision ID: brian@gaz-20100207013354-d2pg1n68u5c09pgo
Remove giant include header to its own file.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/small_tmp_table.result
1
1
DROP TABLE IF EXISTS t1;
2
 
Warnings:
3
 
Note    1051    Unknown table 't1'
4
2
CREATE TABLE t1 (
5
 
a varchar(32) character set utf8 collate utf8_bin NOT NULL,
6
 
b varchar(32) character set utf8 collate utf8_bin NOT NULL )
7
 
ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
3
a varchar(32) collate utf8_bin NOT NULL,
 
4
b varchar(32) collate utf8_bin NOT NULL );
8
5
INSERT INTO t1 VALUES
9
6
('AAAAAAAAAA','AAAAAAAAAA'), ('AAAAAAAAAB','AAAAAAAAAB '),
10
7
('AAAAAAAAAB','AAAAAAAAAB'), ('AAAAAAAAAC','AAAAAAAAAC'),
14
11
('AAAAAAAAAJ','AAAAAAAAAJ'), ('AAAAAAAAAK','AAAAAAAAAK');
15
12
set tmp_table_size=1024;
16
13
SELECT MAX(a) FROM t1 GROUP BY a,b;
17
 
ERROR 23000: Can't write; duplicate key in table 'tmp_table'
 
14
MAX(a)
 
15
AAAAAAAAAA
 
16
AAAAAAAAAB
 
17
AAAAAAAAAC
 
18
AAAAAAAAAD
 
19
AAAAAAAAAE
 
20
AAAAAAAAAF
 
21
AAAAAAAAAG
 
22
AAAAAAAAAH
 
23
AAAAAAAAAI
 
24
AAAAAAAAAJ
 
25
AAAAAAAAAK
18
26
set tmp_table_size=default;
19
27
DROP TABLE t1;