[sqlite] Parser Grammar for MAX,MIN,SUM,COUNT,AVG functions

Thanks a lot Clemens ! Thanks a lot :) On Mon, Sep 21, 2015 at 2:58 PM, Clemens Ladisch wrote: > Prakash Premkumar wrote: > > Can you please tell me which grammar rule in parse.y file parses > aggregate > > function ? > > As you already were told, there are rules th

[sqlite] Parser Grammar for MAX,MIN,SUM,COUNT,AVG functions

Thanks a lot for your reply Ambrus. Can you please tell me which grammar rule in parse.y file parses aggregate function ? Thanks a lot for your time Prakash On Mon, Sep 21, 2015 at 2:07 PM, Zsb?n Ambrus wrote: > On Mon, Sep 21, 2015 at 9:11 AM, Prakash Premkumar > wrote: > > I&#

[sqlite] Parser Grammar for MAX,MIN,SUM,COUNT,AVG functions

Hi, I'm reading the sqlite parser grammar. I could not find the grammar rules which parses aggregate functions like MAX,MIN,SUM,COUNT,TOTAL. Can you please tell me how the aggregate functions are parsed (the grammar rule that parses them) Thanks a lot for your time Prakash

[sqlite] Compiling sqlite as as library

I tried with the following flags : gcc -arch x86_64 -o sqlite3.o sqlite3.c shell.c and > gcc -m32 -o sqlite3.o sqlite3.c shell.c but both results in the same error. Can you please help me solve this ? On Thu, Jul 2, 2015 at 2:47 PM, Andy Ling wrote: > > I get the following error while

[sqlite] Compiling sqlite as as library

Hi Andy, I get the following error while trying to compile after linking with the library ld: warning: ignoring file > /Users/prakash-2282/Downloads/sqlite-amalgamation-201506301510/libsqlite3.a, > file was built for archive which is not the architecture being linked > (x86_64): > /Users/prakash-

[sqlite] Compiling sqlite as as library

Thanks a ton Andy for your reply. can you specify how I should specify the include flags (-I). The kore build complais that "sqlite3.h" header file is not found . Thanks a lot for your time On Thu, Jul 2, 2015 at 1:51 PM, Andy Ling wrote: > > Can you please tell me how to compile it as a libra

[sqlite] Compiling sqlite as as library

please tell me how to compile it as a library on Mac OSX and Linux platforms ? On Wed, Jul 1, 2015 at 7:28 PM, Kees Nuyt wrote: > On Wed, 1 Jul 2015 14:28:37 +0530, Prakash Premkumar > wrote: > > >Hi, > > > >Can you please tell me how to compile sqlite as a lib

[sqlite] Compiling sqlite as as library

Hi, Can you please tell me how to compile sqlite as a library and link with other applications using the "-L" flag ? Thanks a lot for your time .

[sqlite] Sqlite subquery parsing

Hello, Can you please tell me how Sub queries in select are parsed ? Can you please point out which rule in the parse.y file does the job of parsing this ? Thank you

Re: [sqlite] Using binding in sqlite insert statements

Thanks a lot for your reply Simon. It was returning SQLITE_DONE. (But I have checked for SQLITE_OK in my code). It's fixed now Thank you Prakash On Tue, Dec 9, 2014 at 5:02 PM, Simon Davies wrote: > On 9 December 2014 at 10:56, Prakash Premkumar > wrote: > > Hi, > > &g

[sqlite] Using binding in sqlite insert statements

Hi, I'm trying to use the sqlite_bind function calls to pass values to the insert queries in sql. Here's the code I'm trying to execute: http://pastebin.com/kMvAHsrk I get an error after the sqlite3_step() function call : The error message is "Unknown error". Can you kindly help me fix this ?

[sqlite] SQLite where clause tree

The where clause in sqlite is encoded as a tree Let's say I have select statement like : SELECT * from employee where salary = 3+5*4+3; The tree which takes care of operator precedence is : = /\ salary+

Re: [sqlite] Inmemory database in sqlite

journaling mode is set, then the database file will very likely > go corrupt. So you can go all the ways from no acid (data and journal in > ram), to aci database (syncronous=normal) to fully acid. If you increase > cache size enough you'll have the same as a "in memory"

Re: [sqlite] Inmemory database in sqlite

122/e21631/overview.htm#TTCIN129 Does sqlite's in memory db have this feature ? Thanks Prakash On Fri, Oct 17, 2014 at 11:54 AM, Prakash Premkumar wrote: > Is features like WAL (https://www.sqlite.org/wal.html) not available for > in memory databases ? > > Thanks > Prakash > &

Re: [sqlite] Inmemory database in sqlite

M>), where stored information is lost > if > the power is removed, although many efforts have been made to develop > non-volatile RAM chips. > > Source: Wikipedia > Il 17/ott/2014 11:48 "Prakash Premkumar" ha > scritto: > > > Hi, > > Does in memory

Re: [sqlite] Inmemory database in sqlite

