2014 08:32:02 +0400
Subject: Re: [sqlite] Once again about random values appearance
On Fri, Feb 14, 2014 at 6:35 AM, James K. Lowden
jklow...@schemamania.orgwrote:
select id, (select id from TestTable where id = abs(random() %
100)) as rndid from TestTable where id=rndid
On Thu, 13 Feb 2014
On 17 Feb 2014, at 7:59am, Max Vlasov max.vla...@gmail.com wrote:
So the nanosec example modified
Select v-v from
(
Select nanosec() as v from TestTable
)
...shows non-zero values for the current (3.8.3) and for older (3.6.10)
version.
Erm ... that worries me a
On Mon, Feb 17, 2014 at 2:27 PM, Simon Slavin slav...@bigfraud.org wrote:
On 17 Feb 2014, at 7:59am, Max Vlasov max.vla...@gmail.com wrote:
So the nanosec example modified
Select v-v from
(
Select nanosec() as v from TestTable
)
...shows non-zero values for
On 2014/02/17 09:59, Max Vlasov wrote:
Ok, I hope I found the topic, the title was
racing with date('now') (was: Select with dates):
one of the links to the archive
https://www.mail-archive.com/sqlite-users@sqlite.org/msg79456.html
CMIIW, but as I see it, the final modification was
On Mon, Feb 17, 2014 at 7:00 PM, RSmith rsm...@rsweb.co.za wrote:
On 2014/02/17 09:59, Max Vlasov wrote:
.
So
Select nanosec() - nanosec() from ...
returns non-zero values for most of the times, so there's no guarantee the
user functions or any other functions will be called once
Subject: Re: [sqlite] Once again about random values appearance
On Fri, Feb 14, 2014 at 6:35 AM, James K. Lowden
jklow...@schemamania.orgwrote:
select id, (select id from TestTable where id = abs(random() %
100)) as rndid from TestTable where id=rndid
On Thu, 13 Feb 2014 07:26:55 -0500
of SQLite Database
sqlite-users@sqlite.org Date: Fri, 14 Feb 2014 08:32:02 +0400
Subject: Re: [sqlite] Once again about random values appearance
On Fri, Feb 14, 2014 at 6:35 AM, James K. Lowden
jklow...@schemamania.orgwrote:
select id, (select id from TestTable where id = abs(random
Hi,
probably was discussed and modified before, but I still can not understand
some peculiarities with random column values.
The table
Create table [TestTable] ([id] integer primary key)
populated with 100 default values (thanks to CTE now made with a single
query):
with recursive
On Thu, Feb 13, 2014 at 4:45 AM, Max Vlasov max.vla...@gmail.com wrote:
Hi,
probably was discussed and modified before, but I still can not understand
some peculiarities with random column values.
The table
Create table [TestTable] ([id] integer primary key)
populated with 100 default
On Thu, Feb 13, 2014 at 4:26 PM, Richard Hipp d...@sqlite.org wrote:
On Thu, Feb 13, 2014 at 4:45 AM, Max Vlasov max.vla...@gmail.com wrote:
Hi,
probably was discussed and modified before, but I still can not
understand
some peculiarities with random column values.
It is undefined
select id, (select id from TestTable where id = abs(random() % 100))
as rndid from TestTable where id=rndid
On Thu, 13 Feb 2014 07:26:55 -0500
Richard Hipp d...@sqlite.org wrote:
It is undefined behavior, subject to change depending the specific
version of SQLite, compile-time options,
On Fri, Feb 14, 2014 at 6:35 AM, James K. Lowden
jklow...@schemamania.orgwrote:
select id, (select id from TestTable where id = abs(random() % 100))
as rndid from TestTable where id=rndid
On Thu, 13 Feb 2014 07:26:55 -0500
Richard Hipp d...@sqlite.org wrote:
It is undefined behavior,
12 matches
Mail list logo