Re: [sqlite] Help with custom collation

ite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] Help with custom collation On 02/02/2017 02:08 AM, x wrote: > Thanks Clemens. You’re right about changing the UTF8String* to char* as it > now works but when trying it with a column containing Unicode characters it > didn’t. I’d hav

Re: [sqlite] Help with custom collation

ion16() should point to a buffer containing a utf-16 string. Not utf-8. Dan. From: Clemens Ladisch<mailto:clem...@ladisch.de> Sent: 01 February 2017 17:32 To: sqlite-users@mailinglists.sqlite.org<mailto:sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] Help with c

Re: [sqlite] Help with custom collation

ers@mailinglists.sqlite.org> Betreff: Re: [sqlite] Help with custom collation The interface your (simple) function must support is: void xFunc(sqlite3_context*,int,sqlite3_value**) with the first parameter being the sqlite3_context, the second parameter being the number of arguments passed in, and the

Re: [sqlite] Help with custom collation

Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von x Gesendet: Mittwoch, 01. Februar 2017 17:45 An: sqlite-users@mailinglists.sqlite.org Betreff: [sqlite] Help with custom collation The collation function used was as follows int Compare(void* Data, int

Re: [sqlite] Help with confirming a couple of error traces

Thanks, Richard. I think that I fully understand what happens now. Thanks again for your patience. May I ask that do you see null pointer deferences during development regularly? Shaobo Richard Hipp 于2017年2月1日周三 下午6:52写道： > On 2/1/17, Shaobo He wrote: >

Re: [sqlite] Help with confirming a couple of error traces

On 2/1/17, Shaobo He wrote: > Thanks for your reply. I repeated the experiment by setting > db->mallocFailed upon return. You are right that there is no segmentation > fault (there were some assertion failures: e.g, "sqlite3OomClear: Assertion > `db->lookaside.bDisable>0'

Re: [sqlite] Help with confirming a couple of error traces

Thanks for your reply. I repeated the experiment by setting db->mallocFailed upon return. You are right that there is no segmentation fault (there were some assertion failures: e.g, "sqlite3OomClear: Assertion `db->lookaside.bDisable>0' failed"). Instead I got error messages saying out of memory.

Re: [sqlite] Help with confirming a couple of error traces

On 2/1/17, Shaobo He wrote: > > Basically, the error trace indicate that `sqlite3SrcListAppend` can return > a null pointer under the presence of OOM and this return value can > propagate to somewhere in the program, resulting in a null pointer > deference. An OOM

Re: [sqlite] Help with confirming a couple of error traces

Hi Richard, all, It's so nice of you to help out. Now we understand better what we should do to reduce the number of false positives. Thanks a lot. I'm sorry to bother you again. But it would be great if you could provide some feedback on the new error trace returned by our tool. Basically, the

Re: [sqlite] Help with custom collation

17 17:32 To: sqlite-users@mailinglists.sqlite.org<mailto:sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] Help with custom collation x wrote: > int Compare(void* Data, int Len1, const void *s1, int Len2, const void *s2) > { > const UTF8String *S1 = static

Re: [sqlite] Help with custom collation

x wrote: > int Compare(void* Data, int Len1, const void *s1, int Len2, const void *s2) > { > const UTF8String *S1 = static_cast(s1), > *S2 = static_cast(s2); > return 0; > } > > if (sqlite3_create_collation(SQLiteDB, "Compare", SQLITE_UTF8, NULL, > ) != SQLITE_OK)

[sqlite] Help with custom collation

The collation function used was as follows int Compare(void* Data, int Len1, const void *s1, int Len2, const void *s2) { const UTF8String *S1 = static_cast(s1), *S2 = static_cast(s2); return 0; } Which was registered with the following code if

Re: [sqlite] Help with confirming a couple of error traces

On 1/31/17, Shaobo He wrote: > Hi there, > > My name is Shaobo He and I am a graduate student at University of Utah. I > am applying a couple of static analysis tools to C projects. The tools I am > using reports a few partial error traces about null pointer dereferences. I

[sqlite] Help with confirming a couple of error traces

Hi there, My name is Shaobo He and I am a graduate student at University of Utah. I am applying a couple of static analysis tools to C projects. The tools I am using reports a few partial error traces about null pointer dereferences. I was wondering if you could help me to identify whether they

Re: [sqlite] Help with assigning default values...

Thanks. Yes, saw it. -Original Message- From: Simon Slavin Sent: Tuesday, December 20, 2016 11:54 PM To: SQLite mailing list ; jic...@barrioinvi.net Subject: Re: [sqlite] Help with assigning default values... On 20 Dec 2016, at 9:37pm, jose isaias cabrera <jic...@barrioinvi.

Re: [sqlite] Help with assigning default values...

On 20 Dec 2016, at 9:37pm, jose isaias cabrera wrote: > Trying to learn or understand constraints. Will you please look at the > following... Answers were posted to the mailing list. If you’re not seeing them there’s something wrong with your subscription. Simon.

[sqlite] Help with assigning default values...

Trying to learn or understand constraints. Will you please look at the following... sqlite> PRAGMA foreign_keys=1; sqlite> BEGIN TRANSACTION; sqlite> DROP TABLE IF EXISTS Years; sqlite> CREATE TABLE Years ...> ( ...> IDYear INTEGER PRIMARY KEY, ...> Year TEXT DEFAULT '1980'

Re: [sqlite] Help Installing SQLite on a Windows 8.1 PC

On 6 Jul 2016, at 8:29pm, Krista M Whipple wrote: > I have downloaded the two 64-bit Windows files on my Windows 8.1 PC, but I > cannot get SQLite to install on my PC. > > > > Any help or directions would be greatly appreciated, I understand the source of your

Re: [sqlite] Help Installing SQLite on a Windows 8.1 PC

Hi Krista, Regarding: I have downloaded the two 64-bit Windows files on my Windows 8.1 PC, Are you referring to sqlite.exe and maybe sqlite.dll ? Regarding: but I cannot get SQLite to install on my PC. I'm not sure I understand you. Maybe you could rewrite this in form of something

[sqlite] Help Installing SQLite on a Windows 8.1 PC

Dear SQLite Users, I am in a Predictive Analytics course which requires the use of SQLite. I am not a developer or an analyst and have zero hands on experience with working with software for databases. I have downloaded the two 64-bit Windows files on my Windows 8.1 PC, but I cannot get

[sqlite] help with query

Simon... Yes I forgot the "where sn.nm='std1';" restriction and... also see you've used 2 inner joins. Thank you very much for your thoroughness. It's very much appreciated. > > On 06 April 2016 at 12:41 Simon Davies > wrote: > > > On 6 April 2016 at 12:22, e-mail mgbg25171 >

[sqlite] help with query

On 6 April 2016 at 12:22, e-mail mgbg25171 wrote: > Here are my tables specified as... tbl_nm | col1, col2... > std_nms | id, nm > raw_nms | id, nm > nm_pairs | id, std_nms_id, raw_nms_id > > I'm wondering how to supply a single std_nms.nm and get back a list of pairs > i.e. std_nm.nm,

[sqlite] help with my query...cracked it!

Orig question Here are my tables specified as... tbl_nm | col1, col2... std_nms | id, nm raw_nms | id, nm nm_pairs | id, std_nms_id, raw_nms_id I'm wondering how to supply a single std_nms.nm and get back a list of pairs i.e. std_nm.nm, raw_nms.nm that reflect each record in nm_pairs with a

[sqlite] help with query

Here are my tables specified as... tbl_nm | col1, col2... std_nms | id, nm raw_nms | id, nm nm_pairs | id, std_nms_id, raw_nms_id I'm wondering how to supply a single std_nms.nm and get back a list of pairs i.e. std_nm.nm, raw_nms.nm that reflect each record in nm_pairs with a std_nms_id =

[sqlite] Help needed for COPY Command.

Thank you all for your responses. I'll try your inputs and let me see which one suits my requirement. Thanks & Best Regards, - Mahi On Mon, Mar 28, 2016 at 6:27 PM, Don V Nielsen wrote: > You need to handle the load yourself. Since you are talking bulk load, a > scripting language is probably

[sqlite] Help needed for COPY Command.

about user friendly "alias/shortcut" ? > > Cheers ! > > Fri Mar 25 2016 10:48:52 PM CET from "James K. Lowden" > > Subject: Re: [sqlite] Help needed for COPY > >Command. > > > > On Fri, 25 Mar 2016 17:18:16 +0100 > > "Domin

[sqlite] Help needed for COPY Command.

On 28 Mar 2016, at 6:49am, Mahi Gurram wrote: > I have tried .import and its working for command line interface. But i need > to do a bulk import (copy data from file into table) from c interface. Sorry, but SQLite has no facilities for handling text files. It reads and writes to its own

[sqlite] Help needed for COPY Command.

You need to handle the load yourself. Since you are talking bulk load, a scripting language is probably out of the question because they are too slow. I used C# with the System.Data.Sqlite binary. The db handling you need to worry about is the following: connection to db prepare an insert

[sqlite] Help needed for COPY Command.

Hello ! Have you ever heard about user friendly "alias/shortcut" ? Cheers ! > Fri Mar 25 2016 10:48:52 PM CET from "James K. Lowden" > Subject: Re: [sqlite] Help needed for COPY >Command. > > On Fri, 25 Mar 2016 17:18:16 +0100 > "Domingo Al

[sqlite] Help needed for COPY Command.

On Fri, 25 Mar 2016 17:18:16 +0100 "Domingo Alvarez Duarte" wrote: > Why not have direct command ".export table_name" and internally it > does all commands you mention in one go, simple and intuitively. Importing has unique requirements. .import filename tablename is quite

[sqlite] Help needed for COPY Command.

command I also expected the "export" command, and it seems that I'm not alone. Cheers ! > Fri Mar 25 2016 03:49:37 PM CET from "Simon Slavin" > Subject: Re: [sqlite] Help needed for COPY Command. > > On 25 Mar 2016, at 11:33am, Richard Hipp wrote: > >

[sqlite] Help needed for COPY Command.

Hi, Good Morning. I'm trying to use the COPY command but for some reason i'm unable to make it work. As per the doc, below is the query syntax: *copy* *conflict-algorithm* *table-name * *file-name * ? *column-separator*? ?*null-indicator*? I have created a file with data and tried

[sqlite] Help needed for COPY Command.

On 25 Mar 2016, at 11:33am, Richard Hipp wrote: > On 3/25/16, Simon Slavin wrote: > >> There is no COPY command in SQLite. > > There *was* a COPY command, way back in SQLite 2.x. It was omitted > from SQLite3, circa 2004. Wow. On 25 Mar 2016, at 12:22pm, Domingo Alvarez Duarte wrote: >

[sqlite] Help needed for COPY Command.

Hello ! I also asked the same thing a few days ago and received the same answer. But discovered that it can be somehow emulated by "import tablename" using csv. Would be a good idea to have the complementary of ".import" -> ".export". Cheers ! Cheers ! ?

[sqlite] Help needed for COPY Command.

On 25 Mar 2016, at 10:00am, Mahi Gurram wrote: > I'm trying to use the COPY command but for some reason i'm unable to make > it work. There is no COPY command in SQLite. > As per the doc, below is the query syntax: > > *copy* *conflict-algorithm* *table-name * *file-name * ? >

[sqlite] Help needed for COPY Command.

On 3/25/16, Simon Slavin wrote: > > On 25 Mar 2016, at 10:00am, Mahi Gurram wrote: > >> I'm trying to use the COPY command but for some reason i'm unable to make >> it work. > > There is no COPY command in SQLite. There *was* a COPY command, way back in SQLite 2.x. It was omitted from SQLite3,

[sqlite] Help SQlite

On 10/6/15, jonathan wrote: >> Hello my friends, i need your help, i have problems with the use special >> character for example "?" , work with vb net. The problem consist when >> save >> this character in the data base sqlite, this chance in another character. >> I >> hope your help. Thank you.

[sqlite] Help SQlite

> Hello my friends, i need your help, i have problems with the use special > character for example "?" , work with vb net. The problem consist when save > this character in the data base sqlite, this chance in another character. I > hope your help. Thank you. Bach. Jonathan Mej?a Acosta

[sqlite] Help with ext/misc/regex.c extension

Hello ! Now I realize that in the function re_balanced I also need restore the ReInput back in case of not matching: ___ static int re_balanced( ??? ReInput *p, ??? int cb, /* char that opens a balanced expression */ ??? int ce? /* char that closes a balanced expression */ ){ ? int c

[sqlite] Help with ext/misc/regex.c extension

Hello ! I'm trying to add a new option to ext/misc/regex.c it's "\p()" that's like the LUA operator "%b" %b/xy/, where /x/ and /y/ are two distinct characters; such item matches strings that start with?/x/, end with?/y/, and where the /x/ and /y/ are /balanced/. This means that, if one reads

[sqlite] Help with understanding sqlite3_mprintf_int test expected result

On 7/24/15, Viktor Jancik wrote: > What about these tests? > > do_test printf-1.17.1 { > sqlite3_mprintf_int {abd: %2147483647d %2147483647x %2147483647o} 1 1 1 > } {} > do_test printf-1.17.2 { > sqlite3_mprintf_int {abd: %*d %x} 2147483647 1 1 > } {} > do_test printf-1.17.3 { >

[sqlite] Help with understanding sqlite3_mprintf_int test expected result

Discussion of SQLite Database" Sent: Friday, July 24, 2015 11:20:27 AM Subject: Re: [sqlite] Help with understanding sqlite3_mprintf_int test expected result What about these tests? do_test printf-1.17.1 { sqlite3_mprintf_int {abd: %2147483647d %2147483647x %2147483647o} 1 1 1

[sqlite] Help with understanding sqlite3_mprintf_int test expected result

} {/1.00/} Why are 1.17.3, 3.8, 3.9, 13.7 not getting shot down, while the rest are? Thank you, Viktor - Original Message - From: "Richard Hipp" <d...@sqlite.org> To: "General Discussion of SQLite Database" Sent: Thursday, July 23, 2015 4:45:15 PM

[sqlite] Help with understanding sqlite3_mprintf_int test expected result

Richard, He wrote (ans I wasted my time reading) > If you are reading this email, but you are not gcc-help administrator, > please, please, forward this email to the administrator or simple reply to > all. GCC-help should know what to do with this message. He seems to be trying to contact the

[sqlite] Help with understanding sqlite3_mprintf_int test expected result

On 7/23/15, papa at arbolone.ca wrote: > I have unsubscribe many, many times, but you have a serious problem > receiving the message. I am papa at arbolone.ca, please, please unsubscribe > me. You are not a subscriber. If you are still receiving messages, it probably means that you subscribed

[sqlite] Help with understanding sqlite3_mprintf_int test expected result

: Richard Hipp Sent: Thursday, July 23, 2015 10:45 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Help with understanding sqlite3_mprintf_int test expected result On 7/23/15, Viktor Jancik wrote: > Hi, I am trying to create a patch for sqlite in RHEL6 to backport a > security

[sqlite] Help with understanding sqlite3_mprintf_int test expected result

On 7/23/15, Viktor Jancik wrote: > Hi, I am trying to create a patch for sqlite in RHEL6 to backport a security > fix: > https://www.sqlite.org/src/info/aeca95ac77f6f320 > > That is to sqlite version 3.6.20, and I can't understand why the expected > result of do_test printf-1.17.4 is /.*/ The

[sqlite] Help with understanding sqlite3_mprintf_int test expected result

Hi, I am trying to create a patch for sqlite in RHEL6 to backport a security fix: https://www.sqlite.org/src/info/aeca95ac77f6f320 That is to sqlite version 3.6.20, and I can't understand why the expected result of do_test printf-1.17.4 is /.*/ The test is added in the commit I linked. Could

Re: [sqlite] help with query

Maybe something like this would work for you: SELECT * FROM table WHERE data1 IN (SELECT data1 FROM table GROUP BY data1 HAVING count(*)>=3); ~snowbiwan -- View this message in context:

Re: [sqlite] help with query

.@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Hajo Locke >Sent: Tuesday, 13 January, 2015 00:30 >To: sqlite-users@sqlite.org >Subject: [sqlite] help with query > >Hello list, > >i have a problem finding right query, hope you can help me. >I have a sampl

Re: [sqlite] help with query

,count() AS count FROM table GROUP BY data1 HAVING count >= 3)); -Ursprüngliche Nachricht- Von: Hajo Locke [mailto:hajo.lo...@gmx.de] Gesendet: Dienstag, 13. Jänner 2015 08:30 An: sqlite-users@sqlite.org Betreff: [sqlite] help with query Hello list, i have a problem finding right query,

Re: [sqlite] help with query

..@gmx.de] Gesendet: Dienstag, 13. Jänner 2015 08:30 An: sqlite-users@sqlite.org Betreff: [sqlite] help with query Hello list, i have a problem finding right query, hope you can help me. I have a sample table like this: http://pastebin.com/8qyBzdhH I want to select all lines where at least 3 lines

[sqlite] help with query

Hello list, i have a problem finding right query, hope you can help me. I have a sample table like this: http://pastebin.com/8qyBzdhH I want to select all lines where at least 3 lines in column data1 have same value. My expected result-set ist this: http://pastebin.com/UcaXLVx9 How can this

Re: [sqlite] HELP sqlite3 used in vxworks has some problem

> > > Please try the patch at > > > > http://www.sqlite.org/src/info/b0f6b91f36b503d8ba8d5257bb194f8c1afb483 > > > 3 and > > > see if that fixes the problem. > > > > > > > I think that fixes unixDelete. Running on the vxWorks dosFs disk > > everything works as before. > > > > If I use the host

Re: [sqlite] HELP sqlite3 used in vxworks has some problem

??? >> Sent: 02 September 2014 13:41 >> To: General Discussion of SQLite Database >> Subject: Re: [sqlite] HELP sqlite3 used in vxworks has some problem >> >> >> >> firstly : >> Even if I used >> #if OS_VXWORKS >> || osA

Re: [sqlite] HELP sqlite3 used in vxworks has some problem

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of ??? > Sent: 02 September 2014 13:41 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] HELP sqlite3 used in vxworks has some problem

