Description:
Test build based on ChangeSete (from /mysqldev/mysqldev/aix43/test/mysql-classic-5.0.3-alpha-ibm-aix4.3.3.0-powerpc/mysql-test/var/log/mysqltest 1.1813 05/03/15 18:45:29 serg@serg.mylan +1 -0
sun forte does not define __sun__, only __sun and sun (gcc defines all the three)
Test 'sp' fails in a 'classic' build:
-------------------------------------------------------
*** r/sp.result Wed Mar 16 12:59:22 2005
--- r/sp.reject Wed Mar 16 15:24:25 2005is-------------
***************
*** 2780,2785 ****t Mar 16 15:24:25 2005
--- 2780,2787 ----
drop table t1,t2;
drop procedure if exists sp1;g@serg.mylan +1 -1
create table t1 (a int) engine=innodb|
+ Warnings:
+ Warning/my_glo1266 Using storage engine MyISAM for table 't1'
create procedure sp1 ()8 serg@serg.mylan +15 -0
begin
truncate table t1; insert t1 values (1); rollback;
***************
*** 2788,2800 ****/15 19:43:32 ramil@mysql.com +1 -0
set autocommit=0;
**insert t1 values (2);
call sp1();.cc
- ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
commit;
- set autocommit=1;
select * from t1;
a
! 2
call sp1();
select * from t1;
a
1
--- 2790,2803 ----
set autocommit=0;.test
insert t1 values (2);
call sp1();
commit;
set autocommit=1;.result
select * from t1;
a
! 1
call sp1();t.cc
+ Warnings:
+ Warning 1196 Some non-transactional changed tables couldn't be rolled back
select * from t1;
aeap/hp_create.c
1
-------------------------------------------------------
How to repeat:
Build without InnoDB and test.
Suggested fix:
Ensure this part is bypassed in builds without InnoDB.
