Bug 46651 - JDBC sample does not allow empty string(s) in prepare-SELECT statement - java-exception
Summary: JDBC sample does not allow empty string(s) in prepare-SELECT statement - java...
Status: RESOLVED DUPLICATE of bug 46491
Alias: None
Product: JMeter - Now in Github
Classification: Unclassified
Component: Main (show other bugs)
Version: 2.3.2
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: JMeter issues mailing list
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-02-02 14:15 UTC by Yaroslav
Modified: 2009-02-02 15:02 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Yaroslav 2009-02-02 14:15:29 UTC
Here is my prepare SELECT statement:
----
[Prepared Select Statement] SELECT ('EmailAddress=' + CAST(EmailAddress AS VARCHAR)) as a1 from StoreShop.Trainers WHERE EmailAddress=?+'@'+?
----
with:
Parameter values: ${ID},${EMAIL-GROUP}
Parameter types: VARCHAR,VARCHAR

Here is a bulk of data and how JDBC sample is responding for them:

1) {"",""}(two empty strings - not null)
AR: the sample is failing: Response message: java.sql.SQLException: number of arguments (0) and number of types (2) are not equal
ER: Response data: {"a1"} - data are not found but "a1" is a column name - not java-exception error;

2) {"aaa6",""} - the second parameter is empty string
AR: the sample is failing: Response message: java.sql.SQLException: number of arguments (1) and number of types (2) are not equal
ER:  Response data: {"a1"} - data are not found but "a1" is a column name - not java-exception error;

3) {"","bluerealm.com"} - the first parameter is empty string
AR: Response data: {"a1"} as expected - data not found but "a1" in a column name;

So, JDBC sample is working inconsistency in three similar cases.

My expectation is that in the cases #1&#2 test-results are same as in the #3.
Comment 1 Sebb 2009-02-02 15:02:39 UTC
Same routine is used to parse the parameters as in CSV Dataset when quoted strings are allowed, thus the last parameter(s) are dropped.

*** This bug has been marked as a duplicate of bug 46491 ***
Comment 2 The ASF infrastructure team 2022-09-24 20:37:42 UTC
This issue has been migrated to GitHub: https://github.com/apache/jmeter/issues/2197