[#12348] - [com_finder] - cast to char before use LIKE operator on datetime/tim…
- Fixed in Code Base
- 4 Feb 2017
- Medium
- Build: staging
- # 12348
- Diff
- alikon:patch-83
- Success continuous-integration/travis-ci/pr The Travis CI build passed Details
- Success JTracker/HumanTestResults Human Test Results: 2 Successful 0 Failed. Details
User tests: Successful: Unsuccessful:
fix for standard SQL
Summary of Changes
A timestamp/datetime field CANNOT be used with LIKE operator we need to cast to char before in standard SQL
Testing Instructions
Smart Search: Indexed Content search field with a date work as before
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | Administration Components |
| Labels |
Added:
?
|
||
Is ready to test thanks
On 12 Jan 2017 10:34 am, "Franz Wohlkönig" notifications@github.com wrote:
@alikon https://github.com/alikon ist this PR for testing or waiting on
Answer?—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#12348 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AALFsTUi5eglrGStHuebm2wp8GJ_udomks5rRfOXgaJpZM4KRqzm
.
Searched for "12. 3. 1991" as Part of an Article-Titel in Backend, which is found with and without Patch.
Searched for same at Frontend which is not found with and without Patch.
@franz-wohlkoenig this PR is only for backend
I have tested this item
Searched for "12. 3. 1991" as Part of an Article-Titel in Backend, which is found with and without Patch.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/12348.
I have tested this item
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/12348.
zero-24
- | Milestone |
Added: |
||
| Status | Pending | ⇒ | Ready to Commit |
| Labels |
Added:
?
|
||
| Category | Administration Components | ⇒ | Administration com_finder Components |
wilsonge
- | Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-02-04 17:47:26 |
| Closed_By | ⇒ | wilsonge | |
| Labels | |||
used
$query->castAsChar()as requested