| Bug #15429 | Test "func_math" not prepared for "classic" build | ||
|---|---|---|---|
| Submitted: | 2 Dec 2005 10:09 | Modified: | 26 Jan 2006 2:45 |
| Reporter: | Joerg Bruehe | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 4.1.16 | OS: | Any (all) |
| Assigned to: | Alexey Botchkov | CPU Architecture: | Any |
[10 Dec 2005 14:41]
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/commits/60
[16 Dec 2005 18:02]
Jim Winstead
This patch is wrong. All that needs to be done is to add --disable_warnings/--enable_warnings around the CREATE TABLE in the original test.
[19 Dec 2005 9:47]
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/commits/241
[26 Jan 2006 2:45]
Mike Hillyer
Documented in 4.1.18 changelog:
<listitem>
<para>
Test suite <literal>func_math</literal> test returned warnings
when server not compiled with InnoDB support. (Bug #15429)
</para>
</listitem>

Description: "classic" does not contain InnoDB, hence this effect is to be expected: ------------------------------------------------------- *** r/func_math.result --- r/func_math.reject *************** *** 146,151 --- 146,153 ERROR HY000: Incorrect arguments to RAND drop table t1; create table t1 (a varchar(90), ts datetime not null, index (a)) engine=innodb default charset=utf8; + Warnings: + Warning 1266 Using storage engine MyISAM for table 't1' insert into t1 values ('http://www.foo.com/';, now()); select a from t1 where a='http://www.foo.com/'; order by abs(timediff(ts, 0)); a ------------------------------------------------------- Occurs on all platforms. How to repeat: Build without InnoDB, then run the suite.