Skip to content

can not cast from origin type org.apache.doris.catalog.MultiRowType@59087c43 to target type=VARCHAR(255) #19853

@gaojunjie03

Description

@gaojunjie03

Search before asking

  • I had searched in the issues and found no similar issues.

Version

1.2.0

What's Wrong?

update zllb SET tyshxydm =
(select DISTINCT t.TYSHXYDM from zllb_updata t where qy_id = '10000086')
WHERE ID = '10000776';

error:
1105 - errCode = 2, detailMessage = can not cast from origin type org.apache.doris.catalog.MultiRowType@59087c43 to target type=VARCHAR(255)

What You Expected?

希望可以执行以上该语句,类似mysql

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions