Run SQL asks for duplicate values from variable when used multiple times in a sql statement
Opened this issue · 2 comments
jwflicker commented
Problem description
Duplicate variables in sql are also shown multiple times in Run SQL-dialog.
Variables with the same name used multiple times in a SQL in the new DB2-Editor in IDz v16.0.4 and Db2 Developer Extension have to be assigned a value multiple times. Is this intended behaviour, i would expect the variable only to appear once in the RunSQL screen (where content for variables could be specified)? See screenshot for details.
Observed behavior
For example, when running:
select * from mytable where mycol 2= :name or mycol2 = :name
users are asked to enter two values for variable :name
Expected behavior
To be asked one value for variable when used in multiple places
Development environment where the bug occurred
- Db2 Developer Extension version:
- Editor platform
- Visual Studio Code: Version: 1.86.2
- Eclipse Theia
- IDz 16.0.4
- Operating system on which your editor runs: OS X
- Log files attached?: N/A
equalchenbj commented
@jwflicker Thank you for reporting this issue. We have opened an internal issue to track it.