Re: Counter column impossible to delete and re-insert

Hello Clément This is a known anti-pattern. You should never re-use a deleted counter column otherwise there will be unpredictable result for the counter value. Le 6 nov. 2014 08:45, "Clément Fumey" a écrit : > Hi, > > I have a table with counter column . When I insert (update) a row, delete > i

Counter column impossible to delete and re-insert

Hi, I have a table with counter column . When I insert (update) a row, delete it and try to re-insert, it fail to re-insert the row. Here is the commands i use : CREATE TABLE test( testId int, year int, testCounter counter, PRIMARY KEY (testId, year) )WITH CLUSTERING ORDER BY (yea