[sqlite] A Potential Bug

Hi, all, I am using our automatic bug finding tool to scan the source code of sqlite. The tool is designed to find potential null dereference bug. It issues warning for the function sqlite3VdbeAllocUnpackedRecord. SQLITE_PRIVATE UnpackedRecord *sqlite3VdbeAllocUnpackedRecord( KeyInfo

Re: [sqlite] capturing and testing a hot journal

mm.w wrote: >> Can someone please get this a*h*l* banned? -- Will ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Setting boundaries in a search

> On 16 Jul 2014, at 3:21am, jose isaias cabrera wrote: > > SELECT * from startcodes where code = 'e'; > > but I want to search only from id >= 8 and <= 14. Is there a way to set the > boundary for that SELECT that will only search ids 8-14? I know I can do a > WHERE

Re: [sqlite] Setting boundaries in a search

On 7/15/2014 10:21 PM, jose isaias cabrera wrote: SELECT * from startcodes where code = 'e'; but I want to search only from id >= 8 and <= 14. Just say so: SELECT * from startcodes where code = 'e' and id between 8 and 14; I know I can do a WHERE id BETWEEN 8 AND 14, but is there another

Re: [sqlite] Preferred cast in C#

> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Simon Slavin > > Which does /not/ describe it as "The official SQLite database engine", which > is the point I was making. I used NuGet. http://www.nuget.org/packages/System.Data.SQLite.Core/ "The

[sqlite] Setting boundaries in a search

Greetings. Pardon the newbie question, but is there a way to set boundaries on a search? Imagine this scenario: startcodes id,code,date 1,a,2014-08-06 2,b,2014-08-06 3,z,2014-08-06 4,g,2014-08-06 5,g,2014-08-06 6,j,2014-08-06 7,p,2014-08-06 8,t,2014-08-06 9,e,2014-08-06 10,w,2014-08-06

Re: [sqlite] capturing and testing a hot journal

and yes I don't spit in a face of someone, then selling my so good "reputation" you are joke rsmith and you would dare any of the crap face to face sorry truth must be told and I did not started this shit for the record. On Tue, Jul 15, 2014 at 5:39 PM, mm.w <0xcafef...@gmail.com> wrote: > if

Re: [sqlite] capturing and testing a hot journal

if you want some hint about google mail I can provide you, I could even ask for my username change without any loss On Tue, Jul 15, 2014 at 5:37 PM, mm.w <0xcafef...@gmail.com> wrote: > yes because I have nothing to hide, if you wish to block me so be it, no > offense taken, do it and we can

Re: [sqlite] capturing and testing a hot journal

yes because I have nothing to hide, if you wish to block me so be it, no offense taken, do it and we can share a beer anytime. On Tue, Jul 15, 2014 at 5:35 PM, Scott Robison wrote: > You stay public even when it is annoying the entire list? I don't suppose a > request

Re: [sqlite] capturing and testing a hot journal

You stay public even when it is annoying the entire list? I don't suppose a request to temporarily block him from the list would do any good, would it? May be time to investigate how to get gmail to block specific addresses. On Tue, Jul 15, 2014 at 6:34 PM, mm.w <0xcafef...@gmail.com> wrote: >

Re: [sqlite] capturing and testing a hot journal

and I stay public even it looks weird, but seriously grew up and fast kiddo. On Tue, Jul 15, 2014 at 5:21 PM, mm.w <0xcafef...@gmail.com> wrote: > yes where arethe social kills? telling crap loooking a like a queenie? > just work on tv man not real life. > > > On Tue, Jul 15, 2014 at 5:18 PM,

Re: [sqlite] capturing and testing a hot journal

yes where arethe social kills? telling crap loooking a like a queenie? just work on tv man not real life. On Tue, Jul 15, 2014 at 5:18 PM, mm.w <0xcafef...@gmail.com> wrote: > almost 2 hours of of unbelievable crap seriously? just for accusing me of > bad behaviors towards Simon on a topic you

Re: [sqlite] capturing and testing a hot journal

almost 2 hours of of unbelievable crap seriously? just for accusing me of bad behaviors towards Simon on a topic you don't even know? sorry again. On Tue, Jul 15, 2014 at 5:15 PM, mm.w <0xcafef...@gmail.com> wrote: > I thought you were a good person... seriously? what it is your issue with >

Re: [sqlite] capturing and testing a hot journal

I thought you were a good person... seriously? what it is your issue with just telling the truth, I am the first person here to say I am full of shit, sorry for the derogatory language but that's fact get back on your feet man! On Tue, Jul 15, 2014 at 5:11 PM, mm.w <0xcafef...@gmail.com> wrote:

Re: [sqlite] capturing and testing a hot journal

and moreover you bluntly lie On Tue, Jul 15, 2014 at 4:53 PM, mm.w <0xcafef...@gmail.com> wrote: > I am sorry I am jocking but you 'r calling of for white flag and use it to > charge again. > > > On Tue, Jul 15, 2014 at 4:51 PM, mm.w <0xcafef...@gmail.com> wrote: > >> seriously Rsmith \\\

Re: [sqlite] capturing and testing a hot journal

oh boy On Tue, Jul 15, 2014 at 5:10 PM, mm.w <0xcafef...@gmail.com> wrote: > and moreover you bluntly lie > > > On Tue, Jul 15, 2014 at 4:53 PM, mm.w <0xcafef...@gmail.com> wrote: > >> I am sorry I am jocking but you 'r calling of for white flag and use it >> to charge again. >> >> >> On

Re: [sqlite] capturing and testing a hot journal

I am sorry I am jocking but you 'r calling of for white flag and use it to charge again. On Tue, Jul 15, 2014 at 4:51 PM, mm.w <0xcafef...@gmail.com> wrote: > seriously Rsmith \\\ 3 slashes is the microsoft guy way then I give a try > 8D > > > On Tue, Jul 15, 2014 at 4:48 PM, mm.w

Re: [sqlite] capturing and testing a hot journal

seriously Rsmith \\\ 3 slashes is the microsoft guy way then I give a try 8D On Tue, Jul 15, 2014 at 4:48 PM, mm.w <0xcafef...@gmail.com> wrote: > I already accepted your apologies why don't you give some air simply? > instead of poisoning the actual lame situation? > > > On Tue, Jul 15, 2014

Re: [sqlite] capturing and testing a hot journal

I already accepted your apologies why don't you give some air simply? instead of poisoning the actual lame situation? On Tue, Jul 15, 2014 at 4:46 PM, mm.w <0xcafef...@gmail.com> wrote: > am not else you don't understand one single line of my previous comments, > you are just pissed off and not

Re: [sqlite] capturing and testing a hot journal

am not else you don't understand one single line of my previous comments, you are just pissed off and not able to calling off thing I did On Tue, Jul 15, 2014 at 4:44 PM, mm.w <0xcafef...@gmail.com> wrote: > you dare to affirm that I affirm , I > > > On Tue, Jul 15, 2014 at 4:43 PM, mm.w

Re: [sqlite] capturing and testing a hot journal

you dare to affirm that I affirm , I On Tue, Jul 15, 2014 at 4:43 PM, mm.w <0xcafef...@gmail.com> wrote: > hello, if you think so, I have noting to say to you, because you already > made your judgement without giving a right of answer, so be it. > > > On Tue, Jul 15, 2014 at 4:18 PM, RSmith

Re: [sqlite] capturing and testing a hot journal

hello, if you think so, I have noting to say to you, because you already made your judgement without giving a right of answer, so be it. On Tue, Jul 15, 2014 at 4:18 PM, RSmith wrote: > > On 2014/07/16 00:03, mm.w wrote: > >> And to finally be clear I am a plain guy I don't

Re: [sqlite] capturing and testing a hot journal

On 2014/07/16 00:03, mm.w wrote: And to finally be clear I am a plain guy I don't hide behind the curtain like you lamely try, that's public and solely addressed to you//.. I'd really like to not have another go at this thread, and again would like to apologise to the onlookers - but would

Re: [sqlite] capturing and testing a hot journal

anyway no drama here, I am not here to fight or getting personal, that's just on a situation I ve seen I get passionate that's all On Tue, Jul 15, 2014 at 3:28 PM, mm.w <0xcafef...@gmail.com> wrote: > I agree I am not the best "communication guy ever born" but I can say no > guys don't

Re: [sqlite] capturing and testing a hot journal

I agree I am not the best "communication guy ever born" but I can say no guys don't roll-back this is a terrible idea without getting personal On Tue, Jul 15, 2014 at 3:26 PM, Simon Slavin wrote: > > On 15 Jul 2014, at 11:03pm, mm.w <0xcafef...@gmail.com> wrote: > > >

Re: [sqlite] capturing and testing a hot journal

On 15 Jul 2014, at 11:03pm, mm.w <0xcafef...@gmail.com> wrote: > Simon is enough solid to answer himself Thank you. > I don't think he is > crying in the corner True. But if lots of people all post the same advice it can be more persuasive than one person posting the same thing again and

Re: [sqlite] capturing and testing a hot journal

And to finally be clear I am a plain guy I don't hide behind the curtain like you lamely try, that's public and solely addressed to you, no rocket science here when you are honest with yourself, but I can tell you, I will be the last guy here to burn you out personally, if you don't like arguing

Re: [sqlite] Preferred cast in C#

> On 15 Jul 2014, at 8:05pm, Drago, William @ MWG - NARDAEAST > wrote: > >> On 15 Jul 2014, at 6:42pm, Edward Ned Harvey (sqlite) >> wrote: >> >>> In C#, using the System.Data.Sqlite.Core package, which is described >>> as "The official SQLite

Re: [sqlite] capturing and testing a hot journal

don't try to look good when you are not. thank you. On Tue, Jul 15, 2014 at 2:02 PM, mm.w <0xcafef...@gmail.com> wrote: > why Apologies when it's solely addressed to you, please don't be a hypocrite > everybody can understand that in your first paragraph you are out of the > topic and the

Re: [sqlite] capturing and testing a hot journal

why Apologies when it's solely addressed to you, please don't be a hypocrite everybody can understand that in your first paragraph you are out of the topic and the line. thank you, apology accepted... (SIK) On Tue, Jul 15, 2014 at 1:59 PM, RSmith wrote: > On 2014/07/15

Re: [sqlite] capturing and testing a hot journal

On 2014/07/15 22:33, mm.w wrote: whine_spam++ // Apologies to all. Not sure if this is intended for Simon too, or only myself - either way, would you be so kind as to take it off-list, it is of no benefit to others here - much appreciated.

Re: [sqlite] capturing and testing a hot journal

to be clear, I am not a social worker but an engineer and never argue when I consider that's a lost cause, if you cannot straight talking 5 minutes in your life... don't ask me to say "bravo", it's not big deal my little ducky when I think the contrary especially on a topic I know from the outside

Re: [sqlite] capturing and testing a hot journal

sorry, I did not enter in the specifics of the answer, because it's driven by personal feelings which are off topic and surely misplaced but I will pass on this childish frustrations which are not my concern, bluntly I do not care, if you take that personally it's your problem, deal with it.

Re: [sqlite] [bug] sqlite memory corruption (use by digikam)

On 07/16/2014 03:22 AM, Dan Kennedy wrote: On 07/15/2014 09:06 PM, Mathieu Clabaut wrote: Hello, Digikam bug https://bugs.kde.org/show_bug.cgi?id=323888#c89 seems to be caused by a sqlite memory leak It looks very much like the program is not calling sqlite3_close(). If you have a small

Re: [sqlite] [bug] sqlite memory corruption (use by digikam)

On 07/15/2014 09:06 PM, Mathieu Clabaut wrote: Hello, Digikam bug https://bugs.kde.org/show_bug.cgi?id=323888#c89 seems to be caused by a sqlite memory leak It looks very much like the program is not calling sqlite3_close(). If you have a small program that shows SQLite leaking memory

Re: [sqlite] capturing and testing a hot journal

morality good question, wrong solution from the op + wrong solution gain of simon to endorse the bad design, so then when you are serious you roll-back to the entry point not the broken branch. On Tue, Jul 15, 2014 at 1:12 PM, mm.w <0xcafef...@gmail.com> wrote: > to be clear, the original

Re: [sqlite] capturing and testing a hot journal

to be clear, the original solution does not answer the question, it tries to relay on sqlite specifics, where specifics are beyond the sqlite small world. you must read back the first request to understand. On Tue, Jul 15, 2014 at 1:10 PM, mm.w <0xcafef...@gmail.com> wrote: > yes that's exactly

Re: [sqlite] capturing and testing a hot journal

yes that's exactly what I said thank you to confirm my dear 8) " If the pipe dies halfway then the app would know it" sorry LOL On Tue, Jul 15, 2014 at 12:13 PM, RSmith wrote: > > On 2014/07/15 19:06, mm.w wrote: > >> Simon your design-idea do not reflect any reality, this

Re: [sqlite] capturing and testing a hot journal

On 2014/07/15 19:06, mm.w wrote: Simon your design-idea do not reflect any reality, this is weak, there is a lack of experience on the topic and we can feel it. Strange, I feel nothing of the sort and the only weak thing I can see involves the correlation between the computer and social skill

Re: [sqlite] Preferred cast in C#

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Simon Slavin > Sent: Tuesday, July 15, 2014 2:35 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Preferred cast in C# > > > On 15 Jul 2014, at

[sqlite] System.Data.SQLite - issues

Hi, Below are the two issues I would like to report for SQLite .Net client. 1. SQLiteDataReader.GetString() method: The method fails with "Invalid cast exception" when you try to retrieve a number stored in a text field. 2. SQLiteDataReader.GetValue performance in version 1.0.93: This method is

[sqlite] [bug] sqlite memory corruption (use by digikam)

Hello, Digikam bug https://bugs.kde.org/show_bug.cgi?id=323888#c89 seems to be caused by a sqlite memory leak and is said to be corrected with slqlite 3.8.5, but as shown in https://bugs.kde.org/show_bug.cgi?id=321680 a similar problem appear in digikam 4.0.0 with sqlite 3.8.5. Best regards,

Re: [sqlite] Preferred cast in C#

On 15 Jul 2014, at 6:42pm, Edward Ned Harvey (sqlite) wrote: > In C#, using the System.Data.Sqlite.Core package, which is described as "The > official SQLite database engine" and published by "SQLite Development Team" That's Joe's code. You probably got that off of git

Re: [sqlite] Preferred cast in C#

On 2014/07/15 19:42, Edward Ned Harvey (sqlite) wrote: From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- boun...@sqlite.org] On Behalf Of RSmith System.DBNull is not a native SQLite construct, it is probably one of the third party connectors. In C#, using the

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

On 15 Jul 2014, at 6:58pm, Mayank Kumar (mayankum) wrote: > I was calling it after sqlite3_open,I will try calling before sqlite3_open > and update the thread. When you call sqlite3_config() after sqlite3_open() it returns SQLITE_MISUSE to tell you you're doing it wrong.

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

I was calling it after sqlite3_open,I will try calling before sqlite3_open and update the thread. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Roger Binns Sent: Tuesday, July 15, 2014 10:05 AM To: General Discussion of

Re: [sqlite] Preferred cast in C#

> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of RSmith > > > System.DBNull is not a native SQLite construct, it is probably one of the > third > party connectors. In C#, using the System.Data.Sqlite.Core package, which is described as "The

Re: [sqlite] capturing and testing a hot journal

but it does not imply that in rare cases that either of files are not busted, that's the reason of "backups" being able to recover last seen (the lossy case, shit happens) On Tue, Jul 15, 2014 at 10:06 AM, mm.w <0xcafef...@gmail.com> wrote: > Simon your design-idea do not reflect any reality,

Re: [sqlite] capturing and testing a hot journal

Simon your design-idea do not reflect any reality, this is weak, there is a lack of experience on the topic and we can feel it. "You won't have anything to commit. If your application really had crashed it wouldn't have any transaction data to commit. If your application had not crashed the

