Feeling Lucky
?
[#4258] - Change MySQL Inserts to Insert Ignores
- Closed
- 10 Sep 2014
- Low
- Build: master
- Easy Test
- # 4258
For MySQL, the "INSERT INTO" can be changed to "INSERT IGNORE INTO" so that the installation script can be used as a recovery script if core extensions are uninstalled via the admin. What the ignore will do is ignore entries that are already there and only insert when an entry doesn't exist. I'm not sure what the equivalents are in postgresql and sqlazure.
Steps to reproduce the issue:
Check https://github.com/joomla/joomla-cms/blob/master/installation/sql/mysql/joomla.sql
Expected result:
INSERT IGNORE INTO
Actual result:
INSERT INTO
| Priority | Medium | ⇒ | Low |
| Status | New | ⇒ | Pending |
| Easy | No | ⇒ | Yes |
nicksavov
- comment
- 9 Sep 2014
Documentation for Insert Ignore can be found at http://dev.mysql.com/doc/refman/5.5/en/insert.html
This comment was created with the J!Tracker Application at http://issues.joomla.org/.
mbabker
- comment
- 9 Sep 2014
Neither of the other databases have that type of support without some creative hacking.
nicksavov
- comment
- 9 Sep 2014
Cool
zero-24
- | Status | Pending | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2014-09-10 15:01:10 |
| Labels |
Added:
?
|
||
Pull request: #4259
This comment was created with the J!Tracker Application at http://issues.joomla.org/.