"Fossies" - the Fresh Open Source Software Archive

Member "mroonga-12.04/mysql-test/mroonga/storage/column/generated/virtual/mysql/r/add_index.result" (6 Jun 2022, 367 Bytes) of package /linux/misc/mroonga-12.04.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 DROP TABLE IF EXISTS logs;
    2 CREATE TABLE logs (
    3 id INT,
    4 record JSON,
    5 message VARCHAR(255) GENERATED ALWAYS AS (json_extract(`record`, '$.message')) VIRTUAL
    6 ) ENGINE=Mroonga DEFAULT CHARSET=utf8mb4;
    7 ALTER TABLE logs ADD INDEX (message);
    8 ERROR HY000: Table storage engine 'Mroonga' does not support the create option 'Index on virtual generated column'
    9 DROP TABLE logs;