ql/src/test/queries/clientpositive/udf6.q

--! qt:dataset:src
CREATE TABLE dest1_n60(c1 STRING) STORED AS TEXTFILE;

FROM src INSERT OVERWRITE TABLE dest1_n60 SELECT '  abc  ' WHERE src.key = 86;

EXPLAIN
SELECT IF(TRUE, 1, 2) FROM dest1_n60;

SELECT IF(TRUE, 1, 2) FROM dest1_n60;

EXPLAIN
SELECT IF(TRUE, 1, 2), IF(FALSE, 1, 2), IF(NULL, 1, 2), IF(TRUE, "a", "b"),
       IF(TRUE, 0.1, 0.2), IF(FALSE, CAST(1 AS BIGINT), CAST(2 AS BIGINT)),
       IF(FALSE, CAST(127 AS TINYINT), CAST(126 AS TINYINT)),
       IF(FALSE, CAST(127 AS SMALLINT), CAST(128 AS SMALLINT)),
       CAST(128 AS INT), CAST(1.0 AS DOUBLE),
       CAST('128' AS STRING) FROM dest1_n60;

SELECT IF(TRUE, 1, 2), IF(FALSE, 1, 2), IF(NULL, 1, 2), IF(TRUE, "a", "b"),
       IF(TRUE, 0.1, 0.2), IF(FALSE, CAST(1 AS BIGINT), CAST(2 AS BIGINT)),
       IF(FALSE, CAST(127 AS TINYINT), CAST(126 AS TINYINT)),
       IF(FALSE, CAST(127 AS SMALLINT), CAST(128 AS SMALLINT)),
       CAST(128 AS INT), CAST(1.0 AS DOUBLE),
       CAST('128' AS STRING) FROM dest1_n60;