Hello! 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; 1|0|1 1|1|1 2|2|2 3|3|3 3|4|3 3|5|3 4|6|4 4|7|4 1|8|1 5|9|5 5|10|5 2|11|2 2|12|2 The "value" argument in counter function call is SQL variable, isn't it? If it's so then the result is wrong. Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
