Adding pgq keywords to colid & non-reserved keywords #336
Workflow file for this run
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: Windows | |
| on: | |
| workflow_dispatch: | |
| repository_dispatch: | |
| push: | |
| branches: | |
| - '**' | |
| - '!master' | |
| - '!feature' | |
| tags: | |
| - '**' | |
| paths-ignore: | |
| - '**.md' | |
| - 'tools/**' | |
| - '!tools/odbc/**' | |
| - '.github/workflows/**' | |
| - '!.github/workflows/Windows.yml' | |
| - '.github/config/uncovered_files.csv' | |
| pull_request: | |
| paths-ignore: | |
| - '**.md' | |
| - 'tools/**' | |
| - '!tools/odbc/**' | |
| - '.github/workflows/**' | |
| - '!.github/workflows/Windows.yml' | |
| - '.github/config/uncovered_files.csv' | |
| concurrency: | |
| group: ${{ github.workflow }}-${{ github.ref }}-${{ github.head_ref || '' }}-${{ github.base_ref || '' }}-${{ github.ref != 'refs/heads/master' || github.sha }} | |
| cancel-in-progress: true | |
| env: | |
| GH_TOKEN: ${{ secrets.GH_TOKEN }} | |
| jobs: | |
| win-release-64: | |
| name: Windows (64 Bit) | |
| runs-on: windows-latest | |
| steps: | |
| - uses: actions/checkout@v3 | |
| with: | |
| fetch-depth: 0 | |
| - uses: actions/setup-python@v4 | |
| with: | |
| python-version: '3.7' | |
| - name: Setup Ccache | |
| uses: hendrikmuhs/ccache-action@main | |
| with: | |
| key: ${{ github.job }} | |
| save: ${{ github.ref == 'refs/heads/master' || github.repository != 'duckdb/duckdb' }} | |
| - name: Build | |
| shell: bash | |
| run: | | |
| python scripts/windows_ci.py | |
| cmake -DCMAKE_BUILD_TYPE=Release -DCMAKE_GENERATOR_PLATFORM=x64 -DBUILD_ICU_EXTENSION=1 -DBUILD_PARQUET_EXTENSION=1 -DBUILD_TPCH_EXTENSION=1 -DBUILD_TPCDS_EXTENSION=1 -DBUILD_FTS_EXTENSION=1 -DBUILD_JSON_EXTENSION=1 -DBUILD_EXCEL_EXTENSION=1 -DBUILD_VISUALIZER_EXTENSION=1 -DBUILD_ODBC_DRIVER=1 -DDISABLE_UNITY=1 -DBUILD_AUTOCOMPLETE_EXTENSION=1 | |
| cmake --build . --config Release | |
| - name: Test | |
| shell: bash | |
| run: | | |
| echo "DUCKDB_INSTALL_LIB=D:\a\duckdb\duckdb\src\Release\duckdb.dll" >> $env:GITHUB_ENV | |
| test/Release/unittest.exe | |
| - name: Tools Test | |
| shell: bash | |
| run: | | |
| python tools/shell/shell-test.py Release/duckdb.exe | |
| tools/sqlite3_api_wrapper/Release/test_sqlite3_api_wrapper.exe | |
| - name: Deploy | |
| shell: bash | |
| run: | | |
| python scripts/amalgamation.py | |
| choco install zip -y --force | |
| zip -j duckdb_cli-windows-amd64.zip Release/duckdb.exe | |
| zip -j libduckdb-windows-amd64.zip src/Release/duckdb.dll src/Release/duckdb.lib src/amalgamation/duckdb.hpp src/include/duckdb.h | |
| zip -j duckdb_odbc-windows-amd64.zip tools/odbc/bin/Release/* | |
| python scripts/asset-upload-gha.py libduckdb-windows-amd64.zip duckdb_cli-windows-amd64.zip duckdb_odbc-windows-amd64.zip | |
| - uses: actions/upload-artifact@v3 | |
| with: | |
| name: duckdb-binaries-windows | |
| path: | | |
| libduckdb-windows-amd64.zip | |
| duckdb_cli-windows-amd64.zip | |
| duckdb_odbc-windows-amd64.zip | |
| - uses: ilammy/msvc-dev-cmd@v1 | |
| - name: Duckdb.dll export symbols with C++ on Windows | |
| shell: bash | |
| run: cl -I src/include examples/embedded-c++-windows/cppintegration.cpp -link src/Release/duckdb.lib | |
| win-release-32: | |
| name: Windows (32 Bit) | |
| runs-on: windows-latest | |
| needs: win-release-64 | |
| steps: | |
| - uses: actions/checkout@v3 | |
| with: | |
| fetch-depth: 0 | |
| - uses: actions/setup-python@v4 | |
| with: | |
| python-version: '3.7' | |
| - name: Setup Ccache | |
| uses: hendrikmuhs/ccache-action@main | |
| with: | |
| key: ${{ github.job }} | |
| save: ${{ github.ref == 'refs/heads/master' || github.repository != 'duckdb/duckdb' }} | |
| - name: Build | |
| shell: bash | |
| run: | | |
| cmake -DCMAKE_BUILD_TYPE=Release -DCMAKE_GENERATOR_PLATFORM=Win32 -DBUILD_ICU_EXTENSION=1 -DBUILD_PARQUET_EXTENSION=1 -DBUILD_TPCH_EXTENSION=1 -DBUILD_TPCDS_EXTENSION=1 -DBUILD_FTS_EXTENSION=1 -DBUILD_JSON_EXTENSION=1 -DBUILD_EXCEL_EXTENSION=1 -DBUILD_VISUALIZER_EXTENSION=1 -DBUILD_AUTOCOMPLETE_EXTENSION=1 | |
| cmake --build . --config Release | |
| - name: Test | |
| shell: bash | |
| run: test/Release/unittest.exe | |
| - name: Tools Test | |
| shell: bash | |
| run: | | |
| python tools/shell/shell-test.py Release/duckdb.exe | |
| tools/sqlite3_api_wrapper/Release/test_sqlite3_api_wrapper.exe | |
| - name: Deploy | |
| shell: bash | |
| run: | | |
| python scripts/amalgamation.py | |
| choco install zip -y --force | |
| zip -j duckdb_cli-windows-i386.zip Release/duckdb.exe | |
| zip -j libduckdb-windows-i386.zip src/Release/duckdb.dll src/Release/duckdb.lib src/amalgamation/duckdb.hpp src/include/duckdb.h | |
| python scripts/asset-upload-gha.py libduckdb-windows-i386.zip duckdb_cli-windows-i386.zip | |
| - uses: actions/upload-artifact@v3 | |
| with: | |
| name: duckdb-binaries-windows-32bit | |
| path: | | |
| libduckdb-windows-i386.zip | |
| duckdb_cli-windows-i386.zip | |
| mingw: | |
| name: MingW (64 Bit) | |
| runs-on: windows-latest | |
| needs: win-release-64 | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - uses: msys2/setup-msys2@v2 | |
| with: | |
| msystem: MINGW64 | |
| update: true | |
| install: git mingw-w64-x86_64-toolchain mingw-w64-x86_64-cmake mingw-w64-x86_64-ninja git | |
| # see here: https://gist.github.com/scivision/1de4fd6abea9ba6b2d87dc1e86b5d2ce | |
| - name: Put MSYS2_MinGW64 on PATH | |
| # there is not yet an environment variable for this path from msys2/setup-msys2 | |
| shell: msys2 {0} | |
| run: export PATH=D:/a/_temp/msys/msys64/mingw64/bin:$PATH | |
| - name: Setup Ccache | |
| uses: hendrikmuhs/ccache-action@main | |
| with: | |
| key: ${{ github.job }} | |
| save: ${{ github.ref == 'refs/heads/master' || github.repository != 'duckdb/duckdb' }} | |
| - name: Build | |
| shell: msys2 {0} | |
| run: | | |
| cmake -G "Ninja" -DCMAKE_BUILD_TYPE=Release -DBUILD_PARQUET_EXTENSION=1 | |
| cmake --build . --config Release | |
| - name: Test | |
| shell: msys2 {0} | |
| run: | | |
| cp src/libduckdb.dll . | |
| test/unittest.exe | |
| - name: Tools Test | |
| shell: msys2 {0} | |
| run: | | |
| tools/sqlite3_api_wrapper/test_sqlite3_api_wrapper.exe | |
| odbc-win-64: | |
| name: ODBC Windows | |
| runs-on: windows-latest | |
| needs: win-release-64 | |
| steps: | |
| - uses: actions/checkout@v3 | |
| with: | |
| fetch-depth: 0 | |
| - uses: actions/setup-python@v4 | |
| with: | |
| python-version: '3.7' | |
| - name: Setup Ccache | |
| uses: hendrikmuhs/ccache-action@main | |
| with: | |
| key: ${{ github.job }} | |
| save: ${{ github.ref == 'refs/heads/master' || github.repository != 'duckdb/duckdb' }} | |
| - name: Build | |
| shell: bash | |
| run: | | |
| cmake -DCMAKE_BUILD_TYPE=Release -DCMAKE_GENERATOR_PLATFORM=x64 -DBUILD_ICU_EXTENSION=1 -DBUILD_PARQUET_EXTENSION=1 -DBUILD_TPCH_EXTENSION=1 -DBUILD_TPCDS_EXTENSION=1 -DBUILD_FTS_EXTENSION=1 -DBUILD_JSON_EXTENSION=1 -DBUILD_EXCEL_EXTENSION=1 -DBUILD_VISUALIZER_EXTENSION=1 -DBUILD_ODBC_DRIVER=1 -DDISABLE_UNITY=1 | |
| cmake --build . --config Release | |
| - name: Install ODBC Driver | |
| shell: bash | |
| run: | | |
| tools/odbc/bin/Release/odbc_install.exe //CI //Install | |
| Reg Query "HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources" | |
| Reg Query "HKLM\SOFTWARE\ODBC\ODBC.INI\DuckDB" | |
| Reg Query "HKLM\SOFTWARE\ODBC\ODBCINST.INI\DuckDB Driver" | |
| - name: Enable ODBC Trace HKCU | |
| shell: bash | |
| run: | | |
| REG ADD "HKCU\SOFTWARE\ODBC\ODBC.INI\ODBC" //f | |
| REG ADD "HKCU\SOFTWARE\ODBC\ODBC.INI\ODBC" //v Trace //t REG_SZ //d 1 | |
| REG ADD "HKCU\SOFTWARE\ODBC\ODBC.INI\ODBC" //v TraceDll //t REG_SZ //d "C:\Windows\system32\odbctrac.dll" | |
| REG ADD "HKCU\SOFTWARE\ODBC\ODBC.INI\ODBC" //v TraceFile //t REG_SZ //d "D:\a\duckdb\duckdb\ODBC_TRACE.log" | |
| echo "----------------------------------------------------------------" | |
| Reg Query "HKCU\SOFTWARE\ODBC\ODBC.INI\ODBC" | |
| - name: Install psqlodbc | |
| shell: bash | |
| run: | | |
| git clone https://github.com/Mytherin/psqlodbc.git | |
| (cd psqlodbc && git checkout edd9890a5046a2006f210849abb97c6a6589a45c && make release) | |
| - name: Test psqlodbc | |
| shell: bash | |
| run: | | |
| cd psqlodbc | |
| export PSQLODBC_TEST_DSN=DuckDB | |
| build/release/Release/psql_odbc_test.exe -f ../tools/odbc/test/psql_supported_tests | |
| - name: Print ODBC trace on failure | |
| if: ${{ failure() }} | |
| shell: bash | |
| run: cat ODBC_TRACE.log | |
| win-extensions-64: | |
| name: Windows Extensions (64-bit) | |
| runs-on: windows-latest | |
| needs: win-release-64 | |
| steps: | |
| - uses: actions/checkout@v3 | |
| with: | |
| fetch-depth: 0 | |
| - uses: actions/setup-python@v4 | |
| with: | |
| python-version: '3.7' | |
| - name: Setup Ccache | |
| uses: hendrikmuhs/ccache-action@main | |
| with: | |
| key: ${{ github.job }} | |
| save: ${{ github.ref == 'refs/heads/master' || github.repository != 'duckdb/duckdb' }} | |
| - name: Install OpenSSL | |
| shell: bash | |
| run: | | |
| choco install openssl -y --force | |
| - uses: ./.github/actions/build_extensions | |
| with: | |
| deploy_as: windows_amd64 | |
| post_install: choco uninstall openssl -y --force | |
| treat_warn_as_error: 0 | |
| s3_id: ${{ secrets.S3_ID }} | |
| s3_key: ${{ secrets.S3_KEY }} | |
| signing_pk: ${{ secrets.DUCKDB_EXTENSION_SIGNING_PK }} | |
| python_name: python |