Alexey Pechnikov wrote: > But the result is strange: > > sqlite> select value=0,counter(0),counter(value=0) from state; > 0|0|0 > 0|1|0 > 0|2|0 > 0|3|0 > > Of course I need to get the result of counter(value==0) equal to counter(0). > The result of "value=0" is always 0 and so counter(value=0) may be identical > to counter(0).
>From http://www.sqlite.org/c3ref/get_auxdata.html : "SQLite is free to call the destructor and drop metadata on any parameter of any function at any time. The only guarantee is that the destructor will be called before the metadata is dropped. In practice, metadata is preserved between function calls for expressions that are constant at compile time. This includes literal values and SQL variables." Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
