← 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-12-18 18:24:57 UTC
  • mfrom: (1999.6.3 trunk)
  • Revision ID: brian@tangent.org-20101218182457-yi1wd0so2hml1k1w
Merge in Lee's copyright header fix

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
ERROR HY000: Temporary table too large, rerun with SQL_BIG_RESULT.
 
15
SELECT SQL_BIG_RESULT MAX(a) FROM t1 GROUP BY a,b;
 
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;