DDC-1322: Cannot persist entity with Bidirectional-ManyToOne associations

[doctrinebot]

Jira issue originally created by user apoy2k:

For the following entites:

https://gist.github.com/1129392

When I create a new "Play", using existing User and Room entities and trying to persist them

$play = new Play();
$play->setRoom($room);
$play->setUser($user);
$em->persist($play);

I get the following error:
#1452 - Cannot add or update a child row: a foreign key constraint fails (play, CONSTRAINT play*ibfk_1 FOREIGN KEY (user*id) REFERENCES User (id))

The executed query by Doctrine is

INSERT INTO Play (user_id, room_id) VALUES (?, ?) ({"1":1,"2":32}) [] []

But obviously, this doesn't work. It seems, that the entity manager tries to execute the statement as follows

INSERT INTO Play (user*id ,room*id) VALUES ('1', '32')

which is of course wrong. It should be

INSERT INTO Play (user*id ,room*id) VALUES (1, 32)

[doctrinebot]

Comment created by apoy2k:

Corrected statements

[doctrinebot]

Comment created by @beberlei:

The problem is not the how the values are inserted. A foreign key constraint fails, i.e. there is no corresponding User with id 32 in the User table, that is why you cannot insert that row.

[doctrinebot]

Comment created by apoy2k:

SHOW CREATE TABLE Play;

CREATE TABLE play (
id int(11) NOT NULL AUTO_INCREMENT,
user_id int(11) DEFAULT NULL,
room_id int(11) DEFAULT NULL,
PRIMARY KEY (id),
KEY IDX*FEBB7184A76ED395 (user*id),
KEY IDX*FEBB718454177093 (room*id),
CONSTRAINT play*ibfk_1 FOREIGN KEY (user*id) REFERENCES User (id),
CONSTRAINT play*ibfk_2 FOREIGN KEY (room*id) REFERENCES Room (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

[doctrinebot]

Comment created by @beberlei:

MySQL 5.5 and InnoDB bug on MacOSX

[doctrinebot]

Issue was closed with resolution "Invalid"

[doctrinebot]

Comment created by @beberlei:

See http://bugs.mysql.com/bug.php?id=60309