On Mar 2, 2009, at 1:16 PM, Alberto Simões wrote: > Hello > > I am using random as: > > SELECT word FROM dict ORDER BY RANDOM(term) LIMIT 1; > > And I am getting: > > DBD::SQLite::db prepare failed: wrong number of arguments to function > RANDOM()(1) at dbdimp.c line 271 at OpenDict.pm line 64. > > (yes, using it through DBD::SQLite, but I do not think that is the > problem). >
The RANDOM() function takes zero arguments. This has always been the case. But 3.6.11 has begun to enforce that rule. Prior to 3.6.11, the error was ignored. D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
