[sqlite] Cannot select specific columns from temp.sqlite_master unless temp.sqlite_master is aliased

2020-03-13 Thread Justin Ng
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

Re: [sqlite] [EXTERNAL] Re: COALESCE() does not short-circuit sometimes

2020-03-11 Thread Justin Ng
> 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

Re: [sqlite] COALESCE() does not short-circuit sometimes

2020-03-11 Thread Justin Ng
> 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

Re: [sqlite] COALESCE() does not short-circuit sometimes

2020-03-11 Thread Justin Ng
> 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

Re: [sqlite] COALESCE() does not short-circuit sometimes

2020-03-11 Thread Justin Ng
> 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,

[sqlite] COALESCE() does not short-circuit sometimes

2020-03-11 Thread Justin Ng
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] Extracting metadata about generated columns with SQL only?

2020-03-11 Thread Justin Ng
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

Re: [sqlite] Not Null Constraint Issue?

2020-01-20 Thread Justin Gielski
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/plain; charset=us-ascii On

Re: [sqlite] Not Null Constraint Issue?

2020-01-17 Thread Justin Gielski
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 Thu, Jan 16

[sqlite] Not Null Constraint Issue?

2020-01-15 Thread Justin Gielski
as 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-users mailing li

[sqlite] COALESCE() ignores LIMIT 0 clause in subquery?

2019-09-23 Thread Justin Ng
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

Re: [sqlite] [EXTERNAL] Virtual Tables xConnect Called When?

2019-07-25 Thread Justin Olbrantz
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) "Ardente veri

[sqlite] Virtual Tables xConnect Called When?

2019-07-24 Thread Justin Olbrantz
ing 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

[sqlite] Estimated Costs and Memory DBs

2019-07-23 Thread Justin Olbrantz
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" ___ sq

Re: [sqlite] How to retrieve "latest" fileio.c, test_windirect.c/h files?

2019-05-12 Thread Justin Clift
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

[sqlite] How to retrieve "latest" fileio.c, test_windirect.c/h files?

2019-05-12 Thread Justin Clift
ards and best wishes, Justin Clift ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Figuring out the Cause of SQLite Error 11: Corrupt Database

2017-09-20 Thread Esplin, Justin
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.8039 jlesp

Re: [sqlite] Figuring out the Cause of SQLite Error 11: Corrupt Database

2017-09-17 Thread Esplin, Justin
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

[sqlite] Figuring out the Cause of SQLite Error 11: Corrupt Database

2017-09-15 Thread Esplin, Justin
a 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

[sqlite] Possible bug

2015-11-11 Thread Adams, Justin
quot;. 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:\app\sqlit

[sqlite] DB Browser 3.7.0 for SQLite released

2015-06-14 Thread Justin Clift
as well. :) + Justin

[sqlite] SourceForge seems to have grabbed the "sqlite" project there

2015-06-03 Thread Justin Clift
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

[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-06 Thread Justin Clift
scene goes big. :) (and "... 3D printed groceries ..." hrmm ;>) + Justin

[sqlite] What software is deployed more than SQLite?

2015-05-05 Thread Justin Clift
ng. Some of the crypto libraries are in lots of things too, but not as much as libxml2. + Justin

[sqlite] Integrating sqlite with Core Data and iCloud

2015-05-05 Thread Justin Clift
? Hmmm, searching for that function name across GitHub returns about 27k results. 16.6k+ for just C: https://github.com/search?l=c=sqlite3_vfs_register=Code=? 6k+ for C++: https://github.com/search?l=cpp=sqlite3_vfs_register=Code=? You'll probably not be short of example stuff to drawn from... :D Regards and best wishes, Justin Clift

Re: [sqlite] sqlite3 mailing list broken

