Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
1.4.0
-
None
Description
Build tested: 1.4.0-1
[dlee@master centos7]$ cat gitversionInfo.txt
server commit:
67452bc
engine commit:
4d2a159
Autopilot test case: features.functions
ColumnStore returned:
15 --------------
16 select cidx, CDECIMAL1, HEX(CDECIMAL1) from datatypetestm order by cidx
17 --------------
18
19 cidx CDECIMAL1 HEX(CDECIMAL1)
20 1 -9 FFFF
21 1 row in set
22
23 --------------
24 select cidx, CDECIMAL4, HEX(CDECIMAL4) from datatypetestm order by cidx
25 --------------
26
27 cidx CDECIMAL4 HEX(CDECIMAL4)
28 1 -999 FFFFFFFFFF
29 1 row in set
30
31 --------------
32 select cidx, CDECIMAL4_2, HEX(CDECIMAL4_2) from datatypetestm order by cidx
33 --------------
34
35 cidx CDECIMAL4_2 HEX(CDECIMAL4_2)
36 1 -9.99 FFFFFFFFFFFF
37 1 row in set
38
39 --------------
40 select cidx, CDECIMAL5, HEX(CDECIMAL5) from datatypetestm order by cidx
41 --------------
42
43 cidx CDECIMAL5 HEX(CDECIMAL5)
44 1 -999 FFFFFFFFFFFF
45 1 row in set
95 --------------
96 select cidx, CSMALLINT, HEX(CSMALLINT) from datatypetestm order by cidx
97 --------------
98
99 cidx CSMALLINT HEX(CSMALLINT)
100 1 -766 FFFFFFFFFFFF
101 1 row in set
102
103 --------------
104 select cidx, CTINYINT, HEX(CTINYINT) from datatypetestm order by cidx
105 --------------
106
107 cidx CTINYINT HEX(CTINYINT)
108 1 -26 FFFFFFFF
109 1 row in set
Reference returned:
15 --------------
16 select cidx, CDECIMAL1, HEX(CDECIMAL1) from datatypetestm order by cidx
17 --------------
18
19 cidx CDECIMAL1 HEX(CDECIMAL1)
20 1 -9 FFFFFFFFFFFFFFF7
21 1 row in set
22
23 --------------
24 select cidx, CDECIMAL4, HEX(CDECIMAL4) from datatypetestm order by cidx
25 --------------
26
27 cidx CDECIMAL4 HEX(CDECIMAL4)
28 1 -999 FFFFFFFFFFFFFC19
29 1 row in set
30
31 --------------
32 select cidx, CDECIMAL4_2, HEX(CDECIMAL4_2) from datatypetestm order by cidx
33 --------------
34
35 cidx CDECIMAL4_2 HEX(CDECIMAL4_2)
36 1 -9.99 FFFFFFFFFFFFFFF6
37 1 row in set
38
39 --------------
40 select cidx, CDECIMAL5, HEX(CDECIMAL5) from datatypetestm order by cidx
41 --------------
42
43 cidx CDECIMAL5 HEX(CDECIMAL5)
44 1 -999 FFFFFFFFFFFFFC19
45 1 row in set
96 select cidx, CSMALLINT, HEX(CSMALLINT) from datatypetestm order by cidx
97 --------------
98
99 cidx CSMALLINT HEX(CSMALLINT)
100 1 -766 FFFFFFFFFFFFFD02
101 1 row in set
102
103 --------------
104 select cidx, CTINYINT, HEX(CTINYINT) from datatypetestm order by cidx
105 --------------
106
107 cidx CTINYINT HEX(CTINYINT)
108 1 -26 FFFFFFFFFFFFFFE6
109 1 row in set
Attachments
Issue Links
- duplicates
-
MDEV-20548 Unexpected error on CREATE..SELECT HEX(num)
- Closed