----TEST CASE----

Environment:Phoenix 4.7/HBase 1.1.2

CREATE TABLE TEST_TABLE (
       NAME VARCHAR(100) NOT NULL PRIMARY KEY,
       C1 VARCHAR(32),
       C2 VARCHAR(32)
    );

SELECT NAME, (CASE WHEN ALL(ARRAY[C1,C2]) = 'A' THEN 1 ELSE 2 END) AS VAL
FROM TEST_TABLE;

SELECT NAME, (CASE WHEN ANY(ARRAY[C1,C2]) = 'A' THEN 1 ELSE 2 END) AS VAL
FROM TEST_TABLE;
------

Both select statements fail with a parse error <<[Error Code: 602, SQL
State: 42P00]  ERROR 602 (42P00): Syntax error. Missing "LPAREN">>

Are ANY/ALL functions not supported within a CASE statement?

Alok

Reply via email to