What do other databases return for the types of SQL queries below?
SELECT random(1) AS func FROM test ORDER BY func;
SELECT random() AS func FROM test WHERE func > 10;
MS Access appears to assume all functions called with the same
arguments are constant and returns the same result for every row:
select rnd() from test;
0.5795186162
0.5795186162
0.5795186162
0.5795186162
0.5795186162
SQLite is apparently the other extreme - it assumes that each call a
function can potentially yield a different result each time.
__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
