It's exactly the case.
De : Vladislav Vaintroub [mailto:vvaintr...@gmail.com]
Envoyé : vendredi 31 mars 2017 15:36
À : jerome brauge; Diego Dupin
Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
Objet : Re: [Maria-developers] bb-10.2-compatibility - processlist
On 31.03.20
:* jerome brauge; Diego Dupin
*Cc :* MariaDB Developers (maria-developers@lists.launchpad.net)
*Objet :* Re: [Maria-developers] bb-10.2-compatibility - processlist
On 31.03.2017 14:35, jerome brauge wrote:
Vladislav,
It’s weird to implement setClientInfo without provide a way to see
À : jerome brauge; b...@mariadb.org<mailto:b...@mariadb.org>
Cc : MariaDB Developers
(maria-developers@lists.launchpad.net<mailto:maria-developers@lists.launchpad.net>);
Diego Dupin
Objet : Re: [Maria-developers] bb-10.2-compatibility - processlist
On 3/31/2017 12:16 PM, jerome brauge wrote:
Developers (maria-developers@lists.launchpad.net);
Diego Dupin
*Objet :* Re: [Maria-developers] bb-10.2-compatibility - processlist
On 3/31/2017 12:16 PM, jerome brauge wrote:
Hi Vladislav,
As I understand is that this plugin allow user to see their own
session variables.
Here,
erome brauge; b...@mariadb.org
Cc : MariaDB Developers (maria-developers@lists.launchpad.net); Diego Dupin
Objet : Re: [Maria-developers] bb-10.2-compatibility - processlist
On 3/31/2017 12:16 PM, jerome brauge wrote:
Hi Vladislav,
As I understand is that this plugin allow user to see their own session
vari
rôme.
*De :*Vladislav Vaintroub [mailto:vvaintr...@gmail.com]
*Envoyé :* vendredi 31 mars 2017 12:06
*À :* jerome brauge; b...@mariadb.org
*Cc :* MariaDB Developers (maria-developers@lists.launchpad.net)
*Objet :* Re: [Maria-developers] bb-10.2-compatibility - processlist
Hi Jerome, Bar
is user
: vendredi 31 mars 2017 12:06
À : jerome brauge; b...@mariadb.org
Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
Objet : Re: [Maria-developers] bb-10.2-compatibility - processlist
Hi Jerome, Bar
is user_variables plugin not enough for that ?
https://mariadb.com/kb/en/mariadb
Hi Jerome, Bar
is user_variables plugin not enough for that ?
https://mariadb.com/kb/en/mariadb/information-schema-user_variables-table/
It is only one driver that sets these user variables, so it might not be
worth to extend processlist even more for general case, just for that.
On 3/31/2
Hello Alexander,
Here is a new version of the patch that show call stack on error (rebased on
your last commit).
Of course, I share this code under terms of MCA.
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : lundi 27 mars 2017 09:16
> À : jer
Hi Jerome,
On 03/28/2017 07:38 PM, jerome brauge wrote:
> Hi Alexander,
> Here is the patch that corrects the line number of errors.
> Only tests from test suite for oracle seems to be affected.
Thank you very much. The patch is fine.
I'm going to push it to the "10.2".
It's an old bug, it's no
Hi Alexander,
Here is the patch that corrects the line number of errors.
Only tests from test suite for oracle seems to be affected.
Row number are correct when test is recorded with "mysql-test-run.pl -record",
but wrong with mysql or mysqltest (I don't understand why !)
Regard,
Jérôme.
> --
Hello Alexander,
I will start by doing a separate patch for corrected yylineno.
Thanks you very much !
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : lundi 27 mars 2017 09:16
> À : jerome brauge
> Cc : MariaDB Developers (maria-developers@lists.
Hello Jérôme,
On 03/24/2017 09:00 PM, jerome brauge wrote:
> Hello Alexander,
>
> On oracle when an error occurred inside a stored procedure, the error
> message contains the stack trace of calling procedures.
>
> It’s very useful when you have tons of procedures.
>
> I wrote this little patc
Hello Jerome,
On 03/14/2017 01:18 PM, jerome brauge wrote:
> Hello Alexander,
> I feared something like that.
>
> Comment of class Select_materialize indicate :
> /**
> Select_materialize -- a mediator between a cursor query and the
> protocol. In case we were not able to open a non-materialz
Hello Alexander,
I feared something like that.
Comment of class Select_materialize indicate :
/**
Select_materialize -- a mediator between a cursor query and the
protocol. In case we were not able to open a non-materialzed
cursor, it creates an internal temporary HEAP table, and insert
all
Hello Jerome,
On 03/10/2017 05:21 PM, jerome brauge wrote:
> Hello Alexander,
> Nice to hear you again.
> You can find description here :
> https://mariadb.com/kb/en/sql-99/positioned-update-statement/
> https://mariadb.com/kb/en/sql-99/positioned-delete-statement/
>
> I attached an example (posi
Alexander,
It's done.
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : lundi 13 mars 2017 14:37
> À : jerome brauge
> Cc : maria-developers
> Objet : Re: bb-10.2-compatibility
>
> Hello Jerome,
>
> On 03/10/2017 05:58 PM, jerome brauge wrote:
>
Hello Jerome,
On 03/10/2017 05:58 PM, jerome brauge wrote:
> Hello Alexander,
>
> Yes, it's your first assumption (works fine in Oracle (as a variable, or a
> label, or a table alias), but does not work in sql_mode=ORACLE)
> I attached sql scripts used to do these tests (where every keyword are
Hello Alexander,
Nice to hear you again.
You can find description here :
https://mariadb.com/kb/en/sql-99/positioned-update-statement/
https://mariadb.com/kb/en/sql-99/positioned-delete-statement/
I attached an example (positioned_update.sql).
It's a useful feature to update or delete rows in a ta
Hello Jerome,
Sorry for a late reply.
I was fully busy with the CURSOR FOR LOOP related tasks.
Now have time to catch time with my emails.
On 03/03/2017 05:17 PM, jerome brauge wrote:
> Hello Alexander,
>
> When I compiled some real procedures, I find some tables alias not supported
> by the c
Hello Jerome,
can you please give examples?
Thanks!
On 03/08/2017 07:33 PM, jerome brauge wrote:
> Hello Alexander,
>
> Can you add a task for updatable cursor (for positioned update and delete).
>
>
>
> Regards,
>
> Jérôme.
>
___
Mailing lis
Hello Jerome,
Sorry, I noticed I've never replied this:
On 02/14/2017 08:24 PM, jerome brauge wrote:
> Example :
>
> create or replace table t1 (c1 int, c2 int);
>
> delete from t1 where c1 in (select b.c1 from t1 b where b.c2=0);
>
>
>
> Failed with :
>
> Error: Table 't1' is specified t
Hi Jerome,
On 02/14/2017 12:07 PM, jerome brauge wrote:
> Hello Alexander,
> Attached script fail on my local bb-10.2-compatibility branch on the
> following assert :
>
> /*
> If called from a stored procedure, ensure that we won't rollback
> external changes when cleaning up after va
Hello Alexander,
Thanks for these news and sub-task !
Yes, it commit top-level transaction (as long as you are not in an autonomous
transaction).
The main difference between Mariadb and Oracle transaction is that Oracle
implicitly starts a transaction when the first SQL statement (which need to
Hello Jerome,
On 02/09/2017 04:44 PM, Alexander Barkov wrote:
> Hello Jerome,
>
>
> On 02/09/2017 02:54 PM, jerome brauge wrote:
>> Hello,
>>
>> I come back with a question on functions.
>>
>> On Oracle, there is only one difference between a function and a stored
>> procedure : the return cod
Hello Jerome,
On 02/09/2017 02:54 PM, jerome brauge wrote:
> Hello,
>
> I come back with a question on functions.
>
> On Oracle, there is only one difference between a function and a stored
> procedure : the return code.
>
> On Mariadb, stored functions are more limited :
> - Recursive stor
26 matches
Mail list logo
