datajoint-matlab icon indicating copy to clipboard operation
datajoint-matlab copied to clipboard

Error in restriction of projection of restriction

Open eywalker opened this issue 8 years ago • 2 comments

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)

eywalker avatar Nov 09 '15 20:11 eywalker