← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/small_tmp_table.test

  • 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/t/small_tmp_table.test
1
 
 
2
1
#
3
2
# Bug #28499: crash for grouping query when tmp_table_size is too small
4
3
#
7
5
DROP TABLE IF EXISTS t1;
8
6
 
9
7
CREATE TABLE t1 (
10
 
  a varchar(32) character set utf8 collate utf8_bin NOT NULL,
11
 
  b varchar(32) character set utf8 collate utf8_bin NOT NULL )
12
 
ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
8
  a varchar(32) collate utf8_bin NOT NULL,
 
9
  b varchar(32) collate utf8_bin NOT NULL );
13
10
 
14
11
INSERT INTO t1 VALUES
15
12
  ('AAAAAAAAAA','AAAAAAAAAA'), ('AAAAAAAAAB','AAAAAAAAAB '),
22
19
set tmp_table_size=1024;
23
20
 
24
21
--replace_regex /in table '[^']+'/in table 'tmp_table'/
25
 
--error ER_DUP_KEY
26
22
SELECT MAX(a) FROM t1 GROUP BY a,b;
27
23
 
28
24
set tmp_table_size=default;