Feeling Lucky
?
[#24683] - Remove unnecessary where clause to avoid SQL error on PostgreSQL databases
- Fixed in Code Base
- 22 Apr 2019
- Medium
- Build: staging
- # 24683
- Diff
- richard67:correct-sql-where-2
- Pending Hound Hound is busy sniffing around... Details
User tests: Successful: Unsuccessful:
Pull Request for Issue # #24679 (comment) .
Summary of Changes
Remove unnecessary where clause from delete statement when purging finder taxonomy maps to avoid SQL error on PostgreSQL databases.
There is no need for a where clause in that SQL statement, and the existing where clause 1 will cause an error on PostgreSQL databases, see issue #24679 and PR #24682 for another issue caused by the same kind of condition 1 in a where clause.
Testing Instructions
Code review: There is no need for a where clause in that SQL statement.
Documentation Changes Required
None.
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | Administration com_finder |
| Title |
|
||||||
| Status | Pending | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2019-04-22 13:11:28 |
| Closed_By | ⇒ | zero-24 | |
| Labels |
Added:
?
|
||
zero-24
- comment
- 22 Apr 2019
Merging on review thanks
richard67
- comment
- 22 Apr 2019
Thanks.
@twister65 Could you check this one here, too? Is just a code review. Is obvious.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24683.