Re: [sqlite] HELP sqlite3 used in vxworks has some problem

0 >> To: General Discussion of SQLite Database >> Subject: Re: [sqlite] HELP sqlite3 used in vxworks has some problem >> > > Please try the patch at >> > > >> http://www.sqlite.org/src/info/b0f6b91f36b503d8ba8d5257bb194f8c1afb483 >> > >

Re: [sqlite] HELP sqlite3 used in vxworks has some problem

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Richard Hipp > Sent: 01 September 2014 15:30 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] HELP sqlite3 used in vxwork

Re: [sqlite] HELP sqlite3 used in vxworks has some problem

gt; To: General Discussion of SQLite Database > > Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ > > > > Please try the patch at > > http://www.sqlite.org/src/info/b0f6b91f36b503d8ba8d5257bb194f8c1afb483 > > 3 and > > see if that fixes the problem.

Re: [sqlite] HELP sqlite3 used in vxworks has some problem

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Richard Hipp > Sent: 01 September 2014 14:39 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] HELP sqlite3 used in vxworks has somepr

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Mon, Sep 1, 2014 at 7:04 AM, Andy Ling wrote: > > This can be fixed by changing the patch to something like... > > #if OS_VXWORKS > }else if( errno==0x380003 || errno == 13){ /* == > S_dosFsLib_FILE_NOT_FOUND */ > rc = SQLITE_IOERR_DELETE_NOENT; > #endif > >

