What happens when we insert NULL values in the Column where we have defined a TTL Job. What is the expected behaviour?

FAQ
1

Like what happens are the values deleted or are NULL values treated as Infinite Timestamp as what I can see is, it does the scanning Job like ‘Select * FROM your_table WHERE ttl_column < NOW();’ or some time interval addition and NULL values return false for these.

2

Yes if the column is NULL then it won’t be deleted.