Description:
I start a transaction.
I make a savepoint.
I update.
I rollback to the savepoint.
I select. (The results are wrong but that's a different bug, bug 200).
I quit.
Crash.
How to repeat:
ow to repeat:
mysql> create database f12;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| f12 |
| mysql |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql> use f12;
Database changed
mysql> set @@autocommit=0;
Query OK, 0 rows affected (0.00 sec)
mysql> create table tf2 (s2 char(50)) engine=falcon;
Query OK, 0 rows affected (0.00 sec)
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql> start transaction;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into tf2 values ('The plain');
Query OK, 1 row affected (0.00 sec)
mysql> savepoint a;
Query OK, 0 rows affected (0.00 sec)
mysql> update tf2 set s2 = 'b';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> rollback to savepoint a;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from tf2;
Empty set (0.00 sec)
mysql> quit;
Bye
