[JBoss JIRA] (TEIIDDES-2945) Issues with ddl generation
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2945?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2945:
--------------------------------------
Assignee: Barry LaFond
> Issues with ddl generation
> --------------------------
>
> Key: TEIIDDES-2945
> URL: https://issues.jboss.org/browse/TEIIDDES-2945
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling
> Affects Versions: 10.1
> Reporter: Steven Hawkins
> Assignee: Barry LaFond
> Fix For: 11.0.1
>
>
> This can be separated out into separate issues if needed.
> - most ddl statements are not terminated with the semicolon delimiter. This was a mistake with the original grammar. We'll hopefully get this resolved with minimal breaking changes with TEIID-4528
> - name in source and other options should be added by default. Is there a reason they are omitted by default?
> - triggers / update procedures don't seem to be emitted
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years
[JBoss JIRA] (TEIIDDES-2989) Missing UDF settings in dynamic VDB
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2989?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2989:
----------------------------------------
[~mmajerni] can you add your model project set to this issue too? thx
> Missing UDF settings in dynamic VDB
> -----------------------------------
>
> Key: TEIIDDES-2989
> URL: https://issues.jboss.org/browse/TEIIDDES-2989
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Import/Export
> Affects Versions: 10.0.2
> Reporter: Mario Majernik
> Assignee: Barry LaFond
> Fix For: 11.1
>
>
> When I created UDF function, generate dynamic vdb and generate back view model some things missed there.
> When I set all checkboxes in properties on true in UDF dialog in view model, a lot of them missing in dynamic vdb and of course in view model after generating.
> Determistic checkbox: There is mention in dynamic vdb but wrong because after generating view model is false.
> "Returns null on null" and "Variable Arguments" are set correct
> Other checkboxes(Aggregate, Analytic, ...) are not mention in dynamic vdb and missing in view model after generating
> Update Count is always AUTO same as in srouce model.
> Missing Name in Source for parameters.
> And If I set direction for some column at RETURN, in dynamic vdb is changed on OUT.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years
[JBoss JIRA] (TEIIDDES-2954) Dynamic VDB doesn't contains apostrophe around procedure
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2954?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2954:
----------------------------------------
[~van.halbert] Can you clarify what, if anything needs to get fixed now that mat. wizard is available?
> Dynamic VDB doesn't contains apostrophe around procedure
> --------------------------------------------------------
>
> Key: TEIIDDES-2954
> URL: https://issues.jboss.org/browse/TEIIDDES-2954
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0.2
> Environment: Fedora 24
> Reporter: Matej Kralik
> Attachments: completeJDGproject2.zip
>
>
> I have a project with JDG materialization. I have set
> After load script to: execute BookCacheSource.native('swap cache names');
> and
> Before load script to: execute BookCacheSource.native('truncate cache');
> When I generated Dynamic VDB and I want to deploy it, server shows me error that:
> {code:java}
> org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered ", \"teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT\" 'execute BookCacheSource.native('[*]swap[*] cache names" at line 10, column 188.
> Was expecting: "," | ")"
> {code}
> When I added another apostrophe to procedures in the DDL,
> execute BookCacheSource.native(''truncate cache'');
> execute BookCacheSource.native(''swap cache names'');
> deploy was successful.
> I think that DDL parser should add it automatically.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years