What version of Teiid Designer are you using?
Also, can you duplicate it. I've tried and cannot, but I'm using JBDS 11 with a newer version of TD (11.1.1) that's about to be released.
I am using Oxygen Eclipse , wildFly 10.0 and TD(9.3.1).
I think, some teiid experts can help us.
It is working for you in JDBS 11?
I tried it and didn't see the issue. But that's not to say, with the right keystrokes, it could happen again. When I copy in what you stated above, and then click save, I just get the validation error in the INSERT tab.
I believe when "default" for "supportsUpdate" is used, the canvas should be empty, maybe Designer is generating the default what it thinks then getting into validation issues? Looks like a bug to me.
Iam happy to see your reply. Thanks for support and help continously in this forum.
I have learnt teiid from your blog
Regarding issue, TD is removed all the line after the saving except below three line.
CREATE TRIGGER ON LetterTable
INSTEAD OF UPDATE
I believe since that code is auto-generated in Designer it may be a bug which is failing to clean up properly. IMO, it should not clean up any text but make the editor not editable, and keep the data intact if you entered any text at all in case if you change your mind about default updates, as default updates are very limiting in functionality. So, you can log a JIRA for tooling for this bug at - JBoss Issue Tracker
As a workaround, delete all the text yourself and see if that helps.
Ok Ramesh. I will raise the ticket