I can't truncate table

hi. all

i truncate table , but data not deleted.

please help.

member> select count(*) from ch_user;
count
±------+
25
(1 row)

Time: 1.963309ms

member> truncate table member.ch_user;
TRUNCATE

Time: 183.050781ms

member> select count(*) from ch_user;
count
±------+
25
(1 row)

few minute later… data was deleted…

why???

select count(*) from ch_user;
count
±------+
0
(1 row)

Time: 2.370814ms

Hi,

What version of CockroachDb is this?

Thanks,
Matt

Hi,

This looks like a known limitation. See here.

Let me know if you have any questions. For that operation, it would seem like a delete would be better suited.

hi. version is 19.1.4

                                     version

±----------------------------------------------------------------------------------------+
CockroachDB CCL v19.1.4 (x86_64-unknown-linux-gnu, built 2019/08/06 15:34:13, go1.11.6)