CREATE VIEW IF NOT EXISTS CUSTOM_ENTITY."z01" (COL1 VARCHAR, COL2 VARCHAR, COL3 VARCHAR, COL4 VARCHAR CONSTRAINT PK PRIMARY KEY (COL1 DESC, COL2 DESC, COL3 DESC, COL4 DESC)) AS SELECT * FROM CUSTOM_ENTITY.CUSTOM_ENTITY_DATA_NO_ID WHERE KEY_PREFIX = 'z01';
UPSERT INTO CUSTOM_ENTITY."z01" (COL1, COL2, COL3, COL4) VALUES ('8', 'blah', 'blah', 'blah');
UPSERT INTO CUSTOM_ENTITY."z01" (COL1, COL2, COL3, COL4) VALUES ('6', 'blah', 'blah', 'blah');
UPSERT INTO CUSTOM_ENTITY."z01" (COL1, COL2, COL3, COL4) VALUES ('23', 'blah', 'blah', 'blah');
UPSERT INTO CUSTOM_ENTITY."z01" (COL1, COL2, COL3, COL4) VALUES ('17', 'blah', 'blah', 'blah');
SELECT COL1, COL2, COL3, COL4 FROM CUSTOM_ENTITY."z01" WHERE COL4='blah' AND (COL1='1' OR COL1='2' OR COL1='3' OR COL1='4' OR COL1='5' OR COL1='6' OR COL1='8' OR COL1='17' OR COL1='12' OR COL1='23') AND COL3='blah'
+-------+-------+-------+-------+
| COL1 | COL2 | COL3 | COL4 |
+-------+-------+-------+-------+
| 8 | blah | blah | blah |
| 6 | blah | blah | blah |
+-------+-------+-------+-------+
SELECT COL1, COL2, COL3, COL4 FROM CUSTOM_ENTITY."z01" WHERE COL4='blah' AND (COL1='6'OR COL1='8' OR COL1='17' OR COL1='12' OR COL1='23') AND COL3='blah'
+-------+-------+-------+-------+
| COL1 | COL2 | COL3 | COL4 |
+-------+-------+-------+-------+
| 8 | blah | blah | blah |
| 6 | blah | blah | blah |
| 23 | blah | blah | blah |
| 17 | blah | blah | blah |
+-------+-------+-------+-------
PHOENIX-4306
Add more tests for DESC sort order
PHOENIX-2067 Sort order incorrect for variable length DESC columns
