[sqlite] Program crashes when delete a row in SQLite db table

Priority Delivery Corrupted db attached, the qyery crashes is: delete from objects where dbname='information_schama' Download File at: https://rcpt.yousendit.com/624254893/4d5c40a04a2eb6cdf2468bd999485ef2 Sent by: [EMAIL PROTECTED] File to pick up: crash_db.db File will remain

Re: [sqlite] DISTINCT clause bug in 3.6.4?

The affinities are not being applied correctly when GROUP BY is in play: sqlite> CREATE TABLE t1(a TEXT); sqlite> INSERT INTO t1 VALUES(123); sqlite> SELECT a=123, a='123' FROM t1; 1|1 sqlite> SELECT a=123, a='123' FROM t1 GROUP BY a; 0|1 Dan. On Nov 12, 2008, at 9:19 AM,

Re: [sqlite] DISTINCT clause bug in 3.6.4?

Hi, In case it helps, I've narrowed this down somewhat; it also happens with this far simpler query: sqlite> select b.val, case when b.val = 1 then 'xyz' else b.val end as col1 from b; val|col1 1|xyz 2|2 sqlite> select distinct b.val, case when b.val = 1 then 'xyz' else b.val end as col1 from

[sqlite] DISTINCT clause bug in 3.6.4?

Hello, I'm working on upgrading from sqlite 3.5.7 to 3.6.4 and while running some regression unit tests in my own app I noticed a couple failures. Upon further investigation it looks like either a bug has been introduced into sqlite between 3.5.8 and 3.6.4 or my query is wrong. Here's some sql

Re: [sqlite] Counting rows in one table, and comparing COUNT with column in other table?

On Tue, 11 Nov 2008 07:30:21 -0500, "Igor Tandetnik" <[EMAIL PROTECTED]> wrote: >Add "GROUP BY code.id" Way to do. Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Please test check-in [5338] on HPUX, AIX, QNX, BSD, etc...

The UNIX driver for SQLite has for years contained a run-time test for locking behavior in multi-threaded programs. This run-time test was necessary to work around a bug that exists in some combinations of Linux 2.4 + glibc. Ticket #3472 identified problems in this run-time test.

Re: [sqlite] Are these new functions?

Thanks. There's a nice sqlite example in the homepage called "sqlite in 5 minutes or less". I think it would be nice to update it to follow the recomendations on the page you pointed me to. Best, M. > http://www.sqlite.org/releaselog/3_6_0.html > >> >> I'm having a linking problem and I

Re: [sqlite] Deleting sqlite rows

I have successfully queried for rowid. For some reason, row 1 and 2 always have rowid 1, even when I create a new database. Do you have any idea why that happens? rows = new Object[0][6]; rowid = new int[0]; try { rsmd = rs.getMetaData(); //get row

Re: [sqlite] SQLite3 on vxWorks

I'm not certain if there is a publicly available port to the vxWorks platform, but I know from postings to the mailing list that it has been done. Was there a particular problem you were encountering that we could help with? Were you successful at writing a VFS for that target? -Shane On

Re: [sqlite] About sqlite3_bind

A parameter represents a literal. You can't bind a column name. After binding, your query is equivalent to select 'ID','age','name' from tbl1 where ID=1; > The return value of sqlite3_step(stat) was SQLITE_ROW, but the > values I got were 0, > why? Because the value of the column is a

Re: [sqlite] Number Of Bugs In current version 3.6.4

http://www.sqlite.org/cvstrac/timeline should give you and idea of the number of issues reported against version 3.6.4 and/or which have been fixed. HTH. -Shane On Tue, Nov 11, 2008 at 4:33 AM, Avinash Mittal <[EMAIL PROTECTED]>wrote: > Hi, > > Can someone tell me how many bugs are present in

Re: [sqlite] Are these new functions?

http://www.sqlite.org/releaselog/3_6_0.html -Shane On Tue, Nov 11, 2008 at 6:10 AM, Mauricio <[EMAIL PROTECTED]> wrote: > Hi, > > I'm having a linking problem and I suspect that the fault goes to the > version of sqlite3 that comes with my distribution. It's 3.5.9. These > functions seems

[sqlite] Program crashes when delete a row in SQLite db table

Hello, I build an application in VC++ platform and using SQLite to keep track details that used to update when the application runs. Sometimes the application is crashing when execte query to delete a row in a table (DELETE FROM table where column = 'field1'). the API uses is "sqlite3_exec()".

[sqlite] SQLite3 on vxWorks

Hi, I am currently working with the porting of SQLite3 into vxWorks, but after a couple of weeks I have no success. Can I ask if there is any version done, which is fully compatible with vxWorks platform? Thank you very much - Michael ___

Re: [sqlite] Counting rows in one table, and comparing COUNT with column in other table?

"Gilles Ganault" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Here's an example of data in the CODE and COMPANIES tables: > > > CODE table > id=1 > number=26 > > COMPANIES table > id=x > code=1 > > > This doesn't: > > SELECT

Re: [sqlite] How to build sqlite rpm package

En/na Avinash Mittal ha escrit: > Hi, > > I want to build sqlite rpm package and then install it on machine. > How can i build rpm package for sqlite using spec.template file present in > sqlite folder ? > what changes i need to do in spec.template for building rpm. My advice is to check whether

Re: [sqlite] Recursive Query

Alexander Yap <[EMAIL PROTECTED]> writes: > > Hi All, > I just want to know if WITH RECURSIVE query is supported by SQLite. > > Thanks in advance. > > Regards, > > Alex http://www.sqlite.org/lang_select.html MikeW ___ sqlite-users mailing list

[sqlite] Ticket #3461

Hi, I just found another issue that looks like it might be related to ticket #3461: The following query returns incorrect data for the column 'column_56f32f43' - it seems to repeat the data from other rows for some rows instead of picking the correct data. SELECT

[sqlite] Are these new functions?

Hi, I'm having a linking problem and I suspect that the fault goes to the version of sqlite3 that comes with my distribution. It's 3.5.9. These functions seems to be missing: sqlite3_initialize sqlite3_next_stmt sqlite3_os_end sqlite3_os_init sqlite3_shutdown I wasn't able to find the

[sqlite] How to build sqlite rpm package

Hi, I want to build sqlite rpm package and then install it on machine. How can i build rpm package for sqlite using spec.template file present in sqlite folder ? what changes i need to do in spec.template for building rpm. Regards Avinash ___

Re: [sqlite] Finding rows not in second table?

On Sat, 8 Nov 2008 12:33:28 +0700, Dan <[EMAIL PROTECTED]> wrote: >That is a subjective statement. It could be true if there are a >lot more rows in table 'Companies' than there are in 'Code' and there >is no index on Companies. There are indeed a lot more rows in COMPANIES than in CODE, since

[sqlite] Number Of Bugs In current version 3.6.4

Hi, Can someone tell me how many bugs are present in the current version 3.6.4. Regards Avinash ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Counting rows in one table, and comparing COUNT with column in other table?

Hello This is a newbie question. I could successfully retrieve the results by sending two queries and extracting data with Python, but I was wondering if I could perform the same action in one SQLite query. Here's an example of data in the CODE and COMPANIES tables: CODE table id=1