← 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/parts/r/partition_auto_increment_blackhole.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/parts/r/partition_auto_increment_blackhole.result
120
120
  PRIMARY KEY (`c1`)
121
121
) ENGINE=BLACKHOLE DEFAULT CHARSET=latin1
122
122
DROP TABLE t1;
 
123
CREATE TABLE t1
 
124
(a INT NULL AUTO_INCREMENT,
 
125
UNIQUE KEY (a))
 
126
ENGINE='Blackhole';
 
127
SET LAST_INSERT_ID = 999;
 
128
SET INSERT_ID = 0;
 
129
INSERT INTO t1 SET a = 1 ON DUPLICATE KEY UPDATE a = NULL;
 
130
SELECT LAST_INSERT_ID();
 
131
LAST_INSERT_ID()
 
132
999
 
133
SELECT * FROM t1;
 
134
a
 
135
INSERT INTO t1 SET a = 1 ON DUPLICATE KEY UPDATE a = NULL;
 
136
SELECT LAST_INSERT_ID();
 
137
LAST_INSERT_ID()
 
138
999
 
139
SELECT * FROM t1;
 
140
a
 
141
UPDATE t1 SET a = 1 WHERE a IS NULL;
 
142
SELECT LAST_INSERT_ID();
 
143
LAST_INSERT_ID()
 
144
999
 
145
SELECT * FROM t1;
 
146
a
 
147
UPDATE t1 SET a = NULL WHERE a = 1;
 
148
SELECT LAST_INSERT_ID();
 
149
LAST_INSERT_ID()
 
150
999
 
151
SELECT * FROM t1;
 
152
a
 
153
DROP TABLE t1;
 
154
SET INSERT_ID = 1;
123
155
# Simple test with NULL
124
156
CREATE TABLE t1 (
125
157
c1 INT NOT NULL AUTO_INCREMENT,