Uploaded image for project: 'Camel'
  1. Camel
  2. CAMEL-9711

camel-sql - Allow to use IN queries where the parameter is expanded

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.17.0
    • Component/s: camel-sql
    • Labels:
      None
    • Estimated Complexity:
      Unknown

      Description

      So you can do a

      select * from foo where bar IN :#myValues

      And then have myValues being expanded into a list of values separated by comma. The trick is to know if the values should be quoted or not, eg

      IN (1, 2, 3)

      or

      IN ('1', '2', '3')

      So we may need a way to specify that. Or defer if its numbering then its not quoted, and non numeric is quoted. But then you may want numeric quoted still.

        Attachments

          Activity

            People

            • Assignee:
              davsclaus Claus Ibsen
              Reporter:
              davsclaus Claus Ibsen
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: