09u3PCfY

1CREATE TABLE IF NOT EXISTS ERN_ARCHIVE.TEST_TABLE (ID VARCHAR(36) NOT NULL PRIMARY KEY, DATA VARCHAR);
2UPSERT INTO ERN_ARCHIVE.TEST_TABLE(ID, DATA) VALUES('1', 'data1');
3SELECT * FROM ERN_ARCHIVE.TEST_TABLE;
4UPSERT INTO ERN_ARCHIVE.TEST_TABLE(ID, DATA) VALUES('1', 'data2');
5SELECT * FROM ERN_ARCHIVE.TEST_TABLE;
6UPSERT INTO ERN_ARCHIVE.TEST_TABLE(ID, DATA) VALUES('1', null);
7SELECT * FROM ERN_ARCHIVE.TEST_TABLE;