Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-37859

Mysqltest hex() not working for string values

    XMLWordPrintable

Details

    • Unexpected results
    • Q3/2026 Server Maintenance

    Description

      TITLE

        While testing HEX() for string values, getting error seen in below example.  

      Test Case:

      let $hx1 = $(hex("abc"));
      -- echo hex("abc") -> $hx1;             # 616263
      

      mysqltest output:
      main.hex
      mysqltest: At line 1: invalid number 'abc' for base 10

      Server output:

      MariaDB [(none)]> select hex("abc");
      +------------+
      | hex("abc") |
      +------------+
      | 616263     |
      +------------+
      1 row in set (0.001 sec)

      Attachments

        Issue Links

          Activity

            People

              Khaled.amr Khaled Amr
              poojalamba16 Pooja Rani Lamba
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 0.5d Original Estimate - 0.5d
                  0.5d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 4h 10m
                  4h 10m

                  Git Integration

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