# test name 
name: "sqllogic"
creator: "thix"
# type is the type of the test, supported type: prepare / test
# we will run the prepare tests before all test tests
type: "test"
tags:
  - logic

environment: 
  # machine resources
  resources:
    limits:
      cpu: 1000m
      memory: 2Gi
    requests:
      cpu: 500m
      memory: 1Gi
  # image is a docker execution image for running test 
  # default image: hub.pingcap.net/schrodinger/agent:latest
  #image: hub.pingcap.net/pingcap/agent:latest

  # execution arguments
  args: ""

# manual for users 
manual:
  # description is to introduce the test purpose and instructions for this case.
  description: |-
    Sqllogictest is a program designed to verify that an SQL database engine computes correct results by 
    comparing the results to identical queries from other SQL database engines
  # describe the purpose of the parameters and optional values
  parameters: |-
    db: the name of the created database
    pw: database password
    testPath: test data path
    concurrency: concurrency
    parallel: parallel count"
    skipError: skip error
    run-mode: case mode, support values online / dev, default value online
    case-url: case URL 
  # notes is to list all matters which need to be noted
  # eg: the special requirements of the test environment
  notes: |-
    If there is an error, the sqllogic will fail to run.
    If you are running in dev mode, you need to set:
      Export TIDBS="127.0.0.1:4000"--your local tidb cluster
      Export TIDB_SERVICE="127.0.0.1:4000"--your local tidb cluster