While building some migrations with Goose I had some strange (for me) error, for which you can find a lot of different stuff on Google but nothing helped.
The error was like in the title: “ORA-00933: SQL command not properly ended” for this query
UPDATE table1 SET title = CONCAT('FORMER-', title) WHERE id <= 500;
This query will work without problems in SQL editor like Oracle SQL Developer but not in the GO Goose adapter
The reason for this error is the space between the comma and title column in the CONCAT function and the semicolon ";" at the end, so the query should be like this:
UPDATE table1 SET title = CONCAT('FORMER-',title) WHERE id <= 500
Small tips: don't use space between params in the functions and don't add a semicolon 🙂