# MySQL JDBC 8 Test

## Dependency

- JDK 11+
- Maven
- TiDB
- MySQL JDBC 8.0.29 (At [pom.xml](./pom.xml))

## Run

- Local

    Change `TIDB_SERVER_PATH` parameter in `test_local.sh` script and run:

    ```shell
    sh test_local.sh
    ```

- CI

    `TIDB_SERVER_PATH` parameter required:

    1. Fast test (Without `StatementTest` and `ResultSet`)

        ```shell
        sh test_fast.sh
        ```

    2. Slow test (Only `StatementTest` and `ResultSet`)

        ```shell
        sh test_slow.sh
        ```

## Skipped Test Case

- Using `@Disabled("{reason}")` to skip test cases
- You can search all skiped test case and reason by `@Disabled\(".*"\)`
- There is current [skip reason](./skip-reason.md)

## Raised Issues

|                 Test Case                 |                    Issue                     |
|:-----------------------------------------:|:--------------------------------------------:|
| testDefaultUserWithPasswordAuthentication | https://github.com/pingcap/tidb/issues/9411  |
|               testBug102404               | https://github.com/pingcap/tidb/issues/35309 |
|               testBug80441                | https://github.com/pingcap/tidb/issues/35302 |
|          testLikeWithBackslashes          | https://github.com/pingcap/tidb/issues/35302 |
|          testReversalOfScanFlags          | https://github.com/pingcap/tidb/issues/35303 |
|         testFULLTEXTSearchInnoDB          | https://github.com/pingcap/tidb/issues/35307 |