Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15031

Parameter metadata

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              diego dupin Diego Dupin
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated: