mirror of
https://github.com/MariaDB/server.git
synced 2025-02-22 21:33:08 +01:00
e7f7789482
* automatically disable ps2 and cursor protocol when the
select statement returns no result set
* remove manual {disable|enable}_{ps2|cursor}_protocol from around
`select ... into` in tests
* other misc collateral test cleanups
80 lines
2.9 KiB
Text
80 lines
2.9 KiB
Text
create table t1 (`a` blob);
|
||
insert into t1 values("hello world"),("Hello mars"),(NULL);
|
||
select * into outfile "../../tmp/outfile-test.1" from t1;
|
||
select load_file('../../tmp/outfile-test.1');
|
||
load_file('../../tmp/outfile-test.1')
|
||
hello world
|
||
Hello mars
|
||
\N
|
||
|
||
select * into dumpfile "../../tmp/outfile-test.2" from t1 limit 1;
|
||
select load_file('../../tmp/outfile-test.2');
|
||
load_file('../../tmp/outfile-test.2')
|
||
hello world
|
||
select * into dumpfile "../../tmp/outfile-test.3" from t1 where a is null;
|
||
select load_file('../../tmp/outfile-test.3');
|
||
load_file('../../tmp/outfile-test.3')
|
||
|
||
select * into outfile "../../tmp/outfile-test.1" from t1;
|
||
ERROR HY000: File '../../tmp/outfile-test.1' already exists
|
||
select * into dumpfile "../../tmp/outfile-test.2" from t1;
|
||
ERROR HY000: File '../../tmp/outfile-test.2' already exists
|
||
select * into dumpfile "../../tmp/outfile-test.3" from t1;
|
||
ERROR HY000: File '../../tmp/outfile-test.3' already exists
|
||
select load_file('../../tmp/outfile-test.not-exist');
|
||
load_file('../../tmp/outfile-test.not-exist')
|
||
NULL
|
||
drop table t1;
|
||
select 1 into outfile "../../tmp/outfile-test.4";
|
||
select load_file('../../tmp/outfile-test.4');
|
||
load_file('../../tmp/outfile-test.4')
|
||
1
|
||
|
||
CREATE TABLE t1 (a INT);
|
||
EXPLAIN
|
||
SELECT *
|
||
INTO OUTFILE '/tmp/t1.txt'
|
||
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
|
||
FROM t1;
|
||
id select_type table type possible_keys key key_len ref rows Extra
|
||
1 SIMPLE t1 system NULL NULL NULL NULL 0 Const row not found
|
||
DROP TABLE t1;
|
||
SELECT * INTO OUTFILE "../../tmp/outfile-test.4"
|
||
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
|
||
FROM information_schema.schemata LIMIT 0, 5;
|
||
use information_schema;
|
||
SELECT * INTO OUTFILE "../../tmp/outfile-test.4"
|
||
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
|
||
FROM schemata LIMIT 0, 5;
|
||
use test;
|
||
create table t1(a int);
|
||
select * into outfile "MYSQL_TEST_DIR/outfile-test1" from t1;
|
||
ERROR HY000: The MariaDB server is running with the --secure-file-priv option so it cannot execute this statement
|
||
drop table t1;
|
||
create database mysqltest;
|
||
create user user_1@localhost;
|
||
grant all on mysqltest.* to user_1@localhost;
|
||
connect con28181_1,localhost,user_1,,mysqltest;
|
||
select schema_name
|
||
into outfile "../../tmp/outfile-test.4"
|
||
fields terminated by ',' optionally enclosed by '"'
|
||
lines terminated by '\n'
|
||
from information_schema.schemata
|
||
where schema_name like 'mysqltest';
|
||
ERROR 28000: Access denied for user 'user_1'@'localhost' (using password: NO)
|
||
connection default;
|
||
disconnect con28181_1;
|
||
grant file on *.* to user_1@localhost;
|
||
connect con28181_2,localhost,user_1,,mysqltest;
|
||
select schema_name
|
||
into outfile "../../tmp/outfile-test.4"
|
||
fields terminated by ',' optionally enclosed by '"'
|
||
lines terminated by '\n'
|
||
from information_schema.schemata
|
||
where schema_name like 'mysqltest';
|
||
connection default;
|
||
disconnect con28181_2;
|
||
use test;
|
||
revoke all privileges on *.* from user_1@localhost;
|
||
drop user user_1@localhost;
|
||
drop database mysqltest;
|