Re: [sqlite] HELP sqlite3 used in vxworks has some problem

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Jan Nijtmans > Sent: 01 September 2014 12:29 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] HELP sqlite3 used in vxworks has somepro

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

2014-09-01 13:04 GMT+02:00 Andy Ling : > Although this doesn't feel right having to keep extending the list of error > codes that are checked. > I'm not sure what else can be done though. Maybe some compile options that > let you choose. Here is a list of possible

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

> -Original Message- > From: Andy Ling > Sent: 29 August 2014 16:15 > To: '???'; sqlite-users@sqlite.org > Subject: RE: Re:RE: [sqlite] HELP sqlite3 used in vxworks has someproblem？ > > I would add a printf statement in unixDelete rather than rely on a break po

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

if that works. Regards Andy Ling From: 王庆刚 [mailto:2004wqg2...@163.com] Sent: 29 August 2014 15:49 To: Andy Ling; sqlite-users@sqlite.org Subject: Re:RE: [sqlite] HELP sqlite3 used in vxworks has someproblem？ hi, Andy Ling      I have removed the SQLITE_ENABLE_LOCKING_STYLE compile option, so

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

se). Regards Andy Ling From: 163 [mailto:2004wqg2...@163.com] Sent: 29 August 2014 03:34 To: Andy Ling Cc:sqlite-users@sqlite.org; Jan Nijtmans Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ i find it not enter the unixdelete. 发自我的 iPhone 在 2014年8月28日

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

