[MCOL-4577] VARCHAR(2) NOT NULL: explicit empty string gets converted to DEFAULT - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 5.5.1, 5.6.1
Fix Version/s: 23.10.0
Component/s: PrimProc
Labels:
- rm_invalid_data

Epic Link:
ColumnStore Compatibility Improvements
Sprint:
2021-5, 2021-6

Description

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a VARCHAR(2) NOT NULL DEFAULT 'aa') ENGINE=ColumnStore;

INSERT INTO t1 VALUES ('');

SELECT HEX(a) FROM t1;

+--------+

| HEX(a) |

+--------+

| 6161   |

+--------+

Notice, emptry string was conversion to default 'aa'. Looks wrong.

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a VARCHAR(2) NOT NULL DEFAULT ' ') ENGINE=ColumnStore;

INSERT INTO t1 VALUES ('');

SELECT HEX(a) FROM t1;

+--------+

| HEX(a) |

+--------+

| 20     |

+--------+

Notice, emptry string was conversion to default ' '. Looks wrong.

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a VARCHAR(2) NOT NULL DEFAULT '  ') ENGINE=ColumnStore;

INSERT INTO t1 VALUES ('  ');

SELECT HEX(a) FROM t1;

+--------+

| HEX(a) |

+--------+

| 2020   |

+--------+

Notice, emptry string was conversion to default ' '. Looks wrong.

In all above scenarios, INSERTs should:

either fail on NOT NULL violation for now
or insert an empty string (when we fix the flaw that emptry string is NULL)

But it should not replace to DEFAULT!

Attachments

Issue Links

blocks

MCOL-4403 Trailing spaces not behaving as InnoDB

Closed

is caused by

MCOL-3574 EMPTY column for persistant storage

Closed

relates to

MCOL-271 Improved support for NULL for Varchar/char/text/datetime/timestamp + ?

Closed

Activity

Ascending order - Click to sort in descending order

Alexander Barkov created issue - 2021-03-04 07:55

Alexander Barkov made changes - 2021-03-04 07:55

Field	Original Value	New Value
Link		This issue blocks ~~MCOL-4403~~ [ ~~MCOL-4403~~ ]

Todd Stoffel (Inactive) made changes - 2021-03-08 17:21

Rank

Ranked higher

Gregory Dorman (Inactive) made changes - 2021-03-22 18:03

Sprint

2021-5 [ 504 ]

Gregory Dorman (Inactive) made changes - 2021-03-22 18:03

Rank

Ranked higher

Gregory Dorman (Inactive) made changes - 2021-03-22 18:07

Epic Link

~~MCOL-1049~~ [ 64464 ]

Gregory Dorman (Inactive) made changes - 2021-04-05 16:03

Sprint

2021-5 [ 504 ]

2021-5, 2021-6 [ 504, 509 ]

Todd Stoffel (Inactive) made changes - 2021-04-05 16:56

Rank

Ranked higher

Gregory Dorman (Inactive) made changes - 2021-04-19 16:04

Sprint

2021-5, 2021-6 [ 504, 509 ]

2021-5, 2021-6, 2021-7 [ 504, 509, 514 ]

David Hall (Inactive) made changes - 2021-04-20 18:26

Fix Version/s		6.1.1 [ 25600 ]
Fix Version/s	5.6.1 [ 25031 ]

Gregory Dorman (Inactive) made changes - 2021-04-20 22:59

Link

This issue is caused by ~~MCOL-3574~~ [ ~~MCOL-3574~~ ]

Gregory Dorman (Inactive) made changes - 2021-04-20 23:31

Sprint

2021-5, 2021-6, 2021-7 [ 504, 509, 514 ]

2021-5, 2021-6 [ 504, 509 ]

Gregory Dorman (Inactive) made changes - 2021-04-20 23:31

Rank

Ranked higher

Gregory Dorman (Inactive) made changes - 2021-04-29 20:55

Fix Version/s		6.5.1 [ 25801 ]
Fix Version/s	6.1.1 [ 25600 ]

Todd Stoffel (Inactive) made changes - 2021-05-03 16:38

Rank

Ranked lower

Todd Stoffel (Inactive) made changes - 2021-05-03 16:38

Rank

Ranked lower

Todd Stoffel (Inactive) made changes - 2021-05-03 16:52

Rank

Ranked lower

Todd Stoffel (Inactive) made changes - 2022-02-18 00:40

Assignee

Alexander Barkov [ bar ]

Todd Stoffel (Inactive) made changes - 2022-03-01 06:54

Rank

Ranked higher

Todd Stoffel (Inactive) made changes - 2022-03-01 06:54

Rank

Ranked higher

David Hall (Inactive) made changes - 2022-03-04 20:15

Fix Version/s		6.4.1 [ 26046 ]
Fix Version/s	6.3.1 [ 25801 ]

Todd Stoffel (Inactive) made changes - 2022-03-29 20:26

Rank

Ranked higher

Todd Stoffel (Inactive) made changes - 2022-05-25 17:49

Fix Version/s		22.08 [ 26904 ]
Fix Version/s	6.4.1 [ 26046 ]

Todd Stoffel (Inactive) made changes - 2022-09-30 19:45

Fix Version/s		23.02 [ 28209 ]
Fix Version/s	22.08 [ 26904 ]

Todd Stoffel (Inactive) made changes - 2023-02-07 20:23

Fix Version/s		23.08 [ 28540 ]
Fix Version/s	23.02 [ 28209 ]

Daniel Lee (Inactive) added a comment - 2023-04-25 16:36

Build verified:
engine: 1e56a0b557efb677d07533d05eb02ad723955317
server: 11c83d9ae9eb249d00589cc6ab71e7f4e67ffa27
buildNo: 7534
This scenario has been fixed as part of ~~MCOL-271~~. ColumnStore and InnoDB results matched.

Daniel Lee (Inactive) added a comment - 2023-04-25 16:36 Build verified: engine: 1e56a0b557efb677d07533d05eb02ad723955317 server: 11c83d9ae9eb249d00589cc6ab71e7f4e67ffa27 buildNo: 7534 This scenario has been fixed as part of MCOL-271 . ColumnStore and InnoDB results matched.

Daniel Lee (Inactive) made changes - 2023-04-25 16:36

Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

alexey vorovich (Inactive) made changes - 2023-07-25 16:41

Fix Version/s		23.08.1 [ 29105 ]
Fix Version/s		23.08.1 [ 29105 ]
Fix Version/s	23.08 [ 28540 ]

alexey vorovich (Inactive) made changes - 2023-07-25 17:07

Link

This issue relates to ~~MCOL-271~~ [ ~~MCOL-271~~ ]

alexey vorovich (Inactive) made changes - 2023-07-25 17:07

Assignee

Sergey Zefirov [ JIRAUSER47362 ]

alexey vorovich (Inactive) made changes - 2023-07-26 16:05

Labels

rm_invalid_data

Todd Stoffel (Inactive) made changes - 2023-09-22 15:26

Fix Version/s

23.10.0 [ 29422 ]

Todd Stoffel (Inactive) made changes - 2023-09-22 15:29

Fix Version/s

23.10.1 [ 29105 ]

People

Assignee:: Sergey Zefirov

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2021-03-04 07:55

Updated:: 2023-09-22 15:29

Resolved:: 2023-04-25 16:36

Git Integration

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

MariaDB ColumnStore

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration