projects / ceph.git / blame
| Commit | Line | Data |
|---|---|---|
| 1d09f67e TL |
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 | ||
| 12 | name: 'table1' | |
| 13 | ||
| 14 | type: 'selected_null_column' | |
| 15 | ||
| 16 | vectors: | |
| 17 | - 'BIGINT_FIELD5' | |
| 18 | - 'DECIMAL_FIELD6' | |
| 19 | - 'DOUBLE_FIELD7' | |
| 20 | - 'REAL_FIELD8' | |
| 21 | - 'TIME_FIELD9' | |
| 22 | - 'DATE_FIELD10' | |
| 23 | - 'TIMESTAMP_FIELD11' | |
| 24 | - 'BINARY_FIELD12' | |
| 25 | - 'VARCHAR_FIELD13' | |
| 26 | - 'BLOB_FIELD14' | |
| 27 | - 'CLOB_FIELD15' | |
| 28 | - 'CHAR_FIELD16' | |
| 29 | - 'BIT_FIELD17' | |
| 30 | ||
| 31 | rowCount: '5' | |
| 32 | ||
| 33 | create: 'CREATE TABLE table1 (int_field1 INT, bool_field2 BOOLEAN, tinyint_field3 TINYINT, smallint_field4 SMALLINT, bigint_field5 BIGINT, | |
| 34 | decimal_field6 DECIMAL(20,2), double_field7 DOUBLE, real_field8 REAL, time_field9 TIME, date_field10 DATE, timestamp_field11 TIMESTAMP, | |
| 35 | binary_field12 BINARY(100), varchar_field13 VARCHAR(256), blob_field14 BLOB, clob_field15 CLOB, char_field16 CHAR(16), bit_field17 BIT);' | |
| 36 | ||
| 37 | data: | |
| 38 | - 'INSERT INTO table1 (int_field1, bool_field2, tinyint_field3, smallint_field4) VALUES (102, 0, 46, 12001);' | |
| 39 | - 'INSERT INTO table1 (int_field1, bool_field2, tinyint_field3, smallint_field4) VALUES (102, 0, 46, 12001);' | |
| 40 | - 'INSERT INTO table1 (int_field1, bool_field2, tinyint_field3, smallint_field4) VALUES (102, 0, 46, 12001);' | |
| 41 | - 'INSERT INTO table1 (int_field1, bool_field2, tinyint_field3, smallint_field4) VALUES (102, 0, 46, 12001);' | |
| 42 | - 'INSERT INTO table1 (int_field1, bool_field2, tinyint_field3, smallint_field4) VALUES (102, 0, 46, 12001);' | |
| 43 | ||
| 44 | query: 'select bigint_field5, decimal_field6, double_field7, real_field8, time_field9, date_field10, timestamp_field11, binary_field12, varchar_field13, blob_field14, clob_field15, char_field16, bit_field17 from table1' | |
| 45 | ||
| 46 | drop: 'DROP table table1;' |