1 Reply Latest reply on Aug 22, 2012 8:50 AM by Steven Hawkins Branched from an earlier discussion.

    Re: Continuous request against Procedure Execution Using WITH

    Andriy Rokhmanov Newbie

      Thank you Steven, this is useful info. I don't think we need now to cache the repeating execution results, but if it might quickly change when we will get to more complex queries.

       

      About using nested tables to control the order of queries - I think the "WITH ..." statement makes a temp table, which teiid then uses internally to process subquery. I found that having continuous execution inside the WITH() statement and simply combining its output with a regular query makes strange results: DataNotAvailableException is not honored (setStrict is true). If I specifically join this two queries together - execution blocks. I do not have a good test code to illustrate this scenario, but I'll try spend some time later on research.