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

Add RANDOM_BYTES function

Details

    Description

      MySQL 5.6 added the RANDOM_BYTES function: https://dev.mysql.com/doc/refman/5.6/en/encryption-functions.html#function_random-bytes

      This is needed for compatibility purposes.

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-28906 MySQL 8.0 desired compatibility

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29028 Queries using RANDOM_BYTES get stored in query cache

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29029 Index corruption and/or assertion failure upon using RANDOM_BYTES for indexed virtual column

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29099 Missing capitalization in the error message from ER_DATA_OUT_OF_RANGE template

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29108 Assertion `m_using_unique_constraint || m_group_buff <= param->group_buff + param->group_length' failed in Create_tmp_table::finalize

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29154 Excessive warnings upon a call to RANDOM_BYTES

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29185 RANDOM_BYTES as a virtual column function makes binlog non-deterministic

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            View 11 older comments
            danblack Daniel Black added a comment -

            As suggested, I implemented this at the end of bb-10.10-MDEV-25704 and tested for mysql 8,0 compatibility. select random_bytes(0) is our extension. Note the fixme on TIME conversion in the test. Suggestions on implementing this much appreciated.

            danblack Daniel Black added a comment - As suggested, I implemented this at the end of bb-10.10- MDEV-25704 and tested for mysql 8,0 compatibility. select random_bytes(0) is our extension. Note the fixme on TIME conversion in the test. Suggestions on implementing this much appreciated.
            elenst Elena Stepanova added a comment -

            bb-10.10-MDEV-25704 as of ce1c50665 is NOT OK to push into the main tree, it fails in buildbot and otherwise.

            elenst Elena Stepanova added a comment - bb-10.10- MDEV-25704 as of ce1c50665 is NOT OK to push into the main tree, it fails in buildbot and otherwise.
            danblack Daniel Black added a comment - - edited

            fixed most. Debug builds only of query_cache test failing because args[0]->can_eval_in_optimize() changes from false to true between Item_func_random_bytes::fix_length_and_dec and Item_func_random_bytes::val_str. This is due to args[0]->table->const_table becoming true.

            danblack Daniel Black added a comment - - edited fixed most. Debug builds only of query_cache test failing because args[0]->can_eval_in_optimize() changes from false to true between Item_func_random_bytes::fix_length_and_dec and Item_func_random_bytes::val_str . This is due to args[0]->table->const_table becoming true.
            danblack Daniel Black added a comment -

            Ok, buildbot happy again. serg, nikitamalyavin can I get a review on the last two commits on the bb-10.10-MDEV-25704 branch.

            danblack Daniel Black added a comment - Ok, buildbot happy again. serg , nikitamalyavin can I get a review on the last two commits on the bb-10.10- MDEV-25704 branch.
            elenst Elena Stepanova added a comment -

            I have no further objections against pushing bb-10.10-MDEV-25704 as of 7f422495 into 10.10 main and releasing it with 10.10.1.

            elenst Elena Stepanova added a comment - I have no further objections against pushing bb-10.10- MDEV-25704 as of 7f422495 into 10.10 main and releasing it with 10.10.1.

            People

              serg Sergei Golubchik
              greenman Ian Gilfillan
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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