I've faced with "Unsupported non nullable index type BINARY" while using
"UPSERT INTO...". My table and indexes are:

                jdbcTemplate.execute("CREATE TABLE IF NOT EXISTS " +
tableName
                        + "( id BIGINT NOT NULL PRIMARY KEY" // INDEX_ID
                        + ", t BINARY(16) NOT NULL" // INDEX_THING_ID
                        + ", e BINARY(16) NOT NULL" // INDEX_EVENT_KEY
                        + ", d DATE NOT NULL" // INDEX_TIMESTAMP
                        + ", y BINARY(16) NULL" // INDEX_METATYPE_ID
                        + ", v VARBINARY NULL)"); // INDEX_VALUE

                jdbcTemplate.execute("CREATE INDEX IF NOT EXISTS " +
TED_INDEX
                        + " ON " + tableName + "(t, e, d DESC)");
                jdbcTemplate.execute("CREATE INDEX IF NOT EXISTS " +
TDE_INDEX
                        + " ON " + tableName + "(t, d DESC, e)");

It is confusing me because all columns indexes have built on is "NOT NULL".
Where is a mistake?

-- 
Respectfully yours,

Dmitry Salychev
darkness....@gmail.com

Reply via email to