If I use the command line tool mysql.exe, it seems to block key entry after 254 characters. I was originally doing the query via JDBC and this also seemed to fail, which was why I was trying it in the command line tool.
The query I am doing is quite complex - it must be failing for a different reason. The query is
select date_format(xx_start, '%d %b %Y %H:%i'), xx_userid, xx_link, date_format(xx_due_date, '%d %b %Y %H:%i'), xx_synopsis, xx_workflowid, xx_tasks.xx_taskid, xx_tasks.xx_elementid, xx_tasks.xx_cdocid
from xx_tasks, xx_task_recipients
where ( xx_tasks.xx_workflowid = '1012858233' ) and xx_tasks.xx_taskid = xx_task_recipients.xx_taskid and xx_completedby = null
I will split it up and check it in the command line tool.