I just encountered something weird with "temp" and "sqlite_master".
I was wondering if it was another bug, or intentional.
-
This throws a "column not found" error,
SELECT
sqlite_master.sql
FROM
temp.sqlite_master;
-
This throws a "column not found" error,
SELECT
temp.sqli
> I have a patch to fix the problem on a branch
> (https://www.sqlite.org/src/timeline?r=do-not-factor-functions) which
> you can experiment with. More changes and analysis are needed prior to
> landing on trunk. I cannot guarantee that such a landing will in fact
> occur, though it seems more lik
> It is not a "hack" because it does not work. It is what is called a "failed
> attempt" at a hack.
Yeah, the ABS() hack does not work.
Which led me to use `(SELECT SUM(9223372036854775807) FROM (SELECT NULL UNION
ALL SELECT NULL))`
which **does** work.
> However, your assessment that coalesc
> It is not a "hack" because it does not work. It is what is called a "failed
> attempt" at a hack.
Yeah, the ABS() hack does not work.
Which led me to use `(SELECT SUM(9223372036854775807) FROM (SELECT NULL UNION
ALL SELECT NULL))`
which **does** work.
> However, your assessment that coalesc
> Why do you think that that it should not evaluate ABS? It is there and you
> asked for it. I believe it's a good idea to say, "hey, the amount you placed
> here is out of boundary, think about what you are doing here." IMO, of
> course. Thanks.
>
> josé
Sometimes, when querying data, rather
This happens in SQLite 3.28 and 3.31.
Consider the following queries,
-- Query 1
SELECT
COALESCE(
NULL,
(SELECT SUM(9223372036854775807) FROM (SELECT NULL UNION ALL SELECT NULL))
);
-- Query 2
SELECT
COALESCE(
(SELECT 'hello'),
(SELECT SUM(9223372036854775807) FROM (SELECT
SQLite 3.31 introduced generated columns.
However, pragma table_xinfo() does not seem to give you the parenthesized
expression of a generated column.
Is there a version of "dflt_value" (in table_xinfo()) for generated columns?
How would I access that?
Also, does the "hidden" column (in table_x
lly NULL, but an empty string value sitting
in an INTEGER field.
I definitely know to look out for this now.
From: Simon Slavin
To: SQLite mailing list
Subject: Re: [sqlite] Not Null Constraint Issue?
Message-ID: <46053091-b9ab-43c4-b7f9-c89d70986...@bigfraud.org>
Content-Type: text/pla
the .NET Framework do not allow for empty values
which is why we didn't notice that it was saved this way in the DB. It
appears the issue was application side as your suggestions suspected.
We're looking into why, but your responses helped us to realize this so
thank you.
-Justin
On T
oss was
reported yet.
I've been working with SQLite for a while now, and this was the first time
I've seen a constraint not catch something like this. Just wanted to pass
along as I found it odd.
Have a great day
-Justin
___
sqlite-u
Is this the appropriate place to discuss this?
The below examples are expected to return 3.
The first example returns 4, the second returns 3.
It seems like LIMIT 0 is ignored by COALESCE().
https://www.db-fiddle.com/f/7YWZ5naLUfAHgNmh93Yo44/0
CREATE TABLE "myTable" (
"myColumn" INT PRIMARY KEY
t.
xCreate is working fine (in fact it's already handling queries properly),
but I'm not seeing any calls to xConnect including in queries (as you
suggest). So for a table with different xCreate and xConnect functions,
when would xConnect be called?
--
Justin Olbrantz (Quantam)
"Ar
g I
have a non-eponymous table). How would you create a new connection to an
exiting virtual table?
--
Justin Olbrantz (Quantam)
"Ardente veritate
Urite mala mundi
Ardente veritate
Incendite tenebras mundi"
___
sqlite-users maili
query
on an indexed column, meaning the cost for an indexed column should be much
lower than the cost for an unindexed column. How should I be doing this?
--
Justin Olbrantz (Quantam)
"Ardente veritate
Urite mala mundi
Ardente veritate
Incendite tenebras mundi"
__
On 2019-05-12 21:39, Warren Young wrote:
On May 11, 2019, at 10:46 PM, Justin Clift
wrote:
One of the steps uses curl to download fileio.c, test_windirent.c/.h
from fossil
[snip]
Is there a way to always get "the latest" version of the file? :)
$ curl -L -o src/extension
e? :)
Regards and best wishes,
Justin Clift
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
locked
- I assume they are pulled down as dependencies of the nuget package, but I am
also seeing SQLiteInterop.dll v1.0.61.0, and Mono.Data.Sqlite.dll v1.0.61.0 in
the bin of our solution.
Thanks,
Justin Esplin
Applications Dev II
Verisk Insurance Solutions - Xactware
Phone: +1.801.932.
I was able to access a computer which encountered these errors, about 10
minutes after they occurred. I ran "PRAGMA integrity_check" and it returned
"ok". How/why would this have changed? I verified the user did not re-install
our app or otherwise reconfigure the data
question on SO which you can see
here<https://stackoverflow.com/questions/46180021/how-to-debug-the-cause-for-sqliteerror11-database-corruption?noredirect=1#comment79326475_46180021>.
Thanks in advance for any help you may have to offer.
Justin Esplin
Applications Dev II | Xactware
t;.
Thanks to everyone for your help. If there is any more info you need please let
me know. Also, if anybody can tell me what file/function in the source deals
with this I would appreciate it.
Thank you,
Justin Adams
Example 1
C:\>C:
as well. :)
+ Justin
her
string of project seizures? eg:
http://arstechnica.com/information-technology/2015/06/black-mirror-sourceforge-has-now-siezed-nmap-audit-tool-project/
Regards and best wishes,
Justin Clift
scene goes big. :)
(and "... 3D printed groceries ..." hrmm ;>)
+ Justin
me of the crypto libraries are in lots of things too, but not as much
as libxml2.
+ Justin
plements sqlite3_vfs_register()?
Hmmm, searching for that function name across GitHub returns about 27k results.
16.6k+ for just C:
https://github.com/search?l=c&q=sqlite3_vfs_register&type=Code&utf8=?
6k+ for C++:
https://github.com/search?l=cpp&q=sqlite3_vfs_register&type=Code&utf8=?
You'll probably not be short of example stuff to drawn from... :D
Regards and best wishes,
Justin Clift
s
neither a joke nor an exaggeration), so it's _exceedingly_ unlikely
to go
anywhere, regardless of how many +1s people collect to the contrary.
Yeah, I know. ;)
+ Justin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi
ut of frustration.
+1 for GitHub. Purely because of the large qty of potential
contributors
there, many of whom actively get involved.
And yeah, I'm aware of fossil, but (to my thinking ;>) that shouldn't
hold
back _this_ bit of software. ;)
Regards and best wis
ment,
that'd be great for us too. (we don't support SQLCipher in our Win32
builds yet, due to this missing bit) ;)
Regards and best wishes,
Justin Clift
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
It turned out there were a few important bugs in 3.5.0, so now there's
a v3.5.1 with fixes for them.
https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.5.1
Hope that's useful to people. :)
+ Justin
On 2015-01-31 18:46, jus...@postgresql.org wrote:
Hi all,
We'v
ecome available.
Hope that's helpful for people. :)
Regards and best wishes,
Justin Clift
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
coded the options into the SQLite dll file you
compiled?
Regards and best wishes,
Justin Clift
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
management tools intended to be used
support the same encryption extension.
Ahhh, thanks Ulrich, that's really good info. :)
Regards and best wishes,
Justin Clift
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cg
a MacOS X, Linux, or BSD desktop you could try
with?
Regards and best wishes,
Justin Clift
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
gé of PostgreSQL
https://www.youtube.com/watch?v=ZvmMzI0X7fE
Just saying. ;)
Regards and best wishes,
Justin Clift
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
3:
http://en.wikipedia.org/wiki/Red_Hat_Linux#Version_history
While there is probably some someone - somewhere - still running on it
an ancient PC under a desk... it's not worth worrying about.
Just saying. ;)
Regards and best wishes,
Justin Clift
___
and best wishes,
Justin Clift
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
n-ish. You can compile it
yourself very easily though. Instructions here if it
helps:
https://github.com/sqlitebrowser/sqlitebrowser/blob/master/BUILDING.md
+ Justin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/m
Ugh. :/
Regards and best wishes,
Justin Clift
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
might have changed things, etc. ;)
Regards and best wishes,
Justin Clift
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
code for it is here:
https://github.com/sqlitebrowser/sqlitebrowser
It's written in a language called "C++", and uses a popular
cross platform toolkit called "Qt" (qt-project.org).
Does that help? :)
Regards and best wishes,
Justin Clift
__
atabase
Browser". Which supports SQLite (and others).
http://www.etl-tools.com/database-browser/overview.html
Looks like we'll need to do some thinking about new name v2 (or
v3). "Fluffy Pink Rabbits of Doom for SQLite" has a certain
a
people do keep on calling Hwaci regarding our app, feel free
to direct them to our GitHub issues page. Or have them email me
and I'll try to point them in the right direction.
Regards and best wishes,
Justin Clift
___
sqlite-users mailing li
push out an updated release with the new name sometime
in the next few days. :)
Regards and best wishes,
Justin Clift
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I'll communicate this to the rest of the team. I don't
think it'll be too hard to do for the pieces we control (eg
application,
website, some of the external project pages and similar).
Not sure how long it'll take for the information to propagate out, bu
of general improvements, and we've begun
going multi-linugal. (English, Russian, German so far)
Hope that's of use to some people. And if anyone's
interested in helping out with further translations
that'd be very welcome. :)
Regards
27;s a lot of
improvements over v3.1). :)
Regards and best wishes,
Justin Clift
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Just watched it. Very cool. :D
+ Justin
On 2014-06-02 16:47, Andreas Kupries wrote:
-- Forwarded message --
From: Joel Bruick
Date: Sun, Jun 1, 2014 at 4:20 PM
Subject: [fossil-users] DRH's PGCon 2014 Keynote (with Fossil
sighting!)
To: Fossil SCM user's discu
On 2014-05-21 08:36, Tim Streater wrote:
Of course, it might be lying in its teeth for all I know, but the fan
did wind up.
Nah, it wasn't lying. Qt is a huge amount of code,
and Homebrew uses all available processor cores to
compile it. And it still take ages. ;)
+ J
If you encounter bugs
or have suggestions, please feel free to open an Issue on GitHub
(preferred) or email. :)
Regards and best wishes,
Justin Clift
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 2014-05-20 16:35, big stone wrote:
Hi Justin,
What are the necessary steps to rebuild SQLite Database Browser from
source, on a windows 7 PC ?
(I have no Qt experience, so not sure of what to download )
Good question. We should write up some instructions for that. :)
Rene or Martin
Hope that's useful for people. :)
Regards and best wishes,
Justin Clift
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
nd it only handles the HAVE_SQLITE3 path, not the HAVE_SQLITE2 or
HAVE_BOTH paths.
-Justin
Christian Werner wrote:
> Justin Deoliveira wrote:
>
> Justin,
>
>> I have ran into an issue while using the javasqlite jdbc wrapper.The
>> issue can be illustrated with the
lt set metdata is not properly
initialized when a query returns no rows.
I guess my question is is this a bug or is it intended behavior?
Implementing a similar program with the C api I am able to get the
proper count of columns back so I would assume a bug.
I should note that I am runn
Is there syntax to do multiple row insert? Something like:
insert into my_table (a,b,c) values ((1,2,3),(4,5,6));
The documentation for INSERT seems to imply this is not possible.
Thanks,
Justin
___
sqlite-users mailing list
sqlite-users@sqlite.org
double x = ::sqlite3_column_double(stmt, 0);
printf("%5.5f %d\n", x, isnan(x));
}
sqlite3_close(db);
Binding NAN to a statement works fine. The inserts are successful.
But what I put in as NAN comes back out as 0.0.
Is there any way to insert a NAN and get a NAN back o
se of their environment) run the parser.
* The amalgamation distribution, as we have now, for those users who
treat the database as a black-box and never wish to know any more than that
it compiled and works.
--
Justin Fletcher, Senior Software Engineer
Picsel Technologies Ltd
es (1);
sqlite> insert into t0 values (1);
sqlite> insert into t0 values (1);
sqlite> insert into t0 values (2);
sqlite>
sqlite> update t0 set x=9 where x=1; select changes(), total_changes();
10|13
8<
Is there a reason for this seeming discrepa
[EMAIL PROTECTED] wrote:
Justin Fletcher <[EMAIL PROTECTED]> wrote:
do_test select1-11.2.2 {
execsql2 {
SELECT * FROM t3, t4;
}
} {a 3 b 4 a 3 b 4}
Can someone explain how the test can be correct ?
This comes about because of duplicate column names.
The execsql2 procedure
rstanding of TCL is very very rough, but I believe that the loop
'foreach f $data(*)' loops over every column name and prepends the column
name to those values in the result string. As the column names match in
the results, I think that gives the strange results.
--
Justin Fletcher, Seni
any thanks
Justin
It will be always get 'database table is locked' message when trying to
delete
a record after select.
I'v tested on WinXP and Ubuntu 5.10, but got the same error.
SQLite version v3.2.8
please see the following code
#include
#include
#include
#define DATFILE "test.dat"
int main(int argc, ch
I've used the C# .net provider for SQLite quite a bit. You can use SQL3
with these providers, you just have to add something to the connection
string to tell the driver which version you're using and also the text
encoding (UTF8Encoding=true;Version=3;). To create a new database, you
just have
MyGeneration is a template based code generator that runs in the Win32
environment. It is 100% free and supports SQLite. There is not yet a set
of templates that generate code for a specific SQLite supported framework,
but the Meta-Data API supports SQLite, so writing your own templates
should be a
MyGeneration software has added SQLite support to thier freeware template
based code generator.
http://www.mygenerationsoftware.com/
MyGeneration has a generic meta-data API that supports 9 databases with
more on the way. The meta-data (which includes columns, indeces, foreign
keys, etc) is made
64 matches
Mail list logo
