--! qt:dataset:src1
DESCRIBE FUNCTION reverse;
DESCRIBE FUNCTION EXTENDED reverse;

CREATE TABLE dest1_n44(len STRING);
EXPLAIN FROM src1 INSERT OVERWRITE TABLE dest1_n44 SELECT reverse(src1.value);
FROM src1 INSERT OVERWRITE TABLE dest1_n44 SELECT reverse(src1.value);
SELECT dest1_n44.* FROM dest1_n44;
DROP TABLE dest1_n44;

-- Test with non-ascii characters
-- kv4.txt contains the text 0xE982B5E993AE, which should be reversed to
-- 0xE993AEE982B5
CREATE TABLE dest1_n44(name STRING) STORED AS TEXTFILE;
LOAD DATA LOCAL INPATH '../../data/files/kv4.txt' INTO TABLE dest1_n44;
SELECT count(1) FROM dest1_n44 WHERE reverse(dest1_n44.name) = _UTF-8 0xE993AEE982B5;