Bug #32513 Falcon test checks for InnoDB presence
Submitted: 20 Nov 2007 11:51 Modified: 21 Nov 2007 20:30
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:6.0.4-alpha (pre) OS:Any
Assigned to: Joerg Bruehe CPU Architecture:Any

[20 Nov 2007 11:51] Joerg Bruehe
Description:
Found in local tests of current "6.0-build":

The Falcon table handler is replaced by MyISAM.

funcs_1.falcon_storedproc_10   [ fail ]

--- /MySQL/M60/work-6.0/mysql-test/suite/funcs_1/r/falcon_storedproc_10.result  2007-11-09 00:34:34.000000000 +0300
+++ /MySQL/M60/work-6.0/mysql-test/suite/funcs_1/r/falcon_storedproc_10.reject  2007-11-20 11:43:49.000000000 +0300
@@ -12,18 +12,36 @@
 CREATE DATABASE db_storedproc_1;
 USE db_storedproc;
 create table t1(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int) engine = falcon;
+Warnings:
+Warning        1286    Unknown table engine 'falcon'
+Warning        1266    Using storage engine MyISAM for table 't1'
 load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' into table t1;
 create table t2(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int) engine = falcon;
+Warnings:
+Warning        1286    Unknown table engine 'falcon'
+Warning        1266    Using storage engine MyISAM for table 't2'
 ...

How to repeat:
Run the "funcs_1" suite,
for example by "make test-bt".

Suggested fix:
Look at the test file:

      1 #### suite/funcs_1/t/falcon_storedproc_10.test
      2 # created: 2007-11-02 by hhunger
      3 #
      4 # 1. Check if Falcon is available
      5 --source include/have_innodb.inc
      6
      7 # 2. Set $engine_type
      8 let $engine_type= falcon;
      9
     10 --source suite/funcs_1/storedproc/storedproc_10.inc

In line 5, use "have_falcon.inc".

This will make the test skip, as then the problem of bug#32512 applies.
[20 Nov 2007 12:04] 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/38129

ChangeSet@1.2676, 2007-11-20 13:04:21+01:00, joerg@trift2. +1 -0
  Fix bug#32513 "Falcon test checks for InnoDB presence", it was a typing error.
[21 Nov 2007 18:54] Bugs System
Pushed into 6.0.4-alpha
[21 Nov 2007 20:30] Paul Dubois
Test case changes. No changelog entry needed.