This knowledge base article addresses a situation where a vulnerability was identified and wanted to confirm if this is impacting Vertica. The article explains the cause of the errors, provides a resolution to address the issue, and offers insight into potential preventative measures.
Environment
Vertica 24.3
Situation
Y2k38 issue (https://en.wikipedia.org/wiki/Year_2038_problem) was identified on the product and is needed to understand if Vertica 233.4 is vulnerable to this. The Vertica documentation states that all Date/Time data types are stored in 8 bytes (64 bits). The Y2K38 issue is only an issue for dates stored in a signed 32-bit value, so is assumed that Vertica would not be vulnerable to this but would like to confirm this.