github.com/dolthub/go-mysql-server@v0.18.0/enginetest/sqllogictest/README.md (about)

     1  # SQLLogicTest Converter and Checker
     2  
     3  This package contains a tool to convert SQLLogicTest files from CockroachDB's format to the standard 
     4  SQLLogicTest format, which is readable and runnable by our SQLLogicTest suite.
     5  
     6  ## Converter Usage
     7  From within the `gms/enginetest/sqllogictest` directory, run the following command:
     8  ```shell
     9  go run ./convert/convert.go <infile> <outfile>
    10  ```
    11  
    12  CochroachDB's tests use PostgreSQL syntax, while we expect MySQL syntax; the converter does not
    13  take this into account. This is where the Checker is useful.
    14  
    15  ## Checker Usage 
    16  ```shell
    17  go run ./check/check.go <infile>
    18  ```
    19  
    20  This will run the SQLLogicTests against a running MySQL/Dolt server.
    21  You can use the error output to sanity check some of the results, and fix any queries.
    22  Common differences are the use of `SELECT ... from ... AS a(x)` instead of `SELECT ... AS x ... from ... AS a`,
    23  and missing `ORDER BY`.
    24  
    25  It is likely you will have to modify the connection string.
    26  Additionally, it is possible to use this on a running dolt sql server.
    27