It is not a bug AFAIK. SQLite uses what the documentation calls
dynamic typing for its actual values. So if you are inserting integers
into a real column, you are going to store integers. However, when you
select from it they are presented as reals and mix up (looking as if
there were duplicates, e
On Wednesday, 31 October, 2018 13:22, Gerlando Falauto
wrote:
>first of all let me tell you I cannot thank you enough for going
>through all this trouble for me!
No problem. I still really do not know if the answer is correct however it
does let you get data about how much data is actually b
Dear SQLite people,
Please bless me with your infinite wisdom.
I'm using SQLite 3.25.2 on Windows, downloaded the latest precompiled
binaries from the official page https://sqlite.org/download.htmlExecuting
the following code
DROP TABLE IF EXISTS TestReal;CREATE TABLE TestReal(A REAL
UNIQUE);INSER
Thank you very much for the detailed answer. I now understand things better and
can better accept that they are how they are :-))
- Original Message -
From: R Smith
To: sqlite-users@mailinglists.sqlite.org
Sent: Wednesday, October 31, 2018, 21:34:30
Subject: [sqlite] use column alias i
Hi Keith,
first of all let me tell you I cannot thank you enough for going through
all this trouble for me!
It did not occur to me it would help to run checkpoints manually.
There's a couple of things I don't understand though.
- After a checkpoint runs to completion (assuming no other process i
On 2018/10/31 9:21 PM, Simon Slavin wrote:
On 31 Oct 2018, at 7:14pm, Thomas Kurz wrote:
may I ask whether there is a deeper reason why using a column alias in the same
SELECT query doesn't work, e.g.
SELECT column1 AS a, 5*column2 AS b, a+b FROM...
The canonical answer to this is that
On 31 Oct 2018, at 7:14pm, Thomas Kurz wrote:
> may I ask whether there is a deeper reason why using a column alias in the
> same SELECT query doesn't work, e.g.
>
> SELECT column1 AS a, 5*column2 AS b, a+b FROM...
The canonical answer to this is that there's nothing in the SQL specificati
Dear all,
may I ask whether there is a deeper reason why using a column alias in the same
SELECT query doesn't work, e.g.
SELECT column1 AS a, 5*column2 AS b, a+b FROM...
This is not an SQlite issue, it doesn't work in MariaDB either. It would,
however, be very handy if it worked. Sometime
My typical use case is trying to determine how many rows I just wrote out
to a file. Window functions are no help because they alter the output
format, which is usually undesirable. It's sort of absurd to run `wc -l`
over the newest 25MiB file in my system to get an answer that's probably
already i
On 2018/10/31 4:52 PM, David Fletcher wrote:
Hi all,
Is there a mode in the sqlite shell, or some fancy extension, that
will display a row
number when outputting results? You know, something like this:
sqlite> .row on
sqlite> select * from SomeTable where ... ;
1. a|17|93|...
> On Oct 25, 2018, at 10:45 AM, Keith Medcalf wrote:
>
> There is an extra column load and compare when using the between version of
> the query (this is because although the optimization of the index use is the
> same, the use of x BETWEEN y AND z adds both the y <= x and x <= z checks as
>
> that will display a row number when outputting results?
Is this for your schema, or a 'general-could-be-anything' schema? If your
own, any reason why you don't use the rowid or _rowid_ columns? They
provide a unique reference for each row in a table.
Thanks,
Chris
On Wed, Oct 31, 2018 at
If you're going to change the sqlite3 command shell, add a ".count" and
maybe ".changes" display option.
On Wed, Oct 31, 2018 at 11:23 AM Don V Nielsen
wrote:
> I really enjoy using JetBrains DataGrip. It connects to everything and has
> great intellisense, find and replace tools, sql templates,
I really enjoy using JetBrains DataGrip. It connects to everything and has
great intellisense, find and replace tools, sql templates, all the goodies
a big IDE brings to the table.
On Wed, Oct 31, 2018 at 11:05 AM Dominique Devienne
wrote:
> On Wed, Oct 31, 2018 at 3:55 PM Clemens Ladisch
> wro
On Wed, Oct 31, 2018 at 3:55 PM Clemens Ladisch wrote:
> David Fletcher wrote:> Hi all,
> > Is there a mode in the sqlite shell, or some fancy extension, that will
> display a row
> > number when outputting results?
>
> No. You'd have to modify the shell, or add the row_number() window
> functio
On 10/31/18, Roman Ivasyshyn wrote:
>
> I faced with an issue of creating int array with the same name without
> closing connection.
That is not allowed. But you can use sqlite3_intarray_bind() to
change the array to which the intarray table is bound, or the length
of the array.
Another option
Hi all,
In a web-based application I developed, I have a table that holds SQL for
various statement used in the application. It's simple and looks something
like this:
create table if not exists StmtSQL (
StmtName TEXT NOT NULL UNIQUE,
SQL TEXT NOT NU
Hi all,
Is there a mode in the sqlite shell, or some fancy extension, that will
display a row
number when outputting results? You know, something like this:
sqlite> .row on
sqlite> select * from SomeTable where ... ;
1. a|17|93|...
2. b|212|104|...
I tend to use the sqlite sh
David Fletcher wrote:> Hi all,
> Is there a mode in the sqlite shell, or some fancy extension, that will
> display a row
> number when outputting results?
No. You'd have to modify the shell, or add the row_number() window function to
the
query.
Regards,
Clemens
___
Hi all,
Is there a mode in the sqlite shell, or some fancy extension, that will
display a row
number when outputting results? You know, something like this:
sqlite> .row on
sqlite> select * from SomeTable where ... ;
1. a|17|93|...
2. b|212|104|...
I tend to use the sqlite sh
Hello sqlite team,
I faced with an issue of creating int array with the same name without
closing connection.
I use sqlite3_intarray_create to create int array on a second call I
receive SQLITE_MISUSE error.
What I found inside create function that it tries to create module that
already exist
On Wed, Oct 31, 2018 at 12:51 PM Graham Holden
wrote:
> > There are, of course, multiple apps on my system that use sqlite3.dll -
> including the Bricscad app that I am running my vba code from.Speculating
> somewhat: Have you tried updating the copy Briscad is using? If one version
> is already
> There are, of course, multiple apps on my system that use sqlite3.dll -
> including the Bricscad app that I am running my vba code from.Speculating
> somewhat: Have you tried updating the copy Briscad is using? If one version
> is already in memory, you _may_ have problems persuading Windows
Hi,
and thanks for the suggestion. I am familiar with the vbRichClient
solution. There are also odbc drivers that are free to use but in the
end I am looking for system that has to work as 64 bit inside 64-bit
Autocad where vba runs in-process. The system that I am using seems
ideal in that I
Hi Richard,
I have discovered that there is a problem in that the vba code (I got
from the github site) is somehow failing to load my custom library from
my specified location and in fact keeps referencing a file with version
3.8.5 from 2014. I am not sure how to overcome this right now apart f
25 matches
Mail list logo