dynamobi/dynamobi — Issue #192: [LDB-129] push down filtering the import foreign schema "limit to" and "except"
Author: dynamobi-build
Created: 2011-12-30 02:20:38+00:00
State: open
Labels: Flatfile, LDB

[reporter="schoi", created="Thu, 24 Aug 2006 19:07:13 -0500 (GMT-05:00)"]
in "IMPORT FOREIGN SCHEMA .. LIMIT TO | EXCEPT", all the metadata about all tables in the foreign schema are actually returned, then the "LIMIT TO" or "EXCEPT" filtering is done locally.

Is it possible to push down the filtering, because in the cases where extracting metadata on some table we don't want fails, the entire IMPORT fails. But if we don't want the failed table anyway, the error seems weird.

I think this is true in all wrappers right now? but the problem can be easily repro'd using the flatfile wrapper.