[sqlite] What to do with a .journal file

[Robert Weiss]

I had a process that was writing a sqlite database when the computer crashed. I 
now have two files: f6.db and f6.db-journal. How do I get the information in 
the journal file to be incorporated in the database? 
I tried open f6.db in the sqlite3 console program, and afterwards the journal 
file is still there.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] CSV import deletes trailing zeroes on text fields

[Robert Weiss]

 1. Rename .csv to .txt2. Excel will now ask for column treatment on import3. 
Specify the problem column(s) as "text" not "general"
There are other problems with csv recognizing text as numbers. I had a column 
with content, say 123D4. Excel recognized the old FORTRAN double precision 
format and called it 123.

On Thursday, July 12, 2018, 2:39:09 PM PDT, David Burgess 
 wrote:  
 
 "CSV import deletes /leading/ zeroes on text fields" excel does this.
Quite difficult to stop it from doing so.

On Fri, Jul 13, 2018 at 6:52 AM, R Smith  wrote:
> I believe your subject should read: "CSV import deletes /leading/ zeroes on
> text fields" - Your trailing Zero is in tact.
>
> And your declaration is wrong - in SQL the column name is first, then the
> Type, so it must be:
> CREATE TABLE foo(bar TEXT NOT NULL);
>
> Opening the csv file in Excel or CALC will probably do the exact same thing
> - but SQLite should be better than that.
>
>
>
> On 2018/07/12 10:47 AM, Simon Leo Hafner wrote:
>>
>> To reproduce:
>>
>> create table foo (
>>    text bar not null
>> );
>>
>> .import test.csv foo
>>
>> select * from foo;
>>
>> With test.csv:
>>
>> test
>> 01230
>>
>> Expected result:
>>
>> test
>> 01230
>>
>> Actual result:
>>
>> test
>> 1230
>> ___
>> sqlite-users mailing list
>> sqlite-users@mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
  
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Minor typo in example

[Robert Weiss]

Two more in here:
or an ISO-8601 dates string. But some application store dates


 

On Friday, October 14, 2016 12:27 PM, Robert Weiss <weiss...@yahoo.com> 
wrote:
 

 While we're on the subject there are at least two grammatical errors on the 
same page:
there is no substitutions 

and
A NULL means of "unknown"
 

On Friday, October 14, 2016 12:20 PM, David Raymond 
<david.raym...@tomtom.com> wrote:
 

 In the Row Values page http://www.sqlite.org/rowvalue.html, section 2.2 
there’s an extra semicolon in the code box, turning it into 2 statements.


UPDATE tab3 
  SET (a,b,c) = (SELECT x,y,z
                    FROM tab4
                  WHERE tab4.w=tab3.d);
 WHERE tab3.e BETWEEN 55 AND 66;


(Are miniscule things like that worth pointing out by the way? I just don't 
want my OCD to run amok looking for typos that don't really cause confusion or 
affect the meaning of something)
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


   

   
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Minor typo in example

[Robert Weiss]

While we're on the subject there are at least two grammatical errors on the 
same page:
there is no substitutions 

and
A NULL means of "unknown"
 

On Friday, October 14, 2016 12:20 PM, David Raymond 
 wrote:
 

 In the Row Values page http://www.sqlite.org/rowvalue.html, section 2.2 
there’s an extra semicolon in the code box, turning it into 2 statements.


UPDATE tab3 
  SET (a,b,c) = (SELECT x,y,z
                    FROM tab4
                  WHERE tab4.w=tab3.d);
 WHERE tab3.e BETWEEN 55 AND 66;


(Are miniscule things like that worth pointing out by the way? I just don't 
want my OCD to run amok looking for typos that don't really cause confusion or 
affect the meaning of something)
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


   
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Query time execution difference between my application and SQLiteBrowser

[Robert Weiss]

I haven't gone through the previous emails to see whether anyone has proposed 
this, but it seems possible to me that the GUI tool (oriented as it is to 
interaction) is not waiting for the query to finish before displaying the first 
results. 

