On 19 Jan 2018, at 5:04am, petern <[email protected]> wrote:
> WITH flips(s) AS (VALUES (random()), (random()), (random())) > SELECT * FROM flips; > > s > 0.760850821621716 > 0.9941047639586031 > 0.48273737309500575 Are you expecting the three values to be the same ? What about INSERT INTO MyTable VAKUES (random(), random(), random()) ? Would you expect those three values to be the same ? If you think of random() as an external function, do you think of it as marked SQLITE_DETERMINISTIC as defined in the following page ? <https://sqlite.org/c3ref/create_function.html> Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
