Feeling Lucky
?
[#17000] - "SELECT 1" returns null
- Closed
- 7 Jul 2017
- Medium
- Build: staging
- # 17000
Steps to reproduce the issue
Don't know. It's the query in asset table check(): https://github.com/joomla/joomla-cms/blob/staging/libraries/joomla/table/asset.php#L110
The result is always null for a specific page load. I'm logging the query:
query = "\nSELECT 1\nFROM `#__assets`\nWHERE `id` = 1"
If I run it in our database, the result is 1. If I change SELECT 1 to SELECT COUNT(*), the query works.
Expected result
1
Actual result
null
System information (as much as possible)
Additional comments
I copied this exact query into a CLI test file, but was not able to reproduce the problem.
| Labels |
Added:
?
|
||
| Title |
|
||||||
| Category | ⇒ | SQL |
csthomas
- comment
- 7 Jul 2017
In short this is Falang issue.
See: #14319 (comment)
| Closed_Date | 2017-07-07 09:56:11 | ⇒ | 2017-07-07 09:56:12 |
| Closed_By | franz-wohlkoenig | ⇒ | joomla-cms-bot |
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-07-07 09:56:11 |
| Closed_By | ⇒ | franz-wohlkoenig |
joomla-cms-bot
- comment
- 7 Jul 2017
Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/17000
franz-wohlkoenig
- comment
- 7 Jul 2017
closed as no Core Issue.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/17000.
Changing the query to
->select('1 AS x')makes it work.