Prakash On Fri, Oct 17, 2014 at 10:27 AM, Igor Tandetnik wrote: > On 10/17/2014 12:48 AM, Prakash Premkumar wrote: > >> Does in memory database in sqlite have journal files associated with it ? >> > > No. The journal is in memory, too. > > If there's a system fail

[sqlite] Inmemory database in sqlite

Hi, Does in memory database in sqlite have journal files associated with it ? If there's a system failure before an in memory database is backed up ? Will there be data loss ? Or Can you kindly tell me how sqlite handles this ? Thanks Prakash ___ sqlite

[sqlite] Granularity of Locks in sqlite

Hi, >From what I understand from reading the followig doc: http://www.sqlite.org/lockingv3.html sqlite supports only file level locking.Is there any attempts to improve the granularity of locking to table level or row level ? Thanks a lot. Prakash ___

Re: [sqlite] sqlite Query Optimizer

gt; On 16 Oct 2014, at 7:50am, Prakash Premkumar > wrote: > > > Does sqlite implement the pointers in the System R Algorithm ? > > SQLite does not implement the System R Algorithm, so no, it doesn't > implement the pointers from System R. It implements the algorithms &

Re: [sqlite] sqlite Query Optimizer

Thanks a lot for your time. Regards Prakash On Wed, Oct 15, 2014 at 5:36 PM, Simon Slavin wrote: > > On 15 Oct 2014, at 12:54pm, Prakash Premkumar > wrote: > > > I'm trying to understand the sqlite select query optimizer. It works by > > assigning costs to

[sqlite] sqlite Query Optimizer

Hi, I'm trying to understand the sqlite select query optimizer. It works by assigning costs to each relation in FROM clause. As far as I understand, it primarily uses the logarithmic estimate of the number of rows in the relation. Query optimization algorithms like IBM System R algorithm assigns

[sqlite] Performance gain in SQLite

Will I get any performance benefits if I directly generate the Vdbe program instead of generating the sql string ? My application emits out sql strings for execution. Instead if I generate the Vdbe program myself , will I get performance benefits since, I am bypassing the parser. Thanks Prakash _

Re: [sqlite] struct SrcList

table of cursors required for > processing the statement and there will be assertions to satisfy. > > -Ursprüngliche Nachricht- > Von: Prakash Premkumar [mailto:prakash.p...@gmail.com] > Gesendet: Montag, 06. Oktober 2014 11:59 > An: General Discussion of SQLite Dat

[sqlite] struct SrcList

Hi, struct SrcList has a field int iCursor, if I'm manually filling up this struct ,can I assign any integral value to iCursor,so that this value can be used by OpenRead or OpenReadWrite opcode when it accesses this particular table ? Thanks Prakash __

[sqlite] Filling struct Select in sqlite

Hi, Instead of generating an sql query for a select statement, I would like to bypass the parser and fill in struct Select by myself based on the data I have and Pass it to sqlite3Select() function. Can you please give me some pointers in this direction ? I think eliminating parsing would be an o

Re: [sqlite] Vdbe Program Generation

Thanks a lot Clemens Regards Prakash On Sun, Oct 5, 2014 at 2:56 PM, Clemens Ladisch wrote: > Prakash Premkumar wrote: > > On Fri, Oct 3, 2014 at 7:37 PM, Kees Nuyt wrote: > >> On Fri, 3 Oct 2014 18:39:29 +0530, Prakash Premkumar > >> wrote: > >> > &g

Re: [sqlite] Vdbe Program Generation

Thanks a lot for your reply Kees, sqlite3_prepare calls other functions, can you kindly tell me which is the exact function that does the conversion ? Thanks Prakash On Fri, Oct 3, 2014 at 7:37 PM, Kees Nuyt wrote: > On Fri, 3 Oct 2014 18:39:29 +0530, Prakash Premkumar > wrote: > &g

[sqlite] Vdbe Program Generation

Can you please tell me which function is sqlite actually generates the Vdbe program for a give sql string ? Thanks Prakash ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Results of Joins in sqlite

rks > first? > > -Ursprüngliche Nachricht- > Von: Prakash Premkumar [mailto:prakash.p...@gmail.com] > Gesendet: Mittwoch, 24. September 2014 12:54 > An: General Discussion of SQLite Database > Betreff: Re: [sqlite] Results of Joins in sqlite > > Thanks a lot Hick

Re: [sqlite] Results of Joins in sqlite

scussed), > there will be one pointer from T1 row to T2 row and 3 pointers from T2 row > to the > 3 T3 rows(one pointer per row). > > The end data structure will look like a graph. > > I want the API to return this graph./ is there an alternative ? > API call : graph* sqlit

Re: [sqlite] Results of Joins in sqlite

3 T3 rows(one pointer per row). The end data structure will look like a graph. I want the API to return this graph./ is there an alternative ? API call : graph* sqlite3_join(select_stmt*) Thanks Prakash On Wed, Sep 24, 2014 at 12:45 PM, Clemens Ladisch wrote: > Prakash Premkumar wrote: &

