Mapcache seed does not delete or overwrite tiles in sqlite cache

[mwalker]

The sqlite cache does not change when using mapcache_seed with the options -o now to force an update or -m delete to remove tiles.

The same options work correctly when seeding a disk cache.

[tbonfort]

please attach a mapcache.xml file that reproduces the issue

[mwalker]

Seed

Disk

mapcache_seed -c mapcache.xml -t debug_disk -g WGS84 -z 1,1

creates all tiles on disk:

x y z file
0 0 1 /tmp/debug_disk/WGS84/01/000/000/000/000/000/000.png
1 0 1 /tmp/debug_disk/WGS84/01/000/000/001/000/000/000.png
2 0 1 /tmp/debug_disk/WGS84/01/000/000/002/000/000/000.png
3 0 1 /tmp/debug_disk/WGS84/01/000/000/003/000/000/000.png
0 1 0 /tmp/debug_disk/WGS84/01/000/000/000/000/000/001.png
1 1 1 /tmp/debug_disk/WGS84/01/000/000/001/000/000/001.png
2 1 1 /tmp/debug_disk/WGS84/01/000/000/002/000/000/001.png
3 1 0 /tmp/debug_disk/WGS84/01/000/000/003/000/000/001.png

SQLite

mapcache_seed -c mapcache.xml -t debug -g WGS84 -z 1,1

creates all but the first tile(0 0 1) in SQLite

x y z
1 0 1
2 0 1
3 0 1
0 1 1
1 1 1
2 1 1
3 1 1

Delete

Disk

mapcache_seed -c mapcache.xml -t debug_disk -g WGS84 -z 1,1 -m delete

removes all tiles

SQLite

mapcache_seed -c mapcache.xml -t debug -g WGS84 -z 1,1 -m delete

calls _mapcache_cache_sqlite_delete() only for tile(0 0 1) which was not created. No other tiles are removed.

Update

Disk

mapcache_seed -c mapcache.xml -t debug_disk -g WGS84 -z 1,1 -o now

overwrites all tiles

SQLite

mapcache_seed -c mapcache.xml -t debug -g WGS84 -z 1,1 -o now

no tiles are overwritten

[tbonfort]

there was a typo in the sqlite queries, fixed in r12821, can you update and see if it corrects the issue?

[mwalker]

Now it works correctly. Thank you for the fix.