mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 19:06:14 +01:00
2bd41fc5bf
Specifically: Revert "MDEV-29664 Assertion `!n_mysql_tables_in_use' failed in innobase_close_connection" This reverts commitba875e9396. Revert "MDEV-29620 Assertion `next_insert_id == 0' failed in handler::ha_external_lock" This reverts commitaa08a7442a. Revert "MDEV-29628 Memory leak after CREATE OR REPLACE with foreign key" This reverts commitc579d66ba6. Revert "MDEV-29609 create_not_windows test fails with different result" This reverts commitcb583b2f1b. Revert "MDEV-29544 SIGSEGV in HA_CREATE_INFO::finalize_locked_tables" This reverts commitdcd66c3814. Revert "MDEV-28933 CREATE OR REPLACE fails to recreate same constraint name" This reverts commitcf6c517632. Revert "MDEV-28933 Moved RENAME_CONSTRAINT_IDS to include/sql_funcs.h" This reverts commitf1e1c1335b. Revert "MDEV-28956 Locking is broken if CREATE OR REPLACE fails under LOCK TABLES" This reverts commita228ec80e3. Revert "MDEV-25292 gcol.gcol_bugfixes --ps fix" This reverts commit24fff8267d. Revert "MDEV-25292 Disable atomic replace for slave-generated or-replace" This reverts commit2af15914cb. Revert "MDEV-25292 backup_log improved" This reverts commit34398a20b5. Revert "MDEV-25292 Atomic CREATE OR REPLACE TABLE" This reverts commit93c8252f02. Revert "MDEV-25292 Table_name class for (db, table_name, alias)" This reverts commitd145dda9c7. Revert "MDEV-25292 ha_table_exists() cleanup and improvement" This reverts commit409b8a86de. Revert "MDEV-25292 Cleanups" This reverts commit595dad83ad. Revert "MDEV-25292 Refactoring: moved select_field_count into Alter_info." This reverts commitf02af1d229.
31 lines
987 B
Text
31 lines
987 B
Text
drop table if exists `about:text`;
|
|
create table `about:text` (
|
|
_id int not null auto_increment,
|
|
`about:text` varchar(255) not null default '',
|
|
primary key (_id)
|
|
);
|
|
show create table `about:text`;
|
|
Table Create Table
|
|
about:text CREATE TABLE `about:text` (
|
|
`_id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`about:text` varchar(255) NOT NULL DEFAULT '',
|
|
PRIMARY KEY (`_id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
|
|
drop table `about:text`;
|
|
use test;
|
|
drop table if exists t1;
|
|
create table t1(a int) engine=myisam;
|
|
insert into t1 values(1);
|
|
"We get an error because the table is in the definition cache"
|
|
create table t1(a int, b int);
|
|
ERROR 42S01: Table 't1' already exists
|
|
"Flush the cache and recreate the table anew to be able to drop it"
|
|
flush tables;
|
|
show open tables like "t%";
|
|
Database Table In_use Name_locked
|
|
create table t1(a int, b int, c int);
|
|
"Try to select from the table. This should not crash the server"
|
|
select count(a) from t1;
|
|
count(a)
|
|
0
|
|
drop table t1;
|