OS your host system is running (Windows I assume in your case). Regards Andy Ling From: 163 [mailto:2004wqg2...@163.com] Sent: 29 August 2014 03:34 To: Andy Ling Cc: sqlite-users@sqlite.org; Jan Nijtmans Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ i find it not enter

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

e that doesn’t exist. So it will need > another check adding to unixDelete > > Regards > > Andy Ling > > > From: 王庆刚 [mailto:2004wqg2...@163.com] > Sent: 28 August 2014 15:01 > To: Andy Ling > Cc: sqlite-users@sqlite.org; Jan Nijtmans > Subject: Re:RE:

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

2014 15:01 To: Andy Ling Cc: sqlite-users@sqlite.org; Jan Nijtmans Subject: Re:RE: Re:RE: [sqlite] HELP sqlite3 used in vxworks has someproblem？ Is unixUnlink an function? If it is , but I can not find the funtion in sqlite3.c. Regards Wang Qinggang At 2014-08-28 00:03:23, "Andy

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

be good to find out what is causing the disk I/O error. Did you try putting some debug in unixUnlink? Regards Andy Ling From:王庆刚 [mailto:2004wqg2...@163.com] Sent: 27 August 2014 16:17 To: Andy Ling Cc:sqlite-users@sqlite.org; Jan Nijtmans Subject: Re:RE: [sqlite] HELP sqlite3 used

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

