mirror of
https://github.com/MariaDB/server.git
synced 2025-02-15 18:05:32 +01:00
1f4a9f086a
This was done after discussions with Igor, Sanja and Bar. The main reason for removing the deprication was to ensure that MariaDB is always backward compatible whenever possible. Other things: - Added statistics counters, mainly for the feedback plugin. - INTO OUTFILE - INTO variable - If INTO is using the old syntax (end of query)
38 lines
980 B
Text
38 lines
980 B
Text
include/master-slave.inc
|
|
[connection master]
|
|
connection master;
|
|
drop database if exists mysqltest1;
|
|
create database mysqltest1;
|
|
create table mysqltest1.t1 (n int);
|
|
insert into mysqltest1.t1 values (1);
|
|
select * from mysqltest1.t1 into outfile 'mysqltest1/f1.txt';
|
|
create table mysqltest1.t2 (n int);
|
|
create table mysqltest1.t3 (n int);
|
|
drop database mysqltest1;
|
|
ERROR HY000: Error dropping database (can't rmdir './mysqltest1', errno: 39 "Directory not empty")
|
|
use mysqltest1;
|
|
show tables;
|
|
Tables_in_mysqltest1
|
|
drop database mysqltest1;
|
|
ERROR HY000: Error dropping database (can't rmdir './mysqltest1', errno: 39 "Directory not empty")
|
|
use mysqltest1;
|
|
show tables;
|
|
Tables_in_mysqltest1
|
|
use test;
|
|
create table t1 (n int);
|
|
insert into t1 values (1234);
|
|
connection slave;
|
|
connection slave;
|
|
use mysqltest1;
|
|
show tables;
|
|
Tables_in_mysqltest1
|
|
use test;
|
|
select * from t1;
|
|
n
|
|
1234
|
|
connection master;
|
|
use test;
|
|
drop table t1;
|
|
drop database mysqltest1;
|
|
connection slave;
|
|
include/rpl_end.inc
|