mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
45bc7574fb
Remove usage of deprecated variable storage_engine. It was deprecated in 5.5 but it never issued a deprecation warning. Make it issue a warning in 10.5.1. Replaced with default_storage_engine.
24 lines
761 B
PHP
24 lines
761 B
PHP
# Test if the engine does autocommit in LOAD DATA INFILE, or not
|
|
|
|
eval SET SESSION DEFAULT_STORAGE_ENGINE = $engine_type;
|
|
|
|
--disable_warnings
|
|
drop table if exists t1;
|
|
--enable_warnings
|
|
|
|
let $load_file= $MYSQLTEST_VARDIR/std_data/loaddata2.dat;
|
|
|
|
create table t1 (id int unsigned not null auto_increment primary key, a text, b text);
|
|
start transaction;
|
|
--replace_result $load_file LOAD_FILE
|
|
eval load data infile '$load_file' ignore into table t1 fields terminated by ',' enclosed by '''' (a, b);
|
|
commit;
|
|
select count(*) from t1;
|
|
truncate table t1;
|
|
start transaction;
|
|
--replace_result $load_file LOAD_FILE
|
|
eval load data infile '$load_file' ignore into table t1 fields terminated by ',' enclosed by '''' (a, b);
|
|
rollback;
|
|
select count(*) from t1;
|
|
|
|
drop table t1;
|