[JBoss JIRA] (TEIIDDES-2782) Copy paste sql to the transformation editor is not parsable
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2782?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2782:
----------------------------------------
I'm not seeing that behavior on Ubuntu
> Copy paste sql to the transformation editor is not parsable
> -----------------------------------------------------------
>
> Key: TEIIDDES-2782
> URL: https://issues.jboss.org/browse/TEIIDDES-2782
> Project: Teiid Designer
> Issue Type: Bug
> Components: Editors, Transformations
> Affects Versions: 10.0.1
> Environment: Windows 10 Pro N
> Reporter: Matej Kralik
> Priority: Minor
> Attachments: XmlStagingProject.zip
>
>
> When I copy a sql query from any source (notepad, web browser ...) and paste it to the transformation editor show me that "The query is not parsable.Error in parsing of sql - null ."
> When I deleted all newlines from sql query or I wrote it myself to the editor, sql query was validated.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIIDDES-2782) Copy paste sql to the transformation editor is not parsable
by Matej Kralik (JIRA)
Matej Kralik created TEIIDDES-2782:
--------------------------------------
Summary: Copy paste sql to the transformation editor is not parsable
Key: TEIIDDES-2782
URL: https://issues.jboss.org/browse/TEIIDDES-2782
Project: Teiid Designer
Issue Type: Bug
Components: Editors, Transformations
Affects Versions: 10.0.1
Environment: Windows 10 Pro N
Reporter: Matej Kralik
Priority: Minor
Attachments: XmlStagingProject.zip
When I copy a sql query from any source (notepad, web browser ...) and paste it to the transformation editor show me that "The query is not parsable.Error in parsing of sql - null ."
When I deleted all newlines from sql query or I wrote it myself to the editor, sql query was validated.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIIDDES-2780) Use of Format property in Properties window in source model doesn't seem to work
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2780?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2780:
----------------------------------------
[~cballego] FYI... Teiid runtime does not use the *Format* property for any of the standard JDBC translators _(see comment above)_. You'll have to go the *view with function conversion* route.
> Use of Format property in Properties window in source model doesn't seem to work
> --------------------------------------------------------------------------------
>
> Key: TEIIDDES-2780
> URL: https://issues.jboss.org/browse/TEIIDDES-2780
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0, 9.0.5
> Reporter: Matus Makovy
> Priority: Minor
>
> Issue copied from BZ, original reporter is cvanball(a)redhat.com.
> Description of problem:
> We have a use case where we have to replace datatypes with alternate
> For example
> SHIPPING_DATE and RETURN_DUE_DATE on CUSTOMER_ORDER_LINE_COPY from DATE to string field of 10 (dd-mm-yyyy) and name it STR_SHIPPING_DATE, STR_RETURN_DUE_DATE respectibly.
> Version-Release number of selected component (if applicable):
> N/A
> Actual results:
> Date are not conform the dd-MM-yyyy format. Iow no transformation done despite the fact of Format property filled in
> Expected results:
> Date transformation to dd-MM-yyyy
> mmakovy: I reproduced this with 10.0.0.Beta2, formatting doesn't work.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIIDDES-2780) Use of Format property in Properties window in source model doesn't seem to work
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2780?page=com.atlassian.jira.plu... ]
Steven Hawkins commented on TEIIDDES-2780:
------------------------------------------
Format is only used by the ldap translator and then only for timestamp fields. Other than that it could be used by a custom translator. This field existed all the way back in the MMX days and I can't say for certain what the intention was behind it.
> Use of Format property in Properties window in source model doesn't seem to work
> --------------------------------------------------------------------------------
>
> Key: TEIIDDES-2780
> URL: https://issues.jboss.org/browse/TEIIDDES-2780
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0, 9.0.5
> Reporter: Matus Makovy
> Priority: Minor
>
> Issue copied from BZ, original reporter is cvanball(a)redhat.com.
> Description of problem:
> We have a use case where we have to replace datatypes with alternate
> For example
> SHIPPING_DATE and RETURN_DUE_DATE on CUSTOMER_ORDER_LINE_COPY from DATE to string field of 10 (dd-mm-yyyy) and name it STR_SHIPPING_DATE, STR_RETURN_DUE_DATE respectibly.
> Version-Release number of selected component (if applicable):
> N/A
> Actual results:
> Date are not conform the dd-MM-yyyy format. Iow no transformation done despite the fact of Format property filled in
> Expected results:
> Date transformation to dd-MM-yyyy
> mmakovy: I reproduced this with 10.0.0.Beta2, formatting doesn't work.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIIDDES-2780) Use of Format property in Properties window in source model doesn't seem to work
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2780?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2780:
----------------------------------------
[~shawkins] Designer gas defined a "Format" property on a column for quite some time and it's being added to the indexed column metadata. Does Teiid runtime use this field?
> Use of Format property in Properties window in source model doesn't seem to work
> --------------------------------------------------------------------------------
>
> Key: TEIIDDES-2780
> URL: https://issues.jboss.org/browse/TEIIDDES-2780
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0, 9.0.5
> Reporter: Matus Makovy
> Priority: Minor
>
> Issue copied from BZ, original reporter is cvanball(a)redhat.com.
> Description of problem:
> We have a use case where we have to replace datatypes with alternate
> For example
> SHIPPING_DATE and RETURN_DUE_DATE on CUSTOMER_ORDER_LINE_COPY from DATE to string field of 10 (dd-mm-yyyy) and name it STR_SHIPPING_DATE, STR_RETURN_DUE_DATE respectibly.
> Version-Release number of selected component (if applicable):
> N/A
> Actual results:
> Date are not conform the dd-MM-yyyy format. Iow no transformation done despite the fact of Format property filled in
> Expected results:
> Date transformation to dd-MM-yyyy
> mmakovy: I reproduced this with 10.0.0.Beta2, formatting doesn't work.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIIDDES-2780) Use of Format property in Properties window in source model doesn't seem to work
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2780?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2780:
---------------------------------------------------
Matus Makovy <mmakovy(a)redhat.com> changed the Status of [bug 1306641|https://bugzilla.redhat.com/show_bug.cgi?id=1306641] from NEW to CLOSED
> Use of Format property in Properties window in source model doesn't seem to work
> --------------------------------------------------------------------------------
>
> Key: TEIIDDES-2780
> URL: https://issues.jboss.org/browse/TEIIDDES-2780
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0, 9.0.5
> Reporter: Matus Makovy
> Priority: Minor
>
> Issue copied from BZ, original reporter is cvanball(a)redhat.com.
> Description of problem:
> We have a use case where we have to replace datatypes with alternate
> For example
> SHIPPING_DATE and RETURN_DUE_DATE on CUSTOMER_ORDER_LINE_COPY from DATE to string field of 10 (dd-mm-yyyy) and name it STR_SHIPPING_DATE, STR_RETURN_DUE_DATE respectibly.
> Version-Release number of selected component (if applicable):
> N/A
> Actual results:
> Date are not conform the dd-MM-yyyy format. Iow no transformation done despite the fact of Format property filled in
> Expected results:
> Date transformation to dd-MM-yyyy
> mmakovy: I reproduced this with 10.0.0.Beta2, formatting doesn't work.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months
[JBoss JIRA] (TEIIDDES-2780) Use of Format property in Properties window in source model doesn't seem to work
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2780?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2780:
-----------------------------------
Affects Version/s: 9.0.5
> Use of Format property in Properties window in source model doesn't seem to work
> --------------------------------------------------------------------------------
>
> Key: TEIIDDES-2780
> URL: https://issues.jboss.org/browse/TEIIDDES-2780
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0, 9.0.5
> Reporter: Matus Makovy
> Priority: Minor
>
> Issue copied from BZ, original reporter is cvanball(a)redhat.com.
> Description of problem:
> We have a use case where we have to replace datatypes with alternate
> For example
> SHIPPING_DATE and RETURN_DUE_DATE on CUSTOMER_ORDER_LINE_COPY from DATE to string field of 10 (dd-mm-yyyy) and name it STR_SHIPPING_DATE, STR_RETURN_DUE_DATE respectibly.
> Version-Release number of selected component (if applicable):
> N/A
> Actual results:
> Date are not conform the dd-MM-yyyy format. Iow no transformation done despite the fact of Format property filled in
> Expected results:
> Date transformation to dd-MM-yyyy
> mmakovy: I reproduced this with 10.0.0.Beta2, formatting doesn't work.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 2 months