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

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.5
    • Fix Version/s: 2.0.17, 3.0.6
    • Component/s: General
    • Labels:
      None
    • Environment:
      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

            Assignee:
            Lawrin Lawrin Novitsky
            Reporter:
            immortal Martin Lane
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: