← Back to branch summary

~ubuntu-branches/ubuntu/lucid/mysql-dfsg-5.1/lucid-security

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 22:33:55 UTC
  • mto: (1.2.1) (37.1.1 lucid-security)
  • mto: This revision was merged to the branch mainline in revision 36.
  • Revision ID: package-import@ubuntu.com-20120222223355-ku1tb4r70osci6v2
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_plugin/r/innodb-autoinc-56228.result
 
1
DROP TABLE IF EXISTS t1_56228;
 
2
Warnings:
 
3
Note    1051    Unknown table 't1_56228'
 
4
DROP TABLE IF EXISTS t2_56228;
 
5
Warnings:
 
6
Note    1051    Unknown table 't2_56228'
 
7
DROP FUNCTION IF EXISTS bug56228;
 
8
Warnings:
 
9
Note    1305    FUNCTION bug56228 does not exist
 
10
CREATE TEMPORARY TABLE t1_56228(
 
11
c1 iNT AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB;
 
12
CREATE TEMPORARY TABLE t2_56228(
 
13
c1 iNT AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB;
 
14
CREATE FUNCTION bug56228() RETURNS INT DETERMINISTIC
 
15
BEGIN
 
16
INSERT INTO t1_56228 VALUES(NULL);
 
17
INSERT INTO t2_56228 VALUES(NULL);
 
18
INSERT INTO t1_56228 VALUES(NULL);
 
19
INSERT INTO t2_56228 VALUES(NULL);
 
20
DROP TEMPORARY TABLE t1_56228;
 
21
RETURN 42;
 
22
END //
 
23
SELECT bug56228();
 
24
bug56228()
 
25
42
 
26
DROP FUNCTION bug56228;
 
27
DROP TEMPORARY TABLE t2_56228;
 
28
DROP TEMPORARY TABLE IF EXISTS t1_56228;
 
29
Warnings:
 
30
Note    1051    Unknown table 't1_56228'