Description

csakhogy

opened on May 10, 2023

Issue body actions

Failing SQL Feature:

SQl Statement including an input parameter (that is being defined via user prompt during execution) cannot be parsed and throws ParseException: Encountered unexpected token "=" "="

SQL Example:

select * from all_tables
where owner = &myowner

Note: AFAIK such input parameter might also contain a dot at the end (e.g. &myowner.).

Software Information:

• JSqlParser version 4.60
• Oracle v19

Activity

1. manticore-projects

   added a commit that references this issue on May 11, 2023

   feat: JdbcNamedParameter allows "&" (instead of ":")

   This issue will close once commit c07a43b is merged into the 'master' branch.

   c07a43b
2. manticore-projects commented on May 11, 2023

   

   manticore-projects

   on May 11, 2023

   Contributor

   More actions

   Greetings.

   I have amended the JDBCNamedParameter to support the & character, but no way the parameter's name will end with a . since it is used as list separator for name fragments.
3. manticore-projects

   closed this as completedin 41b6fceon Jun 1, 2023
4. manticore-projects

   closed this as completedin #1778on Jun 1, 2023
5. manticore-projects

   added a commit that references this issue on Jun 15, 2023

   Assorted Fixes #8 (#1807)

   This issue will close once commit a815f5f is merged into the 'master' branch.

   a815f5f
6. manticore-projects

   added a commit that references this issue on Jun 27, 2023

   Backslash Quotation of Single-Quote `'\\''` (#1813)

   This issue will close once commit c79dfff is merged into the 'master' branch.

   c79dfff

Issue actions