| Bug #71953 | SQL_PATH not documented | ||
|---|---|---|---|
| Submitted: | 6 Mar 2014 7:12 | Modified: | 7 Mar 2014 19:49 |
| Reporter: | Daniël van Eeden (OCA) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
| Version: | 5.6 | OS: | Any |
| Assigned to: | Paul DuBois | CPU Architecture: | Any |
[6 Mar 2014 7:12]
Daniël van Eeden
[6 Mar 2014 8:36]
MySQL Verification Team
Hello Daniel, Thank you for the bug report. Thanks, Umesh
[6 Mar 2014 9:45]
Daniël van Eeden
In Oracle Database SQLPATH is used to configure a search path for sql scripts. http://docs.oracle.com/cd/B28359_01/server.111/b31189/ch2.htm So the SQLPATH is probably not used. It is somewhat related to secure_file_priv.
[7 Mar 2014 16:41]
Paul DuBois
"What is the SQL_PATH? What does it do?" As indicated in the table on that page, it's NULL. It does nothing. "So the SQLPATH is probably not used. It is somewhat related to secure_file_priv." Can you clarify? How could it be related if it's NULL?
[7 Mar 2014 17:11]
Daniël van Eeden
Indeed the 'NULL' remark is correct. Feel free to close this as not-a-bug. I would have found 'Reserved for future use' a more clear and understandable remark. The 'SHOW Name' column is empty, but for the row with SCHEMA_NAME is should have 'Database' shouldn't it? Maybe the column should be named 'Value' instead of Remark?
[7 Mar 2014 19:49]
Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products. "Maybe the column should be named 'Value' instead of Remark?" The column is sometimes used for others things than the value. General notes about columns in these tables are found here: http://dev.mysql.com/doc/refman/5.6/en/information-schema.html under Conventions in the INFORMATION_SCHEMA Reference Sections. "The 'SHOW Name' column is empty, but for the row with SCHEMA_NAME is should have 'Database' shouldn't it?" Actually, that *is* a bug: Database should be in the SHOW Name column, not the Remarks column. I've moved it. Thanks for pointing this out.