On Wednesday, September 7, 2016 7:21 AM, Laura BERGOENS 
 wrote:
 

 Hi Mr. Slavin,

As for why the query takes so long, I do know the answer !
Long story short, my application does a lot of calculation and things, I
don't want to get into the details here, but queries are built and
auto-generated piece by piece. Therefore, sometimes the queries aren't
optimized at all.
I solved that issue myself by touching up the queries a bit before
executing them, and everything is fine now.
I was concerned mainly because I figured that maybe some queries were a bit
longer to execute as they should have (let's say 200 ms instead of 100 ms),
and I'm running a lot of queries in the app (approx 1000 per seconds).

I know now that there is nothing to worry about regarding my settings or
pragmas choices, since I get the same execution time with the sqlite3 tool

Thanks again for taking some time to answer

2016-09-07 16:14 GMT+02:00 Simon Slavin :

>
> On 7 Sep 2016, at 3:10pm, Laura BERGOENS 
> wrote:
>
> > I guess I don't have further question regarding my issue, since I have
> the
> > same time execution as with the sqlite3.exe tool, so there are no
> problems
> > with my pragmas or whatsoever.
>
> Nevertheless, 100 seconds is a very long time for a query, and we can
> probably improve on it if you're willing to include your "SELECT" command
> and your schema.  It might be something as simple as creating one
> additional index.
>
> You might also try executing "ANALYZE" in sqlite3.exe and see whether that
> speeds things up.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Laura BERGOENS
Technicienne supérieure en Informatique et étudiante à l'IMERIR de Perpignan

*Institut Méditerranéen d'Étude etde Recherche en Informatique*
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


   
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLITE_USER_AUTHENTICATION

[Robert Weiss]

Tthe documentation says to use the flag as?
-DSQLITE_USER_AUTHENTICATION

whereas in your message you said you used?
-D_SQLITE_USER_AUTHENTICATION

So unless cl ignores a leading underscore (seems unlikely), you're defining 
something the code doesn't care about.


On Monday, March 14, 2016 10:26 AM, siddharth kotian  wrote:


 Thanks, It works now.


On Mon, Mar 14, 2016 at 10:06 PM, syl leo  wrote:

> Hi,
> In your c++ program, if you use directly sqlite.c and .h and not the
> dll+lib, you should remove the sqlite3.lib in your link.(project properties
> -> linker -> input)
> No ?
> Regards.
> Sylvain.
>
>? ? ? De : siddharth kotian 
>? ? : sqlite-users at mailinglists.sqlite.org
>? Envoy? le : Lundi 14 mars 2016 13h39
>? Objet : [sqlite] SQLITE_USER_AUTHENTICATION
>
> Hi,
>
> I have downloaded the SQLITE amalgamation folder along with the entire
> source code.
>
> Followed the steps mentioned here
> http://www.sqlite.org/src/doc/trunk/ext/userauth/user-auth.txt
>
> Using the following command to build the sqlite3.exe:-
>
> cl -D_SQLITE_USER_AUTHENTICATION shell.c sqlite3.c userauth.c
> -Fesqlite3.exe
>
> But i can still open the database with sqlite3_open_v2. No authentication
> is required.
>
> Another problem is that I am trying to add a user to the sqlite_user table.
> I have appended userauth.c to the sqlite3.c amalgamation and have provided
> sqlite3userauth.h to the C++ program.
> I am able to access sqlite_user_add method but it gives error lnk1181:
> cannot find sqlite3.lib
>
> I am using VS2012, x64, Release Mode.
>
> Regards,
> Siddharth
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How to check if connection to main database is still open or closed before new query ?

[Robert Weiss]

Another tactic: ?why not try a simple query such as "SELECT SQLITE_VERSION()"? 
?If you get a decent answer you have verified your connection and can execute 
your actual query. 

On Tuesday, March 1, 2016 2:41 PM, Keith Medcalf  
wrote:



After you close the connection and verify the return code, why not set the 
pointer to 0 (NULL).? In that way you will know that the handle is no more 
valid rather than just hoping and praying that it is?


> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-
> bounces at mailinglists.sqlite.org] On Behalf Of a a
> Sent: Tuesday, 1 March, 2016 10:13
> To: SQLite mailing list
> Subject: Re: [sqlite] How to check if connection to main database is still
> open or closed before new query ?
> 
> Let me explain it better cause i got confused and i am a? newbie also.
> 
> I open a connection like this
> 
> sqlite3 *ppDB;
> int dbcon;
>? dbcon = sqlite3_open(databasename, );
> /// i do my code i query the database i do some stuff and i close the
> database like this
> dbcon = sqlite3_close(ppDB);
> 
> I want to check after a while if the connection is allready closed or not
> for the simple reason not to reopen the database but if is open to run a
> query or if it is closed
> to reopen the database and then run the query.
> 
> so i think the dbcon is the one i have to check not the ppDB :/
> 
> it works now maby i didnt understand what ppDB you were reffering to
> 
> if(dbcon){
> //is open
> }else{
> //is closed
> }
> 
> :) thanks though it is tested and runs ok
> 
> 
> From: sqlite-users-bounces at mailinglists.sqlite.org  bounces at mailinglists.sqlite.org> on behalf of Simon Slavin
> 
> Sent: Tuesday, March 1, 2016 7:01 PM
> To: SQLite mailing list
> Subject: Re: [sqlite] How to check if connection to main? ? ? ? database
> is? ? ? still? open or closed before new query ?
> 
> On 1 Mar 2016, at 4:59pm, a a  wrote:
> 
> > the sqlite3_close() <--- needs one argument if i pass
> sqlite3_close(NULL) it actually closes again a closed connection ?
> 
> No.? If you pass it null it realises that the connection is closed and
> does nothing.
> 
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Is there an index of conformances and deviations against standard SQL?

[Robert Weiss]

In partial answer to the original question:
http://sqlite.org/omitted.html

http://sqlite.org/nulls.html

http://sqlite.org/conflict.html

Furthermore any non-standard extension, such as FTS3 and ATTACH, might be 
regarded as a deviation from the standard.

And after consulting https://en.wikipedia.org/wiki/SQL-92: does SQLITE have a 
MUMPS binding or a bit string variable type?
Bob Weiss 

On Thursday, January 28, 2016 12:06 PM, Simon Slavin  wrote:



On 28 Jan 2016, at 6:41pm, Yannick Duch?ne  wrote:

> I wonder if this is the same with SQLite4

You can ignore SQLite4.? It is purely experimental at the moment and any 
feature may change or disappear or work differently before launch.? Nobody 
should be using SQLite4 for anything important.

Simon.
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Build fail: undefined reference to `pthread_create'

[Robert Weiss]

A few builds ago I got a similar message. ?I don't recall whether I actively 
tried to use threads or got blindsided by change. ?The short story is that 
linking in libpthread caused the build to succeed. ?The longer story is that 
threads were unreliable in my environment (Windows/cygwin), caused errors, and 
I dropped them from later builds.
Bob Weiss 

On Wednesday, January 27, 2016 2:06 PM, jungle Boogie  wrote:


 On 21 January 2016 at 11:16, Richard Hipp  wrote:
> The change that is causing your problem was put in at the suggestion
> of Hanno B?ck on the sqlite-dev mailing list.? Hanno said he was going
> to try to contact you off-list in order to figure out how to reproduce
> the issue you are seeing and to devise a work-around.? The change
> facilitates compiling SQLite with ASAN.


I think this is who you're referring to: https://hboeck.de/
I have contacted him off-list to see if he has any suggestions.

-- 
---
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite crash

[Robert Weiss]

It will take a little while to compile with MSVC. ?In the meantime I removed 
-DSQLITE_DEFAULT_WORKER_THREADS=4 from the compilation flags and the index was 
created successfully. ?Haste makes waste?
Thanks, everyone.Bob Weiss 


 On Tuesday, August 11, 2015 1:55 PM, Joe Mistachkin  wrote:



Robert Weiss wrote:
>
> [continuing from previous gdb output]:(gdb) thread apply all where 15
> Thread 6 (Thread 12300.0xa64):#0 ?0x74d66d61 in sysfer!FirstHookFunc ()
> from /cygdrive/c/Windows/SysWOW64/SYSFER.DLL#1 ?0x in ?? ()
> 

Anyhow, the cause of this appears to be the "sysfer.dll", which belongs to
Symantec Network Threat Protection (NTP):

http://www.symantec.com/connect/forums/weve-found-new-big-one#comment-504141
1

I'm not exactly sure what is causing the bad interaction here; however, it
is possible that Cygwin and Symantec are attempting to hook similar Win32
APIs, with unpredictable results.

Does this issue occur when running a build of SQLite on your machine without
Cygwin (i.e. built using MSVC)?

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite crash

[Robert Weiss]

[continuing from previous gdb output]:(gdb) thread apply all where 15
Thread 6 (Thread 12300.0xa64):#0 ?0x74d66d61 in sysfer!FirstHookFunc () from 
/cygdrive/c/Windows/SysWOW64/SYSFER.DLL#1 ?0x in ?? ()
Thread 5 (Thread 12300.0x389c):#0 ?0x77791f92 in 
ntdll!ZwWaitForWorkViaWorkerFactory () from 
/cygdrive/c/Windows/SysWOW64/ntdll.dll#1 ?0x77791f92 in 
ntdll!ZwWaitForWorkViaWorkerFactory () from 
/cygdrive/c/Windows/SysWOW64/ntdll.dll#2 ?0x777c1d63 in 
ntdll!RtlpQueryDefaultUILanguage () from 
/cygdrive/c/Windows/SysWOW64/ntdll.dll#3 ?0x6100626b in _cygtls::call2(unsigned 
long (*)(void*, void*), void*, void*) () from /usr/bin/cygwin1.dll#4 
?0x61006306 in _cygtls::call(unsigned long (*)(void*, void*), void*) () from 
/usr/bin/cygwin1.dll#5 ?0x610828d8 in threadfunc_fe(void*) () from 
/usr/bin/cygwin1.dll#6 ?0x75c4337a in KERNEL32!BaseThreadInitThunk () from 
/cygdrive/c/Windows/syswow64/kernel32.dll#7 ?0x777a92e2 in 
ntdll!RtlInitializeExceptionChain () from 
/cygdrive/c/Windows/SysWOW64/ntdll.dll#8 ?0x777a92b5 in 
ntdll!RtlInitializeExceptionChain () from 
/cygdrive/c/Windows/SysWOW64/ntdll.dll#9 ?0x in ?? ()
Thread 4 (Thread 12300.0x328c):#0 ?0x777901a9 in ntdll!ZwWaitForMultipleObjects 
() from /cygdrive/c/Windows/SysWOW64/ntdll.dll#1 ?0x777901a9 in 
ntdll!ZwWaitForMultipleObjects () from /cygdrive/c/Windows/SysWOW64/ntdll.dll#2 
?0x777b1541 in ntdll!TpIsTimerSet () from 
/cygdrive/c/Windows/SysWOW64/ntdll.dll#3 ?0x75c4337a in 
KERNEL32!BaseThreadInitThunk () from 
/cygdrive/c/Windows/syswow64/kernel32.dll#4 ?0x777a92e2 in 
ntdll!RtlInitializeExceptionChain () from 
/cygdrive/c/Windows/SysWOW64/ntdll.dll#5 ?0x777a92b5 in 
ntdll!RtlInitializeExceptionChain () from 
/cygdrive/c/Windows/SysWOW64/ntdll.dll#6 ?0x in ?? ()
Thread 3 (Thread 12300.0x3530):#0 ?0x7778f951 in ntdll!ZwReadFile () from 
/cygdrive/c/Windows/SysWOW64/ntdll.dll#1 ?0x7778f951 in ntdll!ZwReadFile () 
from /cygdrive/c/Windows/SysWOW64/ntdll.dll#2 ?0x7549dd62 in ReadFile () from 
/cygdrive/c/Windows/syswow64/KERNELBASE.dll#3 ?0x00a0 in ?? ()#4 
?0x in ?? ()
Thread 2 (Thread 12300.0x32f0):#0 ?0x002c03a3 in ?? ()#1 ?0x6100626b in 
_cygtls::call2(unsigned long (*)(void*, void*), void*, void*) () from 
/usr/bin/cygwin1.dll#2 ?0x61006306 in _cygtls::call(unsigned long (*)(void*, 
void*), void*) () from /usr/bin/cygwin1.dll#3 ?0x610828d8 in 
threadfunc_fe(void*) () from /usr/bin/cygwin1.dll#4 ?0x75c4337a in 
KERNEL32!BaseThreadInitThunk () from 
/cygdrive/c/Windows/syswow64/kernel32.dll#5 ?0x777a92e2 in 
ntdll!RtlInitializeExceptionChain () from 
/cygdrive/c/Windows/SysWOW64/ntdll.dll#6 ?0x777a92b5 in 
ntdll!RtlInitializeExceptionChain () from 
/cygdrive/c/Windows/SysWOW64/ntdll.dll#7 ?0x in ?? ()
Thread 1 (Thread 12300.0x294c):#0 ?0x7778fc66 in ntdll!ZwQueryInformationThread 
() from /cygdrive/c/Windows/SysWOW64/ntdll.dll#1 ?0x7778fc66 in 
ntdll!ZwQueryInformationThread () from /cygdrive/c/Windows/SysWOW64/ntdll.dll#2 
?0x754a38f6 in KERNELBASE!GetThreadPriority () from 
/cygdrive/c/Windows/syswow64/KERNELBASE.dll#3 ?0x6108dcc4 in yield () from 
/usr/bin/cygwin1.dll#4 ?0x61106585 in pthread::create(void* (*)(void*), 
pthread_attr*, void*) () from /usr/bin/cygwin1.dll#5 ?0x61107d3d in 
pthread::create(pthread**, pthread_attr* const*, void* (*)(void*), void*) () 
from /usr/bin/cygwin1.dll#6 ?0x610e1e15 in _sigfe () from 
/usr/bin/cygwin1.dll#7 ?0x00421070 in vdbeSorterListToPMA ()#8 ?0x8006ae42 in 
?? ()Backtrace stopped: previous frame inner to this frame (corrupt stack?)



 On Tuesday, August 11, 2015 1:03 PM, Dan Kennedy  wrote:


 On 08/12/2015 02:15 AM, Robert Weiss wrote:
> The bug seems to be repeatable.? At least, it happened again today.
> I haven't used gdb in a long time.? Here's my first crack at it; what else 
> should I do?
> $ gdb sqliteGNU gdb (GDB) 7.8Copyright (C) 2014 Free Software Foundation, 
> Inc.License GPLv3+: GNU GPL version 3 or later 
> <http://gnu.org/licenses/gpl.html>This is free software: you are free to 
> change and redistribute it.There is NO WARRANTY, to the extent permitted by 
> law.? Type "show copying"and "show warranty" for details.This GDB was 
> configured as "i686-pc-cygwin".Type "show configuration" for configuration 
> details.For bug reporting instructions, please 
> see:<http://www.gnu.org/software/gdb/bugs/>.Find the GDB manual and other 
> documentation resources online 
> at:<http://www.gnu.org/software/gdb/documentation/>.For help, type 
> "help".Type "apropos word" to search for commands related to "word"...Reading 
> symbols from sqlite...done.(gdb) run /cygdrive/r/errd200.dbStarting program: 
> /usr/local/bin/sqlite /cygdrive/r/errd200.db[New Thread 12300.0x294c][New 
> Thread 12300.0x32f0][New Thread 12300.0x3530][New Thread 12300.0x328c][New 
> Thread 12300.0x389c]SQLite version 3.8.11.1 2015-

[sqlite] SQLite crash

[Robert Weiss]

The bug seems to be repeatable. ?At least, it happened again today.
I haven't used gdb in a long time. ?Here's my first crack at it; what else 
should I do? 
$ gdb sqliteGNU gdb (GDB) 7.8Copyright (C) 2014 Free Software Foundation, 
Inc.License GPLv3+: GNU GPL version 3 or later 
<http://gnu.org/licenses/gpl.html>This is free software: you are free to change 
and redistribute it.There is NO WARRANTY, to the extent permitted by law. ?Type 
"show copying"and "show warranty" for details.This GDB was configured as 
"i686-pc-cygwin".Type "show configuration" for configuration details.For bug 
reporting instructions, please see:<http://www.gnu.org/software/gdb/bugs/>.Find 
the GDB manual and other documentation resources online 
at:<http://www.gnu.org/software/gdb/documentation/>.For help, type "help".Type 
"apropos word" to search for commands related to "word"...Reading symbols from 
sqlite...done.(gdb) run /cygdrive/r/errd200.dbStarting program: 
/usr/local/bin/sqlite /cygdrive/r/errd200.db[New Thread 12300.0x294c][New 
Thread 12300.0x32f0][New Thread 12300.0x3530][New Thread 12300.0x328c][New 
Thread 12300.0x389c]SQLite version 3.8.11.1 2015-07-29 20:00:57Enter ".help" 
for usage hints.sqlite> create index d200_on_passport_fn on 
d200_on_passport(fn);[New Thread 12300.0xa64]gdb: unknown target exception 
0x8001 at 0x74d66d61
Program received signal ?, Unknown signal.[Switching to Thread 
12300.0xa64]0x74d66d61 in sysfer!FirstHookFunc () from 
/cygdrive/c/Windows/SysWOW64/SYSFER.DLL(gdb) bt#0 ?0x74d66d61 in 
sysfer!FirstHookFunc () from /cygdrive/c/Windows/SysWOW64/SYSFER.DLL#1 
?0x in ?? ()


 On Tuesday, August 11, 2015 1:43 AM, Dan Kennedy  wrote:


 On 08/11/2015 12:23 AM, Robert Weiss wrote:
> Dan Kennedy--
> What address, precisely, should I use to send the database to you?? When I 
> "reply" to your message I get the whole SQLite discussion group, which is 
> what I want to avoid (no offense intended, guys and gals).
> BTW, the problem does not seem to occur in version 3.8.10.2.
> Robert Weiss

Thanks for the database. We couldn't reproduce the problem here though.

The crash is repeatable, correct? Are you able to capture a stack trace 
from the command line shell with gdb?

Thanks,
Dan.


>
>
>? ? ? On Friday, August 7, 2015 11:31 PM, Dan Kennedy gmail.com> wrote:
>? ? 
>
>? On 08/08/2015 04:11 AM, Robert Weiss wrote:
>> I observed the sqlite command shell version 3.8.11.1 to crash (exit to the 
>> OSwithout an error message) while running in a Cygwin shell under Windows 7 
>> when I tried to create anindex.? The source was compiled by gcc 4.9.2.? The 
>> same type of crashhappened when I tried the operation from a Lua script 
>> linked to the same objectlibrary.
>>
>>
>>? ? 
>> Here are the DDL statements entered previous to the crash:
>>
>>
>>? ? 
>> CREATE TABLEd200_on_passport(fn,path,size,serial,pid);
>>
>> CREATE INDEX d200_on_passport_serial ond200_on_passport(serial);
>>
>> CREATE VIEW d200 as select * fromd200_on_passport;
>>
>>
>>? ? 
>> And here is the statement thatcaused the crash:
>>
>> create index d200_on_passport_fn ond200_on_passport(fn);
>>
>>
>>? ? 
>> The crash didn?t happen when Itried the CREATE INDEX statement on a test 
>> database with the same ddlstatements but containing no data.
>>
>>
>> The compressed version of the database that illustrates the problem is a 
>> little smaller than 2 MB.? It contains some semi-personal information (it's 
>> part of an attempt to organize my photo library; pathnames hint at where 
>> I've been on vacation and so on, but the database contains no images) and 
>> I'd prefer not to post it to a list, but I can send it for use by those 
>> tracking down the bug.
>
> Can you send the database to me? Or to drh if that seems more prudent to
> you.
>
> Thanks,
> Dan.
>
>
>
>
>
>> Robert Weiss
>> ___
>> sqlite-users mailing list
>> sqlite-users at mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
>? ? 
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite crash

[Robert Weiss]

Dan Kennedy--
What address, precisely, should I use to send the database to you? ?When I 
"reply" to your message I get the whole SQLite discussion group, which is what 
I want to avoid (no offense intended, guys and gals).
BTW, the problem does not seem to occur in version 3.8.10.2.
Robert Weiss 


 On Friday, August 7, 2015 11:31 PM, Dan Kennedy  
wrote:


 On 08/08/2015 04:11 AM, Robert Weiss wrote:
> I observed the sqlite command shell version 3.8.11.1 to crash (exit to the 
> OSwithout an error message) while running in a Cygwin shell under Windows 7 
> when I tried to create anindex.? The source was compiled by gcc 4.9.2.? The 
> same type of crashhappened when I tried the operation from a Lua script 
> linked to the same objectlibrary.
>
>
>? 
> Here are the DDL statements entered previous to the crash:
>
>
>? 
> CREATE TABLEd200_on_passport(fn,path,size,serial,pid);
>
> CREATE INDEX d200_on_passport_serial ond200_on_passport(serial);
>
> CREATE VIEW d200 as select * fromd200_on_passport;
>
>
>? 
> And here is the statement thatcaused the crash:
>
> create index d200_on_passport_fn ond200_on_passport(fn);
>
>
>? 
> The crash didn?t happen when Itried the CREATE INDEX statement on a test 
> database with the same ddlstatements but containing no data.
>
>
> The compressed version of the database that illustrates the problem is a 
> little smaller than 2 MB.? It contains some semi-personal information (it's 
> part of an attempt to organize my photo library; pathnames hint at where I've 
> been on vacation and so on, but the database contains no images) and I'd 
> prefer not to post it to a list, but I can send it for use by those tracking 
> down the bug.


Can you send the database to me? Or to drh if that seems more prudent to 
you.

Thanks,
Dan.





>
> Robert Weiss
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite crash

[Robert Weiss]

I observed the sqlite command shell version 3.8.11.1 to crash (exit to the 
OSwithout an error message) while running in a Cygwin shell under Windows 7 
when I tried to create anindex.? The source was compiled by gcc 4.9.2. ?The 
same type of crashhappened when I tried the operation from a Lua script linked 
to the same objectlibrary.


?
Here are the DDL statements entered previous to the crash:


?
CREATE TABLEd200_on_passport(fn,path,size,serial,pid);

CREATE INDEX d200_on_passport_serial ond200_on_passport(serial);

CREATE VIEW d200 as select * fromd200_on_passport;


?
And here is the statement thatcaused the crash:

create index d200_on_passport_fn ond200_on_passport(fn);


?
The crash didn?t happen when Itried the CREATE INDEX statement on a test 
database with the same ddlstatements but containing no data.


The compressed version of the database that illustrates the problem is a little 
smaller than 2 MB. ?It contains some semi-personal information (it's part of an 
attempt to organize my photo library; pathnames hint at where I've been on 
vacation and so on, but the database contains no images) and I'd prefer not to 
post it to a list, but I can send it for use by those tracking down the bug.

Robert Weiss