Teiid Designer Virtual procedure changes select ti.* to SELECT #tmp_infections AS [*]ti.*

[gadeyne.bram]

When I try to insert my problem here then I get a message indicating the content is not allowed.

So I've added it as a text file attachment.

[rareddy]

Instead of using ti.*, try to expand the columns out. Designer is trying to that, but looks like some issue there. May be you can recreate with a smaller SQL and submit as Designer bug, we will fix it.

Ramesh..

[gadeyne.bram]

Hi Ramesh,

That works indeed! Thank you!