Hello Alexander,
As stored procedures seems to be very memory aggressive, I found two possible
optimizations to avoid having three strings containing the stored procedure
code in memory.
Probably, same optimizations may be applied to packages.
I haven't add any tests because I think everything
Hi Alexander,
I've done a pull request .
Regards.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.com]
> Envoyé : jeudi 4 octobre 2018 17:29
> À : jerome brauge
> Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
> Objet : Re: MDEV-1
tobre 2018 17:29
> À : jerome brauge
> Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
> Objet : Re: MDEV-17359
>
> Hi Jerome,
>
>
> On 10/04/2018 06:11 PM, jerome brauge wrote:
> > Hi Alexander,
> > Thank you very much.
> > Do you think this
Hi Alexander,
Thank you very much.
Do you think this these patches will be ready for 10.3.10 GA ?
Regards.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.com]
> Envoyé : jeudi 4 octobre 2018 16:05
> À : jerome brauge
> Cc : MariaDB Developers (m
Hi,
I'd like to know what is the best way to track memory consumption /leak in
mariadb.
Our application use intensively stored procedure and with only 35 connection we
have to restart mariadb each 1.5 hours because it use 15Go of memory very fast.
Mysqladmin doesn't show excessive memory
Hello Sergei,
> -Message d'origine-
> De : Sergei Golubchik [mailto:s...@mariadb.org]
> Envoyé : mercredi 11 avril 2018 20:37
> À : jerome brauge
> Cc : maria-developers@lists.launchpad.net
> Objet : Re: sql_mode=oracle : Rollback on error
>
> Hi, Jerome!
>
=qualiac@lists.launchpad.net] De
la part de jerome brauge
Envoyé : jeudi 5 avril 2018 14:14
À : 'Vladislav Vaintroub'; Sergei Golubchik (s...@mariadb.com)
Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
Objet : Re: [Maria-developers] sql_mode=oracle : Rollback on error
Hi
it handler is fired.
De : Vladislav Vaintroub [mailto:vvaintr...@gmail.com]
Envoyé : jeudi 5 avril 2018 13:03
À : jerome brauge; Sergei Golubchik (s...@mariadb.com)
Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
Objet : Re: [Maria-developers] sql_mode=oracle : Rollbac
gt; De : Alexander Barkov [mailto:b...@mariadb.com]
> Envoyé : mardi 3 avril 2018 12:43
> À : jerome brauge
> Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
> Objet : Re: sql_mode=oracle : Rollback on error
>
> Hello Jerome,
>
> On 03/30/2018 06:52 PM, jerome bra
Hello Alexander,
I've found one another difference between Mariadb and Oracle : oracle always
rollback the active transaction if an error is raised, Maria leave the
transaction active.
Possible workaround in stored procedure: add an exit handler which do a
rollback and resignal the error.
Hello Alexander,
Can you open an MDEV for rpad/lpad (return NULL instead of empty string when
sql_mode=oracle) and review this patch ?
Regards.
pad_func.diff
Description: pad_func.diff
___
Mailing list: https://launchpad.net/~maria-developers
Post to
Hello Alexander,
Can you review this patch for trim functions for Oracle ?
Regards,
Jérôme.
patch_trim.diff
Description: patch_trim.diff
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Hello Alexander,
Did you have any time to review this patch ?
Regard,
Jérôme.
> -Message d'origine-
> De : jerome brauge
> Envoyé : jeudi 1 février 2018 14:20
> À : 'Alexander Barkov'
> Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
> Objet : Oracle
make a similar patch ? (by adding
functions ltrim_oracle, ... like for substr)
It's for us the last blocking point.
Regards,
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : mardi 19 septembre 2017 13:16
> À : jerome brauge
> Obj
23:17
> À : jerome brauge
> Cc : b...@mariadb.org
> Objet : Re: Patch for MDEV-13417 - UPDATE produces wrong values if an
> updated column is later used as an update source
>
> Hi, Jérôme!
>
> Happy New Year!
>
> Sorry for the delay.
>
> But I've fi
Hi All,
Since some time ago, my app crashed the server (10.2.-ext) in some case
(repeatable) with the following stack trace :
On Linux Centos 7:
./sql/mysqld(my_print_stacktrace+0x38)[0x7f463f49a093]
./sql/mysqld(handle_fatal_signal+0x3a3)[0x7f463ed2747a]
Hi all,
The following script crashs the server (built with last bb-10.2-ext sources).
use test;
CREATE or replace TABLE `gtfmt` (
`numgtfmt` char(10) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
create or replace view gtfmtl(numgtfmt)
as
select 'x' from
Hi All,
I've a question on kind of delete on whose we have performance issues.
Consider two tables:
CREATE TABLE `gapfl` (
`pgegapfl` varchar(150) COLLATE utf8_bin NOT NULL,
`blkgapfl` varchar(30) COLLATE utf8_bin NOT NULL,
`fldgapfl` varchar(30) COLLATE utf8_bin NOT NULL,
`ordgapfl`
ilto:b...@mariadb.org]
> Envoyé : mercredi 29 novembre 2017 08:14
> À : jerome brauge
> Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
> Objet : Re: Error 1422 - Explicit or implicit commit is not allowed in stored
> function or trigger
>
> Hi Jerome,
>
>
> On 11/2
Hello Alexander,
I'm facing to a new issue with my stored procedures.
Some of them are called directly or from trigger.
When these procedures are called directly, they manage the transaction and when
they are called from trigger, they doesn't manage the transaction.
This works fine on Oracle,
Hello Alexander,
Simple and effective, as usual!
Thank you very much.
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : lundi 13 novembre 2017 13:26
> À : jerome brauge
> Cc : MariaDB Developers (maria-developers@lists.launchpad.ne
Hello Alexander,
Well, I can do this.
Can I submit a patch for each function instead of a big one ?
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : vendredi 10 novembre 2017 13:15
> À : jerome brauge
> Cc : MariaDB Developers (m
Hello Alexander,
To have a behavior the nearest possible to Oracle, I use STRICT_TRANS_TABLES
sql_mode.
But then I have a problem with cast to varchar that failed with "truncated
incorrect value" .
Ex:
set sql_mode='ORACLE,STRICT_TRANS_TABLES';
delimiter /
CREATE or replace procedure p3(b1
Hi Alexander,
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : jeudi 9 novembre 2017 14:52
> À : jerome brauge
> Cc : 'MariaDB Developers (maria-developers@lists.launchpad.net)'
> Objet : Re: MDEV-13418 Compatibility: The order of eval
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : jeudi 9 novembre 2017 11:05
> À : jerome brauge
> Cc : 'MariaDB Developers (maria-developers@lists.launchpad.net)'
> Objet : Re: MDEV-13418 Compatibility: The order of eval
Hello Alexander,
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : mardi 7 novembre 2017 16:34
> À : jerome brauge
> Cc : 'MariaDB Developers (maria-developers@lists.launchpad.net)'
> Objet : Re: MDEV-13418 Compatibility: The o
-----Message d'origine-
> De : jerome brauge
> Envoyé : vendredi 3 novembre 2017 12:18
> À : 'Alexander Barkov'
> Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
> Objet : RE: MDEV-13418 Compatibility: The order of evaluation of
> SELECT..INTO assignments
>
&
.
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : vendredi 3 novembre 2017 11:02
> À : jerome brauge
> Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
> Objet : Re: MDEV-13418 Compatibility: The order of eval
db.org]
> Envoyé : lundi 30 octobre 2017 10:02
> À : jerome brauge
> Objet : Re: MDEV-14139 Anchored data types for variables
>
>
>
> On 10/28/2017 07:29 PM, Alexander Barkov wrote:
> >
> > On 10/27/2017 10:27 PM, Alexander Barkov wrote:
> >> Hello Jerome,
&
Hi Alexander,
I agree, your code is more clearer.
I've added your additional tests and done the pull request.
Thank you very much.
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : vendredi 13 octobre 2017 14:34
> À : jerome b
Hello Alexander,
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : lundi 2 octobre 2017 13:41
> À : jerome brauge
> Cc : MariaDB Developers (maria-developers@lists.launchpad.net); 'Sergei
> Golubchik'
> Objet : Re: MDEV-13417 / M
Hello Alexander,
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : lundi 2 octobre 2017 08:21
> À : jerome brauge; 'Sergei Golubchik'
> Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
> Objet : Re: MDEV-13417 / MDEV
017 15:16
> À : jerome brauge; 'Sergei Golubchik'
> Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
> Objet : Re: MDEV-13417 / MDEV - 13418 The order of evaluation of
> SELECT..INTO assignments
>
> Hi Jerome,
>
> Can you please split the patch:
> extract and
feature).
Do you really want I remove it ?
Thank you very much.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : mercredi 27 septembre 2017 09:38
> À : jerome brauge
> Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
> Obje
,
Jérôme.
> -Message d'origine-
> De : jerome brauge
> Envoyé : mardi 19 septembre 2017 14:13
> À : 'Alexander Barkov'
> Objet : RE: Oracle strings functions compatibility : substr
>
> Hello Alexander,
> Yes I'm aware.
> This point will be treated by my next p
Hi Alexander,
In sql_mode=oracle, when a stored procedure varchar parameter is defined
without size, you have chosen to translate it by VARCHAR(4000) (or CHAR(2000)
for CHAR parameter).
Oracle does not work like this. Size is inherited from the size of argument at
runtime.
Example:
CREATE OR
Hello Sergei,
Here is a patch for MDEV-13417 and MDEV-13418.
Until you choose the right name for this new sql_mode, I temporarily chosen
"SET_CONSISTENCY".
It is set only for sql_mode=oracle for now.
Can you review it ?
Thank you.
Regard.
mdev13417_13418.diff
Description: mdev13417_13418.diff
to understand multi_update code to see if I can use it (but my
skills are a bit limited)
Many thanks.
Jérôme.
> -Message d'origine-
> De : Sergei Golubchik [mailto:s...@mariadb.org]
> Envoyé : mardi 29 août 2017 14:01
> À : jerome brauge
> Cc : maria-developers@lists.launchpad
db.org]
> Envoyé : vendredi 18 août 2017 01:24
> À : jerome brauge
> Cc : maria-developers@lists.launchpad.net; Alexander Barkov
> Objet : Re: Patch for MDEV-12874 - UPDATE statements with the same
> source and target
>
> Hi, jerome!
>
> On Jul 21, jerome brauge wrote:
&
Hello Alexander,
Here is a patch for function SUBSTR in sql_mode=oracle (If position is 0, then
it is treated as 1).
Regards,
Jérôme.
substr.diff
Description: substr.diff
___
Mailing list: https://launchpad.net/~maria-developers
Post to :
Hi All,
Build of last 10.2-ext fail on Win32 with message :
Sysvar 'optimizer_switch' failed 'def_val < my_set_bits(typelib.count)'
The problem seems to be in sys_vars.ic (Sys_var_set) :
>
> {
> option.var_type|= GET_SET;
> global_var(ulonglong)= def_val;
>
Hello,
Here is a patch for MDEV-13417 (on branch 10.2-ext).
Can anyone review it ?
Best regards,
Jérôme.
MDEV-13417.diff
Description: MDEV-13417.diff
___
Mailing list: https://launchpad.net/~maria-developers
Post to :
Hello Alexander,
Do you know why STRICT_TRANS_TABLES is not set in sql_mode=ORACLE ?
The following script should not work:
set sql_mode=oracle;
create table t1 (c1 integer not null,c2 integer not null);
insert into t1 (c1) values(1);
Query OK, 1 row affected, 1 warning
Regards,
Jérôme.
Hello Alexander,
Something seems to be wrong in sql_yacc_ora.yy. (10.2-ext branch)
We can't create a table with a virtual column because the grammar try to reduce
the rule sp_cursor_name_and_offset.
CREATE TABLE t1 (c1 INTEGER, c2 INTEGER AS (c1 MOD 10) VIRTUAL) ENGINE=InnoDb;
ERROR 1324
(b1 as varchar(10)) into b1, res from dual;
return ;
END;
$$
DELIMITER ;
call psselerr_field (@res);
select @res;
Mariadb : res = 1
Oracle: res = 10
Best regards,
Jérôme.
> -Message d'origine-
> De : jerome brauge
> Envoyé : vendredi 21 juillet 2017 17:04
> À : mari
Hello,
Here is a patch for MDEV-12874 (on branch 10.2-ext).
Can anyone review it ?
Alexander, during my work on this MDEV, I've found a new issue with update
statement and Oracle compatibility.
create table t1 (c1 integer, c2 integer, c3 integer);
insert into t1(c1,c2,c3) values (1,1,1);
Hi Alexander,
I agree.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : vendredi 7 juillet 2017 09:52
> À : jerome brauge
> Cc : maria-developers
> Objet : Re: Confusion between variable / alias and row type.
>
> Hello Jerome,
Hello Alexander,
I think there is a regression introduced with row type.
Attached stored procedure creation fail with error : ERROR 1105 (HY000) at line
9: 'a' is not a row variable.
Regards,
Jérôme.
ps_row_and_alias.sql
Description: ps_row_and_alias.sql
egards,
Jérôme.
De : Alexander Barkov <b...@mariadb.org>
Envoyé : mardi 23 mai 2017 11:41
À : jerome brauge
Cc : MariaDB Developers (maria-developers@lists.launchpad.net); Sergei Golubchik
Objet : Re: MDEV-10142 - Replace function
Hello Jerome,
On 05/1
Hello Alexander,
Great news.
I've done requested changes and re-record some tests (error number has changed).
Pull request is submitted.
Thank!
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : lundi 22 mai 2017 14:13
> À : jerome brauge; mari
ATE' and as a separate source for data
Regards,
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : vendredi 19 mai 2017 16:18
> À : jerome brauge
> Cc : 'MariaDB Developers (maria-developers@lists.launchpad.net)'
> Objet : Re:
Hello Alexander,
In the same spirit of MDEV-12137, can you create a task for update with same
source and target ?
Regard,
Jérôme.
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe
.
With all patches that I provided, I can connect to our application and it's
already a challenge !
Regards,
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : jeudi 18 mai 2017 14:32
> À : jerome brauge
> Cc : MariaDB Developers (m
Hello everyone,
I've done a patch for MDEV-12137 based on branch bb-10.2-ext (DELETE statement
with the same source and target).
At this time the patch is for all sql_mode.
It could be interesting to add an information in explain plan to indicate the
extra step.
Something like :
Hi Alexander,
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : jeudi 4 mai 2017 09:00
> À : jerome brauge
> Cc : MariaDB Developers
> Objet : Re: MDEV-10142 - bb-10.2-compatibility
>
> Hi Jerome,
>
> On 05/04/2017
db.org]
> Envoyé : jeudi 4 mai 2017 06:16
> À : jerome brauge
> Cc : MariaDB Developers
> Objet : Re: MDEV-10142 - bb-10.2-compatibility
>
> Hello Jerome,
>
>
> On 04/27/2017 08:43 AM, jerome brauge wrote:
> > Hello Alexander,
> > This is the patch for CHR().
>
gt; De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : mardi 2 mai 2017 09:39
> À : jerome brauge
> Cc : MariaDB Developers
> Objet : Re: bb-10.2-ext / rpad lpad with 2 args
>
> Hi Jerome,
>
> Thanks for your contribution!
> The patch generally looks good.
>
vril 2017 06:12
> À : jerome brauge
> Cc : MariaDB Developers
> Objet : Re: MDEV-10142 - bb-10.2-compatibility / MDEV-10574
>
> Hello Jerome,
>
> Thanks for working on this!
>
> On 04/25/2017 11:42 PM, jerome brauge wrote:
> > Hello Alexander,
> > Some ti
Hello Alexander,
This is the patch for length/lengthb.
Regard,
Jérôme.
PS : I share this code under terms of MCA.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : mercredi 26 avril 2017 06:12
> À : jerome brauge
> Cc : MariaDB Develope
Barkov [mailto:b...@mariadb.org]
> Envoyé : mercredi 26 avril 2017 06:12
> À : jerome brauge
> Cc : MariaDB Developers
> Objet : Re: MDEV-10142 - bb-10.2-compatibility / MDEV-10574
>
> Hello Jerome,
>
> Thanks for working on this!
>
> On 04/25/2017 11:42 PM, jero
rcredi 26 avril 2017 06:12
> À : jerome brauge
> Cc : MariaDB Developers
> Objet : Re: MDEV-10142 - bb-10.2-compatibility / MDEV-10574
>
> Hello Jerome,
>
> Thanks for working on this!
>
> On 04/25/2017 11:42 PM, jerome brauge wrote:
> > Hello Alexander,
> >
Hello Alexander,
I will do this.
Many thanks.
Regards,
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : mercredi 26 avril 2017 06:12
> À : jerome brauge
> Cc : MariaDB Developers
> Objet : Re: MDEV-10142 - bb-10.2-compatib
ilto:b...@mariadb.org]
> Envoyé : lundi 23 janvier 2017 12:49
> À : jerome brauge
> Cc : MariaDB Developers
> Objet : Re: MDEV-10142 - bb-10.2-compatibility / MDEV-10574
>
> Hi Jerome,
>
> On 01/18/2017 01:22 PM, jerome brauge wrote:
> > Hello Alexander,
> > Someti
Hi Marko, Alexander,
I confirm, I can load my database with no hang (with delete or truncate).
Thank you very much.
Regards,
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : mercredi 5 avril 2017 12:12
> À : Marko Mäkelä
> Cc
ine InnoDB for table 't' |
| Error | 1050 | Table 't' already exists |
+-+--+---+
but JDBC is not aware of the warnings.
Regards,
Jérôme.
De : Diego Dupin [mailto:diego.du...@mariadb.com]
Envoyé : mercredi 5 avril 2017 13:08
À : jerom
:09
> À : maria-developers@lists.launchpad.net; Diego Dupin
> Objet : Re: [Maria-developers] JDBC getWarnings and stored procedure
>
>
>
> On 03/04/17 20:21, jerome brauge wrote:
> > Hello,
> >
> > When we call a stored procedure in JDBC which emit warning
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
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
specific to sql_mode=ORACLE.
Best regards,
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : lundi 3 avril 2017 06:24
> À : Marko Mäkelä
> Cc : jerome brauge; MariaDB Developers (maria-
> develop...@lists.launchpad.net); Sergey Voj
Hello,
We have a java tools to massively load data in a database (parallel load in
different tables).
With it, on bb-10.2-compatibility branch, I'm able to reproduce crash and
sometimes database corruption:
· on truncate (but delete works fine)
· on parallel insert
Crash
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.2017 15
Using connectionAttributes is not possible in case where you use a connection
pool ...
De : Vladislav Vaintroub [mailto:vvaintr...@gmail.com]
Envoyé : vendredi 31 mars 2017 14:44
À : jerome brauge; Diego Dupin
Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
Objet : Re: [Maria
to use one solution per database vendor or a
feature with a performance cost.
But I agree, it's boring if it's implementation can change in future.
Thanks.
Regards
Jérôme.
De : Vladislav Vaintroub [mailto:vvaintr...@gmail.com]
Envoyé : vendredi 31 mars 2017 12:37
À : jerome brauge; b
: 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
09:16
> À : jerome brauge
> Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
> Objet : Re: bb-10.2-compatibility
>
> Hello Jérôme,
>
>
> On 03/24/2017 09:00 PM, jerome brauge wrote:
> > Hello Alexander,
> >
> > On oracle when an error occurr
rd,
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : mardi 28 mars 2017 07:42
> À : jerome brauge
> Objet : Re: bb-10.2-compatibility
>
> Hi Jerome,
>
>
> On 03/28/2017 08:45 AM, jerome brauge wrote:
> > Alexander
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 (m
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 patch to do something like that by adding the stack trace
as "notes".
To show
Alexander,
As requested, this is my last patch for MDEV-10598.
Of course, I share this code under MCA.
Best regards,
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : mercredi 22 mars 2017 12:00
> À : jerome brauge
> Objet : Re:
t; Envoyé : jeudi 16 mars 2017 13:03
> À : jerome brauge
> Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
> Objet : Re: MDEV-10598 - bb-10.2-compatibility
>
> Hello Jerome,
>
>
> On 03/14/2017 06:07 PM, jerome brauge wrote:
> > Hi Alexander,
> >
t;b...@mariadb.org>
Date : 16/03/2017 13:03 (GMT+01:00)
À : jerome brauge <j.bra...@qualiac.com>
Cc : "MariaDB Developers (maria-developers@lists.launchpad.net)"
<maria-developers@lists.launchpad.net>
Objet : Re: MDEV-10598 - bb-10.2-compatibility
Hello Jerome,
On 03/14/2017 06:07 P
ne-
De : Maria-developers
[mailto:maria-developers-bounces+j.brauge=qualiac@lists.launchpad.net] De
la part de jerome brauge
Envoyé : mardi 7 mars 2017 15:49
À : MariaDB Developers (maria-developers@lists.launchpad.net)
Objet : [Maria-developers] Adding information de Information_schema.processl
Hi Alexander,
Can you review this patch ?
I could add more tests when your others points will be corrected.
Thanks.
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : mardi 14 mars 2017 11:54
> À : jerome brauge
> Cc : MariaDB De
Alexander,
This a new version of scripts that you can replay (I forgot that you haven't my
patch).
Jérôme
> -Message d'origine-
> De : Maria-developers [mailto:maria-developers-
> bounces+j.brauge=qualiac@lists.launchpad.net] De la part de jerome
> brauge
> Envoyé
11:11
> À : jerome brauge
> Objet : Re: MDEV-10598 - bb-10.2-compatibility
>
> Hello Jerome,
>
>
>
> On 03/13/2017 07:46 PM, jerome brauge wrote:
> > Alexander,
> > I think there is a little bug with ROWTYPE: when I affect a variable with a
> field value, t
age d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : mardi 14 mars 2017 05:33
> À : jerome brauge
> Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
> Objet : Re: bb-10.2-compatibility - Updatable cursor
>
> Hello Jerome,
>
> On 0
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
Hello Alexander,
I have to do some changes in the patch and add some tests cases (with row type)
I think it will be ready this afternoon (CET).
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : lundi 13 mars 2017 14:38
> À : jerome
Alexander,
It's work fine now.
Regards.
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : samedi 11 mars 2017 07:43
> À : jerome brauge
> Cc : maria-developers
> Objet : Re: MDEV-10598 - bb-10.2-compatibility
>
> Hi Jerom
d be 'uint32
char_to_byte_length_safe(uint32,uint32)'
I quickly installed a CenOS 7 VM and build works fine but I don't know
development tools under linux.
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : vendredi 10 mars 2017 11:36
> À : jerome brauge
in a table without unique key
and lock all records when cursor is open.
Regards,
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : vendredi 10 mars 2017 11:24
> À : jerome brauge
> Cc : MariaDB Developers (maria-developers@lists.launchp
Hello Alexander,
Can you add a task for updatable cursor (for positioned update and delete).
Regards,
Jérôme.
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe :
Hello,
Connector/J support the method setClientInfo and standard information :
ApplicationName, ClientUser and ClientHostname.
(https://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#setClientInfo(java.lang.String,%20java.lang.String)
It's seem that there is no way to see these
Hello Alexander,
When I compiled some real procedures, I find some tables alias not supported by
the current grammar.
Example :
create table t1 (col1 int);
select dec.* from t1 dec;
select mod.* from t1 mod;
I have done a complete test on Oracle and Mariadb with all keywords used as
Hello Alexander,
Thanks for the explanation.
It's something we do not use. I did not think about it.
I look forward to your patch.
Regards,
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : lundi 27 février 2017 11:28
> À : jerome
017 13:27
> À : jerome brauge
> Cc : maria-developers
> Objet : Re: MDEV-10598 - bb-10.2-compatibility
>
> Hello Jerome,
>
> Thank you very much for the patch.
> I'm reviewing it. But most likely won't finish today.
> I'll be away on Thursday and Friday. Will reply
Hello Alexander,
I've done this patch for MDEV-10598.
Can you review it ?
Regards,
Jérôme.
0001-MDEV-10598-sql_mode-ORACLE-Variable-declarations-can.patch
Description: 0001-MDEV-10598-sql_mode-ORACLE-Variable-declarations-can.patch
___
Mailing list:
Hello Alexander,
Can you add a task for delete statement with same table as source and target in
sql_mode=oracle
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 twice, both as a
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 validation.
*/
DBUG_ASSERT(thd->change_list.is_empty());
Stack trace
Hello Alexander,
This is the latest version of the patch.
I will try to do a pull request (I'm new on github)
I send the agreement asap.
Regard,
Jérôme.
> -Message d'origine-
> De : Alexander Barkov [mailto:b...@mariadb.org]
> Envoyé : jeudi 9 février 2017 13:16
> À : jerome
1 - 100 of 117 matches
Mail list logo