| Bug #10929 | Tests "bugs" and "type_newdecimal" need InnoDB, skip otherwise | ||
|---|---|---|---|
| Submitted: | 27 May 2005 20:18 | Modified: | 14 Jul 2005 14:28 |
| Reporter: | Joerg Bruehe | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.6 | OS: | all Unix |
| Assigned to: | Alexey Botchkov | CPU Architecture: | Any |
[27 May 2005 20:48]
Joerg Bruehe
Same holds for test "type_newdecimal": ------------------------------------------------------- *** r/type_newdecimal.result Thu May 26 18:32:47 2005 --- r/type_newdecimal.reject Fri May 27 16:49:10 2005 *************** *** 877,882 **** --- 877,884 ---- 9999999999999999999999999999999999.00000000000000000000 0.00 DROP TABLE t1; CREATE TABLE t1 (GRADE DECIMAL(4) NOT NULL, PRIMARY KEY (GRADE)) ENGINE=INNODB; + Warnings: + Warning 1266 Using storage engine MyISAM for table 't1' INSERT INTO t1 (GRADE) VALUES (151),(252),(343); SELECT GRADE FROM t1 WHERE GRADE > 160 AND GRADE < 300; GRADE -------------------------------------------------------
[1 Jun 2005 15:43]
Mikael Ronström
Test case bugs fixed (moved enabling of warnings to after CREATE TABLE statement) also renamed bugs.test to default.test at the same time
[14 Jul 2005 13:49]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/27074
[14 Jul 2005 14:28]
Alexey Botchkov
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.
If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information
about accessing the source trees is available at
http://www.mysql.com/doc/en/Installing_source_tree.html
Description: See synopsis. Symptom in a "classic" build: ------------------------------------------------------- *** r/bugs.result Thu May 26 18:32:44 2005 --- r/bugs.reject Fri May 27 16:05:28 2005 *************** *** 29,34 **** --- 29,36 ---- a1 varchar(30) binary NOT NULL DEFAULT ' ', b1 tinyblob NULL) ENGINE=InnoDB DEFAULT CHARACTER SET = latin1 COLLATE latin1_bin; + Warnings: + Warning 1266 Using storage engine MyISAM for table 't1' SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( *************** *** 60,66 **** `z` varchar(20) collate latin1_bin NOT NULL default ' ', `a1` varchar(30) collate latin1_bin NOT NULL default ' ', `b1` tinyblob ! ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin INSERT into t1 (b) values ('1'); SHOW WARNINGS; Level Code Message --- 62,68 ---- `z` varchar(20) collate latin1_bin NOT NULL default ' ', `a1` varchar(30) collate latin1_bin NOT NULL default ' ', `b1` tinyblob ! ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin INSERT into t1 (b) values ('1'); SHOW WARNINGS; Level Code Message ------------------------------------------------------- How to repeat: Run the test suite.