[JBoss JIRA] (TEIIDDES-2693) Allow warnings to be presented to the user when importing from JDBC
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2693?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2693:
-----------------------------------
Fix Version/s: 10.2
> Allow warnings to be presented to the user when importing from JDBC
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2693
> URL: https://issues.jboss.org/browse/TEIIDDES-2693
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Andrej Šmigala
> Fix For: 10.2
>
>
> This came up when resolving TEIIDDES-2458. The fix attempts to get the correct name in source for the sybase tables, but there's a possibility this will fail. We still want to finish the import, but we'd also like to warn the user the NIS might be incorrect.
> See the comment in this PR: https://github.com/Teiid-Designer/teiid-designer/pull/516
> <blafond> asmigala: oops. missed it. Since this warning would probably occur on multiple tables/columns it wouldn't be good to pop up a dialog during the processing.
> <blafond> asmigala: If we added an IStatus[] to RelationalModelProcessorImpl, we could check it's Severity and throw up a Warning/Error summary dialog after processing?
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIIDDES-2715) Add support for searching in array types
by Steven Hawkins (JIRA)
Steven Hawkins created TEIIDDES-2715:
----------------------------------------
Summary: Add support for searching in array types
Key: TEIIDDES-2715
URL: https://issues.jboss.org/browse/TEIIDDES-2715
Project: Teiid Designer
Issue Type: Feature Request
Components: Teiid Integration
Reporter: Steven Hawkins
Teiid supports searching in an array using quantified comparisons:
expression operator ALL|SOME|ANY (array_expression)
Parsing and resolving logic will be needed in Designer.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIIDDES-2714) Add support for searching in array types
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2714?page=com.atlassian.jira.plu... ]
Steven Hawkins reassigned TEIIDDES-2714:
----------------------------------------
Description:
Teiid supports searching in an array using quantified comparisons:
expression operator ALL|SOME|ANY (array_expression)
Parsing and resolving logic will be needed in Designer.
was:We should support a simple syntax for searching within an array, such as the quantified comparison and/or a function to get the index of a value in an array.
Assignee: (was: Steven Hawkins)
> Add support for searching in array types
> ----------------------------------------
>
> Key: TEIIDDES-2714
> URL: https://issues.jboss.org/browse/TEIIDDES-2714
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Teiid Integration
> Reporter: Steven Hawkins
>
> Teiid supports searching in an array using quantified comparisons:
> expression operator ALL|SOME|ANY (array_expression)
> Parsing and resolving logic will be needed in Designer.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIIDDES-2714) Add support for searching in array types
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2714?page=com.atlassian.jira.plu... ]
Steven Hawkins moved TEIID-3809 to TEIIDDES-2714:
-------------------------------------------------
Project: Teiid Designer (was: Teiid)
Key: TEIIDDES-2714 (was: TEIID-3809)
Component/s: Teiid Integration
(was: Query Engine)
Fix Version/s: (was: 9.0)
> Add support for searching in array types
> ----------------------------------------
>
> Key: TEIIDDES-2714
> URL: https://issues.jboss.org/browse/TEIIDDES-2714
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Teiid Integration
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
>
> We should support a simple syntax for searching within an array, such as the quantified comparison and/or a function to get the index of a value in an array.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIIDDES-2702) DynamicVDB NameInSource generation should be the same
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2702?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2702:
----------------------------------------
The example in the what's new has the table NIS defined without D-Quotes, hence it appears different. Below is a Books Authors table that was imported that d-quotes the table NIS as well, so the resulting NIS's for columns and tables are single-quoted the same. *NAMEINSOURCE '"AUTHOR_ID"'* and *NAMEINSOURCE '"BOOKS"."AUTHORS"'*
{code}
CREATE FOREIGN TABLE AUTHORS (
AUTHOR_ID long NOT NULL OPTIONS(NAMEINSOURCE '"AUTHOR_ID"', NATIVE_TYPE 'BIGINT', CASE_SENSITIVE 'FALSE', FIXED_LENGTH 'TRUE', SEARCHABLE 'ALL_EXCEPT_LIKE'),
FIRSTNAME string(255) OPTIONS(NAMEINSOURCE '"FIRSTNAME"', NATIVE_TYPE 'VARCHAR'),
LASTNAME string(255) OPTIONS(NAMEINSOURCE '"LASTNAME"', NATIVE_TYPE 'VARCHAR'),
MIDDLEINIT string(255) OPTIONS(NAMEINSOURCE '"MIDDLEINIT"', NATIVE_TYPE 'VARCHAR'),
CONSTRAINT PK_AUTHORS PRIMARY KEY(AUTHOR_ID)
) OPTIONS(NAMEINSOURCE '"BOOKS"."AUTHORS"')
{code}
> DynamicVDB NameInSource generation should be the same
> -----------------------------------------------------
>
> Key: TEIIDDES-2702
> URL: https://issues.jboss.org/browse/TEIIDDES-2702
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Van Halbert
> Assignee: Barry LaFond
>
> Looking at the page for WhatsNewIn92 teiid Designer [1], it appears the NameInSource quoting is generated differently for a column versus the table. The columns has double quotes inside single tic's, where the table only has single tic's.
> It would be good if all nameinsource generation is done the same.
> [1] https://developer.jboss.org/wiki/TeiidDesigner92WhatsNew
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months