× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
aquaclusters.josekibold reported Jan 24, 2013  · last modified Feb 1, 2013

go -i or -n options for assigning the value of one column to different variables


Dev
Fun Fun
funfun
QA
Sachin Prakash
SachinPrakash
Priority Low
Complexity Unknown
Component App - FluidShell - Command
Version 12.0

Using the -i or -n params from the go command to assign the value of one column to different variables does not seem to work.

Examples: (# - denotes an output line in FS, the rest are input lines)

DROP TABLE IF EXISTS test_table /
CREATE TABLE test_table (`col one` VARCHAR(20)) /
INSERT INTO test_table VALUES ('one') /

declare test_var1=val1
declare test_var2=val2
SELECT * FROM test_table
go -i test_var1=1 -i test_var2=1
declare -p test_var1 test_var2


# declare -- test_var1="val1" <---The expected output would be test_var1="one"
# declare -- test_var2="one"


declare test_var1=val1
declare test_var2=val2
SELECT * FROM test_table
go -n test_var1='col one' -n test_var2='col one'
declare -p test_var1 test_var2

# declare -- test_var1="val1" <---The expected output would be test_var1="one"
# declare -- test_var2="one"

declare test_var1=val1
declare test_var2=val2
SELECT * FROM test_table
go -n test_var1='col one' -i test_var2=1
declare -p test_var1 test_var2

# declare -- test_var1="one" <--- OK, if using -n and -i the assignment works
# declare -- test_var2="one"

Tested on both ADS 12.0.15 and ADS 13 RC1 using both MySQL and SQLite, in all the cases the behavior is as above.

funfun   Jan 24, 2013
Field Old Value New Value
Version 13.0 12.0
funfun   Jan 25, 2013
Field Old Value New Value
Fixed Build 12.0/r31083-84,13.0/r31085,trunk/r31086
Resolution Fixed
Resolved Date Jan 25, 2013 5:04 AM
Status New Resolved
aquaclusters.josekibold   Feb 1, 2013
Field Old Value New Value
Status Resolved Closed

Issue #8244

Closed
Fixed
Resolved Jan 25, 2013
 
 
Completion
No due date
Fixed Build 12.0/r31083-84,13.0/r31085,trunk/r31086
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017