Searching for Y- with no syntactic query expansion in all metadata.Query 3 create temporary table if not exists query_resultu77xe5 ENGINE=memory select id, match (title) against ('Y-' in boolean mode) as score from dblp_pub_new where match (title) against ('Y-' in boolean mode) UNION ALL select p1.id, match (p2.title) against ('Y-' in boolean mode) as score from dblp_pub_new p1 join dblp_pub_new p2 on p1.crossref=p2.dblp_key where match (p2.title) against ('Y-' in boolean mode) UNION ALL select id, match (source) against ('Y-' in boolean mode) as score from dblp_pub_new where match (source) against ('Y-' in boolean mode) UNION ALL select id, 1 from dblp_pub_new where source = 'Y-' UNION ALL select id, match (name) against ('Y-' in boolean mode) as score from dblp_keywords_new where match (name) against ('Y-' in boolean mode) UNION ALL select id, 1 from dblp_keywords_new where name = 'Y-' UNION ALL select id, match (abstract) against ('Y-' in boolean mode) as score from dblp_abstracts_new where match (abstract) against ('Y-' in boolean mode) UNION ALL select id, match (author) against ('Y-' in boolean mode) as score from dblp_author_ref_new where match (author) against ('Y-' in boolean mode) failed syntax error, unexpected $end