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

Parameter metadata

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Binary Protocol
    • 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

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

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.