DDC-1967: mysql Tiny ints not behaving properley #2639

Closed
doctrinebot opened this Issue Aug 4, 2012 · 7 comments

2 participants

@doctrinebot

Jira issue originally created by user jonathanpete:

If I set up a field as a tinyint lets say called bob. I then extract a record.

If I do $object->getBob() - when bob = 1, everything works fine.

However, if I do $object->getBob() when bob = 0, the null value is returned.

If bob is null, everything works fine.

This issues only seems to happen with mysql tinyint.

@doctrinebot

Comment created by @asm89:

I guess it is 'false' that is being returned? That's because MySql's tinyint will be mapped as boolean (by doctrine dbal).

@doctrinebot

Comment created by jonathanpete:

No. The value "" is returned as in an empty string.

@doctrinebot

Comment created by @beberlei:

can you show your mapping for this value?

@doctrinebot

Comment created by jonathanpete:

Sure. Mapping is:

/****
 * @var boolean $isvegetarian
 *
 * @Column(name="IsVegetarian", type="boolean", nullable=true)
 */
private $isvegetarian;

DBAL maps field as a tiny int. If I manually set field to 0, DBAL returns null. If I set to null, DBAL returns null. If I set to 1, DBAL returns true.

@doctrinebot

Comment created by jonathanpete:

I installed the new version, then reverted back and the problem seems to have gone away. I'm very confused!! Perhaps it was an installation problem at my end. But can't think what. Oh well...

@doctrinebot

Comment created by jonathanpete:

nope, i'm wrong. it is a bug - something else fooled me into thinking it was working. I have tried setting up other boolean data fields and the same issue occurs.

@doctrinebot

Issue was closed with resolution "Invalid"

@beberlei beberlei was assigned by doctrinebot Dec 6, 2015
@doctrinebot doctrinebot closed this Dec 6, 2015
@doctrinebot doctrinebot added the Bug label Dec 7, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment