Skip to content

ERROR: inconvertible types: CHAR -> STRING #3004

@river320

Description

@river320

Describe the bug

HI,I have a table,and a COLUMN named op, this field data type is "string",when i update it,.
for example ,update table set op='u' where name='test';
this sql return the ERROR: inconvertible types: CHAR -> STRING [from=, to=op];

the ”PostgreSQL wire protocol“ way and the ”Web Console“ way return the same error

How can i update this success ?

Thank you

To reproduce

No response

Expected Behavior

the sql "update table set op='u' where name='test'; “ can be success when the field data type is string

Environment

- **QuestDB version**: 7.0.0
- **OS**:centos7.0
- **Browser**: chrome

Additional context

No response

Metadata

Metadata

Assignees

Labels

BugIncorrect or unexpected behaviorSQLIssues or changes relating to SQL execution

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions