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