lddlww

Results 36 comments of lddlww

@kennytm thanks after alter,when i insert row,i encountered error: ``` ERROR 8059 (HY000): Failed to read auto-random value from storage engine ```

@kennytm i create new table ```test_auto_random``` for test,but i foud the error always been,after alter: ``` ERROR 8059 (HY000): Failed to read auto-random value from storage engine ```

@kennytm both encountered 8059 error operator: ``` MySQL [bi]> show create table test_auto; +-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | test_auto | CREATE TABLE `test_auto` ( `id` bigint(20)...

@kennytm can the alter auto_random_base operator be used ,only for tables created by tidb-lighting?

@kennytm i created by mysql cli,just for test: ``` MySQL [gamelab]> create table test_auto(id bigint(20) primary key auto_random,name varchar(10)); ```

follow steps: ``` MySQL [test]> create table test_auto(id bigint(20) primary key auto_random,name varchar(10)); Query OK, 0 rows affected, 1 warning (0.16 sec) MySQL [test]> insert into test_auto(name) values('1'); Query OK,...

@kennytm does mysql cli version affect? ``` mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1 ```

@kennytm thanks just ```max(id & ((1 create table test_auto(id bigint(20) primary key auto_random,name varchar(10)); Query OK, 0 rows affected, 1 warning (0.16 sec) MySQL [test]> insert into test_auto(name) values('1'); Query...