Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-1163

jdbcCompliantTruncation Does Not Appear To Be Working

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.0.0, 3.3.3
    • 3.4.0
    • configuration
    • None

    Description

      We are trying to upgrade our java application from MariaDB connector J 2.7.12 to 3.3.2.

      As part of our testing, we found that the driver no longer rejects an insert when a column value is longer than the column.

      environment:
      MariaDB Server version: 10.4.29, sql_mode = "NO_KEY_OPTIONS"

      CREATE TABLE `test`
      		 
      (
      		 
          `ID`   int(11)       NOT NULL auto_increment,
      		 
          `TEST` varchar(1500) NOT NULL DEFAULT '',
      		 
          PRIMARY KEY (`ID`),
      		 
      )

      To reproduce:
      Disable strict mode on MariaDB Server, set jdbcCompliantTruncation=true or unconfigured in connector config

      Attempt to insert into the table, with TEST value more than 1,500 characters.

      Expected result:

      • error is returned by driver when we try to insert <-- works as expected with 2.7.12

      Actual result:

      • value is inserted (truncated) <-- 3.0 to 3.3.3

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. CONJ-1047 Version 2.7.8 vs Version 3.x.y - ERROR 1406

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONJ-1055 MySQL Connector Incompatible result from Statement.execute for out-of-range value

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. CONJ-1179 Sql strict mode is not enabled by default as mysql connector

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Task - A task that needs to be done. CONJ-210 Implement truncation as error

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            diego dupin Diego Dupin added a comment -

            This option is not in 3.x that is a complete rewrite: since all server default to strict mode, it doesn't seem necessary.
            It doesn't cost to have this option jdbcCompliantTruncation added, so will be

            diego dupin Diego Dupin added a comment - This option is not in 3.x that is a complete rewrite: since all server default to strict mode, it doesn't seem necessary. It doesn't cost to have this option jdbcCompliantTruncation added, so will be

            People

              diego dupin Diego Dupin
              stephen.hames Stephen Hames
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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