Uploaded image for project: 'MariaDB Connector/C'
  1. MariaDB Connector/C
  2. CONC-407

mysql_stmt_fetch: required buffer for zerofil integer is 1 more than reported length

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 3.0.9
    • 3.1
    • None
    • None

    Description

      mysql_fetch_fields() says a "smallint(5) unsigned zerofill" has a (max)length of 5.

      However If I use mysql_stmt_fetch() with a MYSQL_BIND with buffer_length of 5 I get return code 101 (MYSQL_DATA_TRUNCATED).

      With a buffer of 6 it works fine.

      With 10.3.11 a buffer of 5 was working fine.

      Related: https://github.com/perl5-dbi/DBD-mysql/issues/304

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18143 mysql_stmt_fetch return code is wrong if buffer size is 1

          • Major - Major loss of function.
          • Closed

          Activity

            dveeden Daniël van Eeden added a comment -

            Output of attached testcase:

            Client compile version: 100311
            		 
            Client runtime version: 10.3.11
            		 
            Server version: 100311
            		 
            Field 0 length: 5
            		 
            Field 0 max_length: 5
            		 
            Result: 00001
            		 
             
            		 
            Buffer length: 1
            		 
            mysql_stmt_fetch result: 0
            		 
            Result: 1�/E (prepared statement)
            		 
             
            		 
            Buffer length: 2
            		 
            mysql_stmt_fetch result: 101
            		 
            Result: 00/E (prepared statement)
            		 
             
            		 
            Buffer length: 3
            		 
            mysql_stmt_fetch result: 101
            		 
            Result: 000E (prepared statement)
            		 
             
            		 
            Buffer length: 4
            		 
            mysql_stmt_fetch result: 101
            		 
            Result: 0000 (prepared statement)
            		 
             
            		 
            Buffer length: 5
            		 
            mysql_stmt_fetch result: 0
            		 
            Result: 00001 (prepared statement)
            		 
             
            		 
            Buffer length: 6
            		 
            mysql_stmt_fetch result: 0
            		 
            Result: 00001 (prepared statement)
            		 
            Client compile version: 100313
            		 
            Client runtime version: 10.3.13
            		 
            Server version: 100313
            		 
            Field 0 length: 5
            		 
            Field 0 max_length: 5
            		 
            Result: 00001
            		 
             
            		 
            Buffer length: 1
            		 
            mysql_stmt_fetch result: 101
            		 
            Result: 1 (prepared statement)
            		 
             
            		 
            Buffer length: 2
            		 
            mysql_stmt_fetch result: 101
            		 
            Result: 1 (prepared statement)
            		 
             
            		 
            Buffer length: 3
            		 
            mysql_stmt_fetch result: 101
            		 
            Result: 1 (prepared statement)
            		 
             
            		 
            Buffer length: 4
            		 
            mysql_stmt_fetch result: 101
            		 
            Result: 1 (prepared statement)
            		 
             
            		 
            Buffer length: 5
            		 
            mysql_stmt_fetch result: 101
            		 
            Result: 1 (prepared statement)
            		 
             
            		 
            Buffer length: 6
            		 
            mysql_stmt_fetch result: 0
            		 
            Result: 00001 (prepared statement)

            dveeden Daniël van Eeden added a comment - Output of attached testcase: Client compile version: 100311 Client runtime version: 10.3.11 Server version: 100311 Field 0 length: 5 Field 0 max_length: 5 Result: 00001   Buffer length: 1 mysql_stmt_fetch result: 0 Result: 1�/E (prepared statement)   Buffer length: 2 mysql_stmt_fetch result: 101 Result: 00/E (prepared statement)   Buffer length: 3 mysql_stmt_fetch result: 101 Result: 000E (prepared statement)   Buffer length: 4 mysql_stmt_fetch result: 101 Result: 0000 (prepared statement)   Buffer length: 5 mysql_stmt_fetch result: 0 Result: 00001 (prepared statement)   Buffer length: 6 mysql_stmt_fetch result: 0 Result: 00001 (prepared statement) Client compile version: 100313 Client runtime version: 10.3.13 Server version: 100313 Field 0 length: 5 Field 0 max_length: 5 Result: 00001   Buffer length: 1 mysql_stmt_fetch result: 101 Result: 1 (prepared statement)   Buffer length: 2 mysql_stmt_fetch result: 101 Result: 1 (prepared statement)   Buffer length: 3 mysql_stmt_fetch result: 101 Result: 1 (prepared statement)   Buffer length: 4 mysql_stmt_fetch result: 101 Result: 1 (prepared statement)   Buffer length: 5 mysql_stmt_fetch result: 101 Result: 1 (prepared statement)   Buffer length: 6 mysql_stmt_fetch result: 0 Result: 00001 (prepared statement)

            People

              georg Georg Richter
              dveeden Daniël van Eeden
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.