From: Ann W. Harrison
Date: October 16 2008 10:15pm
Subject: Re: Odd new error message since today's pull from 6.0
List-Archive: http://lists.mysql.com/falcon/38
Message-Id: <48F7BCE4.90605@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset=ISO-8859-1
Content-Transfer-Encoding: 7BIT

Philip Stoev wrote:
> This script does only CREATE TABLE and single-row INSERT IGNORE , so 
> whatever it is , it is not good.
> 

Yup.  The problem is insert ignore, as this case shows ...


mysql> create database awh;
Query OK, 1 row affected (0.02 sec)

mysql> use awh;
Database changed
mysql> create table t1 (f1 integer) engine=Falcon;
Query OK, 0 rows affected (0.19 sec)

mysql> insert ignore into t1 (f1) values (5);
ERROR 1598 (HY000): Binary logging not possible.
   Message: Statement-based format required for this statement, but
   not allowed by this combination of engines
mysql>

Sigh.


Ann