Uploaded image for project: 'Railo'
  1. Railo
  2. RAILO-1818

Query error "No operations allowed after statement closed."

    Details

    • Steps to Reproduce:
      Hide

      table:
      simple table with genre_id, weight, entity_id (INT fields)

      my query:

      SELECT 'Pop' AS genre, IFNULL( ratio_pop, 0) AS weight, 10 AS genre_id FROM custom_music_profile WHERE entity_ID = 59611 UNION SELECT 'Rock' AS genre, IFNULL( ratio_rock, 0) AS weight, 20 AS genre_id FROM custom_music_profile WHERE entity_ID = 59611 ORDER BY weight DESC

      Show
      table: simple table with genre_id, weight, entity_id (INT fields) my query: SELECT 'Pop' AS genre, IFNULL( ratio_pop, 0) AS weight, 10 AS genre_id FROM custom_music_profile WHERE entity_ID = 59611 UNION SELECT 'Rock' AS genre, IFNULL( ratio_rock, 0) AS weight, 20 AS genre_id FROM custom_music_profile WHERE entity_ID = 59611 ORDER BY weight DESC
    • Affects:
      Compatibility/Configuration

      Description

      some queries with union statements fire a "No operations allowed after statement closed." exception.

      reverting the latest railo update fixes the issue.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                micstriit Michael Offner
                Reporter:
                funkymusic Hansjoerg Posch
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: