You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
82 lines
2.9 KiB
82 lines
2.9 KiB
5 months ago
|
# 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;
|
||
|
|
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
||
|
|
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;
|
||
|
|
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
||
|
|
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;
|
||
|
|
Note (Code 1007): Can't create database 'test'; database exists
|
||
|
|
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=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
||
|
|
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;
|