Column Invalid for Replication Timestamp
When attempting to set CHECK CONFLICTS
for an element in a CREATE REPLICATION
statement, you may encounter an error similar to the following.
8004: Column REPL.TABS.TS cannot be used for replication timestamp checking if in an index or added by ALTER TABLE; and must be binary(8) with NULL values allowed.
In this situation, check:
-
That the timestamp column in the specified table is a nullable column of type
BINARY(8)
. In the above example, the TS column in theREPL.TAB
table should have a type ofBINARY(8)
. -
The timestamp column is defined in the original
CREATE TABLE
statement, rather than added later usingALTER TABLE
.