Doctrine 2 - ORM

Boolean discriminator field for single table inheritance does not work as expected with MySQL

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 2.0-BETA4
  • Fix Version/s: 2.0-RC1
  • Component/s: Mapping Drivers
  • Security Level: All
  • Labels:
    None
  • Environment:
    MySQL 5

Description

Hello,

I have a a single table inheritance, with a boolean discriminator field, see: http://pastie.org/1269467
As MySQL does not have a boolean field, true / false should be translated to 1/0 (as it uses a TINYINT(1) field instead).

If I use 1 / 0 in the annotation instead of true / false it works, but than it's not boolean anymore...

So it should either translate that, or mention this in the documentation (although vendor specific exceptions should be avoided imo).

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Benjamin Eberlei added a comment -

This is not supported, i suggest using smallint and 0 / 1 instead.

Show
Benjamin Eberlei added a comment - This is not supported, i suggest using smallint and 0 / 1 instead.
Hide
Permalink
Benjamin Eberlei added a comment -

Throwing an exception now on using boolean, object, array, datetime, date or time for the discriminator column.

Show
Benjamin Eberlei added a comment - Throwing an exception now on using boolean, object, array, datetime, date or time for the discriminator column.

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    seba kerckhof
Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: