#44477: check failed: 'field[1].type == MYSQL_TYPE_BLOB' -----------------------------+-------------------------------- Reporter: ora.et.labora@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.1 Keywords: | Port: -----------------------------+-------------------------------- {{{ $ 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@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. -- Ticket URL: <https://trac.macports.org/ticket/44477> MacPorts <http://www.macports.org/> Ports system for OS X