maria-developers team mailing list archive

[sriram patil <spsrirampatil@xxxxxxxxx>]

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.briggs@xxxxxxxxx>wrote:

> 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@xxxxxxxxxxx> wrote:
>
>  Subject: Re: [Maria-developers] [GSOC 2014] "CREATE OR REPLACE, CREATE IF
> NOT EXISTS, and DROP IF EXISTS" Project
>  To: "sriram patil" <spsrirampatil@xxxxxxxxx>
>  Cc: maria-developers@xxxxxxxxxxxxxxxxxxx
>  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@xxxxxxxxxxxxxxxxxxx
>  Unsubscribe : https://launchpad.net/~maria-developers
>  More help   : https://help.launchpad.net/ListHelp
>
>