⚝
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 :
mysqldump-binary.result
# Bug#22601255 Restoring a dump of binary column, made with mysqldump, warns of invalid string CREATE TABLE t1( u CHAR(10), b BINARY(16), blo BLOB, g GEOMETRY, bi BIT(64)); INSERT INTO t1 VALUES( 'basic', x'EE0C6D03C34C11E5B1640026B977EB17', x'EE0C6D03C34C11E5B1640026B977EB17', ST_GeomFromText('POINT(1 1)'), x'EE0C6D03C34C11E5'); SELECT u='basic', HEX(b)='EE0C6D03C34C11E5B1640026B977EB17', HEX(blo)='EE0C6D03C34C11E5B1640026B977EB17', HEX(g)='000000000101000000000000000000F03F000000000000F03F', HEX(bi)='EE0C6D03C34C11E5', ST_AsText(g) FROM t1; u='basic' HEX(b)='EE0C6D03C34C11E5B1640026B977EB17' HEX(blo)='EE0C6D03C34C11E5B1640026B977EB17' HEX(g)='000000000101000000000000000000F03F000000000000F03F' HEX(bi)='EE0C6D03C34C11E5' ST_AsText(g) 1 1 1 1 1 POINT(1 1) DROP TABLE t1; Warning (Code 3090): Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. Warning (Code 3090): Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `u` char(10) DEFAULT NULL, `b` binary(16) DEFAULT NULL, `blo` blob, `g` geometry DEFAULT NULL, `bi` bit(64) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 SELECT u='basic', HEX(b)='EE0C6D03C34C11E5B1640026B977EB17', HEX(blo)='EE0C6D03C34C11E5B1640026B977EB17', HEX(g)='000000000101000000000000000000F03F000000000000F03F', HEX(bi)='EE0C6D03C34C11E5', ST_AsText(g) FROM t1; u='basic' HEX(b)='EE0C6D03C34C11E5B1640026B977EB17' HEX(blo)='EE0C6D03C34C11E5B1640026B977EB17' HEX(g)='000000000101000000000000000000F03F000000000000F03F' HEX(bi)='EE0C6D03C34C11E5' ST_AsText(g) 1 1 1 1 1 POINT(1 1) DROP TABLE t1; Warning (Code 3090): Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. Warning (Code 3090): Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `u` char(10) DEFAULT NULL, `b` binary(16) DEFAULT NULL, `blo` blob, `g` geometry DEFAULT NULL, `bi` bit(64) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 SELECT u='basic', HEX(b)='EE0C6D03C34C11E5B1640026B977EB17', HEX(blo)='EE0C6D03C34C11E5B1640026B977EB17', HEX(g)='000000000101000000000000000000F03F000000000000F03F', HEX(bi)='EE0C6D03C34C11E5', ST_AsText(g) FROM t1; u='basic' HEX(b)='EE0C6D03C34C11E5B1640026B977EB17' HEX(blo)='EE0C6D03C34C11E5B1640026B977EB17' HEX(g)='000000000101000000000000000000F03F000000000000F03F' HEX(bi)='EE0C6D03C34C11E5' ST_AsText(g) 1 1 1 1 1 POINT(1 1) DROP TABLE t1; Warning (Code 3090): Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. Note (Code 1007): Can't create database 'test'; database exists Warning (Code 3090): Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `u` char(10) DEFAULT NULL, `b` binary(16) DEFAULT NULL, `blo` blob, `g` geometry DEFAULT NULL, `bi` bit(64) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 SELECT u='basic', HEX(b)='EE0C6D03C34C11E5B1640026B977EB17', HEX(blo)='EE0C6D03C34C11E5B1640026B977EB17', HEX(g)='000000000101000000000000000000F03F000000000000F03F', HEX(bi)='EE0C6D03C34C11E5', ST_AsText(g) FROM t1; u='basic' HEX(b)='EE0C6D03C34C11E5B1640026B977EB17' HEX(blo)='EE0C6D03C34C11E5B1640026B977EB17' HEX(g)='000000000101000000000000000000F03F000000000000F03F' HEX(bi)='EE0C6D03C34C11E5' ST_AsText(g) 1 1 1 1 1 POINT(1 1) DROP TABLE t1;