====
---- QUERY
# test querying text table "extended" ASCII (latin) delimiters:
# fields terminated by '-2' -- thorn character
# escaped by '-22' -- lowercase e with circumflex
# lines terminated by '\n'
select * from functional.text_thorn_ecirc_newline
---- RESULTS
'one','two',3,4
'one\xfeone','two',3,4
'one\xea','two',3,4
'one\xea\xfeone','two',3,4
'one\xea\xea','two',3,4
---- TYPES
STRING,STRING,INT,INT
====
---- QUERY
# create new tables like the ones above to test inserting
create table tecn like functional.text_thorn_ecirc_newline;
---- RESULTS
'Table has been created.'
====
---- QUERY
# insert data into tecn table and check results
# TODO: Expand verification to cover inserting a field terminator and escape character.
# Some additional work needs to be done in the test framework to properly encode/decode
# the values going into the INSERT query before this will work.
insert overwrite tecn values
('abc', 'xyz', 1, 2),
('efg', 'xyz', 3, 4)
====
---- QUERY
select * from tecn
---- RESULTS
'abc','xyz',1,2
'efg','xyz',3,4
---- TYPES
STRING,STRING,INT,INT
====