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

--! qt:dataset:src
set hive.fetch.task.conversion=more;

DESCRIBE FUNCTION when;
DESCRIBE FUNCTION EXTENDED when;

EXPLAIN
SELECT CASE
        WHEN 1=1 THEN 2
        WHEN 1=3 THEN 4
        ELSE 5
       END,
       CASE
        WHEN 6=7 THEN 8
        ELSE 9
       END,
       CASE
        WHEN 10=11 THEN 12
        WHEN 13=13 THEN 14
       END,
       CASE
        WHEN 15=16 THEN 17
        WHEN 18=19 THEN 20
       END,
       CASE
        WHEN 21=22 THEN NULL
        WHEN 23=23 THEN 24
       END,
       CASE
        WHEN 25=26 THEN 27
        WHEN 28=28 THEN NULL
       END
FROM src tablesample (1 rows);

SELECT CASE
        WHEN 1=1 THEN 2
        WHEN 1=3 THEN 4
        ELSE 5
       END,
       CASE
        WHEN 6=7 THEN 8
        ELSE 9
       END,
       CASE
        WHEN 10=11 THEN 12
        WHEN 13=13 THEN 14
       END,
       CASE
        WHEN 15=16 THEN 17
        WHEN 18=19 THEN 20
       END,
       CASE
        WHEN 21=22 THEN NULL
        WHEN 23=23 THEN 24
       END,
       CASE
        WHEN 25=26 THEN 27
        WHEN 28=28 THEN NULL
       END
FROM src tablesample (1 rows);

-- Allow compatible types to be used in return value
SELECT CASE
        WHEN 1=1 THEN 123.0BD
        ELSE 0.0BD
       END,
       CASE
        WHEN 1=1 THEN 123
        WHEN 1=2 THEN 1.0
        ELSE 222.02BD
       END,
       CASE
        WHEN 1=1 THEN 'abcd'
        WHEN 1=2 THEN cast('efgh' as varchar(10))
        ELSE cast('ijkl' as char(4))
       END
FROM src tablesample (1 rows);