Re: [Maria-developers] [GSOC 2014] "CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS" Project

Hi James, Sure, I will try and implement that feature too. I am just getting started. I would love to get such suggestions when I start working on the project too. Thanks, Sriram On Thu, Mar 20, 2014 at 4:02 AM, James Briggs wrote:Hi Sriram. If you could add "CREATE VIEW

Re: [Maria-developers] A fix for MDEV-5689 ExtractValue(xml, 'substring(/x, /y)') crashes

Hi Sergei, Thanks for review. Please see my comments inline: On 03/19/2014 12:03 AM, Sergei Golubchik wrote: Hi, Alexander! On Feb 20, Alexander Barkov wrote: please review a fix for MDEV-5689. It also fixes MDEV-5709 ExtractValue() with XPath variable references returns wrong result. Desc

[Maria-developers] [GSoC 2014]

Hello, I would like to take part into one of your projects on base of GSoC 2014. I am an experienced C/C++ programmer with wide knowledge of algorithms and data structures and huge interest into this sphere. I have some basic knowledge of SQL language, but unfortunatelly I don't have any database

Re: [Maria-developers] [GSOC 2014] "CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS" Project

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

Re: [Maria-developers] [Commits] Rev 4053: MDEV-5864 - Reduce usage of LOCK_open: TABLE_SHARE::tdc.free_tables

Hi, Sergey! On Mar 19, Sergey Vojtovich wrote: > > > === modified file 'sql/sql_plist.h' > > > --- a/sql/sql_plist.h 2013-11-20 11:05:39 + > > > +++ b/sql/sql_plist.h 2014-03-15 18:53:01 + > > > @@ -142,6 +142,14 @@ class I_P_List : public C, public I > > > > > > return resu

Re: [Maria-developers] [GSOC 2014] "CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS" Project

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 im

Re: [Maria-developers] [GSOC 2014] "CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS" Project

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. I found out that OR REPLACE and IF NOT EXISTS is already implemented for tables. The IF NOT EXISTS rule is also defined fo

Re: [Maria-developers] [Commits] Rev 4053: MDEV-5864 - Reduce usage of LOCK_open: TABLE_SHARE::tdc.free_tables

Hi, Sergey! On Mar 15, Sergey Vojtovich wrote: > At lp:maria/10.0 > > > revno: 4053 > revision-id: s...@mariadb.org-20140315185301-ce4r6br023co80dm > parent: sa...@montyprogram.com-20140314073116-nklb0jkjd4t1w40n > committer: Sergey Voj

Re: [Maria-developers] Transactions behind a failed transaction could commit in parallel replication

"nanyi607rao" writes: > if (unlikely(entry->stop_on_error_sub_id <= rgi->wait_commit_sub_id)) > skip_event_group= true; > > this codes can tell latter transactions to skip but can't tell them rollback. > because if a transaction started commiting before a former transaction fai

Re: [Maria-developers] [GSOC 2014] GIS Enhancement

Hi, Bang. I think yes, the third coordinate operations should be implemented in that tool MariaDB is going to support that later anyway and we can specify the SQL syntax and other ways to input 3d points now. Best regards. HF 18.03.2014 22:36, bang honam wrote: Hi everybody. I am Honam Ban