BUG: SHOW CREATE DATABASE doesn't respect SQL_QUOTE_SHOW_CREATE - Michael Widenius - com.mysql.lists.bugs

4 messages in com.mysql.lists.bugsBUG: SHOW CREATE DATABASE doesn't res...

From	Sent On	Attachments
Paul DuBois	06 Oct 2002 18:55
Alexander Barkov	07 Oct 2002 03:03
Alexander Barkov	07 Oct 2002 03:22
Michael Widenius	07 Oct 2002 11:06

Subject:	BUG: SHOW CREATE DATABASE doesn't respect SQL_QUOTE_SHOW_CREATE
From:	Michael Widenius (mon...@mysql.com)
Date:	10/07/2002 11:06:12 AM
List:	com.mysql.lists.bugs

Hi!

"Paul" == Paul DuBois <pa...@snake.net> writes:

Paul> SHOW CREATE TABLE respects the value of the SQL_QUOTE_SHOW_CREATE
variable. Paul> SHOW CREATE DATABASE doesn't.

This is because we wanted to have an option to get CREATE TABLE compatible with other databases.

CREATE DATABASE doesn't have to be compatible (as this isn't a SQL standard command) and thus its better to always quite the result to avoid bugs for strange database names.

I agree that that this neads to be document...

Regards, Monty