Re: [Maria-discuss] SQL_MODE=ORACLE documentation

2018-03-05 Thread Alexander Barkov
Hello Federico, On 03/02/2018 07:12 PM, Federico Razzoli wrote: With SQL_MODE='ORACLE' a completely new syntax has been introduced. Basic syntax constructs of MariaDB become unavailable, but not all Oracle syntax seems to be supported. Is there any plan to document the supported syntax? Curren

Re: [Maria-discuss] Charsets and collations

2017-06-19 Thread Alexander Barkov
Hi Peter, On 06/16/2017 04:01 PM, Peter Laursen wrote: Does anybody know if there are any plans to bring collations added in MySQL 8 - refer http://mysqlserverteam.com/new-collations-in-mysql-8-0-0/ - to MariaDB and are there any plans to change the default charset to a unicode-based one? We

Re: [Maria-discuss] Collations, trailing spaces and unique indexes

2016-03-20 Thread Alexander Barkov
; > > > On 3/11/16, 6:20 AM, "Maria-discuss on behalf of Alexander Barkov" > b...@mariadb.org> wrote: > >> Hello Binarus, Kristian, >> >> On 03/11/2016 02:25 PM, Kristian Nielsen wrote: >>> Binarus writes: >>> >>>> &q

Re: [Maria-discuss] Collations, trailing spaces and unique indexes

2016-03-19 Thread Alexander Barkov
Hi, On 03/16/2016 09:59 AM, Alexander Barkov wrote: ... >> >> - My main problem: I did not find my_strnncollsp_utf8_general_ci anywhere >> (nor in the same neither in any other file). Where is it? > > > The function name is just "my_strnncollsp_utf8". &

Re: [Maria-discuss] MariaDB CONNECT Storage Engine access to Oracle 11GR2

2016-03-15 Thread Alexander Barkov
Hi Ghazi, Thanks for your interest in Connect Storage Engine! On 03/14/2016 04:10 PM, Ghazi Btissam wrote: > > Hi, > > I saw an article about the equivalent of the Oracle DbLink feature in > MariaDb, I found that the connect engine with the ODBC table type can do > an insert+select on an Oracle

Re: [Maria-discuss] Collations, trailing spaces and unique indexes

2016-03-15 Thread Alexander Barkov
Hi Binarus, On 03/11/2016 10:19 PM, Binarus wrote: > On 11.03.2016 15:45, Alexander Barkov wrote: >> FYI, I have added a new task for this: >> >> https://jira.mariadb.org/browse/MDEV-9711 >> > > Alexander, > > I couldn't resist taking a quic

Re: [Maria-discuss] Collations, trailing spaces and unique indexes

2016-03-15 Thread Alexander Barkov
Hi Binarus, On 03/11/2016 09:25 PM, Binarus wrote: > On 11.03.2016 15:45, Alexander Barkov wrote: >> FYI, I have added a new task for this: >> >> https://jira.mariadb.org/browse/MDEV-9711 >> > > Alexander, not sure if my question makes any sense, but what

Re: [Maria-discuss] Collations, trailing spaces and unique indexes

2016-03-15 Thread Alexander Barkov
Hi Binarus, Thanks for a detailed answer. It seems that NO PAD collations are going to be a very welcome feature. Please see my replies and questions below. On 03/11/2016 07:56 PM, Binarus wrote: > Hello Kristian, hello Alexander, > > On 11.03.2016 12:20, Alexander Barkov wrote:

Re: [Maria-discuss] Collations, trailing spaces and unique indexes

2016-03-11 Thread Alexander Barkov
FYI, I have added a new task for this: https://jira.mariadb.org/browse/MDEV-9711 On 03/11/2016 03:20 PM, Alexander Barkov wrote: > Hello Binarus, Kristian, > > On 03/11/2016 02:25 PM, Kristian Nielsen wrote: >> Binarus writes: >> >>> "All MySQL collations ar

Re: [Maria-discuss] Collations, trailing spaces and unique indexes

