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 d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
