[Maria-docs] sql_quote_show and SHOW CREATE PROCEDURE etc
The SHOW CREATE PROCEDURE, SHOW CREATE FUNCTION and SHOW CREATE TRIGGER articles were documented with the change:
The output of these statements is not affected by the sql_quote_show_create server system variable. (see for example https://kb.askmonty.org/en/show-create-procedure/revision/18704/18357/)
I've reverted this, as this is not strictly-speaking true. The output is unreliably affected by the variable. In my testing, the output of ALL procedures was quoted when the MOST RECENT procedure was created with sql_quote_show=1, and the output of all was unquoted when the most recent procedure was created with sql_quote_show=0.
A related bug is: http://bugs.mysql.com/bug.php?id=12719 but that bug report doesn't fully explain the (current) situation. The bug was also noted as "can't fix" in the comments.
I didn't want to document the above without further testing (will the quoted status of functions being created affect procedures? Triggers? Events?), so just reverted for now, but it's worth further investigating.
ian
Maybe we could write in the KB that the name quoting is not reliable for SHOW CREATE PROCEDURE, FUNCTION, TRIGGER statements?
Federico
-------------------------------------------- Gio 22/8/13, Ian Gilfillan launchpad@greenman.co.za ha scritto:
Oggetto: [Maria-docs] sql_quote_show and SHOW CREATE PROCEDURE etc A: maria-docs@lists.launchpad.net Data: Giovedì 22 agosto 2013, 09:15
The SHOW CREATE PROCEDURE, SHOW CREATE FUNCTION and SHOW CREATE TRIGGER articles were documented with the change:
The output of these statements is not affected by the sql_quote_show_create server system variable. (see for example https://kb.askmonty.org/en/show-create-procedure/revision/18704/18357/)
I've reverted this, as this is not strictly-speaking true. The output is unreliably affected by the variable. In my testing, the output of ALL procedures was quoted when the MOST RECENT procedure was created with sql_quote_show=1, and the output of all was unquoted when the most recent procedure was created with sql_quote_show=0.
A related bug is: http://bugs.mysql.com/bug.php?id=12719 but that bug report doesn't fully explain the (current) situation. The bug was also noted as "can't fix" in the comments.
I didn't want to document the above without further testing (will the quoted status of functions being created affect procedures? Triggers? Events?), so just reverted for now, but it's worth further investigating.
ian
_______________________________________________ Mailing list: https://launchpad.net/~maria-docs Post to : maria-docs@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-docs More help : https://help.launchpad.net/ListHelp
Yes, that would be best - I'll add this in, with a link to the bug report. If a more complete bug report is filed, or the behaviour is tested more thoroughly, we can change the link or describe it more completely then.
On 22/08/2013 19:16, Federico Razzoli wrote:
Maybe we could write in the KB that the name quoting is not reliable for SHOW CREATE PROCEDURE, FUNCTION, TRIGGER statements?
Federico
-------------------------------------------- Gio 22/8/13, Ian Gilfillan launchpad@greenman.co.za ha scritto:
Oggetto: [Maria-docs] sql_quote_show and SHOW CREATE PROCEDURE etc A: maria-docs@lists.launchpad.net Data: Giovedì 22 agosto 2013, 09:15
The SHOW CREATE PROCEDURE, SHOW CREATE FUNCTION and SHOW CREATE TRIGGER articles were documented with the change:
The output of these statements is not affected by the sql_quote_show_create server system variable. (see for example https://kb.askmonty.org/en/show-create-procedure/revision/18704/18357/)
I've reverted this, as this is not strictly-speaking true. The output is unreliably affected by the variable. In my testing, the output of ALL procedures was quoted when the MOST RECENT procedure was created with sql_quote_show=1, and the output of all was unquoted when the most recent procedure was created with sql_quote_show=0.
A related bug is: http://bugs.mysql.com/bug.php?id=12719 but that bug report doesn't fully explain the (current) situation. The bug was also noted as "can't fix" in the comments.
I didn't want to document the above without further testing (will the quoted status of functions being created affect procedures? Triggers? Events?), so just reverted for now, but it's worth further investigating.
ian
_______________________________________________ Mailing list: https://launchpad.net/~maria-docs Post to : maria-docs@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-docs More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-docs Post to : maria-docs@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-docs More help : https://help.launchpad.net/ListHelp
Hi all I am writing (on my local machine) a draft for a new GET DIAGNOSTICS page, which is currently missing. However my idea is to create also a "Diagnostics area" page, and before doing it I'd like to ask if my idea is ok for you. "Diagnostics area" would contain these info: * Descriptions of the error properties (remove those descriptions from SIGNAL page, which will have a link to Diagnostics area) * How the DA is populated and when it is cleared * Links to SIGNAL, RESIGNAL, GET DIAGNOSTICS, SHOW WARNINGS/ERRORS
My opinion is that there should even be a "diagnostics area" category, however I don't think I have the rights to create it.
bye Federico Razzoli
Hi Federico
That's great, we do need a GET DIAGNOSTICS article and a Diagnostics category, and I agree with your suggestions for the page. The best place to add the article for now is at https://kb.askmonty.org/en/programmatic-and-compound-statements/
I can't grant permission to create categories, Daniel (who's on holiday) or Bryan normally do this, but I can create it for you in the meantime. For now, just add the article/s to the page above, and I'll create the category once there's at least one article to populate it.
ian
On 24/08/2013 20:50, Federico Razzoli wrote:
Hi all I am writing (on my local machine) a draft for a new GET DIAGNOSTICS page, which is currently missing. However my idea is to create also a "Diagnostics area" page, and before doing it I'd like to ask if my idea is ok for you. "Diagnostics area" would contain these info: * Descriptions of the error properties (remove those descriptions from SIGNAL page, which will have a link to Diagnostics area) * How the DA is populated and when it is cleared * Links to SIGNAL, RESIGNAL, GET DIAGNOSTICS, SHOW WARNINGS/ERRORS
My opinion is that there should even be a "diagnostics area" category, however I don't think I have the rights to create it.
bye Federico Razzoli
_______________________________________________ Mailing list: https://launchpad.net/~maria-docs Post to : maria-docs@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-docs More help : https://help.launchpad.net/ListHelp
Hi Ian
I created the pages and updated SIGNAL & RESIGNAL. My suggestion is that the following pages are good for the diagnostics area category (without leaving their current categories): signal, resignal, get diagnostics, show warnings, show errors, error codes (maybe DECLARE HANDLER?).
Do you think that a SQLSTATE page is needed? The diagnostics area page is long, and some contents could be moved to SQLSTATE. There is a page about SQLSTATE, but it refers to the SQL99 standards, not Maria/My.
Federico
-------------------------------------------- Lun 26/8/13, Ian Gilfillan launchpad@greenman.co.za ha scritto:
Oggetto: Re: [Maria-docs] question, new pages A: maria-docs@lists.launchpad.net Data: Lunedì 26 agosto 2013, 10:22
Hi Federico
That's great, we do need a GET DIAGNOSTICS article and a Diagnostics category, and I agree with your suggestions for the page. The best place to add the article for now is at https://kb.askmonty.org/en/programmatic-and-compound-statements/
I can't grant permission to create categories, Daniel (who's on holiday) or Bryan normally do this, but I can create it for you in the meantime. For now, just add the article/s to the page above, and I'll create the category once there's at least one article to populate it.
ian
On 24/08/2013 20:50, Federico Razzoli wrote:
Hi all I am writing (on my local machine) a draft for a new
GET DIAGNOSTICS page, which is currently missing. However my idea is to create also a "Diagnostics area" page, and before doing it I'd like to ask if my idea is ok for you.
"Diagnostics area" would contain these info: * Descriptions of the error properties (remove those
descriptions from SIGNAL page, which will have a link to Diagnostics area)
* How the DA is populated and when it is cleared * Links to SIGNAL, RESIGNAL, GET DIAGNOSTICS, SHOW
WARNINGS/ERRORS
My opinion is that there should even be a "diagnostics
area" category, however I don't think I have the rights to create it.
bye Federico Razzoli
_______________________________________________ Mailing list: https://launchpad.net/~maria-docs Post to : maria-docs@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-docs More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-docs Post to : maria-docs@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-docs More help : https://help.launchpad.net/ListHelp
Thanks, I've created the category. Do you have permission to assign pages to categories, or do you need me to do that as well for now?
An SQLSTATE page would be good to have as well.
On 26/08/2013 13:24, Federico Razzoli wrote:
Hi Ian
I created the pages and updated SIGNAL & RESIGNAL. My suggestion is that the following pages are good for the diagnostics area category (without leaving their current categories): signal, resignal, get diagnostics, show warnings, show errors, error codes (maybe DECLARE HANDLER?).
Do you think that a SQLSTATE page is needed? The diagnostics area page is long, and some contents could be moved to SQLSTATE. There is a page about SQLSTATE, but it refers to the SQL99 standards, not Maria/My.
Federico
-------------------------------------------- Lun 26/8/13, Ian Gilfillan launchpad@greenman.co.za ha scritto:
Oggetto: Re: [Maria-docs] question, new pages A: maria-docs@lists.launchpad.net Data: Lunedì 26 agosto 2013, 10:22
Hi Federico
That's great, we do need a GET DIAGNOSTICS article and a Diagnostics category, and I agree with your suggestions for the page. The best place to add the article for now is at https://kb.askmonty.org/en/programmatic-and-compound-statements/
I can't grant permission to create categories, Daniel (who's on holiday) or Bryan normally do this, but I can create it for you in the meantime. For now, just add the article/s to the page above, and I'll create the category once there's at least one article to populate it.
ian
On 24/08/2013 20:50, Federico Razzoli wrote:
Hi all I am writing (on my local machine) a draft for a new
GET DIAGNOSTICS page, which is currently missing. However my idea is to create also a "Diagnostics area" page, and before doing it I'd like to ask if my idea is ok for you.
"Diagnostics area" would contain these info: * Descriptions of the error properties (remove those
descriptions from SIGNAL page, which will have a link to Diagnostics area)
* How the DA is populated and when it is cleared * Links to SIGNAL, RESIGNAL, GET DIAGNOSTICS, SHOW
WARNINGS/ERRORS
My opinion is that there should even be a "diagnostics
area" category, however I don't think I have the rights to create it.
bye Federico Razzoli
It seems that I don't have such permission for english language
Federico
-------------------------------------------- Lun 26/8/13, Ian Gilfillan launchpad@greenman.co.za ha scritto:
Oggetto: Re: [Maria-docs] question, new pages A: maria-docs@lists.launchpad.net Data: Lunedì 26 agosto 2013, 13:36
Thanks, I've created the category. Do you have permission to assign pages to categories, or do you need me to do that as well for now?
An SQLSTATE page would be good to have as well.
On 26/08/2013 13:24, Federico Razzoli wrote:
Hi Ian
I created the pages and updated SIGNAL & RESIGNAL.
My suggestion is that the following pages are good for the diagnostics area category (without leaving their current categories): signal, resignal, get diagnostics, show warnings, show errors, error codes (maybe DECLARE HANDLER?).
Do you think that a SQLSTATE page is needed? The
diagnostics area page is long, and some contents could be moved to SQLSTATE. There is a page about SQLSTATE, but it refers to the SQL99 standards, not Maria/My.
Federico
-------------------------------------------- Lun 26/8/13, Ian Gilfillan launchpad@greenman.co.za
ha scritto:
Oggetto: Re: [Maria-docs] question,
new pages
A: maria-docs@lists.launchpad.net Data: Lunedì 26 agosto 2013, 10:22 Hi Federico That's great, we do need a GET
DIAGNOSTICS article and a
Diagnostics category, and I agree with
your suggestions for
the page. The best place to add the
article for now is at https://kb.askmonty.org/en/programmatic-and-compound-statements/
I can't grant permission to
create categories, Daniel (who's
on holiday) or Bryan normally do this,
but I can create it
for you in the meantime. For now, just
add the article/s to
the page above, and I'll create the
category once there's at
least one article to populate it. ian On 24/08/2013 20:50,
Federico Razzoli wrote:
> Hi all > I am writing (on my local
machine) a draft for a new
GET DIAGNOSTICS page, which is
currently missing. However my
idea is to create also a "Diagnostics
area" page, and before
doing it I'd like to ask if my idea is
ok for you.
> "Diagnostics area" would contain
these info:
> * Descriptions of the error
properties (remove those
descriptions from SIGNAL page, which
will have a link to
Diagnostics area) > * How the DA is populated and
when it is cleared
> * Links to SIGNAL, RESIGNAL, GET
DIAGNOSTICS, SHOW
WARNINGS/ERRORS > > My opinion is that there should
even be a "diagnostics
area" category, however I don't think
I have the rights to
create it. > > bye > Federico Razzoli >
_______________________________________________ Mailing list: https://launchpad.net/~maria-docs Post to : maria-docs@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-docs More help : https://help.launchpad.net/ListHelp
Hi. I edited the Virtual Columns page https://mariadb.com/kb/en/virtual-columns/
It said that ALTER TABLE was fully supported. I modified this way:
##ALTER TABLE##'s ##MODIFY## and ##CHANGE## clauses are supported for ##PERSISTENT## columns, but not for ##VIRTUAL## columns.
This is based on the following test:
MariaDB [(none)]> SELECT VERSION(); +--------------------+ | VERSION() | +--------------------+ | 10.0.4-MariaDB-log | +--------------------+ 1 row in set (0.07 sec)
MariaDB [(none)]> DROP TABLE IF EXISTS `test`.`t`; Query OK, 0 rows affected (0.08 sec)
MariaDB [(none)]> CREATE TABLE `test`.`t`(`c` INT, `v` INT) ENGINE = InnoDB; Query OK, 0 rows affected (0.17 sec)
MariaDB [(none)]> ALTER TABLE `test`.`t` MODIFY COLUMN `v` INTEGER GENERATED ALW AYS AS (`c`+1) VIRTUAL; ERROR 1907 (HY000): This is not yet supported for computed columns MariaDB [(none)]> ALTER TABLE `test`.`t` MODIFY COLUMN `v` INTEGER GENERATED ALW AYS AS (`c`+1) PERSISTENT; Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0
MariaDB [(none)]> ALTER TABLE `test`.`t` MODIFY COLUMN `v` INTEGER; Query OK, 0 rows affected (2.27 sec) Records: 0 Duplicates: 0 Warnings: 0
Federico
A foreword: one of the reasons why the community (and also the customers imo, but this is harder to explain) should prefer MariaDB instead of MySQL is that the KB is free, while MySQL manual is not. This fact is not well-advertized though, so I suggest a link to one of the most "classical" GNU articles:
Why Free Software needs Free Documentation http://www.gnu.org/philosophy/free-doc.en.html
It's just a suggestion, of course.
Greetings Federico Razzoli
On Thu, Aug 29, 2013 at 10:51 AM, Federico Razzoli federico_raz@yahoo.it wrote:
A foreword: one of the reasons why the community (and also the customers imo, but this is harder to explain) should prefer MariaDB instead of MySQL is that the KB is free, while MySQL manual is not. This fact is not well-advertized though, so I suggest a link to one of the most "classical" GNU articles:
Why Free Software needs Free Documentation http://www.gnu.org/philosophy/free-doc.en.html
It's just a suggestion, of course.
It's a good suggestion. Where do you think we should we put the link? https://mariadb.com/kb/en/about/ seems to be the most logical. Anywhere else?
Thanks.
Ciao Daniel Colin Charles suggested me to do it myself, so I've added the link exactly in that page, at the end ("see also"): https://mariadb.com/kb/en/about/#see-also
Of course if someone knows a better place and moves the link, it's totally ok for me!
Greetings Federico
-------------------------------------------- Lun 2/9/13, Daniel Bartholomew dbart@mariadb.com ha scritto:
Oggetto: Re: [Maria-docs] suggestion: link to gnu article A: "Federico Razzoli" federico_raz@yahoo.it Cc: "maria-docs" maria-docs@lists.launchpad.net Data: Lunedì 2 settembre 2013, 18:29
On Thu, Aug 29, 2013 at 10:51 AM, Federico Razzoli federico_raz@yahoo.it wrote:
A foreword: one of the reasons why the community (and
also the customers imo, but this is harder to explain) should prefer MariaDB instead of MySQL is that the KB is free, while MySQL manual is not. This fact is not well-advertized though, so I suggest a link to one of the most "classical" GNU articles:
Why Free Software needs Free Documentation http://www.gnu.org/philosophy/free-doc.en.html
It's just a suggestion, of course.
It's a good suggestion. Where do you think we should we put the link? https://mariadb.com/kb/en/about/ seems to be the most logical. Anywhere else?
Thanks.
-- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart
MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org
participants (3)
-
Daniel Bartholomew -
Federico Razzoli -
Ian Gilfillan