On Mon, Feb 17, 2014 at 7:00 PM, RSmith 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
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 2:27 PM, Simon Slavin wrote:
>
> On 17 Feb 2014, at 7:59am, Max Vlasov wrote:
>
> > So the nanosec example modified
> >
> > Select v-v from
> > (
> > Select nanosec() as v from TestTable
> > )
> >
> > ...shows
On 17 Feb 2014, at 7:59am, Max Vlasov 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
f 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.org>wrote:
>>
&
ase <sqlite-users@sqlite.org>
> > Reply-To: General Discussion 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
> 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.org>wrote:
>
> > > > select id, (select id from TestTable where id
On Fri, Feb 14, 2014 at 6:35 AM, James K. Lowden
wrote:
> > > 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 wrote:
>
> > It is
> > 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 wrote:
> It is undefined behavior, subject to change depending the specific
> version of SQLite, compile-time
On Thu, Feb 13, 2014 at 4:26 PM, Richard Hipp wrote:
> On Thu, Feb 13, 2014 at 4:45 AM, Max Vlasov wrote:
>
> > Hi,
> >
> > probably was discussed and modified before, but I still can not
> understand
> > some peculiarities with random column values.
> >
>
On Thu, Feb 13, 2014 at 4:45 AM, Max Vlasov 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
11 matches
Mail list logo