2015-02-12 Thread justin
(that'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:808

Re: [sqlite] sqlite3 mailing list broken

2015-02-12 Thread justin
issue out 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 wishes, Jus

Re: [sqlite] SQLCipher - Full Database Encryption for SQLite

2015-02-09 Thread justin
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

Re: [sqlite] v3.5.0 of DB Browser for SQLite released

2015-02-08 Thread justin
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've just released

[sqlite] v3.5.0 of DB Browser for SQLite released

2015-01-31 Thread justin
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

Re: [sqlite] Encrypted database

2014-12-16 Thread justin
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

Re: [sqlite] Encrypted database

2014-12-15 Thread justin
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/cgi-bin

Re: [sqlite] Encrypted database

2014-12-15 Thread justin
, 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

Re: [sqlite] Locking errors on network

2014-11-10 Thread justin
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

Re: [sqlite] Is sqlite thread-safety sufficient for use with "Go" language ?

2014-11-06 Thread justin
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

[sqlite] OT: Testers needed for full database encryption support

2014-11-05 Thread Justin Clift
, Justin Clift ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] v3.4.0 of DB Browser for SQLite released

2014-10-29 Thread justin
. 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/mailma

[sqlite] v3.4.0 of DB Browser for SQLite released

2014-10-29 Thread justin
:/ Regards and best wishes, Justin Clift ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What if OpenDocument were built atop SQLite?

2014-09-09 Thread justin
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

Re: [sqlite] GUI INfo

2014-09-09 Thread justin
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

Re: [sqlite] SQLite Database Browser v3.3.0 released

2014-09-01 Thread justin
roject called "Database 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 appeal at

Re: [sqlite] SQLite Database Browser v3.3.0 released

2014-08-31 Thread justin
upport calls. :) If 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 m

Re: [sqlite] SQLite Database Browser v3.3.0 released

2014-08-27 Thread justin
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

Re: [sqlite] SQLite Database Browser v3.3.0 released

2014-08-26 Thread justin
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, but hopefully "No

[sqlite] SQLite Database Browser v3.3.0 released

2014-08-25 Thread justin
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 and best wishes, Ju

[sqlite] SQLite Database Browser v3.2 released

2014-07-08 Thread justin
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

Re: [sqlite] Fwd: [fossil-users] DRH's PGCon 2014 Keynote (with Fossil sighting!)

2014-06-02 Thread justin
Just watched it. Very cool. :D + Justin On 2014-06-02 16:47, Andreas Kupries wrote: -- Forwarded message -- From: Joel Bruick <j...@joelface.com> Date: Sun, Jun 1, 2014 at 4:20 PM Subject: [fossil-users] DRH's PGCon 2014 Keynote (with Fossil sighting!) To: Fossil SCM

Re: [sqlite] SQLite Database Browser officially moved to GitHub

2014-05-21 Thread justin
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. ;) + Justin

Re: [sqlite] SQLite Database Browser officially moved to GitHub

2014-05-20 Thread justin
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

Re: [sqlite] SQLite Database Browser officially moved to GitHub

2014-05-20 Thread justin
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

[sqlite] SQLite Database Browser officially moved to GitHub

2014-05-20 Thread justin
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

Re: [sqlite] ResultSetMetaData with javasqlite

2009-04-21 Thread Justin Deoliveira
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

[sqlite] ResultSetMetaData with javasqlite

2009-04-20 Thread Justin Deoliveira
t 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 running javasq

[sqlite] multiple row insert

2009-04-04 Thread Justin Lolofie
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

[sqlite] sqlite and NAN

2008-04-20 Thread Justin Greenfield
t;%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 out of an sqlite database? Thanks, Justin ___

Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

2007-05-04 Thread Justin Fletcher
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 Tel: +44 141 8855588 Titanium Hou

[sqlite] changes() function discrepancy

2007-04-24 Thread Justin Fletcher
gt; 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 discrepancy in the exec

Re: [sqlite] Problem with understanding the test suite

2007-04-20 Thread Justin Fletcher
[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

[sqlite] Problem with understanding the test suite

2007-04-20 Thread Justin Fletcher
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, Senior Software Engineer Picsel Technologies Ltd Tel: +44 141 8855588 Titaniu

[sqlite] Installation with no root access

2006-04-01 Thread Justin Adie
Justin

[sqlite] database table is locked when trying to delete a record after select

2006-01-08 Thread Justin Wu
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,

Re: [sqlite] Dotnet C# support

2005-10-28 Thread Justin Greenwood
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

Re: [sqlite] Object Relational Mapping Tools with Sqlite

2004-12-31 Thread justin . greenwood
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

[sqlite] Freeware code generator now supports SQLite

2004-10-19 Thread justin . greenwood
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