[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) added a comment - 2020-02-06 17:15

Investigated this issue. ColumnStore creates the correct string with length 16, however the server truncates the field length when the string is sent to it via store() call in fetchNextRow().

There is an open server issue for this: https://jira.mariadb.org/browse/MDEV-20548

Closing this issue.

Gagan Goel (Inactive) added a comment - 2020-02-06 17:15 Investigated this issue. ColumnStore creates the correct string with length 16, however the server truncates the field length when the string is sent to it via store() call in fetchNextRow(). There is an open server issue for this: https://jira.mariadb.org/browse/MDEV-20548 Closing this issue.

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 ]

Roman added a comment - 2020-03-06 12:37

Opened as a notification.

Roman added a comment - 2020-03-06 12:37 Opened as a notification.

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

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

Patrick LeBlanc (Inactive) added a comment - 2020-03-10 16:26

changed the fix version to n/a because it was messing up daniel's accounting. Change it to whatever is appropriate once it's fixed.

Patrick LeBlanc (Inactive) added a comment - 2020-03-10 16:26 changed the fix version to n/a because it was messing up daniel's accounting. Change it to whatever is appropriate once it's fixed.

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 ]

Gagan Goel (Inactive) added a comment - 2020-04-03 21:27

The ref file (mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql.ref.log) is temporarily changed to match (incorrect) output from ColumnStore. We need to revert it back when ~~MDEV-20548~~ is fixed.

Gagan Goel (Inactive) added a comment - 2020-04-03 21:27 The ref file (mysql/queries/working_tpch1/qa_fe_cnxFunctions/hex.sql.ref.log) is temporarily changed to match (incorrect) output from ColumnStore. We need to revert it back when MDEV-20548 is fixed.

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) added a comment - 2020-07-01 16:41

~~MDEV-20548~~ is not done, so we cannot do this for 1..5.3.

Gregory Dorman (Inactive) added a comment - 2020-07-01 16:41 MDEV-20548 is not done, so we cannot do this for 1..5.3.

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.

Alexander Barkov added a comment - 2020-11-10 03:00 - edited

How to repeat the problem:

First, I create the table:

cd mariadb-columnstore-regression-test

mysql test < mysql/scripts/create_datatypetestm.sql

Now run this query:

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

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

| cidx | CDECIMAL1 | HEX(CDECIMAL1) |

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

|    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              |

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

Notice, the FFFF in the last column is wrong.

Now if I change the engine from ColumnStore to InnoDB, the results become correct:

alter table datatypetestm engine=innodb;

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

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

| cidx | CDECIMAL1 | HEX(CDECIMAL1)   |

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

|    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                |

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

Alexander Barkov added a comment - 2020-11-10 03:00 - edited How to repeat the problem: First, I create the table: cd mariadb-columnstore-regression-test mysql test < mysql/scripts/create_datatypetestm.sql Now run this query: select cidx, CDECIMAL1, HEX(CDECIMAL1) from datatypetestm order by cidx; +------+-----------+----------------+ | cidx | CDECIMAL1 | HEX(CDECIMAL1) | +------+-----------+----------------+ | 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 | +------+-----------+----------------+ Notice, the FFFF in the last column is wrong. Now if I change the engine from ColumnStore to InnoDB, the results become correct: alter table datatypetestm engine=innodb; select cidx, CDECIMAL1, HEX(CDECIMAL1) from datatypetestm order by cidx; +------+-----------+------------------+ | cidx | CDECIMAL1 | HEX(CDECIMAL1) | +------+-----------+------------------+ | 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 | +------+-----------+------------------+

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