Re: [sqlite] Sometimes when my process restarts, it returns error "database is locked"

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 14/07/14 22:39, Mayank Kumar (mayankum) wrote: > The file system is ext3. I am calling this api > > sqlite3_config(SQLITE_CONFIG_LOG, errorLogCallback, NULL); [...] > Is my understanding correct since my callback is not getting called ? Did you

Re: [sqlite] Preferred cast in C#

On 2014/07/15 13:48, Edward Ned Harvey (sqlite) wrote: I would really love to have an easy way of putting a long? into the database, and then getting a long? back out. Maybe it exists and I'm just doing it the hard way right now... I guess what I'm really getting at is this: The 5 data types

Re: [sqlite] capturing and testing a hot journal

On 15 Jul 2014, at 2:53pm, mm.w <0xcafef...@gmail.com> wrote: > ok sorry, I did not red all thru, may you simply sha1 local and remote ? if > != commit again You won't have anything to commit. If your application really had crashed it wouldn't have any transaction data to commit. If your

Re: [sqlite] R-tree index database

Grzegorz Sikorski wrote: > On 15/07/14 16:13, Clemens Ladisch wrote: >> Grzegorz Sikorski wrote: >>> I have a database file with single virtual table storing R*tree index. >>> There is very strange behaviour I observe: the more rows I put into >>> this table the longer sqlite3_open_v2 operation on

