Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
COM_STMT_PREPARE protocol send parameter metadata :
https://mariadb.com/kb/en/library/com_stmt_prepare/#com_stmt_prepare-response,
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
- precision
- scale
- is nullable
- is signed
Example :
when preparing "SELECT * FROM <table> WHERE username = ? and age = ?",
I would expect indication that first parameter is varchar, second unsigned integer.