Nothing returns from query against multi-tenant table where the SELECT statement contains a WHERE condition filtering on the multi-tenant field and also contains a row value constructor.
Run the statement below and see that no records are returned (the second upserted record should be returned). Notice that you can either remove the multi-tenancy of the table, or the "pk1 = 'a' AND" WHERE condition and the query returns the second record fine, but does not return the second record as it is.
DROP TABLE IF EXISTS TEST_TABLE;
CREATE TABLE IF NOT EXISTS TEST_TABLE (
pk1 VARCHAR NOT NULL,
pk2 DECIMAL NOT NULL,
CONSTRAINT PK PRIMARY KEY
CREATE INDEX TEST_INDEX ON TEST_TABLE (v1);
upsert into TEST_TABLE (pk1, pk2, v1) values ('a', 1, 'value');
upsert into TEST_TABLE (pk1, pk2, v1) values ('a', 2, 'value');
SELECT pk1, pk2, v1
– notice that if you comment/remove the "pk1='a' AND " statement below the query returns the second record correctly
pk1 = 'a' AND
(pk1, pk2) > ('a', 1)
ORDER BY PK1, PK2