Re: [sqlite] R-tree index database

Grzegorz Sikorski wrote: > I have a database file with single virtual table storing R*tree index. > There is very strange behaviour I observe: the more rows I put into > this table the longer sqlite3_open_v2 operation on the database takes. SQLite does not read table contents when opening a

Re: [sqlite] capturing and testing a hot journal

forgot if != commit again or restore if local unusable (lossy scenario) On Tue, Jul 15, 2014 at 7:01 AM, mm.w <0xcafef...@gmail.com> wrote: > yes indeed the "journal tweaking" would work solely for this special file > case, comparing local and remote that's how for instance git works like >

Re: [sqlite] pragma and prepare statement

The second point seems to explain my problems thanks you 2014-07-10 18:05 GMT+02:00 Dan Kennedy : > On 07/10/2014 08:44 PM, Baptiste Daroussin wrote: >> >> Hi, >> >> We are using sqlite intensively in out developement and we discovered >> that apparently we cannot create a

Re: [sqlite] capturing and testing a hot journal

yes indeed the "journal tweaking" would work solely for this special file case, comparing local and remote that's how for instance git works like many other sync software, I don't know the API but is the box thing notify you "on start transaction" then "on close", if not it sucks ? On Tue, Jul

Re: [sqlite] capturing and testing a hot journal

