On 10/3/12 4:20 AM, "Richard Hipp" <d...@sqlite.org> wrote:
>On Tue, Oct 2, 2012 at 5:12 PM, Duquette, William H (318K) < >william.h.duque...@jpl.nasa.gov> wrote: > >> Howdy! >> >> The SQLite3 Tcl interface has a "nullvalue" command, which determines >>how >> NULLs are represented as Tcl values. If you do a query on a NULL value, >> you get the "nullvalue" value. ("nullvalue" defaults to the empty >>string.) >> >> However, if a NULL value is passed to a custom SQL function, defined >>using >> the Tcl [$db function] command, the function body (a Tcl proc) appears >>to >> get the empty string instead of the desired "nullvalue" for the given >> value. This seems like a bug to me. Am I wrong? >> > >Please use this fix: http://www.sqlite.org/src/info/9bf64b661 Thanks, Richard! As it happens, I've worked around the problem for now, and as we're leading up to a delivery I don't want to change out the infrastructure. I'll pick it up next time. Will > >The same patch is also on trunk >(http://www.sqlite.org/src/info/c1f10a2643). >However, I'm in the middle of a significant query planner enhancements on >trunk - specifically I'm working to make the query planner much more >aggressive about optimizing out ORDER BY clauses and arranging for the >query results to naturally come out in the desired order instead of having >to sort. You are, of course, welcomed to try trunk instead. Trunk >currently passes all regression tests. And it would actually be useful >for >us if you tried out trunk and let us know about any ORDER BY anomalies >that >you encounter. Just be aware that the query planner on trunk is under >active development and might not be quite as stable as the 3.7.14 release. > > > >> I'm using SQLite3 3.7.7.1; the function is called from a trigger (if >>that >> matters). >> >> Will >> >> -- >> Will Duquette -- william.h.duque...@jpl.nasa.gov >> Athena Development Lead -- Jet Propulsion Laboratory >> "It's amazing what you can do with the right tools." >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > >-- >D. Richard Hipp >d...@sqlite.org >_______________________________________________ >sqlite-users mailing list >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users