lddlww
lddlww
thanks for reply
@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...