Debian Codegraph @

mysql-test/suite/encryption/t/filekeys_named_pipe.test

raw
1 --echo #
2 --echo # MDEV-9158 file_key_management should support reading from a named pipe
3 --echo #
4 source include/not_windows.inc;
5 source include/have_innodb.inc;
6 source include/have_sequence.inc;
7 #
8 # Test read key from named pipe
9 #
10
11 # large key file, >64K, which is the default value for F_SETPIPE_SZ
12 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
13 eval select seq,md5(seq)
14 into outfile '$MYSQLTEST_VARDIR/tmp/fifo-key.txt'
15 fields terminated by ';'
16 from seq_1_to_20000;
17
18 exec mkfifo $MYSQLTEST_VARDIR/tmp/fifo.key;
19 system cat $MYSQLTEST_VARDIR/tmp/fifo-key.txt > $MYSQLTEST_VARDIR/tmp/fifo.key 2>/dev/null &;
20
21 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
22 INSTALL SONAME 'file_key_management';
23
24 CREATE TABLE t1(c1 BIGINT NOT NULL, b CHAR(200)) ENGINE=INNODB ENCRYPTED=YES ENCRYPTION_KEY_ID=1;
25 SHOW CREATE TABLE t1;
26 INSERT t1 VALUES (12345, REPEAT('1234567890', 20));
27
28 ALTER TABLE t1 ENCRYPTION_KEY_ID=2;
29 SHOW CREATE TABLE t1;
30 ALTER TABLE t1 ENCRYPTION_KEY_ID=3;
31 SHOW CREATE TABLE t1;
32
33 --echo # Reset mysqld
34 DROP TABLE t1;
35 remove_file $MYSQLTEST_VARDIR/tmp/fifo.key;
36 remove_file $MYSQLTEST_VARDIR/tmp/fifo-key.txt;
37 UNINSTALL SONAME 'file_key_management';
38
39 --source include/restart_mysqld.inc
40