maria-developers team mailing list archive

[sriram patil <spsrirampatil@xxxxxxxxx>]

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 huge switch-case statement in
mysql_command_execute can be fixed with the mentioned object oriented
approach for command execution.

And that blog of yours really simplifies it all. I will need to go through
that procedure a lot of times during this project.

I am so much excited now after I saw the complete worklog and so many
things to work on.

Thanks a lot,
Sriram




On Fri, Mar 21, 2014 at 3:45 AM, James Briggs <james.briggs@xxxxxxxxx>wrote:

> 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, yet at the same
> time very useful to end-users.
>
> 3) You can see my notes and references for adding new MySQL commands here:
>
> Howto Add a New Command to the MySQL Server
>
> http://www.jebriggs.com/blog/2013/05/howto-add-a-new-command-to-the-mysql-server/
>
> James.
>
> --------------------------------------------
> On Thu, 3/20/14, sriram patil <spsrirampatil@xxxxxxxxx> wrote:
>
>  Subject: Re: [Maria-developers] [GSOC 2014] "CREATE OR REPLACE, CREATE IF
> NOT EXISTS, and DROP IF EXISTS" Project
>  To: "James Briggs" <james.briggs@xxxxxxxxx>
>  Cc: maria-developers@xxxxxxxxxxxxxxxxxxx
>  Date: Thursday, March 20, 2014, 5:34 AM
>
>  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.
>