Feeling Lucky
?
[#29280] - [4.0] Fix SQL error on update from 3.10-dev to J4 for PostgreSQL
- Fixed in Code Base
- 30 May 2020
- Medium
- Build: 4.0-dev
- # 29280
- Diff
- richard67:4.0-dev-fix-postgresql-update
- Pending Hound Hound is busy sniffing around... Details
User tests: Successful: Unsuccessful:
Pull Request for Issue # .
Summary of Changes
- The schema checker's change item class for PostgreSQL doesn't understand "varchar", it need "character vayring".
- In PostgreSQL you change the "NOT NULL" contrsaint for a column or the default value with a separate statement, or at least our schema checker expects it like this for PostgreSQL.
Testing Instructions
Can be merged by review.
Expected result
Update from current 3.10-dev suceeds.
Actual result
ERROR: syntax error at or near "VARCHAR" at character 52
STATEMENT: ALTER TABLE "j3ux0_history" ALTER COLUMN "item_id" VARCHAR(50) NOT NULL DEFAULT "";
Documentation Changes Required
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | Postgresql SQL Administration com_admin |
| Status | Pending | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2020-05-30 18:40:20 |
| Closed_By | ⇒ | wilsonge | |
| Labels |
Added:
?
|
||
Thanks!