[JBoss JIRA] (TEIID-4930) Scale of 0 always reported for 0 precision
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-4930:
-------------------------------------
Summary: Scale of 0 always reported for 0 precision
Key: TEIID-4930
URL: https://issues.jboss.org/browse/TEIID-4930
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.3
With invalid metadata from designer that specifies a 0 precision, the scale will always be reported as 0 as well.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4228) ODBC "Parse Statements" option can result in changes in LENGTH metadata for columns
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4228?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4228:
---------------------------------------
The logic that adjusts the scale when it is larger than the precision does not account for a zero precision, they the 0 scale. I'll address this under a new issue, but generally it's a corner case as the incoming metadata is invalid.
> ODBC "Parse Statements" option can result in changes in LENGTH metadata for columns
> -----------------------------------------------------------------------------------
>
> Key: TEIID-4228
> URL: https://issues.jboss.org/browse/TEIID-4228
> Project: Teiid
> Issue Type: Sub-task
> Components: ODBC
> Affects Versions: 8.7
> Environment: Connections through ODBC driver
> Reporter: Marc Shirley
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 9.1
>
>
> Connections through ODBC driver with the driver setting "Parse Statements" option enabled can result in incorrect length values being passed to the client. In some cases (such as SQL Server linked server capabilities), this can result in the client throwing exceptions due to the expected LENGTH changing during the course of the query execution.
> This may be limited to columns with precision set to 0, as the SQL Server linked server case was corrected when the precision was changed from 0 to 9 for the column specified in the error.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4572) Grouping by and faceted search for Solr tranlator
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4572?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4572:
---------------------------------------
9.3 CR1 will go out this week. If we are assured that the pull request does not interfere with existing functionality and have not locked in on a single CR, then the pull request could go in next week at the latest. Otherwise it will need to wait until 10.0.
> Grouping by and faceted search for Solr tranlator
> -------------------------------------------------
>
> Key: TEIID-4572
> URL: https://issues.jboss.org/browse/TEIID-4572
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Reporter: Hend Amin
> Fix For: 10.0
>
>
> Currently group by is not supported for Solr translator. For example:
> select x,y, count\(*) from solr_core group by x,y; the corresponding Solr request does not contain group by.
> Please add group by and faceted search support for Solr translator.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4925) Importing a non-existing VDB gives no warning
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4925?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4925.
-----------------------------------
Fix Version/s: 9.3
Resolution: Done
Added an info message that the vdb is waiting on importing another vdb. This may need to be made clearer in tooling - which would need to check for the loading state, then check for imported vdbs and their status. Otherwise it would require some rework in our VDBMetadata Messages, which are currently just schema/model based.
> Importing a non-existing VDB gives no warning
> ---------------------------------------------
>
> Key: TEIID-4925
> URL: https://issues.jboss.org/browse/TEIID-4925
> Project: Teiid
> Issue Type: Enhancement
> Components: Server
> Affects Versions: 9.2.3
> Environment: * Wildfly 10
> * Teiid Server 9.2.3
> Reporter: Pedro Inácio
> Assignee: Steven Hawkins
> Fix For: 9.3
>
> Attachments: ReferenceData.png
>
>
> When importing a "non-existing VDB" in a VDB, when the VDB is deployed, the VDB status is LOADING, and nothing else happens.
> Ideally a warning should be thrown in logs.
> Ex:
> <code>
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <vdb name="ReferenceDataVDB" version="1">
> <description>ReferenceData VDB</description>
> <import-vdb name="NonExistingVDB" version="1"/>
>
> <model name="ReferenceData" type="VIRTUAL">
> .....
> </code>
> Logs:
> <panel>
> 12:56:11,529 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) WFLYSRV0027: Starting deployment of "ReferenceData-vdb.xml" (runtime-name: "ReferenceData-vdb.xml")
> 12:56:11,953 INFO [org.jboss.as.server] (DeploymentScanner-threads - 1) WFLYSRV0010: Deployed "ReferenceData-vdb.xml" (runtime-name : "ReferenceData-vdb.xml")
> </panel>
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4572) Grouping by and faceted search for Solr tranlator
by Amr Ismail (JIRA)
[ https://issues.jboss.org/browse/TEIID-4572?page=com.atlassian.jira.plugin... ]
Amr Ismail commented on TEIID-4572:
-----------------------------------
Dear Steven,
We can work on this pull request on this week. So what is the deasline
before moving this to the nexy version 10.x as we are in a hurry for
releasing this version
thanks
> Grouping by and faceted search for Solr tranlator
> -------------------------------------------------
>
> Key: TEIID-4572
> URL: https://issues.jboss.org/browse/TEIID-4572
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Reporter: Hend Amin
> Fix For: 10.0
>
>
> Currently group by is not supported for Solr translator. For example:
> select x,y, count\(*) from solr_core group by x,y; the corresponding Solr request does not contain group by.
> Please add group by and faceted search support for Solr translator.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4928) Couchbase - NAMEINSOURCE required for all the columns and tables
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4928?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4928:
---------------------------------------
Is the back quote required? If not, I don't think that we should try to automatically quote - especially since that would be different than the JDBC behavior.
But yes, we should definitely not have a null table name.
> Couchbase - NAMEINSOURCE required for all the columns and tables
> ----------------------------------------------------------------
>
> Key: TEIID-4928
> URL: https://issues.jboss.org/browse/TEIID-4928
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 9.3
> Reporter: Juraj Duráni
> Assignee: Kylin Soong
>
> Option *NAMEINSOURCE* is de facto required for all the columns and tables. If it is not present then:
> # column name in source query is not enclosed in back quotes - e.g. *`$cb_t1`.ShortValue* instead of *`$cb_t1`.`ShortValue`*
> # name of the table is not added to the source query - e.g. *SELECT ... FROM null `$cb_t1` LET ... WHERE ...* instead of *SELECT ... FROM `smalla` `$cb_t1` LET ... WHERE ...*
> This should work OOB without need to add NAMEINSOURCE option. Teiid should automatically translate column name from e.g. *MyColumn* to *`MyColumn`* if option is not set. Same with name of the table.
> In case of table I think this is more serious as it does not even try name of the table but supplies *null* to the query
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4928) Couchbase - NAMEINSOURCE required for all the columns and tables
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4928?page=com.atlassian.jira.plugin... ]
Van Halbert reassigned TEIID-4928:
----------------------------------
Assignee: Kylin Soong (was: Steven Hawkins)
> Couchbase - NAMEINSOURCE required for all the columns and tables
> ----------------------------------------------------------------
>
> Key: TEIID-4928
> URL: https://issues.jboss.org/browse/TEIID-4928
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 9.3
> Reporter: Juraj Duráni
> Assignee: Kylin Soong
>
> Option *NAMEINSOURCE* is de facto required for all the columns and tables. If it is not present then:
> # column name in source query is not enclosed in back quotes - e.g. *`$cb_t1`.ShortValue* instead of *`$cb_t1`.`ShortValue`*
> # name of the table is not added to the source query - e.g. *SELECT ... FROM null `$cb_t1` LET ... WHERE ...* instead of *SELECT ... FROM `smalla` `$cb_t1` LET ... WHERE ...*
> This should work OOB without need to add NAMEINSOURCE option. Teiid should automatically translate column name from e.g. *MyColumn* to *`MyColumn`* if option is not set. Same with name of the table.
> In case of table I think this is more serious as it does not even try name of the table but supplies *null* to the query
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months