Re: [Maria-developers] [Maria-discuss] Interval in MYsql query

Use the DATE_ADD( ) or DATE_SUB() function with INTERVAL as explained here: https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-add -- Peter. On Wed, May 16, 2018 at 4:07 PM, Dev C wrote: > Hello > > If I use below query >

Re: [Maria-developers] Deprecate INT(M) in SHOW?

I would also disadvise diverging from MySQL here, as the is no particular reason as far as I can see. -- Peter On Mon, Apr 23, 2018 at 4:17 PM, jocelyn fournier < jocelyn.fourn...@gmail.com> wrote: > > > > Le 23 avr. 2018 à 15:51, Alexander Barkov a écrit : > > > > Does

Re: [Maria-developers] Deprecate INT(M) in SHOW?

https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html " *M* indicates the maximum display width for integer types. The maximum display width is 255. Display width is unrelated to the range of values a type can contain" I just inserted "11" into an INT(5) column and was able

Re: [Maria-developers] Wording suggestion?

or 'concurrent_assign'/'concurrent assignment' -- Peter On Tue, Jan 30, 2018 at 11:35 AM, Peter Laursen <peter_laur...@webyog.com> wrote: > 'concurrent_eval'/'concurrent_evaluation' > > ?'? > > > -- Peter > -- Webyog > > On Mon, Jan 29, 2018 at 6:19 PM, S

Re: [Maria-developers] Fwd: Need Help

"mysqldump --no-data" should do, I believe. Or use a GUI-tool that has the option to create structure-only dumps. Or do things in one operation (eliminate the need for an intermediate script) with some "Schema Sync" tool such as http://sqlyogkb.webyog.com/article/302-schema-synchronization. --

Re: [Maria-developers] Why reserved keywords: UTC_TIME, UTC_DATE, UTC_DATETIME

They are listed as reserved words in MySQL documentation for any version from 5.0 and up (at least): https://dev.mysql.com/doc/refman/5.0/en/keywords.html. I think compablity with MySQL here is an even or a more valid/important concern here than standards' compliance. This is actually a minor

Re: [Maria-developers] Virtual columns and 'mysqldump' (and similar)

NOTHING is inserted to the Virtual Column. The value specified for it is ignored. That is the point! -- Peter On Mon, Nov 9, 2015 at 11:10 AM, Peter Laursen <peter_laur...@webyog.com> wrote: > I posted this blog: > http://blog.webyog.com/2015/11/09/beware-virtual-columns-may-re

Re: [Maria-developers] Virtual columns and 'mysqldump' (and similar)

Is this intentional or an oversight? Either the INSERT should be allowed in strict mode as well or the error message should be changed. Right? -- Peter On Sat, Nov 7, 2015 at 8:28 AM, Peter Laursen <peter_laur...@webyog.com> wrote: > Stupid oversight on my side: it probably depends on sq

Re: [Maria-developers] Virtual columns and 'mysqldump' (and similar)

I posted this blog: http://blog.webyog.com/2015/11/09/beware-virtual-columns-may-render-backups-unusable/. It should appear on planet.mysql.com shortly. -- Peter On Mon, Nov 9, 2015 at 10:17 AM, Peter Laursen <peter_laur...@webyog.com> wrote: > YES .. it is sql_mode that makes the d

Re: [Maria-developers] Virtual columns and 'mysqldump' (and similar)

Stupid oversight on my side: it probably depends on sql-mode. I will check on Monday. But if this is desired behavior (what I don't think) then at least the error message is wrong and confusing in strict mode. -- Peter On Fri, Nov 6, 2015 at 10:53 AM, Peter Laursen <peter_laur...@webyog.

Re: [Maria-developers] Virtual columns and 'mysqldump' (and similar)

packaging issue with the .msi. Some old/wrong code seems to go in there. -- Peter On Fri, Nov 6, 2015 at 12:21 PM, Peter Laursen <peter_laur...@webyog.com> wrote: > Correction .. there is no error (except for my copy-paste error). This is > perfect and exactly as I think it should be.

Re: [Maria-developers] Virtual columns and 'mysqldump' (and similar)

understand. -- Peter On Fri, Nov 6, 2015 at 1:41 PM, Peter Laursen <peter_laur...@webyog.com> wrote: > Further research: > > > > It *does not work* with the .msi package for Windows: > > > select version(); > -- 10.1.8-MariaDB > > CREATE TABLE `t1_virtual_uk` (

[Maria-developers] Virtual columns and 'mysqldump' (and similar)

I reported this bug report to Oracle: http://bugs.mysql.com/bug.php?id=79148 It is almost the same in MariaDB - but the error message is different, see SELECT VERSION(); -- 10.1.2-MariaDB-log CREATE TABLE `vc_test`.`t1`( `id` INT NOT NULL, `id3` INT AS ( id*3 ) VIRTUAL ); INSERT INTO

Re: [Maria-developers] Virtual columns and 'mysqldump' (and similar)

(1,3); SHOW WARNINGS; -- 1906 The value specified for computed column 'id3' in table 't1' ignored SELECT * FROM t1; /* id id3 -- 1 3 */ On Fri, Nov 6, 2015 at 12:10 PM, Peter Laursen <peter_laur...@webyog.com> wrote: > yup .. this is good! > >

Re: [Maria-developers] Virtual columns and 'mysqldump' (and similar)

as various clients would 'abort on error' and flood its log with error messages. -- Peter On Fri, Nov 6, 2015 at 11:32 AM, Ian Gilfillan <i...@mariadb.org> wrote: > > 06/11/2015 07:51, Peter Laursen wrote: > >> I reported this bug report to Oracle: >> http://bugs

Re: [Maria-developers] Virtual columns and 'mysqldump' (and similar)

gt; > INSERT INTO `test`.`t1` VALUES (1,3); > Query OK, 1 row affected, 1 warning (0.07 sec) > > Warning (Code 1906): The value specified for computed column 'id3' in > table 't1' ignored > > > > On 06/11/2015 08:09, Peter Laursen wrote: > > OK, I should

Re: [Maria-developers] passwordless mariadb root login with auht_socket in Debian

DELIMITERs are (should be) definitely handled in the client. The server does not know about it. It is also not listed here http://dev.mysql.com/doc/refman/5.6/en/sql-syntax.html for same reason. -- Peter On Tue, Feb 24, 2015 at 3:05 AM, Daniel Black daniel.bl...@openquery.com wrote: -

Re: [Maria-developers] Interest in Contributing to MariaDB and participation in GSoC 2015

I don't know if the MariaDB people have this priority, but inplementing CHECK CONSTRAINTS always was an omission in MySQL. You may specify such currently in CREATE/ALTER TABLE. but it is silently ignored. -- Peter -- Webyog On Mon, Feb 9, 2015 at 6:47 AM, Jonas Oreland jon...@google.com wrote:

Re: [Maria-developers] MDEV-7286 TRIGGER: CREATE OR REPLACE, CREATE IF NOT EXISTS

As regards TRIGGERS in MySQL I am very much missing what PostgreSQL (and maybe other RDBMS as well) has: an option to [temporarily] disable TRIGGGER[S] for all or specific users - like listed in PostgreSQL docs: ( http://www.postgresql.org/docs/9.2/static/sql-altertable.html) ALTER TABLE ..

Re: [Maria-developers] Dynamic columns support in libmaria client library?

Can't we then have LGPL *clones* bundled with libmariadb? -- Peter On Tue, Jan 27, 2015 at 11:51 PM, Oleksandr Byelkin sa...@montyprogram.com wrote: Hi! On 27.01.15 21:09, Peter Laursen wrote: [skip] Now can ma_dyncol.h be linked against libmaria as well? There are 2

Re: [Maria-developers] Dynamic columns support in libmaria client library?

Is it not possible to have a reply here? --Peter On Fri, Dec 26, 2014 at 1:28 PM, Peter Laursen peter_laur...@webyog.com wrote: This page https://mariadb.com/kb/en/mariadb/documentation/nosql/dynamic-columns-api/ does not mention anything about it. it just says *The API is a part

Re: [Maria-developers] Renaming Virtual Columns to Computed Columns

Few points: 1) As regards terminology, IMHO it would be logical if 'computed' is used as the upperlevel term. sublevel' terms would be 'virtual' and 'persistent' (ie. a 'computed' column may be either 'virtual' or 'persistent'). 2) It is not clear to me if this also proposes a change to DDL

Re: [Maria-developers] Dynamic columns support in libmaria client library?

latin1_swedish_ci text select,insert,update,references */ On Fri, Dec 26, 2014 at 1:28 PM, Peter Laursen peter_laur...@webyog.com wrote: This page https://mariadb.com/kb/en/mariadb/documentation/nosql/dynamic-columns-api/ does not mention anything about it. it just says *The API

[Maria-developers] Dynamic columns support in libmaria client library?

This page https://mariadb.com/kb/en/mariadb/documentation/nosql/dynamic-columns-api/ does not mention anything about it. it just says *The API is a part of libmysql C client library. In order to use it, one needs to include this header file* *#include mysql/ma_dyncol.h* *and link against

[Maria-developers] COMPOUND STATEMENT fails on Windows.

I tried to comment on this Blog https://blog.mariadb.org/mariadb-10-1-1-compound-statements/, but it won't let me use my (corporate) gmail address for authencticaton. So I send this mail instead: I tried the example provided on Windows (both server and client are Win7 64 bit) using the command

Re: [Maria-developers] COMPOUND STATEMENT fails on Windows.

Obviously I neeed to set another delimiter. Thanks! -- Peter On Wed, Oct 22, 2014 at 12:40 PM, Sergei Golubchik s...@mariadb.org wrote: Hi, Peter! On Oct 22, Peter Laursen wrote: I tried to comment on this Blog https://blog.mariadb.org/mariadb-10-1-1-compound-statements/, but it won't

Re: [Maria-developers] Isn't thsi a bug?

OK .. it is not a big deal either! Thanks for replying. -- Peter On Mon, Oct 13, 2014 at 2:35 PM, Sergei Golubchik s...@mariadb.org wrote: Hi, Peter! On Oct 06, Peter Laursen wrote: Refer: http://bugs.mysql.com/bug.php?id=74238 here I prefer the 'relaxed parsing' in Maria DB

Re: [Maria-developers] Is it soon 'end of this year'?

! On Sep 17, Peter Laursen wrote: Around ˝ year ago I discussed with some people here (Sergei G and/or Georg and/or Wlad) about support for Oracle-style plugins in the MariaDB C-API. The plugins include 1 Windows authentication plugin 2) Clear text plugin. At that time I was told

Re: [Maria-developers] Is it soon 'end of this year'?

wrote: do you have the source of oracle plaintext auth plugin? i want read it 2014-10-13 12:09 GMT-03:00 Peter Laursen peter_laur...@webyog.com: Well .. where will I find it documented how to use it with Oracle-MySQL configured for their LDAP authenticaton setup? The same code that worked

Re: [Maria-developers] Is it soon 'end of this year'?

due to this. -- Peter On Mon, Oct 13, 2014 at 7:49 PM, Sergei Golubchik s...@mariadb.org wrote: Hi, Peter! On Oct 13, Peter Laursen wrote: Well .. where will I find it documented how to use it with Oracle-MySQL configured for their LDAP authenticaton setup? The same code that worked

Re: [Maria-developers] Is it soon 'end of this year'?

. -- Peter On Mon, Oct 13, 2014 at 8:29 PM, Peter Laursen peter_laur...@webyog.com wrote: OK .. we will check this again. But in principle we want (always) not to have any external dependencies in our prorams/apllications at at all. We link statically everything to the extend possible. People

Re: [Maria-developers] Is it soon 'end of this year'?

wrote: Hi, Peter! On Oct 13, Peter Laursen wrote: To make it clear: it is not acceptable/not a usable solution for us if it is a requirement that a MariaDB server is installed on user's system. The client (in case SQLyog - but it could be any client) should work for connection to remote

[Maria-developers] Isn't thsi a bug?

Refer: http://bugs.mysql.com/bug.php?id=74238 here I prefer the 'relaxed parsing' in Maria DB. But look at this: CREATE TABLE `d` ( `rec_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `datetime` DATETIME(4) DEFAULT NULL, `timestamp` TIMESTAMP(4) NOT NULL DEFAULT CURRENT_TIMESTAMP(5) ON UPDATE

[Maria-developers] Is it soon 'end of this year'?

Around ½ year ago I discussed with some people here (Sergei G and/or Georg and/or Wlad) about support for Oracle-style plugins in the MariaDB C-API. The plugins include 1 Windows authentication plugin 2) Clear text plugin. At that time I was told that it could be considered 'by end end of this

Re: [Maria-developers] Question about GTIDs in MariaBD

!) -- Peter On Sun, May 11, 2014 at 10:44 PM, AL13N al...@mageia.org wrote: Op zondag 11 mei 2014 16:59:10 schreef Peter Laursen: With autocommit=1 every statement runs in its own transaction, so obviousluy .. yes! MyISAM is/used to be completely 'transaction-agnosstic'. But GTIDs seem

Re: [Maria-developers] Question about GTIDs in MariaBD

I blogged this: http://blog.webyog.com/2014/05/12/suddenly-myisam-became-transaction-aware/ It should appear on planet.mysql.com soon. -- Peter On Mon, May 12, 2014 at 10:53 AM, Kristian Nielsen kniel...@knielsen-hq.org wrote: AL13N al...@rmail.be writes: Peter Laursen peter_laur

Re: [Maria-developers] Question about GTIDs in MariaBD

on slaves. Pavel On Sat, May 10, 2014 at 3:48 AM, Peter Laursen peter_laur...@webyog.com wrote: GTID implementation in MySQL 5.6 has the limitation as described here: https://dev.mysql.com/doc/refman/5.6/en/replication-gtids-restrictions.html nontransactional storage engines such as MyISAM

Re: [Maria-developers] Question about GTIDs in MariaBD