2014 15:01 To: Andy Ling Cc: sqlite-users@sqlite.org; Jan Nijtmans Subject: Re:RE: Re:RE: [sqlite] HELP sqlite3 used in vxworks has someproblem？ Is unixUnlink an function? If it is , but I can not find the funtion in sqlite3.c. Regards Wang Qinggang

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

sqlite.org; Jan Nijtmans Subject: Re:RE: [sqlite] HELP sqlite3 used in vxworks has someproblem？ Firstly: I fixed the disk I/O error by adding -DSQLITE_ENABLE_LOCKING_STYLE=1 to the build macro. Secondly: rc = sqlite3_open("D:\\WindRiver\\SqliteOne.db",); I change it to the

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

. What did you have to do? Are there any more changes that need feeding back into the source? Regards Andy Ling From:王庆刚 [mailto:2004wqg2...@163.com] Sent: 26 August 2014 13:44 To: Andy Ling Cc:sqlite-users@sqlite.org; Jan Nijtmans Subject: Re:RE: Re:Re: [sqlite] HELP sqlite3 used

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

; different error code being set. start by adding a printf to unixUnlink to > find out if that is your problem. > > Regards > > Andy Ling > > > > From: 王庆刚 [2004wqg2...@163.com] > Sent: 25 August 2014 13:13 > To:sqlite-users@sqlite.org; Andy Ling; Jan Ni

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

