[MCOL-3762] HEX(<decimal>) gets truncated - Jira

David Hall (Inactive) created issue - 2020-02-04 21:44

David Hall (Inactive) made changes - 2020-02-04 21:44

Field	Original Value	New Value
Link		This issue is part of ~~MCOL-3747~~ [ ~~MCOL-3747~~ ]

David Hall (Inactive) made changes - 2020-02-04 21:45

Sprint

2020-2 [ 382 ]

David Hall (Inactive) made changes - 2020-02-04 21:46

Story Points

1

Gagan Goel (Inactive) made changes - 2020-02-06 17:11

Status

Open [ 1 ]

In Progress [ 3 ]

Gagan Goel (Inactive) made changes - 2020-02-06 17:15

Resolution		Not a Bug [ 6 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Todd Stoffel (Inactive) made changes - 2020-02-17 00:06

Rank

Ranked higher

Roman made changes - 2020-03-06 12:37

Assignee	Gagan Goel [ tntnatbry ]	Roman [ drrtuy ]
Resolution	Not a Bug [ 6 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Roman made changes - 2020-03-06 12:37

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Roman made changes - 2020-03-06 12:37

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Patrick LeBlanc (Inactive) made changes - 2020-03-10 16:25

Fix Version/s		N/A [ 22302 ]
Fix Version/s	1.4.3 [ 24038 ]

Todd Stoffel (Inactive) made changes - 2020-03-11 04:37

Rank

Ranked higher

Todd Stoffel (Inactive) made changes - 2020-03-11 04:37

Rank

Ranked higher

Todd Stoffel (Inactive) made changes - 2020-04-02 01:47

Fix Version/s		1.44 [ 24312 ]
Fix Version/s	Icebox [ 22302 ]

Todd Stoffel (Inactive) made changes - 2020-04-02 05:34

Fix Version/s		1.4.4 [ 24039 ]
Fix Version/s	1.44 [ 24312 ]

Todd Stoffel (Inactive) made changes - 2020-04-07 06:54

Team

ColumnStore Team

David Hall (Inactive) made changes - 2020-05-05 17:08

Fix Version/s		1..4.5 [ 24427 ]
Fix Version/s		1.5.2 [ 24411 ]
Fix Version/s	1.4.4 [ 24039 ]

Todd Stoffel (Inactive) made changes - 2020-05-14 00:12

Fix Version/s		1.4.5 [ 24424 ]
Fix Version/s	1..4.5 [ 24427 ]

David Hall (Inactive) made changes - 2020-06-22 19:28

Fix Version/s		1.5.3 [ 24412 ]
Fix Version/s	1.5.2 [ 24411 ]

Gregory Dorman (Inactive) made changes - 2020-07-01 16:42

Fix Version/s		1.5.4 [ 24413 ]
Fix Version/s	1.5.3 [ 24412 ]

David Hall (Inactive) made changes - 2020-07-10 15:31

Assignee

Roman [ drrtuy ]

David Hall [ david.hall ]

David Hall (Inactive) made changes - 2020-08-18 18:41

Fix Version/s		1.5.5 [ 24414 ]
Fix Version/s	1.5.4 [ 24413 ]

Todd Stoffel (Inactive) made changes - 2020-09-21 23:42

Fix Version/s		5.5.1 [ 25030 ]
Fix Version/s		5.5.1 [ 25030 ]
Fix Version/s	1.5.5 [ 24414 ]
Fix Version/s	1.4.5 [ 24424 ]

David Hall (Inactive) made changes - 2020-11-09 17:18

Assignee

David Hall [ david.hall ]

Alexander Barkov [ bar ]

Alexander Barkov made changes - 2020-11-10 02:37

Description

see mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql

The query:
select cidx, CDECIMAL1, HEX(CDECIMAL1) from datatypetestm order by cidx;

should return
1 -9.99 FFFFFFFFFFFFFFF6
2 -9.98 FFFFFFFFFFFFFFF6
3 -9.97 FFFFFFFFFFFFFFF6
4 -9.96 FFFFFFFFFFFFFFF6
5 -9.95 FFFFFFFFFFFFFFF6
6 9.95 A
7 9.96 A
8 9.97 A
9 9.98 A
10 9.99 A
11 0.00 0

But instead returns
1 -9 FFFF
2 -8 FFFF
3 -7 FFFF
4 -6 FFFF
5 -5 FFFF
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0

This appears to only affect decimal types. I looked in the utils/funcexp/hex.cpp code and no changes there should have caused this.

see mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql

The query:
select cidx, CDECIMAL1, HEX(CDECIMAL1) from datatypetestm order by cidx;

should return
{noformat}
1 -9.99 FFFFFFFFFFFFFFF6
2 -9.98 FFFFFFFFFFFFFFF6
3 -9.97 FFFFFFFFFFFFFFF6
4 -9.96 FFFFFFFFFFFFFFF6
5 -9.95 FFFFFFFFFFFFFFF6
6 9.95 A
7 9.96 A
8 9.97 A
9 9.98 A
10 9.99 A
11 0.00 0
{noformat}

But instead returns
{noformat}
1 -9 FFFF
2 -8 FFFF
3 -7 FFFF
4 -6 FFFF
5 -5 FFFF
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

This appears to only affect decimal types. I looked in the utils/funcexp/hex.cpp code and no changes there should have caused this.

Alexander Barkov made changes - 2020-11-10 02:37

Description

see mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql

The query:
select cidx, CDECIMAL1, HEX(CDECIMAL1) from datatypetestm order by cidx;

should return
{noformat}
1 -9.99 FFFFFFFFFFFFFFF6
2 -9.98 FFFFFFFFFFFFFFF6
3 -9.97 FFFFFFFFFFFFFFF6
4 -9.96 FFFFFFFFFFFFFFF6
5 -9.95 FFFFFFFFFFFFFFF6
6 9.95 A
7 9.96 A
8 9.97 A
9 9.98 A
10 9.99 A
11 0.00 0
{noformat}

But instead returns
{noformat}
1 -9 FFFF
2 -8 FFFF
3 -7 FFFF
4 -6 FFFF
5 -5 FFFF
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

This appears to only affect decimal types. I looked in the utils/funcexp/hex.cpp code and no changes there should have caused this.

see mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql

The query:
{code:sql}
select cidx, CDECIMAL1, HEX(CDECIMAL1) from datatypetestm order by cidx;
{code}
should return
{noformat}
1 -9.99 FFFFFFFFFFFFFFF6
2 -9.98 FFFFFFFFFFFFFFF6
3 -9.97 FFFFFFFFFFFFFFF6
4 -9.96 FFFFFFFFFFFFFFF6
5 -9.95 FFFFFFFFFFFFFFF6
6 9.95 A
7 9.96 A
8 9.97 A
9 9.98 A
10 9.99 A
11 0.00 0
{noformat}

But instead returns
{noformat}
1 -9 FFFF
2 -8 FFFF
3 -7 FFFF
4 -6 FFFF
5 -5 FFFF
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

This appears to only affect decimal types. I looked in the utils/funcexp/hex.cpp code and no changes there should have caused this.

David Hall (Inactive) made changes - 2020-11-10 04:54

Description

see mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql

The query:
{code:sql}
select cidx, CDECIMAL1, HEX(CDECIMAL1) from datatypetestm order by cidx;
{code}
should return
{noformat}
1 -9.99 FFFFFFFFFFFFFFF6
2 -9.98 FFFFFFFFFFFFFFF6
3 -9.97 FFFFFFFFFFFFFFF6
4 -9.96 FFFFFFFFFFFFFFF6
5 -9.95 FFFFFFFFFFFFFFF6
6 9.95 A
7 9.96 A
8 9.97 A
9 9.98 A
10 9.99 A
11 0.00 0
{noformat}

But instead returns
{noformat}
1 -9 FFFF
2 -8 FFFF
3 -7 FFFF
4 -6 FFFF
5 -5 FFFF
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

This appears to only affect decimal types. I looked in the utils/funcexp/hex.cpp code and no changes there should have caused this.

see mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql

The query:
{code:sq
{code}
should return
{noformat}
1 -9.99 FFFFFFFFFFFFFFF6
2 -9.98 FFFFFFFFFFFFFFF6
3 -9.97 FFFFFFFFFFFFFFF6
4 -9.96 FFFFFFFFFFFFFFF6
5 -9.95 FFFFFFFFFFFFFFF6
6 9.95 A
7 9.96 A
8 9.97 A
9 9.98 A
10 9.99 A
11 0.00 0
{noformat}

But instead returns
{noformat}
1 -9 FFFF
2 -8 FFFF
3 -7 FFFF
4 -6 FFFF
5 -5 FFFF
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

This appears to only affect decimal types. I looked in the utils/funcexp/hex.cpp code and no changes there should have caused this.

David Hall (Inactive) made changes - 2020-11-10 04:58

Description

see mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql

The query:
{code:sq
{code}
should return
{noformat}
1 -9.99 FFFFFFFFFFFFFFF6
2 -9.98 FFFFFFFFFFFFFFF6
3 -9.97 FFFFFFFFFFFFFFF6
4 -9.96 FFFFFFFFFFFFFFF6
5 -9.95 FFFFFFFFFFFFFFF6
6 9.95 A
7 9.96 A
8 9.97 A
9 9.98 A
10 9.99 A
11 0.00 0
{noformat}

But instead returns
{noformat}
1 -9 FFFF
2 -8 FFFF
3 -7 FFFF
4 -6 FFFF
5 -5 FFFF
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

This appears to only affect decimal types. I looked in the utils/funcexp/hex.cpp code and no changes there should have caused this.

see mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql

The query:
{code:sq
{code}
should return
{noformat}
    1 -9 FFFFFFFFFFFFFFF7
    2 -8 FFFFFFFFFFFFFFF8
    3 -7 FFFFFFFFFFFFFFF9
    4 -6 FFFFFFFFFFFFFFFA
    5 -5 FFFFFFFFFFFFFFFB
    6 5 5
    7 6 6
    8 7 7
    9 8 8
   10 9 9
   11 0 0

But instead returns
{noformat}
1 -9 FFFF
2 -8 FFFF
3 -7 FFFF
4 -6 FFFF
5 -5 FFFF
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

This appears to only affect decimal types. I looked in the utils/funcexp/hex.cpp code and no changes there should have caused this.

David Hall (Inactive) made changes - 2020-11-10 05:00

Description

see mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql

The query:
{code:sq
{code}
should return
{noformat}
    1 -9 FFFFFFFFFFFFFFF7
    2 -8 FFFFFFFFFFFFFFF8
    3 -7 FFFFFFFFFFFFFFF9
    4 -6 FFFFFFFFFFFFFFFA
    5 -5 FFFFFFFFFFFFFFFB
    6 5 5
    7 6 6
    8 7 7
    9 8 8
   10 9 9
   11 0 0

But instead returns
{noformat}
1 -9 FFFF
2 -8 FFFF
3 -7 FFFF
4 -6 FFFF
5 -5 FFFF
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

This appears to only affect decimal types. I looked in the utils/funcexp/hex.cpp code and no changes there should have caused this.

see mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql

The query:
{code:sq
{code}
should return
{noformat}
1 -9 FFFFFFFFFFFFFFF7
2 -8 FFFFFFFFFFFFFFF8
3 -7 FFFFFFFFFFFFFFF9
4 -6 FFFFFFFFFFFFFFFA
5 -5 FFFFFFFFFFFFFFFB
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0

But instead returns
{noformat}
1 -9 FFFF
2 -8 FFFF
3 -7 FFFF
4 -6 FFFF
5 -5 FFFF
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

This appears to only affect decimal types. I looked in the utils/funcexp/hex.cpp code and no changes there should have caused this.

Todd Stoffel (Inactive) made changes - 2020-11-12 03:12

Rank

Ranked higher

Todd Stoffel (Inactive) made changes - 2020-11-12 03:12

Rank

Ranked higher

Todd Stoffel (Inactive) made changes - 2020-11-12 03:13

Rank

Ranked higher

Todd Stoffel (Inactive) made changes - 2020-11-12 03:13

Rank

Ranked higher

Todd Stoffel (Inactive) made changes - 2020-11-12 03:13

Rank

Ranked higher

Todd Stoffel (Inactive) made changes - 2020-11-12 03:13

Rank

Ranked higher

Todd Stoffel (Inactive) made changes - 2020-11-12 03:14

Rank

Ranked higher

Todd Stoffel (Inactive) made changes - 2020-11-12 03:14

Rank

Ranked higher

Todd Stoffel (Inactive) made changes - 2020-11-12 03:15

Rank

Ranked higher

Todd Stoffel (Inactive) made changes - 2020-11-12 03:22

Rank

Ranked higher

Todd Stoffel (Inactive) made changes - 2020-11-16 21:24

Rank

Ranked lower

Todd Stoffel (Inactive) made changes - 2020-11-16 21:27

Rank

Ranked higher

David Hall (Inactive) made changes - 2020-12-03 21:09

Fix Version/s		5.6.1 [ 25031 ]
Fix Version/s		6.1 [ 25201 ]
Fix Version/s	5.5.1 [ 25030 ]

Todd Stoffel (Inactive) made changes - 2020-12-11 04:34

Fix Version/s

6.1 [ 25201 ]

Alexander Barkov made changes - 2021-01-20 07:04

Description

see mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql

The query:
{code:sq
{code}
should return
{noformat}
1 -9 FFFFFFFFFFFFFFF7
2 -8 FFFFFFFFFFFFFFF8
3 -7 FFFFFFFFFFFFFFF9
4 -6 FFFFFFFFFFFFFFFA
5 -5 FFFFFFFFFFFFFFFB
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0

But instead returns
{noformat}
1 -9 FFFF
2 -8 FFFF
3 -7 FFFF
4 -6 FFFF
5 -5 FFFF
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

This appears to only affect decimal types. I looked in the utils/funcexp/hex.cpp code and no changes there should have caused this.

see mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql

The query:
{code:sql}
{code}
should return
{noformat}
1 -9 FFFFFFFFFFFFFFF7
2 -8 FFFFFFFFFFFFFFF8
3 -7 FFFFFFFFFFFFFFF9
4 -6 FFFFFFFFFFFFFFFA
5 -5 FFFFFFFFFFFFFFFB
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0

But instead returns
{noformat}
1 -9 FFFF
2 -8 FFFF
3 -7 FFFF
4 -6 FFFF
5 -5 FFFF
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

This appears to only affect decimal types. I looked in the utils/funcexp/hex.cpp code and no changes there should have caused this.

Alexander Barkov made changes - 2021-01-20 07:05

Description

see mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql

The query:
{code:sql}
{code}
should return
{noformat}
1 -9 FFFFFFFFFFFFFFF7
2 -8 FFFFFFFFFFFFFFF8
3 -7 FFFFFFFFFFFFFFF9
4 -6 FFFFFFFFFFFFFFFA
5 -5 FFFFFFFFFFFFFFFB
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0

But instead returns
{noformat}
1 -9 FFFF
2 -8 FFFF
3 -7 FFFF
4 -6 FFFF
5 -5 FFFF
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

This appears to only affect decimal types. I looked in the utils/funcexp/hex.cpp code and no changes there should have caused this.

see mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql

The query:
{code:sql}
{code}
should return
{noformat}
1 -9 FFFFFFFFFFFFFFF7
2 -8 FFFFFFFFFFFFFFF8
3 -7 FFFFFFFFFFFFFFF9
4 -6 FFFFFFFFFFFFFFFA
5 -5 FFFFFFFFFFFFFFFB
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

But instead returns
{noformat}
1 -9 FFFF
2 -8 FFFF
3 -7 FFFF
4 -6 FFFF
5 -5 FFFF
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

This appears to only affect decimal types. I looked in the utils/funcexp/hex.cpp code and no changes there should have caused this.

Alexander Barkov made changes - 2021-01-20 07:10

Priority

Major [ 3 ]

Minor [ 4 ]

Todd Stoffel (Inactive) made changes - 2021-01-22 17:33

Rank

Ranked lower

Todd Stoffel (Inactive) made changes - 2021-01-22 17:33

Rank

Ranked lower

Gregory Dorman (Inactive) made changes - 2021-05-10 17:36

Fix Version/s

5.6.1 [ 25031 ]

Gregory Dorman (Inactive) made changes - 2021-05-10 17:36

Fix Version/s

6.1.1 [ 25600 ]

Gregory Dorman (Inactive) made changes - 2021-05-10 17:40

Link

This issue is blocked by ~~MDEV-20548~~ [ ~~MDEV-20548~~ ]

Gregory Dorman (Inactive) made changes - 2021-06-25 19:13

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

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

Assignee

Alexander Barkov [ bar ]

Roman made changes - 2022-03-03 12:59

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

David Hall (Inactive) made changes - 2022-05-25 17:57

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

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

Fix Version/s		22.08.3 [ 28456 ]
Fix Version/s		22.08.3 [ 28456 ]
Fix Version/s	22.08 [ 26904 ]

David Hall (Inactive) made changes - 2022-10-04 22:10

Fix Version/s

22.08.3 [ 28456 ]

David Hall (Inactive) made changes - 2022-10-04 22:10

Fix Version/s

22.11.01 [ 28458 ]

alexey vorovich (Inactive) made changes - 2022-11-28 21:20

Fix Version/s		23.02 [ 28209 ]
Fix Version/s	23.03.1 [ 28458 ]

alexey vorovich (Inactive) made changes - 2023-02-08 17:48

Status

Stalled [ 10000 ]

In Progress [ 3 ]

alexey vorovich (Inactive) made changes - 2023-02-08 17:48

Status

In Progress [ 3 ]

In Testing [ 10301 ]

Daniel Lee (Inactive) made changes - 2023-02-08 18:17

Assigned for Testing

Daniel Lee [ dleeyh ]

Daniel Lee (Inactive) made changes - 2023-02-09 16:25

Assignee		alexey vorovich [ JIRAUSER48263 ]
Status	In Testing [ 10301 ]	Stalled [ 10000 ]

Todd Stoffel (Inactive) made changes - 2023-07-01 20:04

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

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

Assignee

alexey vorovich [ JIRAUSER48263 ]

Leonid Fedorov [ JIRAUSER48443 ]

Kirill Perov (Inactive) made changes - 2023-11-02 21:25

Description

see mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql

The query:
{code:sql}
{code}
should return
{noformat}
1 -9 FFFFFFFFFFFFFFF7
2 -8 FFFFFFFFFFFFFFF8
3 -7 FFFFFFFFFFFFFFF9
4 -6 FFFFFFFFFFFFFFFA
5 -5 FFFFFFFFFFFFFFFB
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

But instead returns
{noformat}
1 -9 FFFF
2 -8 FFFF
3 -7 FFFF
4 -6 FFFF
5 -5 FFFF
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

This appears to only affect decimal types. I looked in the utils/funcexp/hex.cpp code and no changes there should have caused this.

see mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql

The query:
{code:sql}
select cidx, CDECIMAL1, HEX(CDECIMAL1) from DataTypeTestm order by cidx;
{code}
should return
{noformat}
1 -9 FFFFFFFFFFFFFFF7
2 -8 FFFFFFFFFFFFFFF8
3 -7 FFFFFFFFFFFFFFF9
4 -6 FFFFFFFFFFFFFFFA
5 -5 FFFFFFFFFFFFFFFB
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

But instead returns
{noformat}
1 -9 FFFF
2 -8 FFFF
3 -7 FFFF
4 -6 FFFF
5 -5 FFFF
6 5 5
7 6 6
8 7 7
9 8 8
10 9 9
11 0 0
{noformat}

This appears to only affect decimal types. I looked in the utils/funcexp/hex.cpp code and no changes there should have caused this.

MariaDB ColumnStore

HEX(<decimal>) gets truncated

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration