Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL), 10.4(EOL), 10.5
-
None
Description
I run this script:
CREATE OR REPLACE TABLE t1 (a VARBINARY(10)) CHARACTER SET utf8 |
PARTITION BY LIST COLUMNS (a) (PARTITION p0 VALUES IN (0xFF)); |
SHOW CREATE TABLE t1; |
SELECT PARTITION_DESCRIPTION FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME='t1'; |
It returns the following output:
+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`a` varbinary(10) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8
|
PARTITION BY LIST COLUMNS(`a`)
|
(PARTITION `p0` VALUES IN ('�') ENGINE = InnoDB) |
|
+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
+-----------------------+
|
| PARTITION_DESCRIPTION |
|
+-----------------------+
|
| '?' |
|
+-----------------------+
|
Notice:
- the SHOW CREATE output prints the byte 0xFF as is
- the INFORMATION_SCHEMA.PARTITIONS query changes it to the question mark
The expected behaviour would be to print 0xFF as _binary 0xff.
Attachments
Issue Links
- relates to
-
-
- Closed
-
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Rank | Ranked higher |
| Link |
This issue relates to |
| Link |
This issue relates to |
| issue.field.resolutiondate | 2019-10-18 06:16:50.0 | 2019-10-18 06:16:50.674 |
| Fix Version/s | 10.5.0 [ 23709 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 100496 ] | MariaDB v4 [ 156879 ] |