Re: [sqlite] Strange problem with using random with a table

Does the same thing happen if you select from Psalms, or Thessalonians, instead of Proverbs? Sorry. Little religion humor. Too early in the morning and I haven't had my coffee, yet. On Fri, Nov 11, 2016 at 4:34 AM, Cecil Westerhof wrote: > 2016-11-11 11:22 GMT+01:00

Re: [sqlite] Strange problem with using random with a table

2016-11-11 11:22 GMT+01:00 Clemens Ladisch : > Cecil Westerhof wrote: >> When I execute the following query: >> SELECT *, randomiser * 1000 >> FROM (SELECT abs(random()) / 1 AS randomiser); >> >> I get normal results: >> 61|61000 >> >> But when I change it to:

Re: [sqlite] Strange problem with using random with a table

2016-11-11 11:01 GMT+01:00 Cecil Westerhof : > When I execute the following query: > SELECT * > , randomiser * 1000 > FROM ( > SELECT abs(random()) / 1 AS randomiser > ); > > I get normal results: > 61|61000 > > > But when I change it to: > SELECT *

Re: [sqlite] Strange problem with using random with a table

Cecil Westerhof wrote: > When I execute the following query: > SELECT *, randomiser * 1000 > FROM (SELECT abs(random()) / 1 AS randomiser); > > I get normal results: > 61|61000 > > But when I change it to: > SELECT *, randomiser * 1000 > FROM (SELECT abs(random()) /

[sqlite] Strange problem with using random with a table

When I execute the following query: SELECT * , randomiser * 1000 FROM ( SELECT abs(random()) / 1 AS randomiser ); I get normal results: 61|61000 But when I change it to: SELECT * , randomiser * 1000 FROM ( SELECT abs(random()) / 1 AS randomiser