Skip to content

sql: support casting arrays to string #24746

@awoods187

Description

@awoods187

No error pops up in Navicat when selecting roles.

SELECT fdwname AS name, fdwacl AS acl FROM pg_foreign_data_wrapper WHERE fdwacl::VARCHAR LIKE '%admin%'

I180409 23:48:05.179837 8072 sql/conn_executor.go:1805 [n1,client=[::1]:59064,user=root] execution error: invalid cast: string[] -> VARCHAR

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-pgcompatSemantic compatibility with PostgreSQLA-sql-semanticsC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions