apiVersion: api/v1
kind: Case
name: br_incremenal_ddl_compatibility
features: [ br ]
summary: br incremental backup & restore compatibility testing with DDL
steps: |
    1. Do br full backup
    2. Run DDLs, refer to: https://github.com/pingcap/tidb/issues/33661
      DDL related to tiflash replic lile "alter table sbtest.sbtest1 set tiflash replica 1"
      DDL related to lock/unlock tables, LOCK TABLES t1 WRITE;
    3. Do br incremental backup
    4. Restore full backup to downstream
    5. Restore incremental backup to downstream
expectedResult:
    1. br restore pass

category: FUNCTIONALITY
priority: P1
supportedVersions: [ ">6.0" ]
tags: [ "br", "acceptance" ]
designer: zhangfubin@pingcap.com
automation: AUTOMATED
active: true
framework:
    generic:
        command: [ "/IncrementalDDL" ]
        workingDir: "/"
        env: null
        image: hub-new.pingcap.net/fubinzhang/br-incremental-ddl
        imagePullPolicy: "Always"
        defaultTimeout: 600
parameters:
    -   type: RESOURCE
        name: src_tidb
        default: src-tidb
    -   type: RESOURCE
        name: dst_tidb
        default: dst-tidb
    -   type: RESOURCE
        name: lightning
        default: lightning
    -   type: RESOURCE
        name: br
        default: br
    -   type: RESOURCE
        name: mc
        default: mc
    -   type: STRING
        name: import_basic_opts
        default: |
            {"data-dir":"s3://nfs/tools_test_data/sb_10tables?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true","backend":"local","sorted-kv-dir":"/tmp/sorted-kv-dir", "timeout":"20m","crc32-checksum":312456081}
    -   type: STRING
        name: import_basic_opts_incremental
        default: |
            {"data-dir":"s3://tpcc/10-warehouses-csv?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true","backend":"tidb","sorted-kv-dir":"/tmp/sorted-kv-dir","config":"[mydumper.csv]\nheader=false","timeout":"20m","crc32-checksum":4164883055}
    -   type: STRING
        name: br_opts
        default: |
            {"storage":"s3://tmp/br-backup-incremental?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true", "timeout":"10m","crc32-checksum":3936395774, "storage-incremental":"s3://tmp/br-backup-incremental?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2fminio.pingcap.net%3a9000&force-path-style=true", "backup-full-options": ["--use-backupmeta-v2"]}
    -   type: STRING
        name: mc_rm_opts
        default: '{"path":"qa-minio/tmp/br-backup-incremental","timeout":"20m"}'
    -   type: STRING
        name: global_variable
        default: '[]'
    -   type: STRING
        name: admin_check
        default: '[]'
    -   type: STRING
        name: drop_databases
        default: 'sbtest,test'
    -   type: STRING
        name: ddl_statements
        default: 'alter table sbtest.sbtest1 set tiflash replica 1;|LOCK TABLES sbtest.sbtest2 WRITE;'