[Bug 56535] New: JDBC Sampler: Response wrong if DB-Field is of type "tinyint"

[bu...@apache.org]

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

            Bug ID: 56535
           Summary: JDBC Sampler: Response wrong if DB-Field is of type
                    "tinyint"
           Product: JMeter
           Version: 2.11
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HTTP
          Assignee: issues@jmeter.apache.org
          Reporter: bamboocha324@yahoo.de

Hello,

we have a DB field of type "tinyint" on a mysql database.

When performing a simple select * from xxxx using JDBC Sampler then 
in the reponse the values are "true or false" insted of the real values e.g.
0,1,2,3.

When performing exactly the same sql select statement direclty from the command
line using mysql then the tinyint field's are shown correc values.

For testing purpose we changed the db field from tinyint into int and perform
the same test. Now the JDBC Sampler show the correct values 0,1,2,3.

It seems that if there is a db field of type tinyint then the JDBC Sampler
response do not show them correctly?

Can you please check?

Thanks.
Br.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 56535] JDBC Sampler: Response wrong if DB-Field is of type "tinyint"

[bu...@apache.org]

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

Philippe Mouawad <p....@ubik-ingenierie.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
                 CC|                            |p.mouawad@ubik-ingenierie.c
                   |                            |om
           Hardware|PC                          |All
         Resolution|---                         |WORKSFORME
                 OS|                            |All

--- Comment #1 from Philippe Mouawad <p....@ubik-ingenierie.com> ---
Hello,
this is not a bug in JMeter but the way MySql driver works:
http://dev.mysql.com/doc/refman/5.0/es/connector-j-reference-type-conversions.html

Read MySQL Types to Java Types for ResultSet.getObject(). :
BIT(1) (new in MySQL-5.0)     BIT     java.lang.Boolean
BIT( > 1) (new in MySQL-5.0)     BIT     byte[]
TINYINT     TINYINT     java.lang.Boolean if the configuration property
tinyInt1isBit is set to true (the default) and the storage size is 1, or
java.lang.Integer if not.
BOOL, BOOLEAN     TINYINT     See TINYINT, above as these are aliases for
TINYINT(1), currently.

-- 
You are receiving this mail because:
You are the assignee for the bug.