Re: [sqlite] Results of Joins in sqlite

which table. Thanks Prakash On Wed, Sep 24, 2014 at 11:03 AM, Prakash Premkumar wrote: > Hi, > > Let's say I have tables T1,T2 and T3 with 2 columns each and I am joining > them. > The result rows will have 8 columns each. > > Let's say an output of the join is

[sqlite] Results of Joins in sqlite

Hi, Let's say I have tables T1,T2 and T3 with 2 columns each and I am joining them. The result rows will have 8 columns each. Let's say an output of the join is: r11,r21,r31 r11,r21,r32 r11,r21,r33 where r1i is the i th row in T1, r2i is the i th row in T2 and r3i is the ith row in T3: sqlite

Re: [sqlite] Expose struct Mem and struct Vdbe to other application

ation that you really need to change the approach or acquire a > different tool. Maybe you are trying to nail it with a set of pliers. > Doable, but not as neat as using a hammer in the first place, and also hard > on the pliers. > > -Ursprüngliche Nachricht- > Von: Pra

Re: [sqlite] Expose struct Mem and struct Vdbe to other application

ored procedures"? > > -Ursprüngliche Nachricht- > Von: Prakash Premkumar [mailto:prakash.p...@gmail.com] > Gesendet: Montag, 22. September 2014 15:37 > An: General Discussion of SQLite Database > Betreff: [sqlite] Expose struct Mem and struct Vdbe to other application > &

[sqlite] Expose struct Mem and struct Vdbe to other application

Hi, Let's assume I am writing a c code which directly invokes the sqlite_step statement. After the execution of the statement, I would like to access the pResultRow of Vdbe (which obtained by pVbe = (Vdbe*) pStmt ). How can I expose the struct Vdbe,Mem and the likes to external applications. Incl

Re: [sqlite] Definition of struct sqlite3_stmt

Thanks Clemens and hick On 22 Sep 2014 14:22, "Clemens Ladisch" wrote: > Prakash Premkumar wrote: > > Can you please tell me where is the definition of the struct > sqlite3_stmt ? > > There is no definition of struct sqlite3_stmt. > > Search for this instead:

[sqlite] Definition of struct sqlite3_stmt

Hi, Can you please tell me where is the definition of the struct sqlite3_stmt ? A search in sqlite3.c yields on the typedef statement of the struct , typedef struct sqlite3_stmt sqlite3_stmt; Thanks for your help. ___ sqlite-users mailing list sqlite-

[sqlite] Number of registers/Mem in sqlite Vdbe

Can you kindly tell me where in the source code is the number of registers for Vdbe allocated ? Thanks Prakash ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Generating VDBE program

Thanks a lot Richard for your help. I apologize for not including the script. I will make it a point to add the scripts from hereon. On Fri, Sep 19, 2014 at 10:30 AM, Richard Hipp wrote: > You start by presenting us with a stand-alone script that we can run to see > your question. See you are g

Re: [sqlite] Generating VDBE program

The schema is as follows : create table employee (name text,age int); create table location (name text,addr text); create table company (name text,cname text); Thanks On Fri, Sep 19, 2014 at 10:13 AM, Richard Hipp wrote: > On Fri, Sep 19, 2014 at 12:35 AM, Prakash Premkumar < >

Re: [sqlite] Generating VDBE program

The opcode I'm interested in is 10 column 2 1 3 00 On 19 Sep 2014 10:11, "Richard Hipp" wrote: > On Fri, Sep 19, 2014 at 12:35 AM, Prakash Premkumar < > prakash.p...@gmail.com> > wrote: > > > Let's take this example > > > > explain sel

Re: [sqlite] Generating VDBE program

he virtual machine remember this allocation ? Thanks for your help On Fri, Sep 19, 2014 at 9:46 AM, Richard Hipp wrote: > On Fri, Sep 19, 2014 at 12:10 AM, Prakash Premkumar < > prakash.p...@gmail.com> > wrote: > > > Thanks for your reply. I would like to know how the r

Re: [sqlite] Generating VDBE program

Thanks for your reply. I would like to know how the register allocation decision is made and the part of the code which does it . can you please help me find that? Thanks On 18 Sep 2014 20:20, "Richard Hipp" wrote: > On Thu, Sep 18, 2014 at 10:10 AM, Prakash Premkumar < > pra

[sqlite] Generating VDBE program

ntiguously? Can you point me to the portion of the source code which makes this decision? Can you kindly explain me the concept? Thanks for you help. Regards, Prakash Premkumar ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:80

[sqlite] SQL Query to Vdbe Instructions

Hi, Can you please tell me which function/set of functions convert the SQL query to Vdbe program ? Thanks Prakash ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Set compile time option

Hi, How do I set the sqlite compile time option SQLITE_DEBUG ? Can you please specify how I should set it in the command line ? Thanks Prakash ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-u