Feeling Lucky
?
[#29283] - [4.0] Fix again postgresql update
- Fixed in Code Base
- 30 May 2020
- Medium
- Build: 4.0-dev
- # 29283
- Diff
- richard67:4.0-dev-fix-postgresql-update-2
- Pending Hound Hound is busy sniffing around... Details
User tests: Successful: Unsuccessful:
Pull Request for Issue # .
Summary of Changes
Fix syntax error for PostgreSQL databases in update SQL script.
See also https://stackoverflow.com/questions/7869592/how-to-do-an-update-join-in-postgresql.
Testing Instructions
Update a clean and current 3.10-dev to latest 4.0-dev using a PostgreSQL database and a self made update package for reproducing the issue, or the one built for this PR for testing the fix.
Expected result
Update succeeds,
Actual result
ERROR: syntax error at or near "INNER" at character 29
STATEMENT: UPDATE "j3ux0_history" AS h INNER JOIN "j3ux0_content_types" AS c ON h.ucm_type_id = c.type_id SET h.item_id = CONCAT(c.type_alias, ".", h.item_id);
Documentation Changes Required
None.
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | Postgresql SQL Administration com_admin |
| Labels |
Added:
?
|
||
| Status | Pending | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2020-05-30 19:39:47 |
| Closed_By | ⇒ | wilsonge |
Thanks!