--! qt:dataset:src1
SET hive.vectorized.execution.enabled=false;
set hive.fetch.task.conversion=more;

DESCRIBE FUNCTION character_length;
DESCRIBE FUNCTION EXTENDED character_length;

DESCRIBE FUNCTION char_length;
DESCRIBE FUNCTION EXTENDED char_length;

CREATE TABLE dest1_n97(len INT);
EXPLAIN FROM src1 INSERT OVERWRITE TABLE dest1_n97 SELECT character_length(src1.value);
FROM src1 INSERT OVERWRITE TABLE dest1_n97 SELECT character_length(src1.value);
-- SORT_BEFORE_DIFF
SELECT dest1_n97.* FROM dest1_n97;
DROP TABLE dest1_n97;

-- Test with non-ascii characters.
CREATE TABLE dest1_n97(name STRING) STORED AS TEXTFILE;
LOAD DATA LOCAL INPATH '../../data/files/kv4.txt' INTO TABLE dest1_n97;
INSERT INTO dest1_n97 VALUES(NULL);

EXPLAIN SELECT character_length(dest1_n97.name) FROM dest1_n97;
-- SORT_BEFORE_DIFF
SELECT character_length(dest1_n97.name) FROM dest1_n97;

EXPLAIN SELECT char_length(dest1_n97.name) FROM dest1_n97;
-- SORT_BEFORE_DIFF
SELECT char_length(dest1_n97.name) FROM dest1_n97;
DROP TABLE dest1_n97;