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

        Activity

          People

            diego dupin Diego Dupin
            comanl Liviu Coman
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.