⚝
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
/
r
/
View File Name :
partition-blob.result
# # Bug #20582149 INVALID READ OF SIZE 1 IN PROTOCOL::NET_STORE_DATA # 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; f1 f2 2 Testing MySQL databases is a cool 4 Testing MySQL databases is a cool 42 Testing MySQL databases is a cool DROP TABLE IF EXISTS t1; # # Bug #20685835 INVALID READ OF BLOB MEMORY # # 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; f3 2 3 DROP TABLE t1; # # Bug #28491099 [FATAL] MEMORY BLOCK IS INVALID | INNODB: ASSERTION # FAILURE: UT0UT.CC:670 # set sql_mode=''; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. 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); Warnings: Warning 1364 Field 'b' doesn't have a default value 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;