mySQL JSON not handled by drivers in py3

the test suite itself reveals this, which was generally not being run against JSON here because it's not in mariadb:

#!

__________________________________________________ JSONTest_mysql_pymysql.test_rudimental_round_trip ___________________________________________________
[gw1] linux -- Python 3.5.1 /home/classic/dev/sqlalchemy/.tox/py35-mysql/bin/python
Traceback (most recent call last):
  File "/home/classic/dev/sqlalchemy/test/dialect/mysql/test_types.py", line 645, in test_rudimental_round_trip
    conn.scalar(select([mysql_json.c.foo])),
  File "/home/classic/dev/sqlalchemy/.tox/py35-mysql/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 877, in scalar
    return self.execute(object, *multiparams, **params).scalar()
  File "/home/classic/dev/sqlalchemy/.tox/py35-mysql/lib/python3.5/site-packages/sqlalchemy/engine/result.py", line 1224, in scalar
    return row[0]
  File "/home/classic/dev/sqlalchemy/.tox/py35-mysql/lib/python3.5/site-packages/sqlalchemy/dialects/mysql/json.py", line 65, in process
    return json_deserializer(value)
  File "/opt/python3.5/lib/python3.5/json/__init__.py", line 312, in loads
    s.__class__.__name__))
TypeError: the JSON object must be str, not 'bytes'

Comments (4)