Re: [Maria-developers] [GSOC 2014] CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS Project

2014-03-20 Thread sriram patil
Hi James, Replying again cause the text did not appear in the mailing list. Sure, I will try and implement that feature too. Thank you very much for the suggestion. Thanks, Sriram On Thu, Mar 20, 2014 at 4:02 AM, James Briggs james.bri...@yahoo.comwrote: Hi Sriram. If you could add

Re: [Maria-developers] [GSOC 2014] CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS Project

2014-03-20 Thread James Briggs
Hi Sriram. 1) Here's a worklog related to your project: WL#3129: Consistent clauses in CREATE and DROP https://dev.mysql.com/worklog/ 2) Maybe you can do a follow-on GSOC next year on this worklog: WL#5047: SQL command class hierarchy. There's lots of low-hanging fruit enhancing SQL options,

Re: [Maria-developers] [GSOC 2014] CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS Project

2014-03-20 Thread sriram patil
Hi James, That worklog surely helped me. Now I know what needs to be added for each object type. I have missed three of them while putting up my proposal. Also, it seems the CREATE OR REPLACE and IF [NOT] EXISTS issue is hanging there from a long time. The follow-up project idea is great! That

Re: [Maria-developers] [GSOC 2014] CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS Project

2014-03-19 Thread sriram patil
Hi Sergei, I studied lex and yacc and understood complete parser written in sql_yacc.yy. Also went through the constants and symbols declared in lex.h, sql_yacc.h, sql_cmd.h. I found out that OR REPLACE and IF NOT EXISTS is already implemented for tables. The IF NOT EXISTS rule is also defined

Re: [Maria-developers] [GSOC 2014] CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS Project

2014-03-19 Thread Sergei Golubchik
Hi, sriram! On Mar 19, sriram patil wrote: Hi Sergei, I studied lex and yacc and understood complete parser written in sql_yacc.yy. Also went through the constants and symbols declared in lex.h, sql_yacc.h, sql_cmd.h. Right I found out that OR REPLACE and IF NOT EXISTS is already

Re: [Maria-developers] [GSOC 2014] CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS Project

2014-03-19 Thread James Briggs
Hi Sriram. If you could add CREATE VIEW … FORCE too, that would be awesome. See the Oracle Enterprise docs for the behavior: http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_8004.htm Thanks, James. On Wed, 3/19/14, Sergei Golubchik

Re: [Maria-developers] [GSOC 2014] CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS Project

2014-03-19 Thread Sriram Patil
Hi James, Sure, I will try and implement that feature too. I am just getting started. I would love to get such suggestions when I start working on the project too. Thanks, Sriram On Thu, Mar 20, 2014 at 4:02 AM, James Briggs james.bri...@yahoo.com wrote:Hi Sriram. If you could add "CREATE VIEW

Re: [Maria-developers] [GSOC 2014] CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS Project

2014-03-18 Thread Sergei Golubchik
Hi, Sriram! First: please don't forget to cc: the list maria-developers@lists.launchpad.net Thank you. On Mar 18, sriram patil wrote: Hi Sergei, I was going through the source code and was able to figure out the flow of query execution and major functions through which a query goes before

Re: [Maria-developers] [GSOC 2014] CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS Project

2014-03-18 Thread Sriram Patil
Hi Sergei, Thank you for such a quick reply. I will look into the files you have mentioned. Also, is there any particular format for the proposal draft? Or may be if you expect some points to be mentioned clearly in the proposal draft. Thanks, Sriram On Tue, Mar 18, 2014 at 6:05 PM, Sergei

Re: [Maria-developers] [GSOC 2014] CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS Project

2014-03-18 Thread Sergei Golubchik
Hi, Sriram! On Mar 18, Sriram Patil wrote: Hi Sergei, Thank you for such a quick reply. I will look into the files you have mentioned. Also, is there any particular format for the proposal draft? Or may be if you expect some points to be mentioned clearly in the proposal draft. No

[Maria-developers] [GSOC 2014] CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS Project

2014-03-16 Thread sriram patil
Hi Sergei, I am Sriram Patil. I am a Masters' student at International Institute of Information Technology, Hyderabad, India. I have been working on a small DB Engine as part of my course work in C++. I have also worked on a SQLite DB abstraction library FMDB in Objective-C. Also, I am currently

Re: [Maria-developers] [GSOC 2014] CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS Project

2014-03-16 Thread Sergei Golubchik
Hi, Sriram! On Mar 16, sriram patil wrote: Hi Sergei, I am interested to work on CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS project as part of GSOC 2014. I want to apply my subject knowledge at a bigger level which will also give me an idea about the practical issues while