DBeaver
Error updating whitespace and reformatting data to lowercase in Dbeaver. #35334
-
DescriptionHi everyone, I have a question: after I run the update command to remove spaces and convert the data to lowercase, but after I run the command, the result of the full name column failed. The names of all customers have been replaced with the first person's name. Where is the error in Dbeaver? DBeaver VersionDbeaver 24.1.5 Operating Systemwindow 10 Database and driverNo response Steps to reproduceNo response Additional contextNo response |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments
-
|
This is not a Dbeaver issue but a querry issue. You told the query to replace each row with one string as the sub query will return a list of values and I guess the DB used the first value of the result set. Or as in oracle you need to provide a joining condition between the value you would update and the value you would write in the field. |
Beta Was this translation helpful? Give feedback.
-
|
@TB-HunBoka Thanks so much. I completed the mission thanks to you |
Beta Was this translation helpful? Give feedback.
This is not a Dbeaver issue but a querry issue. You told the query to replace each row with one string as the sub query will return a list of values and I guess the DB used the first value of the result set.
I am not a sqlite user, but I guess it should be this:
Set full_name = LOWER(LTRIM(full_name))
from ....
Or as in oracle you need to provide a joining condition between the value you would update and the value you would write in the field.