Get rid of the comma at the end of the 'timestamp' line.
Rick
On Aug 8, 2012, at 10:03 PM, Brandon Pimenta wrote:
> I just found a bug in SQLite. It says "1: near ")": syntax error". Here's
> my SQL query:
>
> CREATE TABLE online_status (
> username varchar(255) NOT NULL default '',
> timesta
INSERT INTO myTable (Rd, en, ue) SELECT 'aa', 'bb', ue FROM othertable;
Rick
On Jul 22, 2012, at 7:41 PM, YAN HONG YE wrote:
> INSERT INTO myTable (Rd, en, ue) VALUES ("aa","bb",select ue from othertable);
___
sqlite-users mailing list
sqlite-users@
Thanks. I'll hold off on checking the result of every sqlite3_bind_* for now.
It's unlikely I'm using a finalized statement otherwise I believe I would get a
given crash much more often. The sqlite3_prepare_v2 statements that are failing
only fail occasionally, not every time. But I'll double ch
Thanks but I'm not have any issue with the stack traces.
Rick
On Jul 19, 2012, at 12:27 PM, Black, Michael (IS) wrote:
> Found this that might help you:
>
> http://stackoverflow.com/questions/1730180/is-this-kind-of-crash-report-useless
>
>
>
> Michael D. Black
___
19, 2012, at 12:00 PM, Richard Hipp wrote:
> On Thu, Jul 19, 2012 at 1:56 PM, Rick Maddy wrote:
>
>> What about checking all the sqlite3_bind_* methods? Is it possible any of
>> those could cause the problems I'm seeing?
>>
>
> Being busing with other issue
What about checking all the sqlite3_bind_* methods? Is it possible any of those
could cause the problems I'm seeing?
Rick
On Jul 19, 2012, at 11:42 AM, Simon Slavin wrote:
>
> On 19 Jul 2012, at 6:03pm, Rick Maddy wrote:
>
>> Thanks. Time to add checks to nearly
lt values, just not all, and none of the 'prepare' statements.
Thanks,
Rick
On Jul 19, 2012, at 11:42 AM, Simon Slavin wrote:
>
> On 19 Jul 2012, at 6:03pm, Rick Maddy wrote:
>
>> Thanks. Time to add checks to nearly 400 prepare and step statements.
>
> Sorry
But that would flag valid state changes just as much as it would flag corrupted
memory.
Rick
On Jul 19, 2012, at 11:15 AM, Black, Michael (IS) wrote:
> It could easiliy be expanded to look at the whole structure...
>
>
>
> Or just do an XOR checksum on the bytes in sizeof(sqlite3) and comp
Thanks but doesn't that code check to see if the database pointer has changed
and not whether the memory it references has been corrupted? I guess that's a
start though.
Rick
On Jul 19, 2012, at 11:02 AM, Black, Michael (IS) wrote:
> Buffer overflow issues can cause problems at seemingly ran
Thanks. Time to add checks to nearly 400 prepare and step statements.
Rick
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
urn value of the prepare
statement going to help if the prepare statement crashes before returning?
Thanks,
Rick
On Jul 19, 2012, at 10:32 AM, Simon Slavin wrote:
>
> On 19 Jul 2012, at 5:09pm, Rick Maddy wrote:
>
>> Exception Type: SIGSEGV
>> Exception Codes: SEGV_A
For quite some time now I've been getting reports of crashes in my iOS app.
Specifically these are caused by crashes in sqlite3_prepare_v2 and sqlite_step.
The associated code works fine most of the time. So I'm looking for thoughts on
how to find and fix the problem since there seems to be no p
3.7.5 and 3.7.4.
Thanks,
Madhav
On Fri, Feb 25, 2011 at 7:28 PM, Maddy wrote:
> I had tried on sqlite version 3.7.4.
> Let me check it on sqlite version 3.7.5.
>
> Thanks,
> Madhav
>
>
> On Thu, Feb 24, 2011 at 9:19 PM, Richard Hipp wrote:
>
>>
>>
>>
I had tried on sqlite version 3.7.4.
Let me check it on sqlite version 3.7.5.
Thanks,
Madhav
On Thu, Feb 24, 2011 at 9:19 PM, Richard Hipp wrote:
>
>
> On Thu, Feb 24, 2011 at 4:52 AM, Maddy wrote:
>
>> Hi,
>> I have 4 "SELECT" queries which are accessing sa
Hi,
I have 4 "SELECT" queries which are accessing same table.
When I executed these queries concurrently using pthreads in Linux, it took
approximate 10 Seconds.
But same 4 queries executed sequentially it only took 2 seconds.
Total Rows in table are 10.
Sample query is "SELECT column1, sum(col
15 matches
Mail list logo
