datajoint-matlab
datajoint-matlab copied to clipboard
Error in restriction of projection of restriction
Restricting a project of restricted table yields an error due to incorrect MySQL syntax.
For example,
pro(acq.Sessions & 'subject_id = 1') & 'subject_id = 1'
produces an error: Error using mym You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (subject_id = 1) LIMIT 1) as yes' at line 1
Surely enough, checking the SQL query produced via above operation yields:
`acq`.`sessions` WHERE (subject_id = 1) WHERE (subject_id = 1)