[#4595] - Data Type issue when reading fields (using SQL)

Category:
Bug report
Priority:
Low
Status:
Assigned
Project: Severity:
Minor
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:

Hello,

It seems that there is an issue in the retrieval process of fields when a parameter 'Timestamp' or 'Date' has been added to the SQL query.
Whatever date field is added in the where clause, when the 'Read Fields' is being performed an error is returned from Oracle. (ORA-00932: inconsistent datatypes: expected DATE got NUMBER)

We would expect that something is wrong in the set up of parameter or query but this is not the case. It we generate/preview the report then the report is being generated as expected.

As it's not really blocking, i've created it as minor with low priority.

fenix4life's picture
Joined: Oct 5 2009 - 5:27am
Last seen: 7 years 4 months ago
Feedback
randomness