I'm surprised that and extension for this type of functionality has not been been developed by someone with the c/c++. It's seems like a natural fit. I wish I had the kind of ability & smarts to do it.
On Thu, Oct 15, 2015 at 9:04 AM, Igor Tandetnik <igor at tandetnik.org> wrote: > On 10/15/2015 9:36 AM, Don V Nielsen wrote: > >> limit ifnull( ( >> select net_non_pieces from crrt_net_non net >> where net.zip=zip and net.crrt=crrt >> > > I suspect this WHERE clause is equivalent to "where net.zip=net.zip and > net.crrt=net.crrt" - that is, always true. The actual limit value comes > from whichever row accidentally happens to be first. > > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
