[MDEV-20712] Wrong data type for CAST(@a AS BINARY) for a numeric variable - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 5.5(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
Fix Version/s: 10.5.0
Component/s: Data types
Labels:
None

Description

I run this script:

SET NAMES latin1;

SET @a=2;

CREATE OR REPLACE TABLE t1 AS SELECT CAST(1 AS BINARY), CAST(@a AS BINARY), CAST(@b:=3 AS BINARY);

SHOW CREATE TABLE t1;

+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Table | Create Table                                                                                                                                                                                                       |

+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| t1    | CREATE TABLE `t1` (

  `CAST(1 AS BINARY)` varbinary(1) DEFAULT NULL,

  `CAST(@a AS BINARY)` varbinary(20) DEFAULT NULL,

  `CAST(@b:=3 AS BINARY)` varbinary(1) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

Looks fine so far.

Now I change the character set to utf8:

SET NAMES utf8;

SET @a=2;

CREATE OR REPLACE TABLE t1 AS SELECT CAST(1 AS BINARY), CAST(@a AS BINARY), CAST(@b:=3 AS BINARY);

SHOW CREATE TABLE t1;

+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Table | Create Table                                                                                                                                                                                                       |

+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| t1    | CREATE TABLE `t1` (

  `CAST(1 AS BINARY)` varbinary(1) DEFAULT NULL,

  `CAST(@a AS BINARY)` varbinary(60) DEFAULT NULL,

  `CAST(@b:=3 AS BINARY)` varbinary(3) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

Notice, the data type has changed for the second and the third columns.
Looks wrong. The behaviour of numeric user variables should not depend on the character set.

Attachments

Issue Links

blocks

MDEV-4912 Data type plugin API version 1

Closed

Activity

People

Assignee:: Alexander Barkov

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2019-10-01 14:47

Updated:: 2019-10-01 18:33

Resolved:: 2019-10-01 18:33

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server