We want to provide users the ability to save result set values into fluidshell variables.
Lets take an example:
select col1, col2, col3 from table tableA
I want to save the value of "col1" into var1, "col2" into var2 and "col3" into var3.
What if the result set returns multiple rows? We will only store the value from the 1st row.
Here's a proposed syntax:
select col1, col2, col3 from table tableA GO var1=col1 var2=col2 var3=col3
The above is just a proposed syntax. Pls feel free to modify based upon what is a good fit for bash style syntax.
Also, we could optionally let the user specify either column names (as returned in the result set) or column index position
Added -i and -n options for supporting the requested features. Please see \go command man page for details. SVN trunk/r30729.
Updated \go command's man page - SVN trunk/r30742.
Updated \go command's man page - SVN trunk/r30742.
SVN r30729 caused NPE on executing SQL using @ as described by issue #8124 (fixed by SVN trunk/30748). We might want to patch r30748 back to 12.0 as well.
SVN r30729 caused NPE on executing SQL using @ as described by issue #8124 (fixed by SVN trunk/30748). We might want to patch r30748 back to 12.0 as well.
This is not verified and need to be tested more. Talked to Sachin and understood working. man page was missing examples - asked jonathan to update wiki
This is not verified and need to be tested more. Talked to Sachin and understood working. man page was missing examples - asked jonathan to update wiki
Verified using both ADS 12.0.15 and ADS 13 RC1, the requested feature was added.
Other issues regarding this should be posted separately.
Closed.
Verified using both ADS 12.0.15 and ADS 13 RC1, the requested feature was added.
Other issues regarding this should be posted separately.
Closed.
Issue #8112 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build trunk/30729, 30742 |
No time estimate |
1 issue link |
breaks #8124
Issue #8124NPE on executing sql with the @ on fluidshell terminal |
Added -i and -n options for supporting the requested features. Please see \go command man page for details. SVN trunk/r30729.