data.query thought error sql.RawBytes about data type

[krisnamourt]

I'm having a problem with Aurora Cluster Mysql 5.7 data type

Terraform Version

Terraform v1.1.7
on linux_amd64

Affected Resource(s)

Please list the resources as a list, for example:

• data.sql_query

If this issue appears to affect multiple resources, it may be an issue with Terraform's core, so please mention this.

Terraform Configuration Files

data "sql_query" "users" {

  query = "select `user` from mysql.`user`"
  provider = sql.mysql_db_management
}
output "test"{
  value = data.sql_query.users.result
}

Debug Output

mysql_grant.devops_all_schemas_grant: Refreshing state... [id=test.user@%:`gk`]
╷
│ Error: unable to convert value from database: unable to determine type for "user": unexpected type for "user": "CHAR" (slice sql.RawBytes)
│ 
│   with data.sql_query.users,
│   on terrafile.tf line 40, in data "sql_query" "users":
│   40: data "sql_query" "users" {
│ 
╵

but if I change the query for

data "sql_query" "users" {

  query ="select CAST(`user` AS CHAR CHARACTER SET utf8) as user_name from mysql.`user`"
  provider = sql.mysql_db_management
}
output "test"{
  value = data.sql_query.users.result
}

Debug Output

  + test = [
      + {
          + user_name = "user.user"
        },
      + {
          + user_name = "airflow_dag"
        },
.....