On Thu, Dec 6, 2018 at 8:06 PM Keith Medcalf wrote:
>
> Why one would want a particular capability available in the shell that is
> not available when compiling the amalgamation code directly is beyond my
> ken.
The issue is not limited to generate_series (although that one seems to be
pain
On Sun, Dec 16, 2018 at 9:26 PM Thomas Kurz wrote:
> > Good way to overflow your integers.
> > With floating point, that's not a problem.
>
> With int64, it shouldn't be a problem either.
>
>
Well.. are you absolutely sure about that?
Considering these Zimbabwe Dollars amounts mentioned
On Tue, Dec 4, 2018 at 5:57 PM Richard Hipp wrote:
>
> On 12/4/18, Digital Dog wrote:
> >
> > I vote for GENERATE_SERIES to be included in official sqlite3 binary and
> > libraries.
>
> We are under pressure to keep SQLite as small and compact as possible.
>
On Thu, 25 Oct 2018 09:32:05 -0700 Nathan Green wrote:
> According to the online documentation (https://www.sqlite.org/series.html
),
> generate_series is compiled into the command line shell. As it turns out,
> this is not so. It is not even an option in the build system from what I
> can tell.
Hi! Welcome to the list.
I'm reading documentation on the topic:
"In an elegant system, all tables would behave as WITHOUT ROWID tables even
without the WITHOUT ROWID keyword".
then
"However, NOT NULL was not enforced on PRIMARY KEY columns by early
versions of SQLite due to a bug. By the time
> From: E.Pasma
> Digital Dog wrote:
> >
> > PRAGMA default_without_rowid = on
> > To make all tables created while the directive is in use the WITHOUT
ROWID
> > tables.
> ..
> >
> > PRAGMA enforce_not_null_on_primary_key = on
> > For WITH
On Mon, Nov 26, 2018 at 2:52 AM Balaji Ramanathan <
balaji.ramanat...@gmail.com> wrote:
> SQLite> Alter Table Trip rename column StartGMTOffset to StartUTCOffset;
> Error: error in view CumulativeStatisticsByPlaceName after rename: no such
> column: StartGMTOffset
>
> I was able to reproduce this
On Mon, Nov 26, 2018 at 1:19 PM Richard Hipp wrote:
> On 11/23/18, Digital Dog wrote:
> > I think these changes would not add a lot of code to sqlite and will make
> > life easier for users.
>
> SQLite remembers the database schema by storing the origina
I was able to reproduce this behaviour using much shorter query (in
sqlite.exe 3.27.1):
SELECT + sum(0) OVER() ORDER BY + sum(0) OVER();
SELECT + avg(0) OVER() ORDER BY + avg(0) OVER();
SELECT 1 + avg(0) OVER() ORDER BY 1 + avg(0) OVER();
SELECT - - - - - avg(0) OVER()
On Mon, Jan 28, 2019 at 9:26 AM Vladimir Barbu <
vladimir.ba...@schneider-electric-dms.com> wrote:
> This vulnerability has been addressed in SQLite 3.26.0. When could we
> expect new version (official) of System.Data.SQLite which uses 3.26.0?
>
That would also make it much easier to use new
Hi!
I'm late to the party, but want to contribute. I did not read all messages
in the thread, but in those I've read did not contain a question about
number of ROWS. We know how many columns you desire, but how many rows are
there?
No matter how I like SQLite, I would not store this kind of data
On Wed, Nov 6, 2019 at 7:22 PM Jens Alfke wrote:
>
>
> > On Nov 6, 2019, at 9:25 AM, Digital Dog wrote:
> >
> > If there are millions or billions of rows
> > in the data set I consider it big data and the only reasonable format for
> > storing it is a col
For reasons which you've described I'm a big fan of removing virtual memory
from CPUs altogether. That would speed up things considerably.
On Sun, Dec 8, 2019 at 6:43 PM James K. Lowden
wrote:
> On Sat, 7 Dec 2019 05:23:15 +
> Simon Slavin wrote:
>
> > (Your operating system is allowed to
On Sat, Dec 7, 2019 at 3:50 AM Simon Slavin wrote:
> On 7 Dec 2019, at 2:26am, Shawn Wagner wrote:
>
> > The first one uses the index for all sorting, but the second one only
> uses it for sorting a, not b. I feel like the descending sort could make
> use of the index too, just reading the b
On Mon, Nov 18, 2019 at 2:23 AM Joe Mistachkin
wrote:
>
> Mike King wrote:
> >
> > "It needs to be clearly stated somewhere that EF 6.3 is meant only as a
> > tool for migrating from .NET Framework, and that EF Core is the version
> > that should be used." *2
> >
>
> Given the phrasing here, it
On Mon, Feb 10, 2020 at 8:27 PM Richard Hipp wrote:
> On 2/10/20, Digital Dog wrote:
> >
> > Nobody bothered to actually show the downside of increasing this value to
> > e.g. 10 thousands but everybody immediately proceeded to grumble.
> > What is the justifia
On Mon, Feb 10, 2020 at 9:03 PM Richard Hipp wrote:
> On 2/10/20, Digital Dog wrote:
> > Maybe they should be treated as a
> > dictionary/hashtable/linked list or similar?
> >
>
>
> Parameter look-ups are on the critical path. How much performance are
> you wi
Huh so the typical ranting for a valid use case has happened.
> Another alternative is to construct the command as a string.
begging for SQL injection. Thanks, no.
> all the suggestions and examples with temporary tables
and that's what you call easy for the programmer?
Nobody bothered to
> > Is it going to be fixed in 3.31?
>
> I'll fix the documentation, so that it doesn't say that any more, if
> that is what you mean by "fixed". :-)
>
> Hoped to have it compiled in by default :-) It'd be nice addition... Come
on, typical Linux or Windows has multiple gigabytes of memory... I'm
Hi!
In the docs here
https://www.sqlite.org/series.html
there's this statement "The generate_series(START,END,STEP) table-valued
function is a loadable extension included in the SQLite source tree, **and
compiled into the command-line shell.**" Unfortunately in version 3.30.1 on
Windows
20 matches
Mail list logo