regression-test/suites/schema_change_p0/test_uniq_delete_sign_schema_change.groovy

// Licensed to the Apache Software Foundation (ASF) under one
// or more contributor license agreements.  See the NOTICE file
// distributed with this work for additional information
// regarding copyright ownership.  The ASF licenses this file
// to you under the Apache License, Version 2.0 (the
// "License"); you may not use this file except in compliance
// with the License.  You may obtain a copy of the License at
//
//   http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing,
// software distributed under the License is distributed on an
// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
// KIND, either express or implied.  See the License for the
// specific language governing permissions and limitations
// under the License.

suite("test_uniq_delete_sign_schema_change", "schema_change") {
    def tbName1 = "test_uniq_delete_sign_schema_change"

    sql "DROP TABLE IF EXISTS ${tbName1}"
    sql """
            CREATE TABLE IF NOT EXISTS ${tbName1} (
                k1 INT,
                value1 INT,
                value2 INT,
                value3 INT
            )
            UNIQUE KEY (k1)
            DISTRIBUTED BY HASH(k1) BUCKETS 1 properties("replication_num" = "1", "light_schema_change" = "true");
        """
    sql "insert into ${tbName1} values(1,1,1,1);"
    sql "insert into ${tbName1} values(1,1,1,2);"
    sql "insert into ${tbName1} values(2,2,2,2);"
    sql "insert into ${tbName1} values(3,3,3,3);"
    sql "insert into ${tbName1} values(4,4,4,4);"
    qt_sql "select /*+ SET_VAR(enable_vectorized_engine=true) */ * from ${tbName1} order by k1;"
    qt_sql "select /*+ SET_VAR(enable_vectorized_engine=false) */ * from ${tbName1} order by k1;"

    sql "set show_hidden_columns = true"
    sql "insert into ${tbName1} (k1, value1, value2, value3, __DORIS_DELETE_SIGN__) values(1,1,1,1,1);"
    qt_sql "select /*+ SET_VAR(enable_vectorized_engine=true) */ * from ${tbName1} order by k1;"
    qt_sql "select /*+ SET_VAR(enable_vectorized_engine=false) */ * from ${tbName1} order by k1;"

    sql "ALTER TABLE ${tbName1} ADD COLUMN value4 INT;"
    qt_sql "desc ${tbName1};"
    qt_sql "select /*+ SET_VAR(enable_vectorized_engine=true) */ * from ${tbName1} order by k1;"
    qt_sql "select /*+ SET_VAR(enable_vectorized_engine=false) */ * from ${tbName1} order by k1;"

    sql "insert into ${tbName1} values(5,5,5,5,5);"
    sql "insert into ${tbName1} values(6,6,6,6,6);"
    qt_sql "select /*+ SET_VAR(enable_vectorized_engine=true) */ * from ${tbName1} order by k1;"
    qt_sql "select /*+ SET_VAR(enable_vectorized_engine=false) */ * from ${tbName1} order by k1;"

    sql "insert into ${tbName1} (k1, value1, value2, value3, value4, __DORIS_DELETE_SIGN__) values(5,1,1,1,1,1);"
    sql "insert into ${tbName1} (k1, value1, value2, value3, value4, __DORIS_DELETE_SIGN__) values(3,1,1,1,1,1);"
    qt_sql "select /*+ SET_VAR(enable_vectorized_engine=true) */ * from ${tbName1} order by k1;"
    qt_sql "select /*+ SET_VAR(enable_vectorized_engine=false) */ * from ${tbName1} order by k1;"

    sql "ALTER TABLE ${tbName1} DROP COLUMN value1;"
    sql "ALTER TABLE ${tbName1} DROP COLUMN value3;"
    qt_sql "desc ${tbName1};"
    sql "insert into ${tbName1} values(7,7,7);"
    qt_sql "select /*+ SET_VAR(enable_vectorized_engine=true) */ * from ${tbName1} order by k1;"
    qt_sql "select /*+ SET_VAR(enable_vectorized_engine=false) */ * from ${tbName1} order by k1;"

    sql "insert into ${tbName1} (k1, value2, value4, __DORIS_DELETE_SIGN__) values(2,1,1,1);"
    sql "insert into ${tbName1} (k1, value2, value4, __DORIS_DELETE_SIGN__) values(4,1,1,1);"
    sql "insert into ${tbName1} (k1, value2, value4, __DORIS_DELETE_SIGN__) values(6,1,1,1);"
    sql "insert into ${tbName1} (k1, value2, value4, __DORIS_DELETE_SIGN__) values(7,1,1,1);"
    qt_sql "select /*+ SET_VAR(enable_vectorized_engine=true) */ * from ${tbName1} order by k1;"
    qt_sql "select /*+ SET_VAR(enable_vectorized_engine=false) */ * from ${tbName1} order by k1;"

    sql "set show_hidden_columns = false"
    qt_sql "select /*+ SET_VAR(enable_vectorized_engine=true) */ * from ${tbName1} order by k1;"
    qt_sql "select /*+ SET_VAR(enable_vectorized_engine=false) */ * from ${tbName1} order by k1;"
}