← Back to team overview

linux-traipu team mailing list archive

[Bug 1541523] [NEW] jdbc driver interprets VARBINARY as VARCHAR

 

Public bug reported:

1. created a table TEST with column D of type VARBINARY

2. From Mathematica

stmt = javaobj@prepareStatement["Select D from TEST"]
JavaObject[org.drizzle.jdbc.DrizzlePreparedStatement]

metadata = stmt@getMetaData[]
JavaObject[org.drizzle.jdbc.DrizzleResultSetMetaData]

metadata@getColumnType[1]
12

12 is type VARCHAR and not VARBINARY
https://docs.oracle.com/javase/7/docs/api/constant-values.html#java.sql.Types.BIT

** Affects: drizzle
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Drizzle.
https://bugs.launchpad.net/bugs/1541523

Title:
  jdbc driver interprets VARBINARY as VARCHAR

Status in Drizzle:
  New

Bug description:
  1. created a table TEST with column D of type VARBINARY

  2. From Mathematica

  stmt = javaobj@prepareStatement["Select D from TEST"]
  JavaObject[org.drizzle.jdbc.DrizzlePreparedStatement]

  metadata = stmt@getMetaData[]
  JavaObject[org.drizzle.jdbc.DrizzleResultSetMetaData]

  metadata@getColumnType[1]
  12

  12 is type VARCHAR and not VARBINARY
  https://docs.oracle.com/javase/7/docs/api/constant-values.html#java.sql.Types.BIT

To manage notifications about this bug go to:
https://bugs.launchpad.net/drizzle/+bug/1541523/+subscriptions


Follow ups