Re: [Maria-developers] Doubt in bin logging for CREATE VIEW

2014-06-24 Thread Kristian Nielsen
sriram patil writes: > I have not yet figured out how to write automated test cases for > replication, but will do that soon. Here is one existing test case that should be a good simple example as a starting point for this, when you get to it: mysql-test/suite/rpl/t/rpl_locale.test You run

Re: [Maria-developers] Doubt in bin logging for CREATE VIEW

2014-06-23 Thread sriram patil
Hi All, Indeed it is a bug. Here is what I did to verify. I installed MariaDB at two paths on my machine (I could have had multiple data dirs but that struck me later). Wrote a DBUG_EXECUTE_IF as suggested by Kristian in mysql_register_view, which returned ER_OUT_OF_RESOURCES. Ran one mysql serv

Re: [Maria-developers] Doubt in bin logging for CREATE VIEW

2014-06-23 Thread Sergei Golubchik
Hi, Sriram! On Jun 19, sriram patil wrote: > Hi All, > > I was checking the behavior of bin logging in various methods. I found out > CREATE VIEW differs a little bit than others in bin logging. > > The query is written into bin log if query is executed successfully. If > there is any error the

Re: [Maria-developers] Doubt in bin logging for CREATE VIEW - MDEV-6365

2014-06-19 Thread James Briggs
Hi folks. I created this MDEV based on the "bad news" in my previous comment about create view (actually things are worse than I thought, since implementing the missing options will break user applications and affect replication backward compatibility): (MDEV-6365) CREATE VIEW Ignores RESTRICT/

Re: [Maria-developers] Doubt in bin logging for CREATE VIEW

2014-06-19 Thread James Briggs
years. :) Thanks, James. On Thu, 6/19/14, sriram patil wrote: Subject: Re: [Maria-developers] Doubt in bin logging for CREATE VIEW To: "James Briggs" Cc: "maria-developers@lists.launchpad.net" Date: Thursday, June 19, 2014, 2:46

Re: [Maria-developers] Doubt in bin logging for CREATE VIEW

2014-06-19 Thread sriram patil
reate view source, > and there's tons of work that hasn't been finished yet > (just read the comments about union and restrict/ > cascade for starters.) > > Another future project! > > Thanks, James. > > ------------------------ > On Th

Re: [Maria-developers] Doubt in bin logging for CREATE VIEW

2014-06-19 Thread sriram patil
Hi Kristian, I have not yet tried setting up the replication and writing the tests for it. I am reading about it. I will look into setting up the replication and writing test cases for it. Will get back to you when I have the test results ready. Thanks, Sriram On Thu, Jun 19, 2014 at 2:15 PM,

Re: [Maria-developers] Doubt in bin logging for CREATE VIEW

2014-06-19 Thread James Briggs
x27;s tons of work that hasn't been finished yet (just read the comments about union and restrict/ cascade for starters.) Another future project! Thanks, James. On Thu, 6/19/14, sriram patil wrote: Subject: [Maria-developers] Doubt in bin logging

Re: [Maria-developers] Doubt in bin logging for CREATE VIEW

2014-06-19 Thread Kristian Nielsen
sriram patil writes: > In case of CREATE VIEW (method: mysql_create_view file: sql/sql_view.cc), > while the bin logging is skipped for most of the errors by jumping to "err" > label, it is not skipped in following code snippet (line number: 616) > > res= mysql_register_view(thd, view, mode); >

[Maria-developers] Doubt in bin logging for CREATE VIEW

2014-06-19 Thread sriram patil
Hi All, I was checking the behavior of bin logging in various methods. I found out CREATE VIEW differs a little bit than others in bin logging. The query is written into bin log if query is executed successfully. If there is any error the query is not logged. This behavior is observed across all