Alexey Pechnikov wrote: > On Friday 18 December 2009 16:22:47 Igor Tandetnik wrote: >> 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." > > sqlite> select value,counter(0),counter(value) from state; > > The "value" argument in counter function call is SQL variable, isn't it?
No, it's a table column. "Variable" here means a bound parameter. Basically, something that doesn't change row to row, and so would benefit from caching. Remember, the motivating use case for this API is to avoid recompiling a regexp for each row. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
