• Marko Mäkelä's avatar
    MDEV-14023 10.1 InnoDB tables with virtual columns cannot be accessed in 10.2 · e1d9a237
    Marko Mäkelä authored
    MariaDB 10.1 introduced non-indexed virtual columns for InnoDB tables.
    When MySQL 5.7 introduced virtual columns in InnoDB tables, it also
    introduced the table SYS_VIRTUAL that stores metadata on virtual
    columns. This table does not initially exist in data files that were
    imported from 10.1. So, we do not always have virtual column metadata
    inside InnoDB.
    
    dict_index_contains_col_or_prefix(): In the clustered index records,
    all non-virtual columns are present and no virtual columns are present.
    
    ha_innobase::build_template(): In the clustered index, do not
    include virtual columns in the query template. The SQL layer is
    supposed to compute the virtual column values when needed.
    e1d9a237
ha_innodb.cc 646 KB