Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-158

When performing a query with an aggregate function such as Count or Sum from MSAccess, an error is returned

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.0.5
    • 2.0.17, 3.0.6
    • General
    • None
    • Windows 7 Professional 64 bit. MS Access 2010 32 bit

    Description

      When running the following query:
      SELECT Count(tblContacts.contactID) AS CountOfcontactID, tblContacts.firstName
      FROM tblContacts
      GROUP BY tblContacts.firstName

      The error returned is:
      "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data."

      The error is is returned using Count, Sum, Avg, StDev and Var. But not when using Min, Max, First or Last.

      This error is not generated if using the MySQL ODBC connector to connect to the same database.

      connector log attached.

      Attachments

        Activity

          People

            Lawrin Lawrin Novitsky
            immortal Martin Lane
            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.