• Home
  • Features
  • Pricing
  • Docs
  • Announcements
  • Sign In

geoalchemy / geoalchemy2 / 41672154898 / 5
94%
main: 94%

Build:
DEFAULT BRANCH: main
Ran 03 Nov 2026 04:24PM UTC
Files 62
Run time 1s
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst

03 Nov 2026 04:14PM UTC coverage: 91.86% (+0.03%) from 91.827%
41672154898.5

push

github

web-flow
Fix: Render boolean functions bare in MySQL and MariaDB filters (#625)

Since 0.18 (#540), spatial predicates like ST_Contains have a Boolean
return type. MySQL and MariaDB do not support native booleans, so
SQLAlchemy rendered them as `ST_Contains(...) = 1` when used as filters,
which prevents these servers from using spatial indexes (MySQL bug
#76384) and leads to full table scans.

Compile GeoAlchemy2 boolean functions used as filters bare on MySQL and
MariaDB (`ST_Contains(...)` and `NOT ST_Contains(...)`). Other dialects
keep the comparison, which is required by MSSQL and by SpatiaLite, whose
predicates return -1 for NULL arguments. Other boolean expressions are
not affected.

2393 of 2916 branches covered (82.06%)

7685 of 8366 relevant lines covered (91.86%)

0.92 hits per line

Source Files on job run-3.11 - 41672154898.5
  • Tree
  • List 62
  • Changed 7
  • Source Changed 0
  • Coverage Changed 7
Coverage ∆ File Lines Relevant Covered Missed Hits/Line Branch Hits Branch Misses
  • Back to Build 41672154898
  • 8a645d5d on github
  • Prev Job for on main (#41623566302.4)
  • Next Job for on main (#41813782373.4)
STATUS · Troubleshooting · Open an Issue · Sales · Support · CAREERS · ENTERPRISE · START FREE TRIAL · SCHEDULE DEMO
ANNOUNCEMENTS · TWITTER · TOS & SLA · Supported CI Services · What's a CI service? · Automated Testing

© 2026 Coveralls, Inc