[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jmeter-dev
Subject:    DO NOT REPLY [Bug 46932] New: alias given in select statement is not
From:       bugzilla () apache ! org
Date:       2009-03-27 20:21:37
Message-ID: bug-46932-1333 () https ! issues ! apache ! org/bugzilla/
[Download RAW message or body]

https://issues.apache.org/bugzilla/show_bug.cgi?id=46932

           Summary: alias given in select statement is not used as column
                    header in response data for a JDBC request
           Product: JMeter
           Version: 2.3.2
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: Main
        AssignedTo: jmeter-dev@jakarta.apache.org
        ReportedBy: mark.aronszajn@openmarket.com


If you use an alias for an existing column name in a select statement used
within a JDBCSampler request, the original column name is returned with the
response data rather than the alias proposed. Any DB client will return the
given alias as a column header and so should JMeter's JDBCSampler.

For example, if the column is 'expected_arrival_time' and the query is

select residential_street_address as address from residence where id = 3;

the response data element will be

<responseData class="java.lang.String">residential_street_address
222 W. 58th Avenue</responseData>

One exceptional case: if the alias is given for a derived column in a view, the
alias is used as expected.

This derives from behavior of methods in ResultSetMetaData. In the Sampler
code, the ResultSetMetaData getColumnName(int) method is used to retrieve a
column header rather than getColumnLabel(int). I believe the latter always
gives the appropriate result.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org

[prev in list] [next in list] [prev in thread] [next in thread]