2016-03-11 Thread Alexander Barkov
Hello Binarus, Kristian, On 03/11/2016 02:25 PM, Kristian Nielsen wrote: > Binarus writes: > >> "All MySQL collations are of type PADSPACE. This means that all CHAR, >> VARCHAR, and TEXT values in MySQL are compared without regard to any >> trailing spaces. “Comparison” in this context does not

Re: [Maria-discuss] select using date_sub produces unwanted milliseconds in results

2015-09-23 Thread Alexander Barkov
Hi Dan, On 09/24/2015 12:35 AM, Dan Ragle wrote: On 9/22/2015 5:12 PM, Alexander Barkov wrote: On 09/23/2015 01:00 AM, Alexander Barkov wrote: Hi Dan, On 09/20/2015 12:53 AM, Dan Ragle wrote: We're converting from MySQL 5.1 to MariaDB 5.5.44 and I'm hoping someone can help c

Re: [Maria-discuss] select using date_sub produces unwanted milliseconds in results

2015-09-22 Thread Alexander Barkov
On 09/23/2015 01:00 AM, Alexander Barkov wrote: Hi Dan, On 09/20/2015 12:53 AM, Dan Ragle wrote: We're converting from MySQL 5.1 to MariaDB 5.5.44 and I'm hoping someone can help clarify for me what's going on in the following scenario. In brief, we're getting millise

Re: [Maria-discuss] select using date_sub produces unwanted milliseconds in results

2015-09-22 Thread Alexander Barkov
Hi Dan, On 09/20/2015 12:53 AM, Dan Ragle wrote: We're converting from MySQL 5.1 to MariaDB 5.5.44 and I'm hoping someone can help clarify for me what's going on in the following scenario. In brief, we're getting milliseconds displayed in a particular date_sub calculation (and possibly other se

Re: [Maria-discuss] R: Stored Procedure debugger from Peter Gulutzan and Trudy Pelzer

2015-03-11 Thread Alexander Barkov
n SQL - the problems I've found make me seriously doubt on the possibility to follow this path. Regards Federico ---- Mar 10/3/15, Alexander Barkov ha scritto: Oggetto: [Maria-discuss] Stored Procedure debugger from Peter Gulutzan and Trudy P

[Maria-discuss] Stored Procedure debugger from Peter Gulutzan and Trudy Pelzer

2015-03-10 Thread Alexander Barkov
Hi, Peter Gulutzan and Trudy Pelzer announced their GUI debugger for stored procedures. Sources, binaries and a demo are available here: http://ocelot.ca/blog/blog/2015/03/02/the-ocelotgui-debugger/ This is a great news. Greetings. ___ Mailing li

Re: [Maria-discuss] Converting the whole database and tables from one charset+collation to another

2014-12-10 Thread Alexander Barkov
On 12/10/2014 01:48 PM, Honza Horak wrote: Google does not provide any source I would be sure of, many different approaches.. so rather asking here.. Given I have a database with latin1 and some latin* collation, the same for tables and I want to convert database, tables and data to utf8. Are

Re: [Maria-discuss] Mroonga storage engine is merged into MariaDB 10.0

2013-12-01 Thread Alexander Barkov
Hello Colin, On 12/01/2013 07:16 PM, Colin Charles wrote: Hi Bar, On 5 Nov 2013, at 17:24, Sergey Vojtovich wrote: FYI: Alexander Barkov volunteered to take over this task. I see https://mariadb.atlassian.net/browse/MDEV-5222 but there is nothing about it being updated for 10.0.7

Re: [Maria-discuss] Issues using the connect engine with ODBC on Linux

2013-10-15 Thread Alexander Barkov
Hi Eric, Which version of MariaDB, distribution (source or binary) and operating system are you using? On 10/14/2013 11:30 PM, eric hernandez wrote: Hi, I am trying to use the "Connect" engine to read data from Microsoft SQL Server 2008 R2 from a linux based MariaDB instance. I am getting the