github.com/pingcap/br@v5.3.0-alpha.0.20220125034240-ec59c7b6ce30+incompatible/tests/lightning_generated_columns/data/gencol.expr_index-schema.sql (about)

     1  -- https://github.com/pingcap/br/issues/1404
     2  -- expression indices just use a hidden virtual generated column behind the scene.
     3  
     4  CREATE TABLE `expr_index` (
     5      `id` int(11) NOT NULL AUTO_INCREMENT,
     6      `a` varchar(20) DEFAULT NULL,
     7      `b` varchar(20) DEFAULT NULL,
     8      PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */,
     9      KEY `idx_a` (`a`),
    10      KEY `idx_lower_b` ((lower(`b`)))
    11  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=90003;