Browse view on multiple fields generates bad MYSQL

[af05v@…]

view definition includes:

fields => "creators_id/editors_id",

Generates:

SELECT DISTINCT eprint.eprintid,eprint.appears_on_cv FROM eprint_editors_id,eprint_creators_id,eprint WHERE eprint.eprint_status = 'archive' AND ((eprint_creators_id.creators_id = )) OR ((eprint_editors_id.editors_id = )) AND eprint.eprintid = eprint_editors_id.eprintid AND eprint.eprintid = eprint_creators_id.eprintid;

Note no brackets around the OR:

((eprint_creators_id.creators_id = )) OR ((eprint_editors_id.editors_id = ))

Should be:

((eprint_creators_id.creators_id = ) OR (eprint_editors_id.editors_id = ))

[tdb01r]

The constructed SQL is now completely different in 3.2+.