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