← 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: Monty Taylor
  • Date: 2009-03-08 23:45:12 UTC
  • mto: (923.2.1 mordred)
  • mto: This revision was merged to the branch mainline in revision 921.
  • Revision ID: mordred@inaugust.com-20090308234512-tqkygxtu1iaig23s
Removed C99 isnan() usage, which allows us to remove the util/math.{cc,h} workarounds. Yay for standards!

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
#
5
 
 
 
4
--disable_warnings
6
5
DROP TABLE IF EXISTS t1;
 
6
--enable_warnings
7
7
 
8
8
CREATE TABLE t1 (
9
 
  a varchar(32) character set utf8 collate utf8_bin NOT NULL,
10
 
  b varchar(32) character set utf8 collate utf8_bin NOT NULL )
11
 
ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
9
  a varchar(32) collate utf8_bin NOT NULL,
 
10
  b varchar(32) collate utf8_bin NOT NULL );
12
11
 
13
12
INSERT INTO t1 VALUES
14
13
  ('AAAAAAAAAA','AAAAAAAAAA'), ('AAAAAAAAAB','AAAAAAAAAB '),
22
20
set tmp_table_size=1024;
23
21
 
24
22
--replace_regex /in table '[^']+'/in table 'tmp_table'/
25
 
--error ER_DUP_KEY
26
23
SELECT MAX(a) FROM t1 GROUP BY a,b;
27
24
 
28
25
set tmp_table_size=default;