:2004wqg2...@163.com] Sent: 26 August 2014 13:44 To: Andy Ling Cc: sqlite-users@sqlite.org; Jan Nijtmans Subject: Re:RE: Re:Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ hi, Andy Ling: The error disk I / o error I have resolved ; but when I used the following code: rc = sqlite3_open(&q

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

that is your problem. Regards Andy Ling From: 王庆刚 [2004wqg2...@163.com] Sent: 25 August 2014 13:13 To:sqlite-users@sqlite.org; Andy Ling; Jan Nijtmans Subject: Re:Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ hi I modified the code sqlite3.c according to you method, as fo

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

August 2014 13:13 To: sqlite-users@sqlite.org; Andy Ling; Jan Nijtmans Subject: Re:Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ hi I modified the code sqlite3.c according to you method, as follow <http://fossil-scm.org/index.html/vpatch?from=dd5743a8239d1ce9=b68f65bb69a09

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

hi I modified the code sqlite3.c according to you method, as follow or I test you method in workbench3.2(vxworks6.8) , the build macros which I used

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

sqlite.org] on behalf of Jan Nijtmans [jan.nijtm...@gmail.com] Sent: 14 August 2014 08:19 To: General Discussion of SQLite Database Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ 2014-08-13 14:31 GMT+02:00 Andy Ling <andy.l...@quantel.com>: > > From: drhsql...@gm

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

