The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
What is the purpose of the AUDIT_LENGTH() function?
It seems that
AUDIT_LENGTH() is run by an internal process. What's the purpose of this function and how does it differ from LENGTH()? dbadmin=> CREATE TABLE test (name varchar(10)); CREATE TABLE dbadmin=> INSERT INTO test (name) VALUES ('Tim'); OUTPUT -------- 1 (1 row) dbadmin=> INSERT INTO test (name) VALUES ('Michael'); OUTPUT -------- 1 (1 row) dbadmin=> COMMIT; COMMIT dbadmin=> SELECT AUDIT_LENGTH("name") FROM test; AUDIT_LENGTH -------------- 3 7 (2 rows) dbadmin=> SELECT LENGTH("name") FROM test; LENGTH -------- 3 7 (2 rows) 0