fix: replace mariadb's utf8mb4_uca1400_ai_ci with utf8mb4_0900_ai_ci #31
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Password Auth Test | |
| on: | |
| push: | |
| branches: [ "main" ] | |
| pull_request: | |
| branches: [ "main" ] | |
| jobs: | |
| build: | |
| runs-on: ubuntu-latest | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Set up Go | |
| uses: actions/setup-go@v5 | |
| with: | |
| go-version: '1.23' | |
| - name: Set up Python | |
| uses: actions/setup-python@v5 | |
| with: | |
| python-version: '3.10' | |
| - name: Install system packages | |
| uses: awalsh128/cache-apt-pkgs-action@latest | |
| with: | |
| packages: postgresql-client mysql-client | |
| version: 1.0 | |
| - name: Install dependencies | |
| run: | | |
| go get . | |
| pip3 install "sqlglot[rs]" | |
| curl -LJO https://github.com/duckdb/duckdb/releases/latest/download/duckdb_cli-linux-amd64.zip | |
| unzip duckdb_cli-linux-amd64.zip | |
| chmod +x duckdb | |
| sudo mv duckdb /usr/local/bin | |
| - name: Build | |
| run: go build -v | |
| - name: Start MyDuck Server with password | |
| run: | | |
| ./myduckserver --superuser-password=testpass123 & | |
| sleep 5 | |
| - name: Test PostgreSQL auth | |
| run: | | |
| export PGPASSWORD=testpass123 | |
| # Basic connection test | |
| psql -h 127.0.0.1 -U postgres -d postgres -c "SELECT 1 as test;" | |
| # Create and query a table | |
| psql -h 127.0.0.1 -U postgres -d postgres -c "CREATE TABLE test (id int); INSERT INTO test VALUES (42); SELECT * FROM test;" | |
| # Test wrong password | |
| ! PGPASSWORD=wrongpass psql -h 127.0.0.1 -U postgres -d postgres -c "SELECT 1" | |
| - name: Test MySQL auth | |
| run: | | |
| # Basic connection test | |
| mysql -h127.0.0.1 -uroot -ptestpass123 -e "SELECT 1 as test;" | |
| # Create and query a table | |
| mysql -h127.0.0.1 -uroot -ptestpass123 -e "CREATE DATABASE IF NOT EXISTS test; USE test; CREATE TABLE t1 (id int); INSERT INTO t1 VALUES (42); SELECT * FROM t1;" | |
| # Test wrong password | |
| ! mysql -h127.0.0.1 -uroot -pwrongpass -e "SELECT 1" |