[jira] [Work logged] (CAMEL-13305) camel-sql cannot resolve nested simple expression

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CAMEL-13305?focusedWorklogId=210208&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-210208 ]

ASF GitHub Bot logged work on CAMEL-13305:
------------------------------------------

                Author: ASF GitHub Bot
            Created on: 08/Mar/19 15:38
            Start Date: 08/Mar/19 15:38
    Worklog Time Spent: 10m 
      Work Description: rnetuka commented on pull request #2812: [CAMEL-13305] camel-sql cannot resolve nested simple expression
URL: https://github.com/apache/camel/pull/2812
 
 
   Issue: https://issues.apache.org/jira/browse/CAMEL-13305
   
   When using nested expressions in SQL routes, such as
   .to("sql:INSERT INTO example VALUES (:?${array[${index}]})");
   both REPLACE_PATTERN and NAME_PATTERN are unable to match the whole expression correctly. We have to find correct enclosing bracket and create a substring in such cases.
 
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Issue Time Tracking
-------------------

            Worklog Id:     (was: 210208)
            Time Spent: 10m
    Remaining Estimate: 0h

> camel-sql cannot resolve nested simple expression
> -------------------------------------------------
>
>                 Key: CAMEL-13305
>                 URL: https://issues.apache.org/jira/browse/CAMEL-13305
>             Project: Camel
>          Issue Type: Bug
>          Components: camel-sql
>            Reporter: Radovan Netuka
>            Priority: Major
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> - camel-sql cannot resolve nested simple expression
>  - For example, `to("sql:insert into T_EXAMPLE values (:#$\{header.header1[${header.CamelLoopIndex}][COLUMN_NAME1]})")` is resolved as `insert into T_EXAMPLE values (?][COLUMN_NAME1]})` instead of `insert into T_EXAMPLE values ( ? )}`. And database driver will generate a syntax error.
>  - FYI, `.setHeader("header1",simple("$\{header.header1[${header.CamelLoopIndex}][COLUMN_NAME1]})"))` is resolved correctly. So probably sql-camel cannot properly parse the range of simple expression.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)