Status: Open (View Workflow)
Fix Version/s: None
COM_STMT_PREPARE protocol send parameter metadata :
But those server doesn't set any information of parameters.
JDBC API permits access to that information (Implementation is done), but the server doesn't fill any useful data. JDBC API: https://docs.oracle.com/javase/9/docs/api/java/sql/ParameterMetaData.html
for JDBC the following information must be provided :
- data type
- is nullable
- is signed
when preparing "SELECT * FROM <table> WHERE username = ? and age = ?",
I would expect indication that first parameter is varchar, second unsigned integer.