Why is the column nullable if you require a default value to be returned?
-Ursprüngliche Nachricht-
Von: Random Coder [mailto:[email protected]]
Gesendet: Dienstag, 15. Juli 2014 03:50
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] Preferred cast in C#
Could you not
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 commit
> successfully. But
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 n
> From: [email protected] [mailto:sqlite-users-
> [email protected]] 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 as
> From: [email protected] [mailto:sqlite-users-
> [email protected]] 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 System.DBNull
> From: [email protected] [mailto:sqlite-users-
> [email protected]] 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.
> From: [email protected] [mailto:sqlite-users-
> [email protected]] 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 r
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; I'm forcing it to crash with a
> divide-by-zero for
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 15
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 statement with a pragma
forgot if != commit again or restore if local unusable (lossy scenario)
On Tue, Jul 15, 2014 at 7:01 AM, mm.w <[email protected]> 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
> many
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 databa
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
On 15 Jul 2014, at 2:53pm, mm.w <[email protected]> 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 appl
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
-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 ch
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 tran
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 <[email protected]> wrote:
> Simon your design-idea do not reflect any reality, th
> From: [email protected] [mailto:sqlite-users-
> [email protected]] 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
offi
I was calling it after sqlite3_open,I will try calling before sqlite3_open and
update the thread.
-Original Message-
From: [email protected] [mailto:[email protected]]
On Behalf Of Roger Binns
Sent: Tuesday, July 15, 2014 10:05 AM
To: General Discussion of SQL
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. The fact that you di
On 2014/07/15 19:42, Edward Ned Harvey (sqlite) wrote:
From: [email protected] [mailto:sqlite-users-
[email protected]] 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
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 or nuget.org. The
de
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,
-
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 c
> -Original Message-
> From: [email protected] [mailto:sqlite-users-
> [email protected]] 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 6:42pm,
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
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 is weak, there is
>>
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 <[email protected]> wrote:
> yes that's exactly
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 <[email protected]> wrote:
> to be clear, the original solut
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 pleas
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
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.
thank
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
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.
_
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 22:33, mm.w wrote:
>
>>
don't try to look good when you are not.
thank you.
On Tue, Jul 15, 2014 at 2:02 PM, mm.w <[email protected]> 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 line.
> 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 database engine" and published by "SQLite
>>> Dev
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
st
On 15 Jul 2014, at 11:03pm, mm.w <[email protected]> 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 aga
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 <[email protected]> wrote:
>
> > Simon is enough solid to a
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 <[email protected]> wrote:
> I agree I am not the best "communication guy ever born" but I can say no
> guys don't roll-back
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 lik
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 hide behind the curt
you dare to affirm that I affirm , I
On Tue, Jul 15, 2014 at 4:43 PM, mm.w <[email protected]> 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 wro
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 <[email protected]> wrote:
> you dare to affirm that I affirm , I
>
>
> On Tue, Jul 15, 2014 at 4:43 PM, mm.w <0xcafe
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 <[email protected]> wrote:
> am not else you don't understand one single line of my previous comments,
> you are just pissed off and not
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 <[email protected]> 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 at
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 <[email protected]> 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 <0xcafef...@gm
and moreover you bluntly lie
On Tue, Jul 15, 2014 at 4:53 PM, mm.w <[email protected]> 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 <[email protected]> wrote:
>
>> seriously Rsmith \\\ 3
oh boy
On Tue, Jul 15, 2014 at 5:10 PM, mm.w <[email protected]> wrote:
> and moreover you bluntly lie
>
>
> On Tue, Jul 15, 2014 at 4:53 PM, mm.w <[email protected]> wrote:
>
>> I am sorry I am jocking but you 'r calling of for white flag and use it
>> to charge again.
>>
>>
>> On Tu
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 <[email protected]> wrote:
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 <[email protected]> wrote:
> I thought you were a good person... seriously? what it is your issue with
> ju
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 <[email protected]> wrote:
> almost 2 hours of of unbelievable crap seriously? just for accusing me of
> bad behaviors towards Simon on a topic you
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 <[email protected]> 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, mm
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 <[email protected]> wrote:
> a
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 to temporarily block him f
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 <[email protected]> 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 sha
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 <[email protected]> wrote:
> if y
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
11,w,2
> From: [email protected] [mailto:sqlite-users-
> [email protected]] 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 off
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 fa
> 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 id BETWEEN 8 AND 14, bu
mm.w wrote:
>>
Can someone please get this a*h*l* banned?
--
Will
___
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 *pKeyInfo,
In this case, sqlite3VdbeAllocUnpackedRecord is called with pSpace = 0 and
szSpace = 0.
The calculated value of nOff will also be 0, since pSpace is 0. nByte must be
greater than zero, as it is the sum of two positive terms.
Therefore the test "if( nByte>szSpace+nOff )" will be true, and the co
66 matches
Mail list logo
