2
# https://bugs.launchpad.net/drizzle/+bug/385808
5
create temporary table t1 (v varchar(32) not null);
6
insert into t1 values ('def'),('abc'),('hij'),('3r4f');
8
# Fast alter, no copy performed
9
alter table t1 change v v2 varchar(32);
11
# Fast alter, no copy performed
12
alter table t1 change v2 v varchar(64);
14
update t1 set v = 'lmn' where v = 'hij';
17
alter table t1 add i int auto_increment not null primary key first;
19
update t1 set i=5 where i=3;
21
alter table t1 change i i bigint;
23
alter table t1 add unique key (i, v);
24
select * from t1 where i between 2 and 4 and v in ('def','3r4f','lmn');
27
# (Pulled from MySQL, it had a similar issue)
28
# Bug#38821: Assert table->auto_increment_field_not_null failed in open_table()
30
CREATE TABLE t1 (a INTEGER AUTO_INCREMENT PRIMARY KEY, b INTEGER NOT NULL);
31
INSERT IGNORE INTO t1 (b) VALUES (5);
33
CREATE TABLE IF NOT EXISTS t2 (a INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY)
36
CREATE TABLE IF NOT EXISTS t2 (a INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY)
39
CREATE TABLE IF NOT EXISTS t2 (a INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY)
added
removed
tests/t/regression_385808.test
