Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/server/mysql/mysql-test/suite/innodb/r/

Edit File: import_compress_encrypt_upgrade.result

#
# Bug#31313533 : IMPORT FAILS FOR ENCRYPT AND COMPRESSION ENABLED TDE TABLES
# upgrade section
#

# Test 4 : check table from old version are read correctly after upgrade

# Stop the running the server
# Copy and unzip the datadir.
# Restart the server against the unzipped datadir
# restart: --datadir=DATADIR --innodb-page-size=16k --early-plugin-load=keyring_file=keyring_file.so --loose-keyring_file_data=DATADIR/keyring KEYRING_PLUGIN_OPT
# Verify tables after upgrade
USE test;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) NOT NULL AUTO_INCREMENT,
  `c2` varchar(65000) DEFAULT NULL,
  `c3` varchar(255) GENERATED ALWAYS AS (substr(`c2`,2,100)) STORED,
  `c4` varchar(255) GENERATED ALWAYS AS (substr(`c2`,10,200)) VIRTUAL,
  `b` bit(64) DEFAULT NULL,
  `p_c1` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`c1`)
) ENGINE=InnoDB AUTO_INCREMENT=56000 DEFAULT CHARSET=latin1 COMPRESSION='zlib' ENCRYPTION='Y'
SELECT c1, SUBSTRING(c2, 10, 10), SUBSTRING(c3, 10, 10), SUBSTRING(c4, 10, 10), b FROM t1 ORDER BY c1 limit 10;
c1	SUBSTRING(c2, 10, 10)	SUBSTRING(c3, 10, 10)	SUBSTRING(c4, 10, 10)	b
50001	l��>�!u�w	l��>�!u�w�	w����[�s��	�������

50002	l��>�!u�w	l��>�!u�w�	w����[�s��	�������

50003	l��>�!u�w	l��>�!u�w�	w����[�s��	�������

50004	l��>�!u�w	l��>�!u�w�	w����[�s��	�������

50005	l��>�!u�w	l��>�!u�w�	w����[�s��	�������

50006	l��>�!u�w	l��>�!u�w�	w����[�s��	�������

50007	l��>�!u�w	l��>�!u�w�	w����[�s��	�������

50008	l��>�!u�w	l��>�!u�w�	w����[�s��	�������

50009	l��>�!u�w	l��>�!u�w�	w����[�s��	�������

50010	l��>�!u�w	l��>�!u�w�	w����[�s��	�������

# Run some DML statements
INSERT INTO t1(c2,b,p_c1) VALUES(AES_ENCRYPT("5dd0786a3c7adf503202b8e234a95cbe643bc752028e1792ca8e6ef86c69582eb1cc478670c8e5d6c0133d1b4e5c98017aeb893f9db5f1bff397bc9e0f5fde48","abc"),10,100);
DELETE FROM t1 WHERE c1=50001;
# Verify results
SELECT c1, SUBSTRING(c2, 10, 10), SUBSTRING(c3, 10, 10), SUBSTRING(c4, 10, 10), b FROM t1 ORDER BY c1 limit 10;
c1	SUBSTRING(c2, 10, 10)	SUBSTRING(c3, 10, 10)	SUBSTRING(c4, 10, 10)	b
50002	l��>�!u�w	l��>�!u�w�	w����[�s��	�������