OSGeo / gdal / 16479636691

push

github

SQLite: make REGEXP behave like official extension, to hopefully fix https://github.com/OSGeo/gdal/actions/runs/16469510912/job/46560699972?pr=12775

It is likely that on that CI the REGEXP extension is already installed
and thus our implementation didn't register is REGEXP implementation

```
49:     def test_ogr_sqlite_34(sqlite_test_db):
49:
49:         with gdal.quiet_errors():
49:             sql_lyr = sqlite_test_db.ExecuteSQL("SELECT 'a' REGEXP 'a'")
49:         if sql_lyr is None:
49:             pytest.skip()
49:         feat = sql_lyr.GetNextFeature()
49:         val = feat.GetField(0)
49:         sqlite_test_db.ReleaseResultSet(sql_lyr)
49:         assert val == 1
49:         del sql_lyr
49:
49:         # Evaluates to FALSE
49:         with sqlite_test_db.ExecuteSQL("SELECT 'b' REGEXP 'a'") as ok:
49:             feat = ok.GetNextFeature()
49:             val = feat.GetField(0)
49:             assert val == 0
49:
49:         # NULL left-member
49:         with sqlite_test_db.ExecuteSQL("SELECT NULL REGEXP 'a'") as sql_lyr:
49:             feat = sql_lyr.GetNextFeature()
49:             val = feat.GetField(0)
49: >           assert val == 0
49: E           assert None == 0
```

4 of 6 new or added lines in 1 file covered. (66.67%)

567071 of 800268 relevant lines covered (70.86%)

235651.38 hits per line