Fix SHOW PARTITIONS and dual catalog with include-coordinator=false

Mark dual and information schema as system datasources. Also add more unit tests for disabling coordinator work scheduling