List:Falcon Storage Engine« Previous MessageNext Message »
From:Ann W. Harrison Date:October 16 2008 10:15pm
Subject:Re: Odd new error message since today's pull from 6.0
View as plain text  
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
Thread
Odd new error message since today's pull from 6.0Ann W. Harrison16 Oct
  • Re: Odd new error message since today's pull from 6.0Ann W. Harrison21 Oct
    • Re: Odd new error message since today's pull from 6.0Vladislav Vaintroub21 Oct
    • Re: Odd new error message since today's pull from 6.0Manyi Lu21 Oct
  • Re: Odd new error message since today's pull from 6.0Philip Stoev21 Oct
  • Re: Odd new error message since today's pull from 6.0Philip Stoev22 Oct
Re: Odd new error message since today's pull from 6.0Ann W. Harrison17 Oct
  • Re: Odd new error message since today's pull from 6.0Christopher Powers18 Oct