Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3475

HEX() returns incorrect results

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 1.4.0
    • Fix Version/s: Icebox
    • Component/s: ExeMgr
    • Labels:
      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

            Activity

              People

              Assignee:
              jrojas Jose Rojas
              Reporter:
              dleeyh Daniel Lee
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: