mirror of
https://github.com/MariaDB/server.git
synced 2025-11-04 04:46:15 +01:00
e3130d22e1
- MDEV-22062 Assertion `!table->file->keyread_enabled()' failed in close_thread_table() - MDEV-22077 table->no_keyread .. failed in join_read_first() - MDEV-22237 Assertion `!table->file->keyread_enabled()' failed in handler::ha_reset on DELETE
16 lines
470 B
Text
16 lines
470 B
Text
create table t1 (f1 int not null, f2 int, f3 int, primary key (f1,f2), key(f2,f3)) engine=innodb;
|
|
create view v1 as select * from t1 where f2 = 1;
|
|
select distinct f1 from v1;
|
|
f1
|
|
drop view v1;
|
|
drop table t1;
|
|
CREATE TABLE t1 (a INT NOT NULL, UNIQUE(a)) ENGINE=InnoDB;
|
|
INSERT INTO t1 VALUES (1),(2);
|
|
DELETE FROM t1 ORDER BY a LIMIT 1;
|
|
SELECT * FROM t1;
|
|
a
|
|
2
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1 (a CHAR KEY,b BLOB) ENGINE=InnoDB;
|
|
DELETE FROM t1 ORDER BY a LIMIT 1;
|
|
DROP TABLE t1;
|