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
[email protected]
