Gotcha !!!!

[a.furieri]

Hi Folks,

I'm glad to announce you that the most
annoying (and long-standing) SpatiaLite's
*BUG* has just been identified and pitylessly
squashed :D

As many of you surely remember, any SpatiaLite
version released since now was completely
unable to perform any JOIN involving some
VIRTUAL TABLE (Virtual Shape, Virtual DBF ...).

Today, simply by hazard (I was actually performing
a quite thorough debugging session to care
a small memory leak), I've found the actual cause
disabling JOINs for Virtual Tables.

There was a paramount misunderstanding (sorry,
my fault ...) about tasks to be performed by
the "Filter" method which any Virtual Table is
expected to implement; and this caused the SQLite
main-core going crazy.

And once I've applied any required patch, I've
immediately been able to successfully JOIN three
different VirtualShapes (getting back the expected
resultset, obviously) :-D

So, the next-to-be-released version will (finally)
support any kind of JOIN, this including full
Virtual Tables support.

bye Sandro

[romain]

very good news !!!!
Nice work,