Opened 10 years ago

Last modified 5 years ago

#44477 assigned defect

mysql56: check failed: 'field[1].type == MYSQL_TYPE_BLOB' — at Version 2

Reported by: ora.et.labora@… Owned by: pixilla@…
Priority: Normal Milestone:
Component: ports Version: 2.3.1
Keywords: Cc:
Port: mysql56

Description (last modified by ryandesign (Ryan Carsten Schmidt))

$ 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.

Change History (2)

comment:1 Changed 10 years ago by ora.et.labora@…

Sorry, forgot to format code in "what I did section" .. how can I change after having submitted?

comment:2 Changed 10 years ago by ryandesign (Ryan Carsten Schmidt)

Description: modified (diff)
Owner: changed from macports-tickets@… to pixilla@…
Port: mysql56 added
Summary: check failed: 'field[1].type == MYSQL_TYPE_BLOB'mysql56: check failed: 'field[1].type == MYSQL_TYPE_BLOB'
Note: See TracTickets for help on using tickets.