Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-4605

8.0 changes result format of Field_float::make_sort_key

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: 5.7.22-22, 8.0.x
    • Fix Version/s: 5.7.23-23
    • Component/s: MyRocks
    • Labels:
      None

      Description

      8.0 changes the result format for Field_float::make_sort_key in such a way that the MyRocks unpacking mechanism can not properly unpack data stored in the 8.0 format.

      Offending change introduced here https://github.com/mysql/mysql-server/commit/71b2787edcf1cfb5225c26890e8dea8f2b6db43c

      mysql> CREATE TABLE t1 (f FLOAT PRIMARY KEY) ENGINE=rocksdb;
      Query OK, 0 rows affected (0.09 sec)
      
      mysql> insert into t1 values (5.0);
      Query OK, 1 row affected (0.03 sec)
      
      mysql> select * from t1;
      +-----+
      | f |
      +-----+
      | 2.5 |
      +-----+
      1 row in set (0.01 sec)
      

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                george.lorch George Lorch
                Reporter:
                george.lorch George Lorch
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 1 day, 7 hours, 45 minutes
                    1d 7h 45m