⚝
One Hat Cyber Team
⚝
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
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
suite
/
innodb
/
t
/
View File Name :
partition-blob.test
--source include/have_partition.inc --source include/have_innodb.inc --echo # --echo # Bug #20582149 INVALID READ OF SIZE 1 IN PROTOCOL::NET_STORE_DATA --echo # CREATE TABLE t1 (f1 INT NOT NULL, f2 text, PRIMARY KEY(f1)) PARTITION BY KEY() PARTITIONS 4; INSERT INTO t1 VALUES(42,'Testing MySQL databases is a cool '); INSERT INTO t1 VALUES(2,'Testing MySQL databases is a cool '); INSERT INTO t1 VALUES(4,'Testing MySQL databases is a cool '); select f1, f2 from t1 order by f1; DROP TABLE IF EXISTS t1; --echo # --echo # Bug #20685835 INVALID READ OF BLOB MEMORY --echo # --echo # Test correlated subquery with LOB CREATE TABLE t1 (f1 INT, f2 TEXT, f3 INT, PRIMARY KEY(f1)) PARTITION BY HASH(f1) PARTITIONS 1; INSERT INTO t1 VALUES(1,'1', 3); INSERT INTO t1 VALUES(2,'2', 2); INSERT INTO t1 VALUES(3,'3', 2); SELECT DISTINCT f3 FROM t1 HAVING (SELECT 1 FROM t1 HAVING f2 LIMIT 1) ORDER BY f3; DROP TABLE t1; --echo # --echo # Bug #28491099 [FATAL] MEMORY BLOCK IS INVALID | INNODB: ASSERTION --echo # FAILURE: UT0UT.CC:670 --echo # set sql_mode=''; CREATE TABLE t1(a INT, b TEXT NOT NULL) PARTITION BY RANGE(a) (PARTITION p0 VALUES LESS THAN (6), PARTITION p1 VALUES LESS THAN (9), PARTITION p2 VALUES LESS THAN MAXVALUE); INSERT INTO t1(a) VALUES(0); ALTER TABLE t1 ADD COLUMN c DATE NOT NULL; ALTER TABLE t1 drop partition p0; ALTER TABLE t1 ADD COLUMN d DATE NOT NULL; DROP TABLE t1; SET sql_mode = default;