Ticket #9 (closed defect: fixed)

Opened 2 years ago

Last modified 1 month ago

No support for unsigned numerics in MySQL4

Reported by: mark@… Owned by: dhughes
Type: defect Priority: high
Milestone: Component: Reactor - General
Version: 1.0 Severity: major
Keywords: Cc:

Description

I've been getting a lot of errors with ObjectDOA.getCfSqlType() and
ObjectDOA.getCfDataType(). Any unsigned integer value is triggering
the Unsupported (or incorrectly supported) database datatype: error.

In these cases arguments.typeName is "int unsigned", "tinyint unsigned" etc....

I'm not sure whether this has been deliberately ommited, accidentally
ommited or whether <cfset dataType =
REReplace(qFields.TYPE,"(.*)\((.*)\)","\1") /> shouldn't be including
the unsigned part in its search.

Anyway thought I should mention it before I run off and change all my
fields to signed.

Change History

Changed 2 years ago by dhughes

  • status changed from new to closed
  • resolution set to fixed

(In [300]) Fixes #9 and #11. I changed the ObjectDao.cfc for mysql 4 so that unsigned ints are handled as ints.

Changed 2 years ago by dhughes

  • milestone changed from Release Candidate 2 (RC2) to Beta Candidate 2 (BC2)

Changed 1 month ago by anonymous

  • milestone deleted

Milestone Beta Candidate 2 (BC2) deleted

Note: See TracTickets for help on using tickets.