Bug 810627 - mysql_install_db fails with sql-mode NO_BACKSLASH_ESCAPES
mysql_install_db fails with sql-mode NO_BACKSLASH_ESCAPES
Status: CLOSED UPSTREAM
Product: Fedora
Classification: Fedora
Component: mysql (Show other bugs)
16
Unspecified Unspecified
unspecified Severity unspecified
: ---
: ---
Assigned To: Tom Lane
Fedora Extras Quality Assurance
:
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2012-04-07 07:05 EDT by Jon Dufresne
Modified: 2012-04-07 11:42 EDT (History)
2 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2012-04-07 11:42:05 EDT
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)

  None (edit)
Description Jon Dufresne 2012-04-07 07:05:00 EDT
Description of problem:
In /etc/my.cnf set sql-mode to NO_BACKSLASH_ESCAPES:

sql-mode=NO_BACKSLASH_ESCAPES

Once set run mysql_install_db. Some SQL fails, but the install continues.

# mysql_install_db 
Installing MySQL system tables...
OK
Filling help tables...
ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'abc\'), UNHEX(HEX(\'abc\'));\n        -> \'abc\', 616263, \'abc\'\nmysql> SELECT' at line 1
120407  3:57:42 [ERROR] Aborting

120407  3:57:42 [Note] /usr/libexec/mysqld: Shutdown complete

...

Version-Release number of selected component (if applicable):
$ rpm -qa mysql\*
mysql-server-5.5.21-1.fc16.x86_64
mysql-embedded-5.5.21-1.fc16.x86_64
mysql-connector-odbc-5.1.8-3.fc16.x86_64
mysql-5.5.21-1.fc16.x86_64
mysql-libs-5.5.21-1.fc16.x86_64

How reproducible:
100%
Comment 1 Tom Lane 2012-04-07 10:45:06 EDT
This does not look to me like an error in the Fedora packaging of mysql, but an unsupported case in the upstream code.  If you think it's important for it to work, I'd suggest filing a bug upstream at bugs.mysql.com.
Comment 2 Jon Dufresne 2012-04-07 11:42:05 EDT
Filed upstream bug. http://bugs.mysql.com/bug.php?id=64899

Note You need to log in before you can comment on or make changes to this bug.