|
| 1 | +// Licensed to the Apache Software Foundation (ASF) under one |
| 2 | +// or more contributor license agreements. See the NOTICE file |
| 3 | +// distributed with this work for additional information |
| 4 | +// regarding copyright ownership. The ASF licenses this file |
| 5 | +// to you under the Apache License, Version 2.0 (the |
| 6 | +// "License"); you may not use this file except in compliance |
| 7 | +// with the License. You may obtain a copy of the License at |
| 8 | +// |
| 9 | +// http://www.apache.org/licenses/LICENSE-2.0 |
| 10 | +// |
| 11 | +// Unless required by applicable law or agreed to in writing, |
| 12 | +// software distributed under the License is distributed on an |
| 13 | +// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| 14 | +// KIND, either express or implied. See the License for the |
| 15 | +// specific language governing permissions and limitations |
| 16 | +// under the License. |
| 17 | + |
| 18 | +// The cases is copied from https://github.com/trinodb/trino/tree/master |
| 19 | +// /testing/trino-product-tests/src/main/resources/sql-tests/testcases/tpcds |
| 20 | +// and modified by Doris. |
| 21 | +suite("load") { |
| 22 | + def tables = |
| 23 | + [ |
| 24 | + "test_read_size_error_table1", |
| 25 | + "test_read_size_error_table2" |
| 26 | + ] |
| 27 | + for (String table in tables) { |
| 28 | + sql """DROP TABLE IF EXISTS ${table}""" |
| 29 | + sql new File("""${context.file.parent}/ddl/${table}.sql""").text |
| 30 | + } |
| 31 | + |
| 32 | + sql """ |
| 33 | + insert into test_read_size_error_table1 values |
| 34 | + (20221220, 123456, '2022122015233522dadv', 10001, 1, 10000, null), |
| 35 | + (20221221, 123456, '2022122015233522dadv', 10001, 1, 10000, null), |
| 36 | + (20221222, 123456, '2022122015233522dadv', 10001, 1, 10000, null), |
| 37 | + (20221223, 123456, '2022122015233522dadv', 10001, 1, 10000, null), |
| 38 | + (20221224, 123456, '2022122015233522dadv', 10001, 1, 10000, null), |
| 39 | + (20221225, 123456, '2022122015233522dadv', 10001, 1, 10000, null), |
| 40 | + (20221226, 123456, '2022122015233522dadv', 10001, 1, 10000, null), |
| 41 | + (20221227, 123456, '2022122015233522dadv', 10001, 1, 10000, null), |
| 42 | + (20221228, 123456, '2022122015233522dadv', 10001, 1, 10000, null), |
| 43 | + (20221229, 123456, '2022122015233522dadv', 10001, 1, 10000, null), |
| 44 | + (20221230, 123456, '2022122015233522dadv', 10001, 1, 10000, null), |
| 45 | + (20221231, 123456, '2022122015233522dadv', 10001, 1, 10000, null), |
| 46 | + (20230101, 123456, '2022122015233522dadv', 10001, 1, 10000, null), |
| 47 | + (20230102, 123456, '2022122015233522dadv', 10001, 1, 10000, null), |
| 48 | + (20230103, 123456, '2022122015233522dadv', 10001, 1, 10000, null),(20221220, 123457, '2022122015233522dadv', 10002, 1, null, 10000), |
| 49 | + (20221221, 123457, '2022122015233522dadv', 10002, 1, null, 10000), |
| 50 | + (20221222, 123457, '2022122015233522dadv', 10002, 1, null, 10000), |
| 51 | + (20221223, 123457, '2022122015233522dadv', 10002, 1, null, 10000), |
| 52 | + (20221224, 123457, '2022122015233522dadv', 10002, 1, null, 10000), |
| 53 | + (20221225, 123457, '2022122015233522dadv', 10002, 1, null, 10000), |
| 54 | + (20221226, 123457, '2022122015233522dadv', 10002, 1, null, 10000), |
| 55 | + (20221227, 123457, '2022122015233522dadv', 10002, 1, null, 10000), |
| 56 | + (20221228, 123457, '2022122015233522dadv', 10002, 1, null, 10000), |
| 57 | + (20221229, 123457, '2022122015233522dadv', 10002, 1, null, 10000), |
| 58 | + (20221230, 123457, '2022122015233522dadv', 10002, 1, null, 10000), |
| 59 | + (20221231, 123457, '2022122015233522dadv', 10002, 1, null, 10000), |
| 60 | + (20230101, 123457, '2022122015233522dadv', 10002, 1, null, 10000), |
| 61 | + (20230102, 123457, '2022122015233522dadv', 10002, 1, null, 10000), |
| 62 | + (20230103, 123457, '2022122015233522dadv', 10002, 1, null, 10000),(20221220, 123455, '2022122015233522dadv', 10003, 1, 10000, null), |
| 63 | + (20221221, 123455, '2022122015233522dadv', 10003, 1, 10000, null), |
| 64 | + (20221222, 123455, '2022122015233522dadv', 10003, 1, 10000, null), |
| 65 | + (20221223, 123455, '2022122015233522dadv', 10003, 1, 10000, null), |
| 66 | + (20221224, 123455, '2022122015233522dadv', 10003, 1, 10000, null), |
| 67 | + (20221225, 123455, '2022122015233522dadv', 10003, 1, 10000, null), |
| 68 | + (20221226, 123455, '2022122015233522dadv', 10003, 1, 10000, null), |
| 69 | + (20221227, 123455, '2022122015233522dadv', 10003, 1, 10000, null), |
| 70 | + (20221228, 123455, '2022122015233522dadv', 10003, 1, 10000, null), |
| 71 | + (20221229, 123455, '2022122015233522dadv', 10003, 1, 10000, null), |
| 72 | + (20221230, 123455, '2022122015233522dadv', 10003, 1, 10000, null), |
| 73 | + (20221231, 123455, '2022122015233522dadv', 10003, 1, 10000, null), |
| 74 | + (20230101, 123455, '2022122015233522dadv', 10003, 1, 10000, null), |
| 75 | + (20230102, 123455, '2022122015233522dadv', 10003, 1, 10000, null), |
| 76 | + (20230103, 123455, '2022122015233522dadv', 10003, 1, 10000, null); |
| 77 | + """ |
| 78 | + |
| 79 | + sql """ |
| 80 | + insert into test_read_size_error_table2 values |
| 81 | + (1, 10001, 'label_1'), |
| 82 | + (2, 10002, 'label_1'), |
| 83 | + (3, 10003, 'label_1'), |
| 84 | + (4, 10001, 'label_2'), |
| 85 | + (5, 10002, 'label_2'), |
| 86 | + (6, 10003, 'label_2'), |
| 87 | + (7, 10003, 'label_3'); |
| 88 | + """ |
| 89 | +} |
0 commit comments