found 7zip in C:\Program Files\7-Zip\7z.exe set PATH=E:\buildsystem\release-1930-x64\bin;C:\Program Files\Microsoft Visual Studio\2022\Community\VC\Tools\MSVC\14.39.33519\bin\HostX64\x64;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\VC\VCPackages;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\CommonExtensions\Microsoft\TestWindow;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\CommonExtensions\Microsoft\TeamFoundation\Team Explorer;C:\Program Files\Microsoft Visual Studio\2022\Community\MSBuild\Current\bin\Roslyn;C:\Program Files (x86)\Microsoft Visual Studio\Shared\Common\VSPerfCollectionTools\vs2019\\x64;C:\Program Files (x86)\Microsoft Visual Studio\Shared\Common\VSPerfCollectionTools\vs2019\;C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.8 Tools\x64\;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\CommonExtensions\Microsoft\FSharp\Tools;C:\Program Files\Microsoft Visual Studio\2022\Community\Team Tools\DiagnosticsHub\Collector;C:\Program Files (x86)\Windows Kits\10\bin\10.0.19041.0\\x64;C:\Program Files (x86)\Windows Kits\10\bin\\x64;C:\Program Files\Microsoft Visual Studio\2022\Community\\MSBuild\Current\Bin\amd64;C:\Windows\Microsoft.NET\Framework64\v4.0.30319;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\Tools\;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\ActiveTcl\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files\Git\cmd;C:\Program Files\dotnet\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\7-Zip;C:\php;C:\Strawberry\c\bin;C:\Strawberry\perl\site\bin;C:\Strawberry\perl\bin;C:\Users\szekeres\AppData\Local\Microsoft\WindowsApps;C:\Users\szekeres\.dotnet\tools;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\CommonExtensions\Microsoft\CMake\CMake\bin;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\CommonExtensions\Microsoft\CMake\Ninja;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\VC\Linux\bin\ConnectionManagerExe git config --global core.autocrlf false if not exist src\mapserver-vc17x64 git clone -b main https://github.com/mapserver/mapserver.git src\mapserver-vc17x64 cd src\mapserver-vc17x64 git reset --hard HEAD HEAD is now at a8f6acad8 Fix opacity calculation problem with the agg renderer (#5697) (#7085) git fetch git checkout main Your branch is up to date with 'origin/main'. git pull origin main Already up to date. git reset --hard HEAD HEAD is now at a8f6acad8 Fix opacity calculation problem with the agg renderer (#5697) (#7085) git log --pretty=format:%H -n 1 > E:\buildsystem\release-1930-x64\doc\ms_revision.txt type E:\buildsystem\release-1930-x64\doc\ms_revision.txt a8f6acad8b0f064dd50362d74dbd6d84ccec9977 cd E:\buildsystem git config --global core.autocrlf false if not exist src\gdal-vc17x64 git clone -b master https://github.com/OSGeo/gdal.git src\gdal-vc17x64 cd src\gdal-vc17x64 git reset --hard HEAD HEAD is now at 082d0e78c5 autotest/cpp/test_viewshed.cpp: pass argument by const reference (CID 1547189) git fetch git checkout master Your branch is behind 'origin/master' by 32 commits, and can be fast-forwarded. (use "git pull" to update your local branch) git pull origin master Updating 082d0e78c5..2a3af362b1 Fast-forward .pre-commit-config.yaml | 4 +- apps/gdal_translate_lib.cpp | 14 +- autotest/cpp/test_gdal.cpp | 100 +- autotest/gdrivers/gpkg.py | 2 +- autotest/gdrivers/mrf.py | 4 + autotest/gdrivers/vrtfilt.py | 24 + autotest/ogr/ogr_join_test.py | 66 + autotest/ogr/ogr_layer_algebra.py | 25 + autotest/ogr/ogr_pmtiles.py | 8 +- autotest/ogr/ogr_sql_test.py | 103 + autotest/ogr/ogr_sqlite.py | 10 +- doc/source/programs/ogr_layer_algebra.rst | 20 +- doc/source/user/ogr_sql_dialect.rst | 19 + frmts/gtiff/gtiffdataset_write.cpp | 45 +- frmts/mrf/LERC_band.cpp | 18 +- frmts/mrf/QB3_band.cpp | 9 +- frmts/mrf/Tif_band.cpp | 2 + frmts/mrf/mrf_band.cpp | 9 +- frmts/mrf/mrf_overview.cpp | 12 + frmts/mrf/mrfdrivercore.cpp | 5 +- frmts/netcdf/netcdfdataset.cpp | 15 +- frmts/vrt/vrtfilters.cpp | 20 +- frmts/zarr/zarr_array.cpp | 15 +- gcore/gdal_priv_templates.hpp | 52 + gcore/gdalrasterband.cpp | 12 +- ogr/CMakeLists.txt | 2 +- ogr/ogr_srs_usgs.cpp | 3 +- ogr/ogr_swq.h | 9 +- ogr/ogrfeature.cpp | 62 +- ogr/ogrsf_frmts/generic/ogr_gensql.cpp | 263 +- ogr/ogrsf_frmts/generic/ogr_gensql.h | 2 +- ogr/ogrsf_frmts/generic/ogrlayer.cpp | 245 +- ogr/ogrsf_frmts/generic/ogrlayerarrow.cpp | 22 +- ogr/ogrsf_frmts/gpkg/ogrgeopackagetablelayer.cpp | 4 +- ogr/ogrsf_frmts/openfilegdb/filegdbtable_write.cpp | 16 +- .../openfilegdb/ogropenfilegdblayer_write.cpp | 4 +- ogr/ogrsf_frmts/sqlite/ogrsqliteutility.cpp | 105 +- ogr/swq.cpp | 5 + ogr/swq_expr_node.cpp | 5 +- ogr/swq_parser.cpp | 3240 ++++++++++---------- ogr/swq_parser.hpp | 108 +- ogr/swq_parser.y | 86 +- ogr/swq_select.cpp | 23 +- scripts/cppcheck.sh | 6 + .../gdal-utils/osgeo_utils/ogr_layer_algebra.py | 2 +- 45 files changed, 2870 insertions(+), 1955 deletions(-) git reset --hard HEAD HEAD is now at 2a3af362b1 Merge pull request #10260 from rouault/fix_10259 git log --pretty=format:%H -n 1 > E:\buildsystem\release-1930-x64\doc\gdal_revision.txt type E:\buildsystem\release-1930-x64\doc\gdal_revision.txt 2a3af362b1a2d9528c86b0b4123d791a845266e6 cd E:\buildsystem set PATH=E:\buildsystem\release-1930-x64\bin;C:\Program Files\Microsoft Visual Studio\2022\Community\VC\Tools\MSVC\14.39.33519\bin\HostX64\x64;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\VC\VCPackages;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\CommonExtensions\Microsoft\TestWindow;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\CommonExtensions\Microsoft\TeamFoundation\Team Explorer;C:\Program Files\Microsoft Visual Studio\2022\Community\MSBuild\Current\bin\Roslyn;C:\Program Files (x86)\Microsoft Visual Studio\Shared\Common\VSPerfCollectionTools\vs2019\\x64;C:\Program Files (x86)\Microsoft Visual Studio\Shared\Common\VSPerfCollectionTools\vs2019\;C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.8 Tools\x64\;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\CommonExtensions\Microsoft\FSharp\Tools;C:\Program Files\Microsoft Visual Studio\2022\Community\Team Tools\DiagnosticsHub\Collector;C:\Program Files (x86)\Windows Kits\10\bin\10.0.19041.0\\x64;C:\Program Files (x86)\Windows Kits\10\bin\\x64;C:\Program Files\Microsoft Visual Studio\2022\Community\\MSBuild\Current\Bin\amd64;C:\Windows\Microsoft.NET\Framework64\v4.0.30319;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\Tools\;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\ActiveTcl\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files\Git\cmd;C:\Program Files\dotnet\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\7-Zip;C:\php;C:\Strawberry\c\bin;C:\Strawberry\perl\site\bin;C:\Strawberry\perl\bin;C:\Users\szekeres\AppData\Local\Microsoft\WindowsApps;C:\Users\szekeres\.dotnet\tools;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\CommonExtensions\Microsoft\CMake\CMake\bin;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\CommonExtensions\Microsoft\CMake\Ninja;C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE\VC\Linux\bin\ConnectionManagerExe git config --global core.autocrlf false if not exist src\mapcache-vc17x64 git clone -b main https://github.com/MapServer/mapcache.git src\mapcache-vc17x64 cd src\mapcache-vc17x64 git reset --hard HEAD HEAD is now at 339008f handle CMake deprecation warning (#342) git fetch git checkout main Your branch is up to date with 'origin/main'. git pull origin main Already up to date. git log --pretty=format:%H -n 1 > E:\buildsystem\release-1930-x64\doc\mapcache_revision.txt type E:\buildsystem\release-1930-x64\doc\mapcache_revision.txt 339008f3d010364a4c0489bb4b8f0dc68039ca79 cd E:\buildsystem