- discuss - lists.mariadb.org

[Maria-discuss] stream sql
by Roberto Spadim 23 Mar '16

23 Mar '16

hi guys, anyone know if there's a stream sql interface to mysql? something like pipelinedb with postgresql? -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle

1 0

[Maria-discuss] New Question: Is MariaDB effected by the US trade sanctions?
by AskMonty KB 22 Mar '16

22 Mar '16

Hello, A new question has been asked in "Questions about licensing (MariaDB, plugins etc)" by tuomas_backman_g. Please answer it at http://mariadb.com/kb/en/is-mariadb-effected-by-the-us-trade-sanctions/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- My company is Finnish based company that was bought by US origin company. We are distributing an application running MariaDB under GPL to various countries including Iran. Since Mariadb foundation is registered to US, I wonder if US trade restrictions apply, ie. can't deliver MariaDB to Iran? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/is-mariadb-effected-by-the-us-trade-sanctions/

1 0

[Maria-discuss] New Question: mariaDB installation
by AskMonty KB 22 Mar '16

22 Mar '16

Hello, A new question has been asked in "Starting and Stopping MariaDB" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/starting-and-stopping-mariadb-mariadb-installation/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I want to install MariaDB in a directory which i have created and use it from there. Is there any way to do that? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/starting-and-stopping-mariadb-mariadb-installation/

1 0

[Maria-discuss] New Question: MariaDB Installation
by AskMonty KB 22 Mar '16

22 Mar '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-faq-mariadb-installation/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to install MariaDB as a non root user?? If yes,please provide a way to do the same. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-faq-mariadb-installation/

1 0

[Maria-discuss] Collations, trailing spaces and unique indexes
by Binarus 21 Mar '16

21 Mar '16

Dear all, I already have done some MySQL development and now eventually would like to switch to MariaDB because I no longer can stand the following: "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 include the LIKE pattern-matching operator, for which trailing spaces are significant." "For those cases where trailing pad characters are stripped or comparisons ignore them, if a column has an index that requires unique values, inserting into the column values that differ only in number of trailing pad characters will result in a duplicate-key error. For example, if a table contains 'a', an attempt to store 'a ' causes a duplicate-key error." (taken from https://dev.mysql.com/doc/refman/5.5/en/char.html) I did not find any information whether the collations which MariaDB provides are of type PADSPACE as in MySQL (none of the collation tables from MariaDB's documentation does contain this information) or not. To make a long story short: I would like to have CHAR and VARCHAR fields with unique indexes which consider 'a' and 'a ' to be different values (which is the only reasonable point of view IMHO). This is not possible with MySQL. Is it possible with MariaDB? I am generally working with charset UTF8 and would be happy with a general solution, but also with a non-general solution which only works with UTF8. Since the index behaviour obviously depends on the collation, would building an own collation which does not PADSPACE be an option? I have read vague hints about that in MariaDB's documentation, but didn't try yet (before doing so, I would like to know if there is an easy, clean solution). Thank you very much for any ideas, Binarus

10 27

[Maria-discuss] New Question: netframework support
by AskMonty KB 21 Mar '16

21 Mar '16

Hello, A new question has been asked in "MariaDB Documentation" by juantoledo. Please answer it at http://mariadb.com/kb/en/netframework-support/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Do you plan to support connection for apps with Microsoft net framework? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/netframework-support/

1 0

[Maria-discuss] warning : bison executable not found in PATH
by Shubham Barai 18 Mar '16

18 Mar '16

Hello everyone, I was trying to build MariaDB from source on windows. I have already installed bison in the dir C:\GnuWin32\ but still I am getting this error bison executable not found in PATH Any help would be appreciated. Thanks, Shubham

2 1

[Maria-discuss] MariaDB CONNECT Storage Engine access to Oracle 11GR2
by Ghazi Btissam 16 Mar '16

16 Mar '16

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 remote table ,but the *update *of the remote data is it possible? Thanks

2 1

[Maria-discuss] New Question: MariaDB Connector for Windows (1.05)
by AskMonty KB 15 Mar '16

15 Mar '16

Hello, A new question has been asked in "MariaDB Connector/ODBC" by fred_taylor_g. Please answer it at http://mariadb.com/kb/en/mariadb-connector-for-windows-105/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to connect to a MariaDB 10 database using the MariaDB ODBC Connector 1.05 on a WIN7 32 bit machine, but I can't get connected using it as I get an "Connectivity Error: Unknown system variable 'max_allowed_packet_size'". I can create a DSN and the "test" says it works, but I get the same error trying to use that DSN from Visual FoxPro 9.0/SP2. It fails with the above error trying a connection string in VFP: SQLSTRINGCONNECT("Driver={MariaDB ODBC 1.0 Driver};Server=localhost;UID=myuser;PWD=mypwd;DB=test;Port=3306;") Any explanations,as I can't find anything on 'max_allowed_packet_size'? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-connector-for-windows-105/

1 0

[Maria-discuss] Partitionning question
by Ghazi Btissam 14 Mar '16

14 Mar '16

Hi, 1- Could a partitioned table contain, or be referenced by, foreign keys? 2- As I saw in MariaDb documentation ,the subpartitions may use either HASH or KEY partitioning. Does the LIST subpartitioning exists in MariaDb? Can we use : a composite partitionning : RANGE/LIST? Thanks

2 1