source include/have_file_key_management_plugin.inc;

source include/have_sequence.inc;

source include/have_innodb.inc;

select @@encrypt_tmp_files;

set sort_buffer_size= 2000;

create table t1( a DECIMAL(12,0) DEFAULT NULL, b VARCHAR(20) DEFAULT NULL, c DECIMAL(12,0) DEFAULT NULL)engine=INNODB;

insert into t1 select seq, seq, seq from seq_1_to_5000;

select count(*) from (select a, b, c, ROW_NUMBER() OVER (PARTITION BY a) FROM t1)q;

drop table t1;

--encrypt-tmp-files=ON

--loose-file-key-management-encryption-algorithm=aes_cbc

--file-key-management=FORCE

--loose-file-key-management-filename=$MTR_SUITE_DIR/t/filekeys-data.enc

--loose-file-key-management-filekey=FILE:$MTR_SUITE_DIR/t/filekeys-data.key

MariaDB [test]> select count(*) from (select a, b, c, ROW_NUMBER() OVER (PARTITION BY a) FROM t1)q;

+----------+

| count(*) |

+----------+

|     4096 |

+----------+

1 row in set (0.373 sec)

MariaDB [test]> select @@encrypt_tmp_files;

+---------------------+

| @@encrypt_tmp_files |

+---------------------+

|                   0 |

+---------------------+

1 row in set (0.001 sec)

MariaDB [test]> select count(*) from (select a, b, c, ROW_NUMBER() OVER (PARTITION BY a) FROM t1)q;

+----------+

| count(*) |

+----------+

|     5000 |

+----------+

1 row in set (0.378 sec)