kennytm comments

Results 391 comments of


                                            kennytm

allow use lightning tidb backend to load data to mysql

No progress, it is not scheduled for development in this year.

More flexible CSV options

(Internal reference: (1) PRM-332, (2) PRM-243.)

after import data，insert error：duplicate entry for key 'PRIMARY'

Hi. Your primary key is an auto_random column, which was not yet supported by Lightning before v4.0.1 (#298). You may either * Fix up the auto-random base by: ```sql SELECT...

after import data，insert error：duplicate entry for key 'PRIMARY'

@lddlww Oh. Have you successfully inserted some rows after Lightning import and before the "duplicate entry for key 'PRIMARY'" error? If so, `max(id)` unfortunately is no longer the correct measure...

after import data，insert error：duplicate entry for key 'PRIMARY'

@lddlww are you using `max(id)` or `max(id & ((1

after import data，insert error：duplicate entry for key 'PRIMARY'

@lddlww From the `show create table test_auto`, it looks like the problem is due to > AUTO_RANDOM_BASE=4323455642275729509 * 4323455642275729509 = 0x3c00_0000_0000_d065 the sharding bits (0x3c) was somehow included, but the...

after import data，insert error：duplicate entry for key 'PRIMARY'

@lddlww hmm, so how was `test_auto` created and populated?

after import data，insert error：duplicate entry for key 'PRIMARY'

`auto_random_base` can be used for all tables

after import data，insert error：duplicate entry for key 'PRIMARY'

@lddlww 😕 can't reproduce the 8059 error. how are the two rows inserted into `test_auto`?

after import data，insert error：duplicate entry for key 'PRIMARY'

@lddlww oh. well the issue is that this statement will overflow the auto_random_base: ```sql alter table test_auto auto_random_base=6629298651489370114; ```