1#Licensed to the Apache Software Foundation (ASF) under one or more contributor
2#license agreements. See the NOTICE file distributed with this work for additional
3#information regarding copyright ownership. The ASF licenses this file to
4#You under the Apache License, Version 2.0 (the "License"); you may not use
5#this file except in compliance with the License. You may obtain a copy of
6#the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required
7#by applicable law or agreed to in writing, software distributed under the
8#License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS
9#OF ANY KIND, either express or implied. See the License for the specific
10#language governing permissions and limitations under the License.
11
12name: 'table1'
13
14create: 'CREATE TABLE table1 (int_field1 INT, bool_field2 BOOLEAN, tinyint_field3 TINYINT, smallint_field4 SMALLINT, bigint_field5 BIGINT,
15    decimal_field6 DECIMAL(20,2), double_field7 DOUBLE, real_field8 REAL, time_field9 TIME, date_field10 DATE, timestamp_field11 TIMESTAMP,
16    binary_field12 BINARY(100), varchar_field13 VARCHAR(256), blob_field14 BLOB, clob_field15 CLOB, char_field16 CHAR(16), bit_field17 BIT,
17    null_field18 NULL);'
18
19data:
20  - 'INSERT INTO table1 VALUES (101, 1, 45, 12000, 92233720, 17345667789.23, 56478356785.345, 56478356785.345, PARSEDATETIME(''12:45:35 GMT'', ''HH:mm:ss z''),
21  PARSEDATETIME(''2018-02-12 GMT'', ''yyyy-MM-dd z''), PARSEDATETIME(''2018-02-12 12:45:35 GMT'', ''yyyy-MM-dd HH:mm:ss z''),
22  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to varchar'',
23  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to clob'', ''some char text'', 1, null);'
24
25  - 'INSERT INTO table1 VALUES (101, 1, 45, 12000, 92233720, 17345667789.23, 56478356785.345, 56478356785.345, PARSEDATETIME(''12:45:35 GMT'', ''HH:mm:ss z''),
26  PARSEDATETIME(''2018-02-12 GMT'', ''yyyy-MM-dd z''), PARSEDATETIME(''2018-02-12 12:45:35 GMT'', ''yyyy-MM-dd HH:mm:ss z''),
27  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to varchar'',
28  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to clob'', ''some char text'', 1, null);'
29
30  - 'INSERT INTO table1 VALUES (101, 1, 45, 12000, 92233720, 17345667789.23, 56478356785.345, 56478356785.345, PARSEDATETIME(''12:45:35 GMT'', ''HH:mm:ss z''),
31  PARSEDATETIME(''2018-02-12 GMT'', ''yyyy-MM-dd z''), PARSEDATETIME(''2018-02-12 12:45:35 GMT'', ''yyyy-MM-dd HH:mm:ss z''),
32  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to varchar'',
33  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to clob'', ''some char text'', 1, null);'
34
35  - 'INSERT INTO table1 VALUES (101, 1, 45, 12000, 92233720, 17345667789.23, 56478356785.345, 56478356785.345, PARSEDATETIME(''12:45:35 GMT'', ''HH:mm:ss z''),
36  PARSEDATETIME(''2018-02-12 GMT'', ''yyyy-MM-dd z''), PARSEDATETIME(''2018-02-12 12:45:35 GMT'', ''yyyy-MM-dd HH:mm:ss z''),
37  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to varchar'',
38  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to clob'', ''some char text'', 1, null);'
39
40  - 'INSERT INTO table1 VALUES (101, 1, 45, 12000, 92233720, 17345667789.23, 56478356785.345, 56478356785.345, PARSEDATETIME(''12:45:35 GMT'', ''HH:mm:ss z''),
41  PARSEDATETIME(''2018-02-12 GMT'', ''yyyy-MM-dd z''), PARSEDATETIME(''2018-02-12 12:45:35 GMT'', ''yyyy-MM-dd HH:mm:ss z''),
42  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to varchar'',
43  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to clob'', ''some char text'', 1, null);'
44
45  - 'INSERT INTO table1 VALUES (101, 1, 45, 12000, 92233720, 17345667789.23, 56478356785.345, 56478356785.345, PARSEDATETIME(''12:45:35 GMT'', ''HH:mm:ss z''),
46  PARSEDATETIME(''2018-02-12 GMT'', ''yyyy-MM-dd z''), PARSEDATETIME(''2018-02-12 12:45:35 GMT'', ''yyyy-MM-dd HH:mm:ss z''),
47  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to varchar'',
48  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to clob'', ''some char text'', 1, null);'
49
50  - 'INSERT INTO table1 VALUES (101, 1, 45, 12000, 92233720, 17345667789.23, 56478356785.345, 56478356785.345, PARSEDATETIME(''12:45:35 GMT'', ''HH:mm:ss z''),
51  PARSEDATETIME(''2018-02-12 GMT'', ''yyyy-MM-dd z''), PARSEDATETIME(''2018-02-12 12:45:35 GMT'', ''yyyy-MM-dd HH:mm:ss z''),
52  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to varchar'',
53  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to clob'', ''some char text'', 1, null);'
54
55  - 'INSERT INTO table1 VALUES (101, 1, 45, 12000, 92233720, 17345667789.23, 56478356785.345, 56478356785.345, PARSEDATETIME(''12:45:35 GMT'', ''HH:mm:ss z''),
56  PARSEDATETIME(''2018-02-12 GMT'', ''yyyy-MM-dd z''), PARSEDATETIME(''2018-02-12 12:45:35 GMT'', ''yyyy-MM-dd HH:mm:ss z''),
57  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to varchar'',
58  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to clob'', ''some char text'', 1, null);'
59
60  - 'INSERT INTO table1 VALUES (101, 1, 45, 12000, 92233720, 17345667789.23, 56478356785.345, 56478356785.345, PARSEDATETIME(''12:45:35 GMT'', ''HH:mm:ss z''),
61  PARSEDATETIME(''2018-02-12 GMT'', ''yyyy-MM-dd z''), PARSEDATETIME(''2018-02-12 12:45:35 GMT'', ''yyyy-MM-dd HH:mm:ss z''),
62  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to varchar'',
63  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to clob'', ''some char text'', 1, null);'
64
65  - 'INSERT INTO table1 VALUES (101, 1, 45, 12000, 92233720, 17345667789.23, 56478356785.345, 56478356785.345, PARSEDATETIME(''12:45:35 GMT'', ''HH:mm:ss z''),
66  PARSEDATETIME(''2018-02-12 GMT'', ''yyyy-MM-dd z''), PARSEDATETIME(''2018-02-12 12:45:35 GMT'', ''yyyy-MM-dd HH:mm:ss z''),
67  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to varchar'',
68  ''736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'', ''some text that needs to be converted to clob'', ''some char text'', 1, null);'
69
70query: 'select int_field1, bool_field2, tinyint_field3, smallint_field4, bigint_field5, decimal_field6, double_field7, real_field8,
71        time_field9, date_field10, timestamp_field11, binary_field12, varchar_field13, blob_field14, clob_field15, char_field16, bit_field17, null_field18 from table1'
72
73drop: 'DROP table table1;'
74
75rowCount: '10'
76
77values:
78 - 'INT_FIELD1=101,101,101,101,101,101,101,101,101,101'
79 - 'BOOL_FIELD2=1,1,1,1,1,1,1,1,1,1'
80 - 'BIT_FIELD17=1,1,1,1,1,1,1,1,1,1'
81 - 'TINYINT_FIELD3=45,45,45,45,45,45,45,45,45,45'
82 - 'SMALLINT_FIELD4=12000,12000,12000,12000,12000,12000,12000,12000,12000,12000'
83 - 'BIGINT_FIELD5=92233720,92233720,92233720,92233720,92233720,92233720,92233720,92233720,92233720,92233720'
84 - 'REAL_FIELD8=56478356785.345f,56478356785.345f,56478356785.345f,56478356785.345f,56478356785.345f,56478356785.345f,56478356785.345f,56478356785.345f,56478356785.345f,56478356785.345f'
85 - 'DECIMAL_FIELD6=17345667789.23,17345667789.23,17345667789.23,17345667789.23,17345667789.23,17345667789.23,17345667789.23,17345667789.23,17345667789.23,17345667789.23'
86 - 'DOUBLE_FIELD7=56478356785.345,56478356785.345,56478356785.345,56478356785.345,56478356785.345,56478356785.345,56478356785.345,56478356785.345,56478356785.345,56478356785.345'
87 - 'TIME_FIELD9=45935000,45935000,45935000,45935000,45935000,45935000,45935000,45935000,45935000,45935000'
88 - 'DATE_FIELD10=17574,17574,17574,17574,17574,17574,17574,17574,17574,17574'
89 - 'TIMESTAMP_FIELD11=1518439535000,1518439535000,1518439535000,1518439535000,1518439535000,1518439535000,1518439535000,1518439535000,1518439535000,1518439535000'
90 - 'CHAR_FIELD16=some char text,some char text,some char text,some char text,some char text,
91 		 some char text,some char text,some char text,some char text,some char text'
92 - 'VARCHAR_FIELD13=some text that needs to be converted to varchar,some text that needs to be converted to varchar,
93 			some text that needs to be converted to varchar,some text that needs to be converted to varchar,
94 			some text that needs to be converted to varchar,some text that needs to be converted to varchar,
95 			some text that needs to be converted to varchar,some text that needs to be converted to varchar,
96 			some text that needs to be converted to varchar,some text that needs to be converted to varchar'
97 - 'BINARY_FIELD12=736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
98 			736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
99 			736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
100  			736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
101   			736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
102    		736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
103    		736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
104      		736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
105       		736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
106        	736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'
107 - 'BLOB_FIELD14=736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
108 			736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
109 			736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
110  			736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
111   			736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
112    		736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
113    		736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
114      		736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
115       		736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279,
116        	736f6d6520746578742074686174206e6565647320746f20626520636f6e76657274656420746f2062696e617279'
117 - 'CLOB_FIELD15=some text that needs to be converted to clob,some text that needs to be converted to clob,
118 		 some text that needs to be converted to clob,some text that needs to be converted to clob,
119 		 some text that needs to be converted to clob,some text that needs to be converted to clob,
120 		 some text that needs to be converted to clob,some text that needs to be converted to clob,
121 		 some text that needs to be converted to clob,some text that needs to be converted to clob'
122