SQLite Compatibility #92
Description
When I manually run the tests locally with SQLite, the following scenarios are failing:
001 Scenario: Deleting all transients on single site # features/transient.feature:58
Then STDOUT should be: # features/transient.feature:76
$ wp transient delete --all
Success: No transients found.
002 Scenario: Deleting expired transients on single site # features/transient.feature:123
Then STDOUT should be: # features/transient.feature:134
$ wp transient delete --expired
Success: No expired transients found.
003 Scenario: Deleting all transients on multisite # features/transient.feature:194
Then STDOUT should be: # features/transient.feature:215
$ wp transient delete --all
Success: No transients found.
004 Scenario: Deleting expired transients on multisite # features/transient.feature:286
Then STDOUT should be: # features/transient.feature:301
$ wp transient delete --expired
Success: No expired transients found.
005 Scenario: List transients on single site # features/transient.feature:386
Then STDOUT should contain: # features/transient.feature:400
$ wp transient list --format=csv
name,value,expiration
006 Scenario: List transients on multisite # features/transient.feature:431
Then STDOUT should contain: # features/transient.feature:445
$ wp transient list --format=csv
name,value,expiration
007 Scenario: List transients with search and exclude pattern # features/transient.feature:476
Then STDOUT should be: # features/transient.feature:485
$ wp transient list --format=csv --fields=name --search="foo"
name
The transient command uses lots of custom MySQL queries. The SQLite integration plugin is supposed to make those SQLite-compatible, but perhaps something is not working there.
Or, since deletion and listing are failing, maybe the issue is that the insertion using set_transient() is failing in the first place.
Let's figure it out together. This could involve changes to the command, the tests, core, or the SQLite plugin.