Re: [sqlite] Virtual table acting as wrapper of a regular table

2016-10-24 Thread Dimitris Bil
m Auftrag von Dimitris Bil Gesendet: Montag, 24. Oktober 2016 15:10 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] Virtual table acting as wrapper of a regular table Indeed I am not checking argc. This code just only means to serve as a test in order to make c

Re: [sqlite] Virtual table acting as wrapper of a regular table

2016-10-24 Thread Hick Gunter
ober 2016 15:10 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] Virtual table acting as wrapper of a regular table Indeed I am not checking argc. This code just only means to serve as a test in order to make comparisons for execution speed. I have str

Re: [sqlite] Virtual table acting as wrapper of a regular table

2016-10-24 Thread Dimitris Bil
Hick Gunter <h...@scigames.at> Sent: Monday, October 24, 2016 10:39 AM To: 'SQLite mailing list' Subject: Re: [sqlite] Virtual table acting as wrapper of a regular table Your xFilter method is blindly assuming that there is always an argv[0] without checking argc first. You are incurring an e

Re: [sqlite] Virtual table acting as wrapper of a regular table

2016-10-24 Thread Hick Gunter
olumn function. Doing twice as much work taking twice as long seems quite reasonable. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Dimitris Bil Gesendet: Samstag, 22. Oktober 2016 15:31 An: sqlite-users@mailinglists.sq

[sqlite] Virtual table acting as wrapper of a regular table

2016-10-22 Thread Dimitris Bil
Hello, I am trying to create a simple virtual table that acts as wrapper for a normal database table for a specific query. For example, consider that I have tables A and B in my database and the query: select count(A.id) from A CROSS JOIN B where A.id=B.id Now I am using a virtual table acting