Changing username doesn't cascade #184
Description
>>What steps will reproduce the problem?
1. Change username in "members" table in DB:
UPDATE members SET username = 'johns' WHERE username = 'john';
2.Check to see whether username has been updated in other tables (e.g.
"mission" table):SELECT * FROM missoin WHERE username = johns;
3. Find that the "username" field hasn't been updated in this or other tables,
where "username" is a foreign key.
>>What is the expected output? What do you see instead?
Expect that updating the "username" field in the "members" table will cause a
cascading update, which will update all other foreign key references to this
field in all other tables which reference it.
>>What version of the product are you using? On what operating system?
CentOS 7, 64-bit, MariaDB 5.5
>>Please provide any additional information below.
Believe that this can be remedied, by creating the foreign key index with the
"on update cascade" option, as per:
http://stackoverflow.com/questions/16779552/how-to-update-on-cascade-in-mysql
Original issue reported on code.google.com by srdan.du...@gmail.com on 18 Oct 2014 at 8:00