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-se...
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.