why I get Warning 1558 when insert into a falcon table
Posted by:
Lu Tao
Date: March 12, 2007 12:51AM
Warning | 1558 | Falcon does not support SERIALIZABLE ISOLATION, using REPEATABLE READ instead.
mysql> delimiter //
mysql> CREATE PROCEDURE inserttf()
-> BEGIN
-> DECLARE v1 INT DEFAULT 0;
-> WHILE v1 < 1000 DO
-> SET v1 = v1 + 1;
-> insert into tf values(replace(uuid(),'-',''),rand());
-> END WHILE;
-> END
-> //
Query OK, 0 rows affected (0.00 sec)
mysql> delimiter ;
mysql> create table tf (id varchar(32),v decimal(20,2)) engine=falcon;
Query OK, 0 rows affected (0.23 sec)
mysql> call inserttf(1000);
Query OK, 1 row affected, 1121 warnings (0.22 sec)
mysql> show warnings;
+---------+------+--------------------------------------------------------------------------------+
| Level | Code | Message |
+---------+------+--------------------------------------------------------------------------------+
| Warning | 1558 | Falcon does not support SERIALIZABLE ISOLATION, using REPEATABLE READ instead. |
| Warning | 1558 | Falcon does not support SERIALIZABLE ISOLATION, using REPEATABLE READ instead. |
| Warning | 1558 | Falcon does not support SERIALIZABLE ISOLATION, using REPEATABLE READ instead. |
| Warning | 1558 | Falcon does not support SERIALIZABLE ISOLATION, using REPEATABLE READ instead. |
| Warning | 1558 | Falcon does not support SERIALIZABLE ISOLATION, using REPEATABLE READ instead. |
| Warning | 1558 | Falcon does not support SERIALIZABLE ISOLATION, using REPEATABLE READ instead. |
| Note | 1265 | Data truncated for column 'val1' at row 6 |