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