On 10 Nov 2017, at 8:49am, advancenOO wrote:
>hAve you optimised your column orders ?
What is optimal?
- Howard
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 19 Nov 2017, at 2:01am, Kees Nuyt wrote:
> The same happens for
> pragma journal_mode=wal;
Perhaps the PRAGMAs should be reviewed for consistency: that all PRAGMAs which
change values should output their new value.
This might provide a useful piece of diagnostic information for som
On Sat, 18 Nov 2017 22:53:26 +0100, Yannick Duchêne
wrote:
>I believe I found a tiny bug, nothing bad, but may pollute some output.
>
>Using SQLite version 3.20.1, if I do this:
>
>PRAGMA locking_mode=exclusive;
>
>It writes an unexpected reply:
>
>exclusive
The same happens for
On 11/18/17, E.Pasma wrote:
> I found that in the
> SQLite3 timeline
Thanks for watching the timeline!
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman
Thanks very much for finding this worth a change. I found that in the
SQLite3 timeline and I tested the change. As written in an other topic:
.. Just sit tight and again wait and see if Dr Hipp agrees the
behavior should change or not.
It is comforting that this is even true for an unanswer
Hello there,
I believe I found a tiny bug, nothing bad, but may pollute some output.
Using SQLite version 3.20.1, if I do this:
PRAGMA locking_mode=exclusive;
It writes an unexpected reply:
exclusive
It do as if I was requesting the actual value, as in this:
PRAGMA locking_mode;
On 11/18/17, Balaji Ramanathan wrote:
> Hi,
>
> I have installed Tcl/Tk from a couple of places on the web (activetcl
> and magicsplat), and I find that neither of them has the latest version of
> sqlite3 as the standard sqlite3 package. ActiveTcl seems to be linked to
> sqlite 3.13 while mag
Hi,
I have installed Tcl/Tk from a couple of places on the web (activetcl
and magicsplat), and I find that neither of them has the latest version of
sqlite3 as the standard sqlite3 package. ActiveTcl seems to be linked to
sqlite 3.13 while magicsplat's version comes with sqlite 3.20.
Wha
Neither. It has nothing to do with the DISTINCT keyword, which causes only
DISTINCT rows to be returned (duplicates are removed).
You misunderstanding is on the nature of a SCALAR. A Scalar means ONE value.
A correlated SCALAR subquery (a correlated subquery embedded as a column in a
select
I have the query below with one column in the final output coming from the
main query and two columns in the final output coming from correlated
subqueries:
SELECT DISTINCT *modenumber*,
(SELECT tripid
FROM trip
WHERE modenumber = T.modenumber
ORDER BY distance DESC
LIMIT 3
) AS *tripid*,
2017-11-18 15:14 GMT+01:00 Eric :
> On Sat, 18 Nov 2017 14:43:23 +0100, Cecil Westerhof <
> cldwester...@gmail.com> wrote:
> > I found the benefits for TCL/TK. But this is a SQLite mailing list, so
> not
> > the right place to ask questions if it is not connected to SQLite also.
> > What would be
On Sat, 18 Nov 2017 14:43:23 +0100, Cecil Westerhof
wrote:
> I found the benefits for TCL/TK. But this is a SQLite mailing list, so not
> the right place to ask questions if it is not connected to SQLite also.
> What would be good resources for TCL/TK?
>
There is the Usenet group comp.lang.tcl
I found the benefits for TCL/TK. But this is a SQLite mailing list, so not
the right place to ask questions if it is not connected to SQLite also.
What would be good resources for TCL/TK?
--
Cecil Westerhof
___
sqlite-users mailing list
sqlite-users@mai
13 matches
Mail list logo