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

Mysqltest hex() not working for string values

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.6.23
    • 10.6
    • OTHER
    • None
    • Unexpected results

    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

              sanja Oleksandr Byelkin
              poojalamba16 Pooja Rani Lamba
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.