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 <s...@mariadb.org> wrote: Subject: Re: [Maria-developers] [GSOC 2014] "CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS" Project To: "sriram patil" <spsrirampa...@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 _______________________________________________ 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
