xuyali created DRILL-5067: ----------------------------- Summary: AssertionError when connect to mysql and query element of a varchar-type json column Key: DRILL-5067 URL: https://issues.apache.org/jira/browse/DRILL-5067 Project: Apache Drill Issue Type: Bug Components: Storage - JSON Affects Versions: 1.8.0 Reporter: xuyali
Steps: 1.Install drill 1.8.0 to the mysql server. 2.copy mysql-jdbc-connector jar to jars/3rdparty. 3.start embedded drill : bin/drill-embedded. 4.configure a mysql storage on the web console. 5.I use a sql as below: select tb1.json_record.name from tb1 limit 100; note:json_record is a column defined as "varchar",and there's a element called name in the json_record data structure. then I got a error: Error: SYSTEM ERROR: AssertionError: VARCHAR [Error Id: a75b1588-150f-4fce-bd79-db63b9be468d on iZ25hwmeccrZ:31010] (state=,code=0) -- This message was sent by Atlassian JIRA (v6.3.4#6332)