2014-08-13 14:31 GMT+02:00 Andy Ling : > > From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of > Richard Hipp > > OK, I did find some cases where unlink() is called on files that do not > exist. > > > Anyway, a patch has now been checked in. > > Great,

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

> From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of Richard > Hipp > Sent: 13 August 2014 12:40 > To: Andy Ling > Cc: General Discussion of SQLite Database > Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ > OK, I did find so

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem ？

There's a class of errors that affect lots of programs, where backup and/or antivirus software have a file open "unexpectedly", which causes routine operations such as delete and rename to fail unexpectedly. I once promoted a fix for sqlite that combatted these problems by retrying such

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem ？

There's a class of errors that affect lots of programs, where backup and/or antivirus software have a file open "unexpectedly", which causes routine operations such as delete and rename to fail unexpectedly. I once promoted a fix for sqlite that combatted these problems by retrying such

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

--Original Message- > > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > > boun...@sqlite.org] On Behalf Of Andy Ling > > Sent: 13 August 2014 10:06 > > To: 'Richard Hipp' > > Cc: General Discussion of SQLite Database > > Subject: Re: [sqlite] HELP sqlit

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Andy Ling > Sent: 13 August 2014 10:06 > To: 'Richard Hipp' > Cc: General Discussion of SQLite Database > Subject: Re: [sqlite] HELP sqlite

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

> If your build is frequently trying to unlink a file that does not exist, > then something is wrong.  We need to figure out what that is and fix it. I have added some debug. First I create a brand new database called /ata0:3/testdb.sql Then I try and create a table and get an error from

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

