-
Notifications
You must be signed in to change notification settings - Fork 1.5k
Closed
Labels
BugIncorrect or unexpected behaviorIncorrect or unexpected behaviorSQLIssues or changes relating to SQL executionIssues or changes relating to SQL execution
Description
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**: chromeAdditional context
No response
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
BugIncorrect or unexpected behaviorIncorrect or unexpected behaviorSQLIssues or changes relating to SQL executionIssues or changes relating to SQL execution