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

Version 2.7.8 vs Version 3.x.y - ERROR 1406

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 3.4.0
    • Other
    • None

    Description

      Hi,

      I'm using mariadb jdbc connector 2.7.8 to access a mariadb 10.3.23
      and I was considering upgrading to latest version 3.x.z.

      Unfortunately I've noticed that ERROR 1406 is not triggered on 3.x.z.

      Consider the table marks:
      mysql> SELECT * FROM marks;
      ---------------------------------------

      name percentage email

      ---------------------------------------

      Bipin 84% bipin_p@gmail.com
      Deepak 78% cool_deepak@gmail.com
      Rohith 82% rohith_s@gmail.com
      Sujit 94% sujit_jos@gmail.com

      ---------------------------------------

      Error I'm trying to produce with a junit:
      mysql> INSERT INTO marks VALUES('&name','&percentage','&email');
      ERROR 1406 (22001): Data too long for column 'percentage' at row 1

      Issue found on 3.0.x and 3.1.x
      Issue not found on 2.7.x

      Attachments

        Issue Links

          Activity

            People

              diego dupin Diego Dupin
              comanl Liviu Coman
              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.