-- 5.7.20

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20: cat docs/INFO_SRC
commit: 0441472e19e9a2e41df5d61098eb97c3e211547c
date: 2017-09-13 17:44:44 +0200
build-date: 2017-09-13 17:48:35 +0200
short: 0441472
branch: mysql-5.7.20-release

MySQL source 5.7.20

rm -rf 88105
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/88105 
bin/mysqld --basedir=$PWD --datadir=$PWD/88105 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=$PWD/88105/log.err 2>&1 &

CREATE DATABASE IF NOT EXISTS test;
use test;
CREATE TABLE parent (
    id INT NOT NULL,
    PRIMARY KEY (id)
) ENGINE=INNODB;

CREATE TABLE child (
    id INT,
    xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx INT,
    INDEX par_ind (xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx),
    CONSTRAINT `xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx` FOREIGN KEY (xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx)
        REFERENCES parent(id)
        ON DELETE CASCADE
) ENGINE=INNODB;

--

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20: bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.20 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> CREATE DATABASE IF NOT EXISTS test;
Query OK, 1 row affected (0.00 sec)

root@localhost [(none)]> use test;
Database changed
root@localhost [test]> CREATE TABLE parent (
    ->     id INT NOT NULL,
    ->     PRIMARY KEY (id)
    -> ) ENGINE=INNODB;
) ENGINE=INNODB;
Query OK, 0 rows affected (0.01 sec)

root@localhost [test]>
root@localhost [test]> CREATE TABLE child (
    ->     id INT,
    ->     xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx INT,
    ->     INDEX par_ind (xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx),
    ->     CONSTRAINT `xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx` FOREIGN KEY (xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx)
    ->         REFERENCES parent(id)
    ->         ON DELETE CASCADE
    -> ) ENGINE=INNODB;
Query OK, 0 rows affected (0.01 sec)

root@localhost [test]> SELECT CONSTRAINT_SCHEMA, TABLE_NAME, CONSTRAINT_NAME
    -> FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS
    -> WHERE LENGTH(CONSTRAINT_NAME) > 64;
Empty set (0.02 sec)

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20: bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown
[1]+  Done                    bin/mysqld --basedir=$PWD --datadir=$PWD/88105 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=$PWD/88105/log.err 2>&1
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20:


root@localhost [test]> CREATE TABLE child (
    ->     id INT,
    ->     xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx INT,
    ->     INDEX par_ind (xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx),
    ->     CONSTRAINT `xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx` FOREIGN KEY (xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx)
    ->         REFERENCES parent(id)
    ->         ON DELETE CASCADE
    -> ) ENGINE=INNODB;
Query OK, 0 rows affected (0.01 sec)

root@localhost [test]> \q
Bye
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20: bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown
[1]+  Done                    bin/mysqld --basedir=$PWD --datadir=$PWD/88105 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=$PWD/88105/log.err 2>&1
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20:



-- 8.0.3

[umshastr@hod03]/export/umesh/server/binaries/Trunk/mysql-commercial-8.0.3-rc-linux-glibc2.12-x86_64: cat docs/INFO_SRC
commit: 2fb2acba6b8b611fc50c7d18c6c418a907486f8c
date: 2017-09-10 13:41:57 +0200
build-date: 2017-09-10 13:46:11 +0200
short: 2fb2acb
branch: mysql-8.0.3-rc-release

MySQL source 8.0.3

bin/mysqld --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.7.20/88105 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.7.20/88105/log.err 2>&1 &


[umshastr@hod03]/export/umesh/server/binaries/Trunk/mysql-commercial-8.0.3-rc-linux-glibc2.12-x86_64: bin/mysqld --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.7.20/88105 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.7.20/88105/log.err 2>&1 &
[1] 4230
[umshastr@hod03]/export/umesh/server/binaries/Trunk/mysql-commercial-8.0.3-rc-linux-glibc2.12-x86_64:
[umshastr@hod03]/export/umesh/server/binaries/Trunk/mysql-commercial-8.0.3-rc-linux-glibc2.12-x86_64:
[umshastr@hod03]/export/umesh/server/binaries/Trunk/mysql-commercial-8.0.3-rc-linux-glibc2.12-x86_64:
[umshastr@hod03]/export/umesh/server/binaries/Trunk/mysql-commercial-8.0.3-rc-linux-glibc2.12-x86_64:
[1]+  Exit 1                  bin/mysqld --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.7.20/88105 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.7.20/88105/log.err 2>&1


-- extract from 8.0.3 error log

[umshastr@hod03]/export/umesh/server/binaries/Trunk/mysql-commercial-8.0.3-rc-linux-glibc2.12-x86_64: cat /export/umesh/server/binaries/GABuilds/mysql-5.7.20/88105/log.err|grep -A 5 'is too long'
2017-10-17T10:21:55.346917Z 2 [ERROR] /export/umesh/server/binaries/Trunk/mysql-commercial-8.0.3-rc-linux-glibc2.12-x86_64/bin/mysqld: Identifier name 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' is too long
2017-10-17T10:21:55.346952Z 2 [ERROR] InnoDB: Foreign key name:test/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx is too long, for the table:child. Please ALTER the foreign key name to use less than 64 characters and try upgrade again.

2017-10-17T10:21:55.346981Z 2 [ERROR] Error in fixing SE data for test.child
2017-10-17T10:21:55.394179Z 0 [ERROR] Failed to Populate DD tables.
2017-10-17T10:21:55.394211Z 0 [ERROR] Aborting
2017-10-17T10:21:55.394334Z 0 [Note] InnoDB: FTS optimize thread exiting.