Sorry! My bad. I work in one of those shops where everything from a feature request, to a task, to a customer support issue, to an actual software defect is referred to as a "bug". I forget it doesn't always translate.
Thanks for looking into it! - Deon -----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Wednesday, August 31, 2016 4:15 PM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] Expression Indexes - can I project the expression value from the index? On 8/31/16, Deon Brewis <de...@outlook.com> wrote: > Thanks! I'll be willing to test this beta once it's available. > > One more thing - I think there is a bug here in the query planner I'm pedantic about this because it is important: What you describe is not a bug. A bug means it gets the wrong answer. Getting the correct answer more slowly than you would like is not a bug - that's an optimization opportunity. So what you describe (if I can verify it, which seems likely, but which I have not yet attempted to do) is an optimization opportunity, not a bug. Thanks for reporting it. I will look into it when I get a chance. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users