308
308
insert into t1 (id) values (1);
309
309
# We have to clean up the path in the results for safe comparison
311
charset(load_file('../std_data_ln/words.dat')),
312
collation(load_file('../std_data_ln/words.dat')),
313
coercibility(load_file('../std_data_ln/words.dat'));
311
charset(load_file('../../std_data/words.dat')),
312
collation(load_file('../../std_data/words.dat')),
313
coercibility(load_file('../../std_data/words.dat'));
314
314
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
315
315
eval explain extended select
316
charset(load_file('$MYSQLTEST_VARDIR/std_data_ln/words.dat')),
317
collation(load_file('$MYSQLTEST_VARDIR/std_data_ln/words.dat')),
318
coercibility(load_file('$MYSQLTEST_VARDIR/std_data_ln/words.dat'));
316
charset(load_file('$MYSQLTEST_VARDIR/std_data/words.dat')),
317
collation(load_file('$MYSQLTEST_VARDIR/std_data/words.dat')),
318
coercibility(load_file('$MYSQLTEST_VARDIR/std_data/words.dat'));
319
319
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
320
eval update t1 set imagem=load_file('$MYSQLTEST_VARDIR/std_data_ln/words.dat') where id=1;
320
eval update t1 set imagem=load_file('$MYSQLTEST_VARDIR/std_data/words.dat') where id=1;
321
321
select if(imagem is null, "ERROR", "OK"),length(imagem) from t1 where id = 1;
323
323
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
324
eval create table t1 select load_file('$MYSQLTEST_VARDIR/std_data_ln/words.dat') l;
324
eval create table t1 select load_file('$MYSQLTEST_VARDIR/std_data/words.dat') l;
325
325
# We mask out the Privileges column because it differs for embedded server
326
326
--replace_column 8 #
327
327
show full fields from t1;