Jump to content

  • Read Fields does not work when combining GROUP BY and CASE with Oracle

    fenix4life

    By fenix4life

     Share
    Assigned User giulio
    CategoryBug report
    PriorityLow
    ReproducibilityAlways
    ResolutionOpen
    SeverityMinor
    StatusFeedback Requested

    We have found a small issue in version 3.7.1 when creating a SQL statement which mixes a CASE structure within a GROUP BY statement.

    The query on its own run perfectly on Oracle, however when using the read fields we receive a ORA-00979 error (not a GROUP BY expression)

    Attachments: GroupCase_Updatedversion.jrxml
     Share
    Go to bugs

    User Feedback

    Recommended Comments

    mdahlman

    The attached report contains no SQL query.

     

    iReport does no parsing of the SQL query. It just passes the query to Oracle. I think it's likely user error. Consider this from your query:

    WHEN1 = 1

     

    It's not valid. It needs to be this:

    WHEN 1 = 1

     

    If you're sure that you can find a problem, attach a report that reproduces it.

    Link to comment
    Share on other sites
    fenix4life

    It looks indeed that an issue was made during the upload. I Uploaded the document before saving the report :-).

     

    I've attached a new version of the report.

    Link to comment
    Share on other sites
    giulio

    What is the SQL error you get?

    Did you try the query using a different java client?

    As Matt pointed out, iReport does not change a query if there are not parameters involved, the issue may be with the JDBC driver itself.

     

     

    Giulio

    Link to comment
    Share on other sites

×
×
  • Create New...

© 2023 Cloud Software Group,
Inc. All rights reserved

Products

Explore