ok sorry, I did not red all thru, may you simply sha1 local and remote ? if != commit again On Tue, Jul 15, 2014 at 12:49 AM, Simon Slavin wrote: > > On 15 Jul 2014, at 2:20am, William Drago wrote: > > > The software doesn't crash on its own;

Re: [sqlite] Preferred cast in C#

> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Edward Ned Harvey (sqlite) > > I would really love to have an easy way of putting a long? into the database, > and then getting a long? back out. Maybe it exists and I'm just doing it the > hard way

Re: [sqlite] Preferred cast in C#

> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Hick Gunter > > Why is the column nullable if you require a default value to be returned? The default value for long? or string or byte[] is null. Which makes perfect sense.

Re: [sqlite] Preferred cast in C#

> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Random Coder > > Could you not do something like this to handle the nullable types? > > T GetValue(string field) > { > object obj = reader[field]; > > if (obj is

Re: [sqlite] Preferred cast in C#

> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Joseph L. Casale > > > I would really love to have an easy way of putting a long? into the > > database, > and then getting a long? back out. > > What do you want to happen when the column is null

[sqlite] R-tree index database

Hi, I have a database file with single virtual table storing R*tree index. There is very strange behaviour I observe: the more rows I put into this table the longer sqlite3_open_v2 operation on the database takes. The database open/close performance hit is huge and growing linearly with the

Re: [sqlite] capturing and testing a hot journal

On 15 Jul 2014, at 2:20am, William Drago wrote: > The software doesn't crash on its own; I'm forcing it to crash with a > divide-by-zero for test purposes. This doesn't happen in actual use and > there's no reason other than a power failure for a transaction to not

Re: [sqlite] Preferred cast in C#

Why is the column nullable if you require a default value to be returned? -Ursprüngliche Nachricht- Von: Random Coder [mailto:random.co...@gmail.com] Gesendet: Dienstag, 15. Juli 2014 03:50 An: General Discussion of SQLite Database Betreff: Re: [sqlite] Preferred cast in C# Could you not