Feeling Lucky
?
?
[#13895] - [mssql] Simpler workaround for query with limit and offset
- Closed
- 11 Feb 2017
- Medium
- Build: staging
- # 13895
- Diff
- csthomas:mslimit
- Success continuous-integration/drone the build was successful Details
- Success continuous-integration/travis-ci/pr The Travis CI build passed Details
- Success continuous-integration/appveyor/pr AppVeyor build succeeded Details
User tests: Successful: Unsuccessful:
It is a part of the other more complicated PR #13262
Summary of Changes
Better workaround for sql query with offset and limit.
- do not create sub query if there is only
limitapplied, useSELECT TOP
Testing Instructions
Apply patch on installed joomla (on mssql db) with sample data.
Go to article list on backend and check whether pagination works.
Expected result
Works as before,
- start to work in conjunction with PR #13854 at administrator/index.php?option=com_finder&view=maps
Actual result
- sql error at administrator/index.php?option=com_finder&view=maps
- and does not work in conjunction with PR #13854
Documentation Changes Required
No
joomla-cms-bot
- | Category | ⇒ | MS SQL Libraries Unit Tests |
| Labels |
Added:
?
?
|
||
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-02-11 12:50:49 |
| Closed_By | ⇒ | csthomas |
I close it in favour of #13262