Uploaded image for project: 'Sqoop (READ-ONLY)'
  1. Sqoop (READ-ONLY)
  2. SQOOP-49

MySQL import of UNSIGNED column is reported as "INTEGER"

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.4.0
    • Component/s: import, vendors/mysql
    • Labels:
      None

      Description

      MySQL "UNSIGNED" column types are reported as "INTEGER". The 'Integer' type used in Java to hold this result does not have the correct range to hold values in this column.

      A MySQL-specific data dictionary should be consulted for column types, rather than trusting the ResultSetMetaData for the test query.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              aaron Aaron Kimball
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: