Re: [Maria-developers] Database corruption

2017-04-03 Thread jerome brauge
Hello Marko, Alexander, Thanks for your works. When this issue will be corrected on bb-10.2-compatibility, I replay my tests. Best regards, Jérôme. De : Marko Mäkelä [mailto:marko.mak...@mariadb.com] Envoyé : mardi 4 avril 2017 08:14 À : jerome brauge Cc : Alexander Barkov; MariaDB Developers (

Re: [Maria-developers] Database corruption

2017-04-03 Thread Alexander Barkov
Hello Marko, On 04/04/2017 10:13 AM, Marko Mäkelä wrote: > Hi Jérôme, > > Because InnoDB is a transactional storage engine when it comes to DML > operations, DELETE FROM table (without a WHERE clause) is not equivalent > to TRUNCATE TABLE. The reason is that you can ROLLBACK after DELETE, but >

Re: [Maria-developers] Database corruption

2017-04-03 Thread Marko Mäkelä
Hi Jérôme, Because InnoDB is a transactional storage engine when it comes to DML operations, DELETE FROM table (without a WHERE clause) is not equivalent to TRUNCATE TABLE. The reason is that you can ROLLBACK after DELETE, but you cannot ROLLBACK after TRUNCATE, which is a DDL operation (and DDL i

[Maria-developers] JDBC getWarnings and stored procedure

2017-04-03 Thread jerome brauge
Hello, When we call a stored procedure in JDBC which emit warnings, getWarnings() always returns null. I don't really think that the problem is in MariaDB Connector J because warning flag in the EOF packet is not set to true. Mysql client behaves in the same way, by default it shows warnings cou

[Maria-developers] Please review MDEV-12426 Add Field::type_handler()

2017-04-03 Thread Alexander Barkov
Hello Vicențiu, Please review a patch for: MDEV-12426 Add Field::type_handler() also fixing: MDEV-12432 Range optimizer for ENUM and SET does not return "Impossible WHERE" in some case Thank you! commit 1d9f9b8d93fd0d1aad56b77694fb3c2b5a55514d Author: Alexander Barkov Date: Mon Apr 3 13:38:

[Maria-developers] Please review a patch for Mdev-12019

2017-04-03 Thread Sachin Setiya
Hi Monty, Please review a patch for Mdev-12019. -- Regards Sachin Setiya Software Engineer at MariaDB commit 62cda14d7d34fb4a27bad99e7d5aea1c52a71023 Author: Sachin Setiya Date: Mon Apr 3 11:55:51 2017 +0530 MDEV-12019 FLASHBACK: Server crashes in bitmap_bits_set / pack_row / ...