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 Mem struct randomly (when OP_Column opcode is formed) and finally when the OP_ResultRow is executed, the Mem's are rearranged so that the columns of each table are contiguous. How does sqlite know in which Mem the value of a column is stored and how does it finally rearrange the Mems contiguously? 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:8080/cgi-bin/mailman/listinfo/sqlite-users