← Back to branch summary

~vkolesnikov/pbxt/pbxt-preload-test-bug

« back to all changes in this revision

Viewing changes to pbxt/mysql-test-update/mysql-test/r/pbxt_transactions.result

  • Committer: paul-mccullagh
  • Date: 2008-03-10 11:36:34 UTC
  • Revision ID: paul-mccullagh-417ebf175a9c8ee6e5b3777d9e2398e1fb197391
Implemented full durability

Show diffs side-by-side

added added

removed removed

Lines of Context:
pbxt/mysql-test-update/mysql-test/r/pbxt_transactions.result
103
103
a       b
104
104
Osnabr�ck       K�ln
105
105
test.t1: Records: 1  Deleted: 0  Skipped: 0  Warnings: 0
106
 
select * from t1;
 
106
select * from t1 for update;
107
107
a       b
108
108
Osnabr�ck       K�ln
109
109
drop table if exists t1,t3;
148
148
v       c
149
149
bar     4
150
150
drop table t1,t3|
 
151
drop function getcount;
151
152
drop tables if exists t1;
152
153
Warnings:
153
154
Note    1051    Unknown table 't1'
500
501
show create table t3|
501
502
Table   Create Table
502
503
t3      CREATE TABLE `t3` (
503
 
  `j` int(11) DEFAULT NULL
 
504
  `j` bigint(11) DEFAULT NULL
504
505
) ENGINE=PBXT DEFAULT CHARSET=latin1
505
506
select * from t3|
506
507
j
517
518
create procedure t3_update()
518
519
deterministic
519
520
begin
520
 
declare continue handler for 1582 -- ER_DUP_ENTRY
 
521
declare continue handler for 1062 -- ER_DUP_ENTRY
521
522
select 'Outer (bad)' as 't3_update';
522
523
begin
523
 
declare continue handler for 1582 -- ER_DUP_ENTRY
 
524
declare continue handler for 1062 -- ER_DUP_ENTRY
524
525
select 'Inner (good)' as 't3_update';
525
526
insert into t3 values (1);
526
527
end;