mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-04-14 11:15:34 +02:00
Code Issues Projects Releases Packages Wiki Activity Actions1
mariadb/mysql-test/suite/encryption/r
History
Igor Babaev 77ea99a4b5 MDEV-35869 Wrong result using degenerated subquery with window function 
This bug affected queries containing degenerated single-value subqueries
with window functions. The bug led mostly to wrong results for such
queries.

A subquery is called degenerated if it is of the form (SELECT <expr>...).

For degenerated subqueries of the form (SELECT <expr>) the transformation
   (SELECT <expr>) => <expr>
usually is applied. However if <expr> contains set functions or window
functions such rewriting is not valid for an obvious reason. The code
before this patch erroneously applied the transformation when <expr>
contained window functions and did not contain set functions.

Approved by Rex Johnston <rex.johnston@mariadb.com>
2025-01-23 13:50:29 -08:00
..
aria_tiny.result MDEV-25507 CHECK on encrypted Aria table complains about "Wrong LSN" 2021-04-30 15:45:07 +03:00
compressed_import_tablespace.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
corrupted_during_recovery.result Merge 10.4 into 10.5 2019-05-29 22:29:05 +03:00
create_or_replace.result MDEV-23776: Re-apply the fix and make the test more robust 2020-09-22 13:08:09 +03:00
create_or_replace_big.result Merge 10.3 into 10.4 2020-09-21 17:42:02 +03:00
debug_key_management.result MDEV-29613 Improve WITH_DBUG_TRACE=OFF 2022-09-23 13:40:42 +03:00
encrypt_and_grep.result Merge 10.2 into 10.3 2021-11-09 08:26:59 +02:00
encryption_force.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
encryption_key_corruption.result MDEV-27882 Innodb - recognise MySQL-8.0 innodb flags and give a specific error message 2022-11-11 10:21:28 +11:00
file_creation.result Problem: 2019-08-16 18:11:32 +05:30
filekeys_emptyfile.result MDEV-12762 Some files in current 10.2 tree seem to be reverted to an old state 2017-05-10 09:06:57 +03:00
filekeys_encfile.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
filekeys_encfile_bad.result MDEV-12762 Some files in current 10.2 tree seem to be reverted to an old state 2017-05-10 09:06:57 +03:00
filekeys_encfile_badfile.result MDEV-12762 Some files in current 10.2 tree seem to be reverted to an old state 2017-05-10 09:06:57 +03:00
filekeys_encfile_file.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
filekeys_encfile_no.result MDEV-12762 Some files in current 10.2 tree seem to be reverted to an old state 2017-05-10 09:06:57 +03:00
filekeys_nofile.result MDEV-12762 Some files in current 10.2 tree seem to be reverted to an old state 2017-05-10 09:06:57 +03:00
filekeys_secret_openssl_rand_128bits.result MDEV-25343 Error log message not helpful when filekey is too long 2022-10-21 15:54:17 +11:00
filekeys_secret_too_long.result MDEV-25343 Error log message not helpful when filekey is too long 2022-10-21 15:54:17 +11:00
filekeys_syntax.result MDEV-12762 Some files in current 10.2 tree seem to be reverted to an old state 2017-05-10 09:06:57 +03:00
filekeys_tooshort.result MDEV-12762 Some files in current 10.2 tree seem to be reverted to an old state 2017-05-10 09:06:57 +03:00
filekeys_unencfile.result MDEV-12762 Some files in current 10.2 tree seem to be reverted to an old state 2017-05-10 09:06:57 +03:00
import_4k.result MDEV-29692 Assertion `(writeptr + (i * size)) != local_frame' failed upon IMPORT TABLESPACE 2023-03-21 14:33:54 +02:00
innochecksum.result Merge 10.3 into 10.4 2022-04-06 08:59:09 +03:00
innodb-bad-key-change.result MDEV-19335 adjustment for innodb_checksum_algorithm=full_crc32 2019-10-10 15:24:14 +03:00
innodb-bad-key-change2.result Merge 10.3 into 10.4 2022-12-13 11:37:33 +02:00
innodb-bad-key-change3.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
innodb-bad-key-change4.result Fix mtr tests with file_key_managment extension for Windows 2021-06-04 14:57:13 +02:00
innodb-checksum-algorithm,32k.rdiff MDEV-18601 Can't create table with ENCRYPTED=DEFAULT when innodb_default_encryption_key_id!=1 2019-02-28 23:20:31 +02:00
innodb-checksum-algorithm,64k.rdiff MDEV-18601 Can't create table with ENCRYPTED=DEFAULT when innodb_default_encryption_key_id!=1 2019-02-28 23:20:31 +02:00
innodb-checksum-algorithm.result Merge 10.3 into 10.4 2021-03-11 19:33:45 +02:00
innodb-compressed-blob.result Merge 10.3 into 10.4 2019-04-05 11:41:03 +03:00
innodb-discard-import-change.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
innodb-discard-import.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
innodb-encr-threads.result
innodb-encryption-alter.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
innodb-encryption-disable.result Fix mtr tests with file_key_managment extension for Windows 2021-06-04 14:57:13 +02:00
innodb-force-corrupt.result MDEV-22010: Allow mariadbd in mtr suppressions 2020-04-07 17:20:38 +03:00
innodb-key-rotation-disable.result Merge 10.3 into 10.4 2021-06-21 12:38:25 +03:00
innodb-missing-key.result Merge 10.3 into 10.4 2019-04-05 11:41:03 +03:00
innodb-page_encryption-32k.result MDEV-21664 Add opt files for have_innodb_Xk.inc 2023-09-11 09:09:02 +03:00
innodb-page_encryption.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
innodb-page_encryption_compression.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
innodb-page_encryption_log_encryption.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
innodb-read-only.result Write information about restart in .result 2019-04-01 19:47:24 +03:00
innodb-redo-badkey.result MDEV-15053 Reduce buf_pool_t::mutex contention 2020-06-05 12:35:46 +03:00
innodb-redo-nokeys.result MDEV-33274 The test encryption.innodb-redo-nokeys often fails 2024-02-08 08:13:16 +05:30
innodb-remove-encryption.result Merge 10.4 into 10.5 2021-06-08 16:03:53 +03:00
innodb-spatial-index,full_crc32.rdiff Write information about restart in .result 2019-04-01 19:47:24 +03:00
innodb-spatial-index,strict_full_crc32.rdiff Write information about restart in .result 2019-04-01 19:47:24 +03:00
innodb-spatial-index.result MDEV-18644: Support full_crc32 for page_compressed 2019-03-18 14:08:43 +02:00
innodb_encrypt_freed.result MDEV-24792 Assertion `!newest_lsn || fil_page_get_type(page)' failed upon MariaBackup prepare in buf_flush_init_for_writing with innodb_log_optimize_ddl=off 2021-02-14 10:11:03 +03:00
innodb_encrypt_key_rotation_age.result Merge 10.2 into 10.3 2019-05-02 21:45:13 +03:00
innodb_encrypt_log.result Merge 10.3 into 10.4 2020-08-20 11:01:47 +03:00
innodb_encrypt_log_corruption.result MDEV-24412: Create a separate test 2022-11-30 06:57:32 +02:00
innodb_encrypt_temporary_tables.result MDEV-20142 encryption.innodb_encrypt_temporary_tables fails 2023-12-10 13:19:21 +02:00
innodb_encryption-page-compression.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
innodb_encryption.result Merge 10.3 into 10.4 2021-09-22 18:26:54 +03:00
innodb_encryption_discard_import.result MDEV-34670 IMPORT TABLESPACE unnecessary traverses tablespace list 2024-07-31 14:13:38 +05:30
innodb_encryption_filekeys.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
innodb_encryption_is.result MDEV-12762 Some files in current 10.2 tree seem to be reverted to an old state 2017-05-10 09:06:57 +03:00
innodb_encryption_row_compressed.result Write information about restart in .result 2019-04-01 19:47:24 +03:00
innodb_encryption_tables.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
innodb_first_page.result Write information about restart in .result 2019-04-01 19:47:24 +03:00
innodb_import.result Merge 10.4 into 10.5 2021-08-18 18:22:35 +03:00
innodb_onlinealter_encryption.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
innodb_page_encryption_key_change.result Write information about restart in .result 2019-04-01 19:47:24 +03:00
instant_alter_import.result MDEV-18543 IMPORT TABLESPACE fails after instant DROP COLUMN 2021-10-26 22:50:58 +06:00
key_version_rotation.result Merge 10.3 into 10.4 2021-06-21 12:38:25 +03:00
second_plugin-12863.result MDEV-12863 No table can be created after second encryption plugin attempted to load 2017-08-08 14:52:08 +02:00
tempfiles.result Updated mtr files to support different compiled in options 2019-09-01 19:17:35 +03:00
tempfiles_encrypted.result MDEV-35869 Wrong result using degenerated subquery with window function 2025-01-23 13:50:29 -08:00