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 <serg@mariadb.org> wrote: Subject: Re: [Maria-developers] [GSOC 2014] "CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS" Project To: "sriram patil" <spsrirampatil@gmail.com> Cc: maria-developers@lists.launchpad.net Date: Wednesday, March 19, 2014, 12:22 PM 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 implemented for tables. The IF NOT EXISTS rule is also defined for index in yacc file but not handled in the execution code. And for other object types we need to add the rules in yacc files and also need to change the code in "mysql_create_<object_type>" functions in respective files.
Right
The OR REPLACE and IF NOT EXISTS are handled in the create execution itself. I found two flags in LEX class which are used for the purpose, create_info.options and check_exists.
So, are all the things that I have compiled correct?
Yes
I have an initial draft of my proposal ready. I will upload it on the GSOC portal today, please review. Should I also email the same to you?
No, please don't. I get an email automatically for every new proposal. Regards, Sergei _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp