mirror of
https://github.com/MariaDB/server.git
synced 2026-02-17 08:08:42 +01:00
28 lines
832 B
Text
28 lines
832 B
Text
#
|
|
# Check CREATE OR REPLACE TABLE
|
|
#
|
|
--source include/have_perfschema.inc
|
|
|
|
--echo #
|
|
--echo # MDEV-23298 Assertion `table_list->prelocking_placeholder ==
|
|
--echo # TABLE_LIST::PRELOCK_NONE' failed in check_lock_and_start_stmt on
|
|
--echo # CREATE OR REPLACE TABLE
|
|
--echo #
|
|
|
|
create table t2 (a int);
|
|
insert into t2 values(1),(2);
|
|
CREATE TABLE t1 (a INT);
|
|
CREATE OR REPLACE TABLE t1 AS SELECT sys.format_statement('SELECT 1') AS q;
|
|
drop table t1;
|
|
CREATE TABLE t1 (a INT);
|
|
CREATE OR REPLACE TABLE t1 AS SELECT sys.format_statement('SELECT 1') AS q, t2.a from t2;
|
|
SELECT * from t1;
|
|
drop table t1;
|
|
CREATE TABLE t1 (a INT);
|
|
lock table t1 write,t2 read, sys.sys_config read;
|
|
CREATE OR REPLACE TABLE t1 AS SELECT sys.format_statement('SELECT 1') AS q, t2.a from t2;
|
|
unlock tables;
|
|
select * from t1;
|
|
drop table t1,t2;
|
|
|
|
--echo # End of 10.6 tests
|