[MacPorts] #44477: mysql56: check failed: 'field[1].type == MYSQL_TYPE_BLOB' (was: check failed: 'field[1].type == MYSQL_TYPE_BLOB')

[MacPorts]

#44477: mysql56: check failed: 'field[1].type == MYSQL_TYPE_BLOB'
------------------------------+-----------------------
  Reporter:  ora.et.labora@…  |      Owner:  pixilla@…
      Type:  defect           |     Status:  new
  Priority:  Normal           |  Milestone:
 Component:  ports            |    Version:  2.3.1
Resolution:                   |   Keywords:
      Port:  mysql56          |
------------------------------+-----------------------
Changes (by ryandesign@…):

 * owner:  macports-tickets@… => pixilla@…
 * port:   => mysql56


Old description:

> {{{
> $ mysql_client_test -p
> [..]
> #####################################
> 196 of (1/1): test_bug14169
> #####################################
> GROUP_CONCAT() result type
> 253/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_ports_databases_mysql56/mysql56/work/mysql-5.6.19/tests/mysql_client_test.c:15409:
> check failed: 'field[1].type == MYSQL_TYPE_BLOB'
>

> $ type -a mysql_client_test
> mysql_client_test is /opt/local/bin/mysql_client_test
>
> $ mysql_client_test --help
>
> mysql_client_test  Ver 2.1 Distrib 5.6.19, for osx10.8 (x86_64)
> By Monty, Venu, Kent and others
> [..]
>
> $ mysql --version
> mysql  Ver 14.14 Distrib 5.6.19, for osx10.8 (x86_64) using  EditLine
> wrapper
> root at lhasa:~
> $ type -a mysql
> mysql is /opt/local/bin/mysql
> }}}
>
> What I did:
> I upgraded from mysql5 to 5.6 by doing:
> $ /opt/local/lib/mysql5/bin/mysqldump --all-databases -p > mysql5dump.out
> # remove mysql5 et cetera
> $ sudo port install mysql56
> $ sudo port install mysql56-server
> $ sudo port select --set mysql mysql56
> $ mysql_upgrade -p
> $ sudo mysqld --user mysql # in other terminal (just for the record)
> $ mysql_upgrade -p
>

> Personal note:
> MySQL and -- I'm afraid to say Mariadb as well -- are the source of never
> ending trouble.

New description:

 {{{
 $ mysql_client_test -p
 [..]
 #####################################
 196 of (1/1): test_bug14169
 #####################################
 GROUP_CONCAT() result type
 253/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_ports_databases_mysql56/mysql56/work/mysql-5.6.19/tests/mysql_client_test.c:15409:
 check failed: 'field[1].type == MYSQL_TYPE_BLOB'


 $ type -a mysql_client_test
 mysql_client_test is /opt/local/bin/mysql_client_test

 $ mysql_client_test --help

 mysql_client_test  Ver 2.1 Distrib 5.6.19, for osx10.8 (x86_64)
 By Monty, Venu, Kent and others
 [..]

 $ mysql --version
 mysql  Ver 14.14 Distrib 5.6.19, for osx10.8 (x86_64) using  EditLine
 wrapper
 root at lhasa:~
 $ type -a mysql
 mysql is /opt/local/bin/mysql
 }}}

 What I did: [[br]]
 I upgraded from mysql5 to 5.6 by doing:
 {{{
 $ /opt/local/lib/mysql5/bin/mysqldump --all-databases -p > mysql5dump.out
 }}}
 # remove mysql5 et cetera
 {{{
 $ sudo port install mysql56
 $ sudo port install mysql56-server
 $ sudo port select --set mysql mysql56
 $ mysql_upgrade -p
 $ sudo mysqld --user mysql # in other terminal (just for the record)
 $ mysql_upgrade -p
 }}}

 Personal note: [[br]]
 MySQL and -- I'm afraid to say Mariadb as well -- are the source of never
 ending trouble.

--

-- 
Ticket URL: <https://trac.macports.org/ticket/44477#comment:2>
MacPorts <http://www.macports.org/>
Ports system for OS X