search

imiphp / imi

imi 是一款支持长连接微服务分布式的 PHP 开发框架，它可以运行在 PHP-FPM、Swoole、Workerman、RoadRunner 等多种容器环境下。它支持 HttpApi、WebSocket、TCP、UDP、MQTT 服务的开发。特别适合互联网微服务、即时通讯聊天im、物联网等场景！QQ群：17916227
https://www.imiphp.com
Other
1.16k stars 170 forks source link

优化数据库查询构建器：当 where 条件的值为 `NULL` 时，不使用参数绑定 #670

Closed Yurunsoft closed 6 months ago

Yurunsoft commented 6 months ago

MySQL 和 PostgreSQL 都不支持 is NULL 的 NULL 使用参数绑定传值。

NULL 是 SQL 标准关键字，直接拼接不会有兼容问题。

fix #669

codecov[bot] commented 6 months ago

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Comparison is base (f28f988) 65.98% compared to head (6961142) 65.98%.

Additional details and impacted files ```diff @@ Coverage Diff @@ ## 2.1 #670 +/- ## ============================================ - Coverage 65.98% 65.98% -0.01% - Complexity 11285 11287 +2 ============================================ Files 897 897 Lines 30728 30732 +4 ============================================ + Hits 20277 20278 +1 - Misses 10451 10454 +3 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.