Re: [sqlite] Virtual table API performance

Hi, thanks for explaining your syntax in another post. Now about virtual tables if you don't mind. On Fri, Feb 28, 2014 at 8:24 PM, Eleytherios Stamatogiannakis wrote: > > If we load into SQLite, > > create table newtable as select * from READCOMPRESSEDFILE('ctable.rc'); >

Re: [sqlite] Possible issue in optimizer, strips away order by

Great, thanks! 2014-02-26 0:11 GMT-03:00 Richard Hipp-3 [via SQLite] < ml-node+s1065341n74140...@n5.nabble.com>: > On Tue, Feb 25, 2014 at 1:11 PM, nobre <[hidden > email]> > wrote: > > > Hi! Given this schema: > > > > create table q (id integer

Re: [sqlite] sqlite_compileoption_get + cte

On Mar 1, 2014, at 9:34 PM, Stephan Beal wrote: > note the duplicate first entry. Make sure to start everything at zero: select sqlite_compileoption_get( 0 ) as name, 0 as position ___ sqlite-users mailing list

Re: [sqlite] sqlite_compileoption_get + cte

On Sat, Mar 1, 2014 at 8:02 PM, Petite Abeille wrote: > > On Mar 1, 2014, at 7:46 PM, Bogdan Ureche wrote: > > > You are missing one value. To get all the values, start from 0: > > At least someone is paying attention! Thanks :) > Strangely enough,

Re: [sqlite] Compiling SQLite on VxWorks 6.3 (DKM)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 28/02/14 06:37, deltuo wrote: > i compile sqlite 3.8.3 to vxworks 6.9, i first compile sqlite in dkm > and get xx.a lib file, and then test it in vip project, but meet disk > i/o error, can you help me ? thank you , my email is del...@126.com

Re: [sqlite] sqlite_compileoption_get + cte

Hello you meant that's for the Buzz 8) (joke inside) Best Regards On Sat, Mar 1, 2014 at 11:06 AM, Petite Abeille wrote: > > On Mar 1, 2014, at 6:30 PM, mm.w <0xcafef...@gmail.com> wrote: > > > ? PRAGMA compile_options; > > Yes, sure. But much snazzier to use a CTE,

Re: [sqlite] basic "Window function"

On Mar 1, 2014, at 7:39 PM, big stone wrote: > Would it be possible to get a small basic subset of the sql windowing > function for Sqlite 3.8.5 ? Yes! Pretty please :) Supporting windowing functions (aka analytics) would be a major breakthrough.

Re: [sqlite] sqlite_compileoption_get + cte

On Mar 1, 2014, at 6:30 PM, mm.w <0xcafef...@gmail.com> wrote: > ? PRAGMA compile_options; Yes, sure. But much snazzier to use a CTE, no? :D ( One very unfortunate aspect of pragmas is that one cannot query them with regular SQL… sigh…) ___

Re: [sqlite] sqlite_compileoption_get + cte

On Mar 1, 2014, at 7:46 PM, Bogdan Ureche wrote: > You are missing one value. To get all the values, start from 0: At least someone is paying attention! Thanks :) ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] sqlite_compileoption_get + cte

You are missing one value. To get all the values, start from 0: with Option( name, position ) as ( select sqlite_compileoption_get( 0 ) as name, 0 as position union all select sqlite_compileoption_get( position + 1 ) as name, position + 1 as position fromOption

[sqlite] basic "Window function"

Hello, Sqlite 3.8.3 implemented recursive CTE. Sqlite 3.8.4 is shaping to be another great tuning/optimisation release. Would it be possible to get a small basic subset of the sql windowing function for Sqlite 3.8.5 ? If we imagine that the basic windowing is a bit like a CTE 'rewording', it

Re: [sqlite] sqlite_compileoption_get + cte

Hello, ? PRAGMA compile_options; Best Regards. On Sat, Mar 1, 2014 at 7:01 AM, Petite Abeille wrote: > Just because we can: > > with > Option( name, position ) > as > ( > select sqlite_compileoption_get( 1 ) as name, > 1 as position > > union all >

[sqlite] sqlite_compileoption_get + cte

Just because we can: with Option( name, position ) as ( select sqlite_compileoption_get( 1 ) as name, 1 as position union all select sqlite_compileoption_get( position + 1 ) as name, position + 1 as position fromOption where sqlite_compileoption_get(

Re: [sqlite] Compiling SQLite on VxWorks 6.3 (DKM)

i compile sqlite 3.8.3 to vxworks 6.9, i first compile sqlite in dkm and get xx.a lib file, and then test it in vip project, but meet disk i/o error, can you help me ? thank you , my email is del...@126.com -- View this message in context:

[sqlite] compile sqlite3.8.3 to vxworks platform meet disk i/o error

i compile sqlite 3.8.3 to vxworks 6.9, i first compile sqlite in dkm and get xx.a lib file, and then test it in vip project, but meet disk i/o error, can you help me ? thank you , my email is del...@126.com -- View this message in context:

Re: [sqlite] Virtual Table "Functions"

Please excuse me for not explaining. The syntax that you puzzle about is supported by madIS [*] which translates it into SQLite. Having being using madIS for many years (we created it in 2008) it comes natural to me, forgetting that SQLite doesn't support it. What essentially madIS does is

Re: [sqlite] Why SQLITE_FLOAT instead of SQLITE_REAL?

On 2014/03/01 10:32, Darren Duncan wrote: If you're going by semantics though, the meanings are quite different. A real number represents a point on a line and can be either a rational or irrational number. (And a complex number is a point on a plane.) An important bit is that a real is a

Re: [sqlite] Virtual Table "Functions"

On Fri, Feb 28, 2014 at 10:14 PM, Dominique Devienne wrote: > Can someone tell me how the statement below works? > > > Thanks for any help on this. This is really puzzling to me. --DD Very puzzling for me too For any statement like this select * from blablabla(123)

Re: [sqlite] Why SQLITE_FLOAT instead of SQLITE_REAL?

On 3/1/2014, 12:16 AM, RSmith wrote: On 2014/02/28 23:36, L. Wood wrote: SQLite has the REAL data type: https://www.sqlite.org/datatype3.html Then why do we have SQLITE_FLOAT instead of SQLITE_REAL? All the other data types (INTEGER, BLOB, TEXT, NULL) match with the SQLITE_ constants.

Re: [sqlite] Why SQLITE_FLOAT instead of SQLITE_REAL?

On 2014/02/28 23:36, L. Wood wrote: SQLite has the REAL data type: https://www.sqlite.org/datatype3.html Then why do we have SQLITE_FLOAT instead of SQLITE_REAL? All the other data types (INTEGER, BLOB, TEXT, NULL) match with the SQLITE_ constants. Quoting Shakespeare's Juliet: "What's in