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
            greenman Ian Gilfillan created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Labels Compatibility compat56 Compatibility beginner-friendly compat56
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Minor [ 4 ]
            nikitamalyavin Nikita Malyavin made changes -
            Assignee Nikita Malyavin [ nikitamalyavin ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Description MariaDB 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.             		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.
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 121922 ] MariaDB v4 [ 131498 ]
            julien.fritsch Julien Fritsch made changes -
            Assignee Nikita Malyavin [ nikitamalyavin ] Ralf Gebhardt [ ralf.gebhardt@mariadb.com ]
            danblack Daniel Black made changes -
            Assignee Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] Daniel Black [ danblack ]
            danblack Daniel Black made changes -
            Fix Version/s 10.10 [ 27530 ]
            danblack Daniel Black made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            danblack Daniel Black made changes -
            Status In Progress [ 3 ] In Testing [ 10301 ]
            serg Sergei Golubchik made changes -
            Assignee Daniel Black [ danblack ] Lena Startseva [ JIRAUSER50478 ]
            greenman Ian Gilfillan made changes -
            Labels Compatibility beginner-friendly compat56 Compatibility beginner-friendly compat56 compat80
            monty Michael Widenius made changes -
            elenst Elena Stepanova made changes -
            Assignee Lena Startseva [ JIRAUSER50478 ] Elena Stepanova [ elenst ]
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Sergei Golubchik [ serg ]
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Priority Minor [ 4 ] Critical [ 2 ]
            serg Sergei Golubchik made changes -
            Priority Critical [ 2 ] Minor [ 4 ]
            nikitamalyavin Nikita Malyavin made changes -
            Comment [ Right... sorry, i didn't check Item_func_random_bytes::val_str before asking, only RAND_bytes function description, since I remembered something about the length restriction, but nothing was there.

            So, why "if (length > 1024) then NULL", and "if (length > max_allowed_packet) then NULL" should behave differently? ]
            elenst Elena Stepanova made changes -
            Status Stalled [ 10000 ] In Testing [ 10301 ]
            elenst Elena Stepanova made changes -
            Assignee Sergei Golubchik [ serg ] Elena Stepanova [ elenst ]
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Daniel Black [ danblack ]
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            danblack Daniel Black made changes -
            Assignee Daniel Black [ danblack ] Sergei Golubchik [ serg ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Status In Review [ 10002 ] In Testing [ 10301 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Elena Stepanova [ elenst ]
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Sergei Golubchik [ serg ]
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.10.1 [ 27913 ]
            Fix Version/s 10.10 [ 27530 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            AirFocus AirFocus made changes -
            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.             		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.
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Compatibility beginner-friendly compat56 compat80 Compatibility Preview_10.10 beginner-friendly compat56 compat80
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 181096 116234

            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.