⚝
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
/
r
/
View File Name :
partition_utf8.result
set names utf8; create table t1 (a varchar(2) character set cp1250) partition by list columns (a) ( partition p0 values in (0x81)); Warnings: Warning 1300 Invalid cp1250 character string: '81' Warning 1300 Invalid cp1250 character string: '81' show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` varchar(2) CHARACTER SET cp1250 DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 /*!50500 PARTITION BY LIST COLUMNS(a) (PARTITION p0 VALUES IN (_cp1250 0x81) ENGINE = ENGINE) */ Warnings: Warning 1300 Invalid cp1250 character string: '81' drop table t1; Warnings: Warning 1300 Invalid cp1250 character string: '81' create table t1 (a varchar(2) character set cp1250) partition by list columns (a) ( partition p0 values in (0x80)); show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` varchar(2) CHARACTER SET cp1250 DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 /*!50500 PARTITION BY LIST COLUMNS(a) (PARTITION p0 VALUES IN ('€') ENGINE = ENGINE) */ drop table t1; create table t1 (a varchar(1500), b varchar(1570)) partition by list columns(a,b) ( partition p0 values in (('a','b'))); ERROR HY000: The total length of the partitioning fields is too large create table t1 (a varchar(1023) character set utf8 collate utf8_spanish2_ci) partition by range columns(a) ( partition p0 values less than ('CZ'), partition p1 values less than ('CH'), partition p2 values less than ('D')); insert into t1 values ('czz'),('chi'),('ci'),('cg'); select * from t1 where a between 'cg' AND 'ci'; a ci cg drop table t1; create table t1 (a varchar(2) character set ucs2) partition by list columns (a) (partition p0 values in (0x2020), partition p1 values in ('')); show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` varchar(2) CHARACTER SET ucs2 DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 /*!50500 PARTITION BY LIST COLUMNS(a) (PARTITION p0 VALUES IN ('†') ENGINE = ENGINE, PARTITION p1 VALUES IN ('') ENGINE = ENGINE) */ insert into t1 values (''); insert into t1 values (_ucs2 0x2020); drop table t1;