Details
-
Bug
-
Status: Stalled (View Workflow)
-
Minor
-
Resolution: Unresolved
-
1.4.2
-
None
-
2020-2
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 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
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.
Attachments
Issue Links
- is blocked by
-
MDEV-20548 Unexpected error on CREATE..SELECT HEX(num)
- Closed
- is part of
-
MCOL-3747 Regression in 1.4 working_ssb_compareLogOnly/sub/order_limit_sub
- Closed