PHX 4; mutable index strangeness

[Stan Campbell]

This is odd.. I think?

If I create a simple table like..

CREATE TABLE SITE_ACTIVITY_UPDATES (

  SITE_ID VARCHAR(255),
  UPDATED_AT  DATE

    CONSTRAINT PK PRIMARY KEY (SITE_ID)
) SALT_BUCKETS = 3;

If I do a test insert of...

UPSERT INTO SITE_ACTIVITY_UPDATES(SITE_ID, UPDATED_AT) VALUES
('ABC123',NULL);

Then the following select returns the row as expected.

However, if I add an index like this..

CREATE INDEX SITE_ACTIVITY_UPDATES_BY_CREATED_AT ON SITE_ACTIVITY_UPDATES
(UPDATED_AT) SALT_BUCKETS = 3;

Then the row is apparently not inserted at all?

Am I doing something incredibly silly?

-- Stan