codeigniter4 / CodeIgniter4 / 28845727067

90%

develop: 89%

Build Type

push

github

Committed by web-flow

Commit Message

feat: add `Query Builder` lock wait modifiers (#10349)

* feat(query-builder): add lock wait modifiers

Add nowait() and skipLocked() for pessimistic SELECT locks.

- Support driver-specific SQL generation for MySQLi, Postgre, OCI8, and SQLSRV.
- Reject unsupported lock/wait combinations explicitly.
- Preserve lock wait state across compiled selects, exists(), and countAllResults().
- Document driver support and SQLSRV READPAST behavior.
- Add focused Query Builder tests for generated SQL, reset behavior, and unsupported combinations.

Signed-off-by: memleakd <121398829+memleakd@users.noreply.github.com>

* refactor: refine SQLSRV skip locked support

- Avoid incompatible SQLSRV table hints for lockForUpdate()->skipLocked()
- Add live SQLSRV coverage for skip locked execution
- Document pessimistic lock and wait modifier driver support
- Clarify that existence/count probes do not apply locking modifiers

Signed-off-by: memleakd <121398829+memleakd@users.noreply.github.com>

* docs: clarify MySQLi lock wait requirements

Signed-off-by: memleakd <121398829+memleakd@users.noreply.github.com>

---------

Signed-off-by: memleakd <121398829+memleakd@users.noreply.github.com>

Coverage Stats

80 of 80 new or added lines in 6 files covered. (100.0%)

1 existing line in 1 file now uncovered.

25162 of 28206 relevant lines covered (89.21%)

227.17 hits per line