Re: [Maria-developers] [GSoC 2014]

2014-03-20 Thread Sergei Golubchik
Hi, Ivan! On Mar 20, Ivan Nikulin wrote: 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

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

2014-03-20 Thread Sergei Golubchik
Hi, Alexander! On Mar 20, Alexander Barkov wrote: On 03/19/2014 12:03 AM, Sergei Golubchik wrote: 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. +String

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

2014-03-20 Thread sriram patil
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.bri...@yahoo.comwrote: Hi Sriram. If you could add

Re: [Maria-developers] Rev 4077: MDEV-4856 SQL_ERROR_LOG shows 1146 errors which didnt appear in mysql client

2014-03-20 Thread Alexey Botchkov
This looks too complex to me. Why would you extend the base Internal_error_handler class - no other error handler did that or needed that, fwiw. No other handlers need it, but these methods are sometimes used in places where we don't know the type of the handler. So i think the code is nicer

[Maria-developers] Engine independent index statistics - infrastructure questions

2014-03-20 Thread Sergey Petrunia
Hello Igor and others, I've been playing around with engine independent statistics, and got a few questions. == mysqldump == mysqldump dumps table' data, but besides that it can dump other related objects, e.g. it will dump triggers that are attached to the table. Should it dump table

Re: [Maria-developers] Engine independent index statistics - infrastructure questions

2014-03-20 Thread Sergei Golubchik
Hi, Sergey! Here's my opinion below: On Mar 20, Sergey Petrunia wrote: Hello Igor and others, == dropping table statistics == How does one drop table statistics? are we satisfied with needing to run three statements DELETE FROM mysql.column_stats WHERE schema_name=$db AND

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

2014-03-20 Thread James Briggs
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,

Re: [Maria-developers] [GSoC] MDEV-371- index on BLOB

2014-03-20 Thread smit hinsu
Hi Sergei, I am working on writing proposal for this project currently. Currently MariaDB lets user create index upto 1000 bytes. should we use new approach for prefixes less than 1000 chars also(but 63 or some other threshold) to improve performance? Should I first work on MyISAM or Aria

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

2014-03-20 Thread sriram patil
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

[Maria-developers] [GSoC 2014] CREATE OR REPLACE, CREATE IF NOT EXISTS and DROP IF EXISTS

2014-03-20 Thread sriram patil
Hi Sergei, I just went through WL#3129 (thanks to James Briggs for the link). It gave me a detailed insight on what exactly is expected. I have missed 2 object types in my proposal which are, USER and SERVER. I can edit my proposal to incorporate the changes in the deliverables timeline if you