← 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: 2008-12-24 19:41:08 UTC
  • mfrom: (722.2.32 devel)
  • Revision ID: brian@tangent.org-20081224194108-4140ku9dgjkyk97m
Merge from Monty.

Show diffs side-by-side

added added

removed removed

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