in the server layer and not the storeage engine layer) by Oracle 'a dirty hack' (unless somewone can explain me why it it necessary). -- Peter On Sun, May 11, 2014 at 4:42 PM, Roberto Spadim robe...@spadim.com.brwrote: With autoclmmit=1 works? Em domingo, 11 de maio de 2014, Peter Laursen peter_laur

[Maria-developers] Question about GTIDs in MariaBD

be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables. Is there same or similar/other limitations with GTID in MariaDB 10? -- Peter Laursen -- Webyog ___ Mailing

[Maria-developers] MariaDB C-API and specific P_S tables

THis is probably a question that Gerog Richter (or possibly Wlad) could reply to. I came across this bug report: http://bugs.mysql.com/bug.php?id=71801 .. files by former MySQL/Sun/Oracle supporter Veleriuy Kravtchuk We have a 64 bit C-application compiled with MariaDB C-API (on and for Windows

Re: [Maria-developers] MariaDB C-API and specific P_S tables

BTW: the two tables do not exist in P_S in MariaDB 10.0.8 -- Peter On Mon, Feb 24, 2014 at 4:02 PM, Peter Laursen peter_laur...@webyog.comwrote: THis is probably a question that Gerog Richter (or possibly Wlad) could reply to. I came across this bug report: http://bugs.mysql.com/bug.php

Re: [Maria-developers] MariaDB C-API and specific P_S tables

be Win-only problem. -- Peter On Mon, Feb 24, 2014 at 5:47 PM, Sergei Golubchik s...@mariadb.org wrote: Hi, Peter! On Feb 24, Peter Laursen wrote: BTW: the two tables do not exist in P_S in MariaDB 10.0.8 What tables don't exist? MariaDB [test] SELECT * FROM

Re: [Maria-developers] MariaDB C-API and specific P_S tables

\bin -- Peter On Mon, Feb 24, 2014 at 7:29 PM, Peter Laursen peter_laur...@webyog.comwrote: SELECT VERSION(); -- returns 10.0.8-MariaDB USE `performance_schema`; SHOW TABLES LIKE 'session%'; -- empty set .. but maybe I should run rememer to run mysql_upgrade before complaining about

Re: [Maria-developers] parallel replication monitoring

useful to have in I_S or P_S. I vote for I_S. P_S may be disabled by admin due to its memory and cpu overhead. -- Peter -- Webyog On Fri, Nov 15, 2013 at 11:20 AM, Kristian Nielsen kniel...@knielsen-hq.org wrote: Giuseppe Maxia g.ma...@gmail.com writes: * which database they are running

[Maria-developers] MySQL bug affects mariaDB

I think the 'mysql' client with MariaDB has a similar problem as it has with MySQL - refer? http://bugs.mysql.com/bug.php?id=70443 MariaDB installer installs my.ini to /datadir - what with MariaDB is a subfolder to /basedir. The server will look for it correctly as the registry key defining the

Re: [Maria-developers] MySQL bug affects mariaDB

that this bug does not affect MariaDB. ** ** ** ** ** ** *From:* Maria-developers [mailto:maria-developers-bounces+wlad= montyprogram@lists.launchpad.net] *On Behalf Of *Peter Laursen *Sent:* Freitag, 27. September 2013 10:06 *To:* Maria Developers; Maria Discuss *Subject:* [Maria

Re: [Maria-developers] [Maria-discuss] MySQL bug affects mariaDB

alternative. ** ** ** ** *From:* Justin Swanhart [mailto:greenl...@gmail.com] *Sent:* Freitag, 27. September 2013 19:54 *To:* Vladislav Vaintroub *Cc:* Peter Laursen; Maria Developers; Maria Discuss *Subject:* Re: [Maria-discuss] [Maria-developers] MySQL bug affects mariaDB

Re: [Maria-developers] MySQL bug affects mariaDB

. In doubt, I provide –port , and that’s all I need for the command line clients ** ** *From:* Peter Laursen [mailto:peter_laur...@webyog.com] *Sent:* Freitag, 27. September 2013 19:15 *To:* Vladislav Vaintroub *Cc:* Maria Developers; Maria Discuss *Subject:* Re: [Maria-developers] MySQL

Re: [Maria-developers] Some clarifications requested for C client

*including the SQLite codebase* (functionalities of any kind added due to this), then some explanation/documentation would be nice. -- Peter Laursen (Webyog) On Sun, Aug 25, 2013 at 3:25 PM, Peter Laursen peter_laur...@webyog.comwrote: This is probably for Georg Richter (and/or @Wlad). I have a few

[Maria-developers] Some clarifications requested for C client

and why it was added. 4) Why does the changelog here https://kb.askmonty.org/en/mariadb-client-library-for-c-100-changelog/ stop at revision 77? -- Peter Laursen -- Webyog ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria

Re: [Maria-developers] Some clarifications requested for C client

don't understand how to navigate Launchpad! -- Peter On Sun, Aug 25, 2013 at 3:25 PM, Peter Laursen peter_laur...@webyog.comwrote: This is probably for Georg Richter (and/or @Wlad). I have a few qeustion! 1) https://bazaar.launchpad.net/~maria-captains/mariadb-native-client/trunk/revision/80

Re: [Maria-developers] Can't sign up to JIRA

I just want to add that I find JIRA very tedious to use. If I have not used it for a while, I cannot authenticate and will have to go through the reset password procedure again. And the interface for this is confusing. Besides, does password expire after a week? It looks like it. -- Peter On

Re: [Maria-developers] Can there be a better storage engine API?

be useful. -- Peter Laursen On Mon, Aug 19, 2013 at 5:36 PM, MARK CALLAGHAN mdcal...@gmail.com wrote: Thanks for your response. On Fri, Aug 16, 2013 at 11:23 AM, Zardosht Kasheff zardo...@gmail.comwrote: I've worked on the TokuDB storage engine for quite a while now. I have had many

Re: [Maria-developers] COT() function

I just checked in (Oracle) MySQL 5.5.32 and 5.6.13. SELECT COT(0) -- returns Error CODE: 1690 DOUBLE VALUE IS OUT of RANGE IN 'cot(0)' So this change in behaviour has its origin in (Oracle) MySQL 5.5. On Thu, Aug 1, 2013 at 9:56 PM, Ian Gilfillan launch...@greenman.co.zawrote: Hi SELECT

Re: [Maria-developers] RFC: Pausing a query thread

I think it is a known issue wiht 'hsared hosting' . Any user can fire a query killing the server (for example causing excessive memory load ude to a cartesian join on huge tables, or CPU due a a routine entering an infinite loop. It can be both due to user's lack of skills og even be a malicious

Re: [Maria-developers] RFC: Pausing a query thread

Why not take a more daring approach - implement 'priorities' in processlist? SET PRIORITY = high|medium|low [or 1..9] FOR processlist.ID=xx; I realize that this is not a trivial task, and obviously it requires so much change in server architecture that it is not a solution for Marian

Re: [Maria-developers] RFC: Pausing a query thread

what this should do?. Processlist would then have one more column ('PRIORITY*). And the value of that column is the priority with what the OS executes this paricular thread (forever in the lifetime of the thread or for the time of current query only - could be one more parameter). But my system

Re: [Maria-developers] Uninstalling MariaDB 5.2 does not remove everything.

5.2\\include\\mysql.h A C header file added to my registry when installing a binary? -- Peter On Sat, Jun 22, 2013 at 6:19 PM, Peter Laursen peter_laur...@webyog.comwrote: refresh does not work. clsong control panel and opening again also not. deleteing the registry keys

Re: [Maria-developers] Uninstalling MariaDB 5.2 does not remove everything.

. ** ** ** ** *From:* Peter Laursen [mailto:peter_laur...@webyog.com] *Sent:* Samstag, 22. Juni 2013 18:20 *To:* Vladislav Vaintroub *Cc:* Maria Developers *Subject:* Re: [Maria-developers] Uninstalling MariaDB 5.2 does not remove everything. ** ** refresh does not work. clsong control

Re: [Maria-developers] [Maria-discuss] Clear-text plugin

at 3:25 PM, Sergei Golubchik s...@mariadb.org wrote: Hi, Peter! On Jun 04, Peter Laursen wrote: We have the same problem. We cannot test either. But we have a few user reports. We will discuss what we can do. Is there any parameter or compile-time option we should be aware of? Any

[Maria-developers] Clear-text plugin

of customers using Oracle's Enterprise servers wiht Oracle's PAM authentication. A solution/workaround would very much be appreciated. Regards Peter Laursen Webyog ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers

Re: [Maria-developers] [Maria-discuss] Clear-text plugin

For clarity: a 'dummy' parameter doing nothing does not solve our problem. We actually want to build clients that can (also) connect to Oracle MySQL Enterprise servers configured to make use of Oracle's PAM implementation. -- Peter On Tue, Jun 4, 2013 at 11:05 AM, Peter Laursen peter_laur

Re: [Maria-developers] [Maria-discuss] Clear-text plugin

...@mariadb.org wrote: Hi, Peter! On Jun 04, Peter Laursen wrote: For clarity: a 'dummy' parameter doing nothing does not solve our problem. We actually want to build clients that can (also) connect to Oracle MySQL Enterprise servers configured to make use of Oracle's PAM implementation

Re: [Maria-developers] [Maria-discuss] Json Explain

am not well-versed in server internals, I could have ovelooked/misunderstood something, of course. -- Peter On Fri, Sep 28, 2012 at 5:18 PM, Peter Laursen peter_laur...@webyog.comwrote: @wlad is completely right! Workbench introduced a Visual Explain based on JSON EXPLAIN as Blogged here: http

Re: [Maria-developers] [Maria-discuss] Json Explain

BTW: I reported this bug to MySQL: http://bugs.mysql.com/bug.php?id=67022 -- Peter On Fri, Sep 28, 2012 at 5:18 PM, Peter Laursen peter_laur...@webyog.comwrote: @wlad is completely right! Workbench introduced a Visual Explain based on JSON EXPLAIN as Blogged here: http://www.arubin.org/blog

Re: [Maria-developers] [Maria-discuss] Json Explain

+ http://bugs.mysql.com/bug.php?id=67023 -- Peter On Sun, Sep 30, 2012 at 1:39 PM, Peter Laursen peter_laur...@webyog.comwrote: BTW: I reported this bug to MySQL: http://bugs.mysql.com/bug.php?id=67022 -- Peter On Fri, Sep 28, 2012 at 5:18 PM, Peter Laursen peter_laur...@webyog.comwrote

Re: [Maria-developers] [Maria-discuss] Json Explain

to co-sponsor the feature (together with MP AB) we could discuss the details of the possible simple implementation. And of course we will support it in MariaDB if anybody else provide us with a patch for such an implementation. Regards, Igor. On 09/30/2012 04:23 AM, Peter Laursen wrote: I

[Maria-developers] Json Explain

Is Explain output in Json format planned in MariaDB (refer http://glebshchepa.blogspot.in/2012/04/optimizer-new-explain-formatjson.html) ? If so when? and will the implementation details and output format be fully identical to Oracle/MySQL 5.6? (I did not find it mentioned here:

Re: [Maria-developers] [Maria-discuss] Json Explain

] On Behalf Of Michael Widenius Sent: Freitag, 28. September 2012 16:04 To: Peter Laursen; i...@askmonty.org; tim...@askmonty.org; pser...@askmonty.org Cc: Maria Discuss; Maria Developers Subject: Re: [Maria-discuss] [Maria-developers] Json Explain For the moment we don't have a plan

Re: [Maria-developers] Support of the extended syntax for ANALYZE

We usually don't use key words in plural. So what about SHOW COLUMNS? -- Peter On Sat, May 19, 2012 at 7:41 PM, Igor Babaev i...@askmonty.org wrote: On 05/19/2012 04:22 AM, Sergei Golubchik wrote: Hi, Igor! On May 10, Igor Babaev wrote: Serg, Here's the patch we talked about on

Re: [Maria-developers] MariaDB 5.5.21

Wasn't too much copy-paste done? http://kb.askmonty.org/en/mariadb-5520-release-notes reads This is the first 5.5-based release .. Also http://kb.askmonty.org/en/mariadb-5521-release-notes reads This is the first 5.5-based release .. I do not understand how 5.5.21 can be the first if 5.5.20

Re: [Maria-developers] 5.3.5 GA release : binaries are ready and tagged

Typo: Note that: when Multi Ragne Read Note that: when Multi Range Read -- Peter On Wed, Feb 29, 2012 at 11:04, Sergei Petrunia pser...@askmonty.org wrote: On Wed, Feb 29, 2012 at 12:59:55PM +0400, Sergei Petrunia wrote: (I will also look through the changes to see what should be

Re: [Maria-developers] Documentation for MWL#192: non-blocking client API

With what license(s) is this new libmyslclient code being released? GPL (as in MySQL 4.0+) or 'more permissive' of some kind - BSD/Apache/whatever (like MySQL 3.23)? -- Peter -- Webyog On Tue, Feb 28, 2012 at 13:37, Kristian Nielsen kniel...@knielsen-hq.orgwrote: Hi Daniel! I have pushed

Re: [Maria-developers] Feature request: Add support for a syntax check for SQL scripts

It is similar to a request we had from our users from time to time. An option to *parse* SQL statement(s) *server side* without actually executing. (EXPLAIN and EXPLAIN EXTENDED are non-complete solutions). I think it is difficult. MySQL was never designed for it. Basically I think that all SQL

Re: [Maria-developers] Feature request: Add support for a syntax check for SQL scripts

scripts against a test database before sending to the beta server so that users can look at the result before release. This happens almost every night. That helpful? Marco dentro de perez zeledon On 10/13/2011 6:11 PM, Peter Laursen wrote: It is similar to a request we had from our users

Re: [Maria-developers] 5.5 merge status

A maybe provocatice question: Did you consider to discard MySQL 5.5 and focus on 5.6 instead for the next major MariaDB relelase? -- PETER On Fri, Oct 7, 2011 at 22:45, Sergei Golubchik s...@askmonty.org wrote: Hi, Kristian! About LOCK_log, LOCK_index, LOCK_thread_count and the Bug#62614:

[Maria-developers] Microseconds support in MariaDB 5.3.

I noticed: http://askmonty.org/blog/the-2-year-old-mariadb/ The support for microseconds in TIMESTAMP, DATETIME, and TIME. I fully agree the 'full seconds support only' has been a sever limitation in MySQL. But I have two concerns with ths: 1) 'noisyness'. On not very fast systems the last

Re: [Maria-developers] [Maria-discuss] Microseconds support inMariaDB 5.3.

@Philip .. I have one more question. Can libmysql as distributed by Oracle handle those extended precision DATE(TIME)STAMPs - or will only the one distributed with MariaDB do properly?? -- Peter On Wed, Sep 21, 2011 at 16:51, Philip Stoev phi...@stoev.org wrote: That is fine then! Only a

Re: [Maria-developers] WL#202 New (by Monty): Extend progress reporting

I understand that this is implemented in the command line client, but what about the C-API (and what other connectors you may distribute)? Peter Webyog On Thu, Jun 30, 2011 at 13:04, worklog-nore...@askmonty.org wrote: ---

Re: [Maria-developers] WL#202: Extend progress reporting

is working too. But I think it should be listed explicitly if supported.* * -- Peter On Thu, Jun 30, 2011 at 13:29, Sergei Golubchik s...@askmonty.org wrote: Hi, Peter! On Jun 30, Peter Laursen wrote: I understand that this is implemented in the command line client, but what about the C-API

Re: [Maria-developers] WL#202: Extend progress reporting

...@askmonty.org wrote: Hi, Peter! On Jun 30, Peter Laursen wrote: I did already. And it reads Clients that supports progress reporting: * The mysql command line client, starting from version 15.0 (comes with MariaDB 5.3). * mytop which comes with MariaDB 5.3 has a '%' column

Re: [Maria-developers] WL#202: Extend progress reporting

Let me add that the reason I am asking is that for us (MONyog in particular) it would be interesting to support it. To do so will we need to replace the client library/C-API to the one shipped with MariaDB 5.3? -- Peter On Thu, Jun 30, 2011 at 16:02, Peter Laursen peter_laur...@webyog.comwrote

Re: [Maria-developers] MariaDB limits

@Sergei .. I cannot reply on behalf of Marian, of course. But the current 'limitation_per_hour' user settings would have same considerations in this respect as 'limitation_per_24hour' proposed by Marian would as far as I can see. Either it is * between current_time and current_day:00:00:00 --

Re: [Maria-developers] MariaDB limits

@Marain .. you probably know this: http://dev.mysql.com/doc/refman/5.1/en/user-resources.html . This is same for MySQL and MariaDB. I_S is a *read-only* database. And if you want to add more configurable per-user limitations such should IMHO go to the `mysql` database. I also don't think (for

Re: [Maria-developers] [Maria-discuss] Reqeust for SHOW FULL FIELDS FROM and virtual tables in MariaDB

to NULL. -- but in strict mode I think errors whoud be returned where warnings currently are. Virtual columns should be sql_mode-aware'. -- Peter On Fri, Jun 3, 2011 at 05:24, Arjen Lentz ar...@openquery.com wrote: Hi Peter, all From: Peter Laursen peter_laur...@webyog.com Refer http

[Maria-developers] Reqeust for SHOW FULL FIELDS FROM and virtual tables in MariaDB

Refer http://kb.askmonty.org/v/virtual-columns - the example CREATE TABLE table1 ( a INT NOT NULL, b VARCHAR(32), c INT AS (a MOD 10) virtual, d VARCHAR(5) AS (LEFT(b,5)) persistent); now SHOW FULL FIELDS FROM table1; Field Type Collation Null Key Default Extra Privileges Comment --

Re: [Maria-developers] mysql improvement idea - field type file

Actually I believe that could be implemented as a storage engine? The database would be the par of the file system that mysqld can access for both read and write. Each table in it would be a folder and every distinct value a file. A few additional syntactical constructs would be needed (but lots

[Maria-developers] 5.2.6 .msi isntaller questions issues

on both (OR'ed) prefixes 'mysql' and 'maria'. Anyway after just exiting the wizard before executing it everything seems fine. But the wizard GUI can still be 'polished' a little I think. -- Peter Laursen -- Webyog ___ Mailing list: https

Re: [Maria-developers] Windows installer MWL#55 finished.

On Tue, Mar 8, 2011 at 20:23, Vladislav Vaintroub w...@montyprogram.comwrote: *From:* Peter Laursen [mailto:peter_laur...@webyog.com] *Sent:* Mittwoch, 2. März 2011 11:30 *To:* Vladislav Vaintroub *Cc:* Kazuhisa Ichikawa; maria-developers@lists.launchpad.net *Subject:* Re: [Maria

Re: [Maria-developers] [Maria-discuss] MariaDB 5.6

:10, Kristian Nielsen kniel...@knielsen-hq.orgwrote: Peter Laursen peter_laur...@webyog.com writes: I noticed this on planet.mysql: http://kb.askmonty.org/v/plans-for-56 I *again* strongly want to discourage a major version number identical with a MySQL/Oracle release. MySQL plans a 5.6

[Maria-developers] MariaDB 5.6

I noticed this on planet.mysql: http://kb.askmonty.org/v/plans-for-56 I *again* strongly want to discourage a major version number identical with a MySQL/Oracle release. MySQL plans a 5.6 too and I believe that there is already a source-tree available on launchpad. I think I understand that

Re: [Maria-developers] Default parameter settings / Windows MSI installer

1) As I have already told I request a max_allowed_packet setting larger than 1M (in both [mysqld] and [mysqldump] sections). Oracle-MySQL sets 1M in [mysqld] and 16M in [mysqldump]. I prefer 64M in both actually. The reason is that BLOBs are commonly used to store images/photos and with recent

Re: [Maria-developers] Default parameter settings / Windows MSI installer

XtraDB identifies itself as 'InnoDB' (in I_S tables and SHOW ENGINES). And X is in every respect backwards compatible with I. Even in CREATE TABLE statments you name it 'InnoDB'. For those users not familiar with the 'political situation' around MySQL 'InnoDB' would be familiar and 'XtraDB'

Re: [Maria-developers] Windows installer MWL#55 finished.

It seems that http://downloads.askmonty.org/mariadb/ still has the old NSIS-based installer for 5.1.55? -- Peter On Tue, Feb 8, 2011 at 00:46, Vladislav Vaintroub w...@montyprogram.comwrote: -Original Message- From: kah...@gmail.com [mailto:kah...@gmail.com] On Behalf Of Kazuhisa

Re: [Maria-developers] Windows installer MWL#55 finished.

@Vlad SHOW ENGINES ENGINE Support - .. PBXT NO I think that the .zip package had PBXT enabled as default. Can I enable it somehow with this build? PBXT is actually *THE REASON* why MariaDB is interesting for me. -- Peter On Fri, Feb 4, 2011 at 16:51, Vladislav

Re: [Maria-developers] Windows installer MWL#55 finished.

Thanks .. worked fine. No crash till now ... -- Peter On Fri, Feb 4, 2011 at 17:13, Vladislav Vaintroub w...@montyprogram.comwrote: From: Peter Laursen [mailto:peter_laur...@webyog.com] Sent: Freitag, 4. Februar 2011 16:58 To: Vladislav Vaintroub Cc: Kazuhisa Ichikawa; maria-developers

Re: [Maria-developers] Windows installer MWL#55 finished.

I am a little bit busy now, but will confirm tonight. -- Peter On Wed, Feb 2, 2011 at 14:12, Vladislav Vaintroub w...@montyprogram.comwrote: From: Peter Laursen [mailto:peter_laur...@webyog.com] Sent: Dienstag, 1. Februar 2011 20:31 To: Vladislav Vaintroub Cc: maria-developers

Re: [Maria-developers] Windows installer MWL#55 finished.

On Wed, Feb 2, 2011 at 19:04, Vladislav Vaintroub w...@montyprogram.comwrote: From: Peter Laursen [mailto:peter_laur...@webyog.com] Sent: Mittwoch, 2. Februar 2011 17:14 To: Vladislav Vaintroub Cc: maria-developers@lists.launchpad.net Subject: Re: [Maria-developers] Windows installer MWL

Re: [Maria-developers] Windows installer MWL#55 finished.

sorry .. it was 32 bit installer! On Tue, Feb 1, 2011 at 18:43, Peter Laursen peter_laur...@webyog.comwrote: hmmm .. installer rolls back. Why? 64 bit build on 64 bit Win7 (UAC disabled). Default file path. No conflicts with ports or service name specified. After rollback

Re: [Maria-developers] Windows installer MWL#55 finished.

Event Viewer has some info like 'Product: MariaDB 5.2 (x64) -- Installation failed.' But nothing that can be used really. -- Peter On Tue, Feb 1, 2011 at 18:54, Peter Laursen peter_laur...@webyog.comwrote: Same problem with 64 bit. Installation path, port and service name does not matter. i am

  1   2   >