Re: [sqlite] Generating VDBE program

When you do add scripts, put them on pastebin or something of the sort as this mailing list doesn't always allow attachments. (I've seen one or two slip through the cracks) On Fri, Sep 19, 2014 at 1:20 AM, Prakash Premkumar wrote: > Thanks a lot Richard for your help. I

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

Re: [sqlite] Generating VDBE program

You start by presenting us with a stand-alone script that we can run to see your question. See you are getting free help, you really should be striving to make it easy for people to help you. We don't have a script from you, so I made one up. I'm using: CREATE TABLE employee(eid INTEGER

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 select * from employee,company,location where

Re: [sqlite] Generating VDBE program

On Fri, Sep 19, 2014 at 12:35 AM, Prakash Premkumar wrote: > Let's take this example > > explain select * from employee,company,location where location.name= > company.name and location.name=employee.name; > Also please include the schema for your database. > > addr

Re: [sqlite] Generating VDBE program

On Fri, Sep 19, 2014 at 12:35 AM, Prakash Premkumar wrote: > Let's take this example > > explain select * from employee,company,location where location.name= > company.name and location.name=employee.name; > > > How's the register for the highlighted opcode allocated and

Re: [sqlite] Generating VDBE program

Let's take this example explain select * from employee,company,location where location.name= company.name and location.name=employee.name; addr opcode p1p2p3p4 p5 comment - - -- - 0 Init

Re: [sqlite] Generating VDBE program

On 19 Sep 2014, at 5:10am, Prakash Premkumar wrote: > 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 Prakesh, perhaps it would help to read

Re: [sqlite] Generating VDBE program

On Fri, Sep 19, 2014 at 12:10 AM, Prakash Premkumar wrote: > 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 > Which register. Show me a

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 < >

Re: [sqlite] Generating VDBE program

On Thu, Sep 18, 2014 at 10:10 AM, Prakash Premkumar wrote: > Which function in the sqlite generates the Vdbe program for the given > query? > > Let's take an example of the join of two tables. Table A has n columns and > Table B has m columns, and the result has n+m

[sqlite] Generating VDBE program

Which function in the sqlite generates the Vdbe program for the given query? Let's take an example of the join of two tables. Table A has n columns and Table B has m columns, and the result has n+m columns. During the execution of the Vdbe program the values from these columns get copied to the