|
If you were logged in you would be able to see more operations.
|
|
|
|
Original Estimate:
|
Unknown
|
Remaining Estimate:
|
Unknown
|
Time Spent:
|
Unknown
|
|
File Attachments:
|
None
|
|
Image Attachments:
|
|
|
| Resolution Date: |
24/Jul/08
|
|
Queries that work :
SELECT * FROM nt:base order by exo:dateCreated DESC
select * from nt:base order by exo:dateCreated desc
Query that fails :
select * from nt:base ORDER BY exo:dateCreated desc
No exception is thrown but error message : Invalid query statement.
Steps to reproduce :
- Open File Explorer then Advanced Search
- Type the query that fails in New Query tab
- Execute, the error message is displayed.
I (Philippe) discussed with the JCR team that created a JUnit test and runned it successfully, meaning that the bug comes from ECM.
|
|
Description
|
Queries that work :
SELECT * FROM nt:base order by exo:dateCreated DESC
select * from nt:base order by exo:dateCreated desc
Query that fails :
select * from nt:base ORDER BY exo:dateCreated desc
No exception is thrown but error message : Invalid query statement.
Steps to reproduce :
- Open File Explorer then Advanced Search
- Type the query that fails in New Query tab
- Execute, the error message is displayed.
I (Philippe) discussed with the JCR team that created a JUnit test and runned it successfully, meaning that the bug comes from ECM. |
Show » |
|
Bug
Closed
Minor
sql clause "order by" fails when written in upper case
