← Back to branch summary

~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/innodb/r/innodb.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/innodb/r/innodb.result
1293
1293
update t3 set  t3.id=7  where t1.id =1 and t2.id = t1.id and t3.id = t2.id;
1294
1294
ERROR 42S22: Unknown column 't1.id' in 'where clause'
1295
1295
drop table t3,t2,t1;
 
1296
CREATE TABLE t1 (
 
1297
c1 VARCHAR(8), c2 VARCHAR(8),
 
1298
PRIMARY KEY (c1, c2)
 
1299
) ENGINE=InnoDB;
 
1300
CREATE TABLE t2 (
 
1301
c0 INT PRIMARY KEY,
 
1302
c1 VARCHAR(8) UNIQUE,
 
1303
FOREIGN KEY (c1) REFERENCES t1 (c1) ON UPDATE CASCADE
 
1304
) ENGINE=InnoDB;
 
1305
INSERT INTO t1 VALUES ('old', 'somevalu'), ('other', 'anyvalue');
 
1306
INSERT INTO t2 VALUES (10, 'old'), (20, 'other');
 
1307
UPDATE t1 SET c1 = 'other' WHERE c1 = 'old';
 
1308
ERROR 23000: Upholding foreign key constraints for table 't1', entry 'other-somevalu', key 2 would lead to a duplicate entry
 
1309
DROP TABLE t2,t1;
1296
1310
create table t1(
1297
1311
id int primary key,
1298
1312
pid int,
1671
1685
71
1672
1686
SELECT variable_value - @innodb_rows_inserted_orig FROM information_schema.global_status WHERE LOWER(variable_name) = 'innodb_rows_inserted';
1673
1687
variable_value - @innodb_rows_inserted_orig
1674
 
1063
 
1688
1067
1675
1689
SELECT variable_value - @innodb_rows_updated_orig FROM information_schema.global_status WHERE LOWER(variable_name) = 'innodb_rows_updated';
1676
1690
variable_value - @innodb_rows_updated_orig
1677
1691
865
2351
2365
) ENGINE=InnoDB DEFAULT CHARSET=latin1
2352
2366
drop table t1;
2353
2367
set storage_engine=MyISAM;
 
2368
Variable_name   Value
 
2369
Handler_read_key        0
 
2370
f1
 
2371
Variable_name   Value
 
2372
Handler_read_key        1