phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stan Campbell <stan.campbe...@gmail.com>
Subject PHX 4; mutable index strangeness
Date Thu, 13 Mar 2014 20:27:12 GMT
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

Mime
View raw message