...@sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: 12 August 2014 20:59 To: General Discussion of SQLite Database Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ On Tue, Aug 12, 2014 at 3:54 PM, Andy Ling <andy.l...@quantel.com> wrote: > > I did wond

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 3:54 PM, Andy Ling wrote: > > I did wonder if SQLite was making any assumptions about current > directories or the makeup of a file name. > No. Any filename will do. You have to specify -DSQLITE_ENABLE_8_3_NAMES if your filesystem is limited to

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Simon Slavin [slav...@bigfraud.org] Sent: 12 August 2014 20:16 To: General Discussion of SQLite Database Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ On 12 Aug 2014

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On 12 Aug 2014, at 7:46pm, Andy Ling wrote: > I can tell you the name of the database file is /ata0:3/testdb.sql and it > gets created. Can you add some commands to one of your apps using the library which create and delete a file in '/ata0:3/' and see they work ? In

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

n behalf of Richard > Hipp [d...@sqlite.org] > *Sent:* 12 August 2014 19:15 > > *To:* Andy Ling > *Cc:* General Discussion of SQLite Database; 王庆刚 > *Subject:* Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ > > What is the name of the file that SQLite is tr

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

Andy Ling From: drhsql...@gmail.com [drhsql...@gmail.com] on behalf of Richard Hipp [d...@sqlite.org] Sent: 12 August 2014 19:15 To: Andy Ling Cc: General Discussion of SQLite Database; 王庆刚 Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ What

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

What is the name of the file that SQLite is trying to delete but which does not exist? And what is the name of the corresponding database file? The name of the file that fails unlink() will give us a big clue about what is going wrong. On Tue, Aug 12, 2014 at 2:13 PM, Richard Hipp

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 2:00 PM, Andy Ling wrote: > Because the file doesn't exist. I assume because this is a brand new > database the file hasn't been created yet. > > I did debug this originally, but I don't remember the file it is trying to > delete. It definitely

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

] Sent: 12 August 2014 18:01 To: Andy Ling Cc: General Discussion of SQLite Database; 王庆刚 Subject: Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？ On Tue, Aug 12, 2014 at 12:45 PM, Andy Ling <andy.l...@quantel.com<mailto:andy.l...@quantel.com>> wrote: Doing a create table gene

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 12:45 PM, Andy Ling wrote: > Doing a create table generates a disk I/O error > > > > I open / create a new database with sqlite3_open_v2 > > > > *int* err = sqlite3_open_v2 (file, , SQLITE_OPEN_READWRITE | > SQLITE_OPEN_CREATE, "unix-namedsem") ;

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

generates a disk I/O error. I assume it is trying to remove a temporary file. Regards Andy Ling From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of Richard Hipp Sent: 12 August 2014 17:24 To: Andy Ling Cc: General Discussion of SQLite Database; 王庆刚 Subject: Re: [sqlite] HELP sq

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 11:40 AM, Andy Ling wrote: > > From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of > Richard Hipp > > Sent: 12 August 2014 15:46 > > > I put a new snapshot on the download page. Please try it, *without* > SQLITE_ENABLE_LOCKING_MODE.

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

> From: drhsql...@gmail.com [mailto:drhsql...@gmail.com] On Behalf Of Richard > Hipp > Sent: 12 August 2014 15:46 > I put a new snapshot on the download page.  Please try it, *without* > SQLITE_ENABLE_LOCKING_MODE. OK, it builds, but doesn't run. It is missing the patch to unixDelete. Whilst

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

On Tue, Aug 12, 2014 at 10:38 AM, Andy Ling wrote: > 've just downloaded the latest pre-release > sqlite-amalgamation-201408081749.zip > a > I put a new snapshot on the download page. Please try it, *without* SQLITE_ENABLE_LOCKING_MODE. -- D. Richard Hipp

<    1   2   3   4   5   6   7   8   9   >