⚝
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
/
gcol
/
r
/
View File Name :
gcol_partition_myisam.result
SET @@session.default_storage_engine = 'MyISAM'; drop table if exists t1; # Case 1. Partitioning by RANGE based on a non-stored generated column. CREATE TABLE t1 ( a DATE NOT NULL, b int generated always as (year(a)) virtual ) PARTITION BY RANGE( b ) ( PARTITION p0 VALUES LESS THAN (2006), PARTITION p2 VALUES LESS THAN (2008) ); Warnings: Warning 1287 The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead. insert into t1 values ('2006-01-01',default); Warnings: Warning 1287 The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead. insert into t1 values ('2007-01-01',default); insert into t1 values ('2005-01-01',default); select * from t1; a b 2005-01-01 2005 2006-01-01 2006 2007-01-01 2007 # Modify the expression of generated column b ALTER TABLE t1 modify b int generated always as (year(a)-1) virtual; Warnings: Warning 1287 The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead. select * from t1; a b 2005-01-01 2004 2006-01-01 2005 2007-01-01 2006 Warnings: Warning 1287 The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead. drop table t1; # Case 2. Partitioning by LIST based on a stored generated column. CREATE TABLE t1 (a int, b int generated always as (a % 3 ) stored) PARTITION BY LIST (a+1) (PARTITION p1 VALUES IN (1), PARTITION p2 VALUES IN (2)); Warnings: Warning 1287 The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead. insert into t1 values (1,default); Warnings: Warning 1287 The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead. select * from t1; a b 1 1 select * from t1; a b 1 1 drop table t1; # Case 3. Partitioning by HASH based on a non-stored generated column. CREATE TABLE t1 ( a DATE NOT NULL, b int generated always as (year(a)) virtual ) PARTITION BY HASH( b % 3 ) PARTITIONS 3; Warnings: Warning 1287 The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead. insert into t1 values ('2005-01-01',default); Warnings: Warning 1287 The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead. insert into t1 values ('2006-01-01',default); select * from t1; a b 2005-01-01 2005 2006-01-01 2006 # Modify the expression of generated column b ALTER TABLE t1 modify b int generated always as (year(a)-1) virtual; Warnings: Warning 1287 The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead. select * from t1; a b 2005-01-01 2004 2006-01-01 2005 Warnings: Warning 1287 The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead. drop table t1; # # Bug#21779011 INVALID READS AND SENDING RANDOM SERVER MEMORY BACK # TO CLIENT # CREATE TABLE t ( c INTEGER GENERATED ALWAYS AS (2) VIRTUAL, d INTEGER, KEY (d) ) PARTITION BY KEY (d) PARTITIONS 2; Warnings: Warning 1287 The partition engine, used by table 'test.t', is deprecated and will be removed in a future release. Please use native partitioning instead. INSERT INTO t (d) VALUES (1),(1),(2),(2); Warnings: Warning 1287 The partition engine, used by table 'test.t', is deprecated and will be removed in a future release. Please use native partitioning instead. SELECT c FROM t WHERE d >= 1 GROUP BY d LIMIT 2; c 2 2 DROP TABLE t; # # Bug#21779554: CHECK_MISPLACED_ROWS BOGUS "FOUND A MISPLACED ROW" # AND CRASHES # CREATE TABLE t(a INT,b INT GENERATED ALWAYS AS (1) VIRTUAL,c INT) PARTITION BY KEY (b)PARTITIONS 6; Warnings: Warning 1287 The partition engine, used by table 'test.t', is deprecated and will be removed in a future release. Please use native partitioning instead. INSERT INTO t VALUES(); Warnings: Warning 1287 The partition engine, used by table 'test.t', is deprecated and will be removed in a future release. Please use native partitioning instead. CHECK TABLE t EXTENDED; Table Op Msg_type Msg_text test.t check status OK test.t check warning The partition engine, used by table 'test.t', is deprecated and will be removed in a future release. Please use native partitioning instead. FLUSH TABLES; CHECK TABLE t EXTENDED; Table Op Msg_type Msg_text test.t check status OK test.t check warning The partition engine, used by table 'test.t', is deprecated and will be removed in a future release. Please use native partitioning instead. DROP TABLE t; # # Bug#22574695 ASSERTION `!TABLE || (!TABLE->READ_SET || BITMAP_IS_SET(TABLE->READ_SET, FIELD_I # CREATE TABLE t1( col1 VARCHAR(500), col2 INT, col5 VARCHAR(500) GENERATED ALWAYS AS (SUBSTR(col1,1,500)) VIRTUAL ) ENGINE = InnoDB PARTITION BY KEY(col5) PARTITIONS 2; INSERT INTO test . t1 SET col1 = REPEAT('_', 500); COMMIT; UPDATE t1 SET col2 = 1; SELECT 'Obviously no crash'; Obviously no crash Obviously no crash DROP TABLE t1; DROP VIEW IF EXISTS v1,v2; DROP TABLE IF EXISTS t1,t2,t3; DROP PROCEDURE IF EXISTS p1; DROP FUNCTION IF EXISTS f1; DROP TRIGGER IF EXISTS trg1; DROP TRIGGER IF EXISTS trg2; set sql_warnings = 0;