Another testcase (possibly reducible to same original one)
SELECT * FROM (INFORMATION_SCHEMA.INNODB_SYS_FOREIGN AS t1 JOIN INFORMATION_SCHEMA.INNODB_CHANGED_PAGES AS t2 ON (t2.start_lsn=t1.REF_NAME)) WHERE NOT (((t2.end_lsn>='2005-05-25 06:28:02.028009' OR t1.REF_NAME<t1.TYPE) OR t2.space_id<'w') OR t2.start_lsn<='2007-06-10 17:28:40.010864') ;
Another testcase (possibly reducible to same original one)
SELECT * FROM (INFORMATION_ SCHEMA. INNODB_ SYS_FOREIGN AS t1 JOIN INFORMATION_ SCHEMA. INNODB_ CHANGED_ PAGES AS t2 ON (t2.start_ lsn=t1. REF_NAME) ) WHERE NOT (((t2.end_ lsn>='2005- 05-25 06:28:02.028009' OR t1.REF_ NAME<t1. TYPE) OR t2.space_id<'w') OR t2.start_ lsn<='2007- 06-10 17:28:40.010864') ;