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:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.16 OS:Any (all)
Assigned to: Alexey Botchkov CPU Architecture:Any

[2 Dec 2005 10:09] Joerg Bruehe
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.
[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>