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@yahoo.com> 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@gmail.com> wrote:

 Subject: Re: [Maria-developers] [GSOC 2014] "CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS" Project
 To: "James Briggs" <james.briggs@yahoo.com>
 Cc: maria-developers@lists.launchpad.net
 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@yahoo.com> 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.