Details
Description
The option sql_if_exists is documented as follows:
If set to 1, adds an implicit IF EXISTS to ALTER, RENAME and DROP of TABLES, VIEWS, FUNCTIONS and PACKAGES. This variable is mainly used in replication to tag DDLs that can be ignored on the slave if the target table doesn't exist.
So, according to the description, it should have no effect on CREATE at all, and shouldn't anyhow prevent CREATE OR REPLACE. But it does:
create table t (a int); |
set sql_if_exists = on; |
|
|
create or replace table t (b int); |
|
|
drop table t; |
|
main 526f0765b3f961803919ec2c47074c5e029acbfb |
mysqltest: At line 4: query 'create or replace table t (b int)' failed: ER_TABLE_EXISTS_ERROR (1050): Table 't' already exists |
Same on all versions back to early 10.5.
Attachments
Issue Links
- is caused by
-
MDEV-19964 S3 replication support
-
- Closed
-