diff options
Diffstat (limited to 'mysql-test/suite/encryption/t/tempfiles_encrypted.test')
-rw-r--r-- | mysql-test/suite/encryption/t/tempfiles_encrypted.test | 26 |
1 files changed, 25 insertions, 1 deletions
diff --git a/mysql-test/suite/encryption/t/tempfiles_encrypted.test b/mysql-test/suite/encryption/t/tempfiles_encrypted.test index 96b981c1c06..7628442f884 100644 --- a/mysql-test/suite/encryption/t/tempfiles_encrypted.test +++ b/mysql-test/suite/encryption/t/tempfiles_encrypted.test @@ -5,9 +5,31 @@ source include/have_file_key_management_plugin.inc; source include/have_sequence.inc; source include/have_innodb.inc; - + select @@encrypt_tmp_files; +--source main/win.test + +--echo # +--echo # MDEV-23867: select crash in compute_window_func +--echo # + +set @save_sort_buffer_size=@@sort_buffer_size; + +set sort_buffer_size= 2000; +CREATE TABLE t1( a INT, b INT, c INT); +INSERT INTO t1 select seq, seq, seq from seq_1_to_5000; +CREATE TABLE t2( a INT, b INT, c INT); +INSERT INTO t2 SELECT a, b, ROW_NUMBER() OVER (PARTITION BY b) FROM t1; +SELECT COUNT(*), MAX(c) FROM t2; +CREATE TABLE t3( a INT, b INT, c INT); +INSERT INTO t3 SELECT a, b, SUM(a) OVER () FROM t1; +SELECT COUNT(*), MAX(c) FROM t3; +set @@sort_buffer_size=@save_sort_buffer_size; +DROP TABLE t1,t2,t3; + +--echo # end of 10.2 test + --echo # --echo # MDEV-22556: Incorrect result for window function when using encrypt-tmp-files=ON --echo # @@ -21,3 +43,5 @@ select count(*) from (select a, b, c, ROW_NUMBER() OVER (PARTITION BY a) FROM t1 set @@sort_buffer_size=@save_sort_buffer_size; drop table t1; + +--echo # End of 10.4 tests |