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

HEX(<decimal>) gets truncated

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 1.4.2
    • 23.10
    • ExeMgr
    • 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

          Activity

            People

              leonid.fedorov Leonid Fedorov
              David.Hall David Hall (Inactive)
              Daniel Lee Daniel Lee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.