#3426 (ok 3.4.8) Entering foreign keys does not reset NULL
1) Create the test data using the supplied SQL script
2) In phpmyadmin, open database `test` and use Designer to make a relationship between `t2`.`c2` being the foreign key and `t1`.`c1` being the referenced key.
3) open t2 and click "Insert" in the tabbar to start insertion of the new row
4) As a result of setting the relationship on step 2, there will be a "Browse Foreign Values" icon next to the entry field on the insertion page. Click the icon so the "browse foreign values" window pops up.
5) Click on any value in the window that popped up. That will cause that value to be populated into the `t2`.`c2` entry field, BUT the NULL checkbox next to it will not be automatically cleared (as it should!)
5.1) I am not sure what I was doing next, but in some cases clicking Save with this contradictory data (`t2`.`c2` having value in it AND `t2`.`c2` having NULL checkbox checked) caused the record to be inserted with NULL value rather than value I entered into the field).
Discussion
This bug was fixed in repository and will be part of a future release; thanks for reporting.