List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:December 15 2005 9:55am
Subject:Re: invalidation rollback?!
View as plain text  

> I execute follow procedure:
>
> -----------------------------------------------------------
>  create procedure test_transation_rollback()
>  begin
>    start transaction;
>    create table t_34d (c1 int,c2 char(30));
>    rollback;
>  end
> ------------------------------------------------------------
>
> After execute this procedure,i find the table "t_34d" in my schema.Why?
>

Metadata transactions are not supported in MySQL.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Thread
invalidation rollback?!wangxu15 Dec
  • Re: invalidation rollback?!Martijn Tonies15 Dec
    • Re: invalidation rollback?!Joerg Bruehe20 Dec