[JBoss JIRA] (TEIID-3141) Bad result of query with GROUB BY clause (underlying sybase15 datasource)
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3141?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3141:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1146501|https://bugzilla.redhat.com/show_bug.cgi?id=1146501] from NEW to MODIFIED
> Bad result of query with GROUB BY clause (underlying sybase15 datasource)
> -------------------------------------------------------------------------
>
> Key: TEIID-3141
> URL: https://issues.jboss.org/browse/TEIID-3141
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1
> Environment: OS: fedora20
> arch: x86_64
> java: sun 1.7
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> Description:
> There is sybase15 database with table named SmallA and table named SmallA in VDB which is mapped to sybase table (see tables definition below).
> I am trying to run query against VDB:
> SELECT
> INTKEY, STRINGKEY, INTNUM, STRINGNUM, FLOATNUM, LONGNUM, DOUBLENUM, BYTENUM, DATEVALUE, TIMEVALUE, TIMESTAMPVALUE, BOOLEANVALUE, CHARVALUE, SHORTVALUE, BIGINTEGERVALUE, BIGDECIMALVALUE
> FROM
> BQT1.SMALLA
> GROUP BY
> INTKEY, STRINGKEY, INTNUM, STRINGNUM, FLOATNUM, LONGNUM, DOUBLENUM, BYTENUM, DATEVALUE, TIMEVALUE, TIMESTAMPVALUE, BOOLEANVALUE, CHARVALUE, SHORTVALUE, BIGINTEGERVALUE, BIGDECIMALVALUE
> Result is table which misses some values (the other values are OK):
> FloatNum: always 0
> ByteNum: always 0
> DateValue: always 1900-01-01
> TimeValue: always 00:00:00
> BooleanValue: always 'false'
> CharValue: always empty character
> ShortValue: always 0
> BigIntegerValue: always 0
> BigDecimalValue: always 0
> After removing 'INTKEY' and 'STRINGKEY' from the query is result OK (sybase15 has indices only for these two columns).
> ///////////////////
> Table definition
> ///////////////////
> SmallA (sybase) has these columns (name:type):
> IntKey:int -> PRIMARY KEY, HAS INDEX
> StringKey:varchar -> HAS INDEX
> IntNum:int
> StringNum:varchar
> FloatNum:float
> LongNum:numeric
> DoubleNum:float
> ByteNum:real
> DateValue:datetime
> TimeValue:datetime
> TimestampValue:datetime
> BooleanValue:tinyint
> CharValue:char
> ShortValue:numeric
> BigIntegerValue:numeric
> BigDecimalValue:numeric
> ObjectValue:text
> SmallA (VDB) has these columns (name:type):
> IntKey:integer
> StringKey:string
> IntNum:integer
> StringNum:string
> FloatNum:float
> LongNum:long
> DoubleNum:double
> ByteNum:byte
> DateValue:date
> TimeValue:time
> TimestampValue:timestamp
> BooleanValue:boolean
> CharValue:char
> ShortValue:short
> BigIntegerValue:biginteger
> BigDecimalValue:bigdecimal
> ObjectValue:object
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 3 months
[JBoss JIRA] (TEIID-3141) Bad result of query with GROUB BY clause (underlying sybase15 datasource)
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3141?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3141.
-----------------------------------
Resolution: Deferred
Will look at again if there is a similar customer issue such that there is a grouping over an index and there are secondary grouping columns with functions.
> Bad result of query with GROUB BY clause (underlying sybase15 datasource)
> -------------------------------------------------------------------------
>
> Key: TEIID-3141
> URL: https://issues.jboss.org/browse/TEIID-3141
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1
> Environment: OS: fedora20
> arch: x86_64
> java: sun 1.7
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> Description:
> There is sybase15 database with table named SmallA and table named SmallA in VDB which is mapped to sybase table (see tables definition below).
> I am trying to run query against VDB:
> SELECT
> INTKEY, STRINGKEY, INTNUM, STRINGNUM, FLOATNUM, LONGNUM, DOUBLENUM, BYTENUM, DATEVALUE, TIMEVALUE, TIMESTAMPVALUE, BOOLEANVALUE, CHARVALUE, SHORTVALUE, BIGINTEGERVALUE, BIGDECIMALVALUE
> FROM
> BQT1.SMALLA
> GROUP BY
> INTKEY, STRINGKEY, INTNUM, STRINGNUM, FLOATNUM, LONGNUM, DOUBLENUM, BYTENUM, DATEVALUE, TIMEVALUE, TIMESTAMPVALUE, BOOLEANVALUE, CHARVALUE, SHORTVALUE, BIGINTEGERVALUE, BIGDECIMALVALUE
> Result is table which misses some values (the other values are OK):
> FloatNum: always 0
> ByteNum: always 0
> DateValue: always 1900-01-01
> TimeValue: always 00:00:00
> BooleanValue: always 'false'
> CharValue: always empty character
> ShortValue: always 0
> BigIntegerValue: always 0
> BigDecimalValue: always 0
> After removing 'INTKEY' and 'STRINGKEY' from the query is result OK (sybase15 has indices only for these two columns).
> ///////////////////
> Table definition
> ///////////////////
> SmallA (sybase) has these columns (name:type):
> IntKey:int -> PRIMARY KEY, HAS INDEX
> StringKey:varchar -> HAS INDEX
> IntNum:int
> StringNum:varchar
> FloatNum:float
> LongNum:numeric
> DoubleNum:float
> ByteNum:real
> DateValue:datetime
> TimeValue:datetime
> TimestampValue:datetime
> BooleanValue:tinyint
> CharValue:char
> ShortValue:numeric
> BigIntegerValue:numeric
> BigDecimalValue:numeric
> ObjectValue:text
> SmallA (VDB) has these columns (name:type):
> IntKey:integer
> StringKey:string
> IntNum:integer
> StringNum:string
> FloatNum:float
> LongNum:long
> DoubleNum:double
> ByteNum:byte
> DateValue:date
> TimeValue:time
> TimestampValue:timestamp
> BooleanValue:boolean
> CharValue:char
> ShortValue:short
> BigIntegerValue:biginteger
> BigDecimalValue:bigdecimal
> ObjectValue:object
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 3 months
[JBoss JIRA] (TEIID-3121) Teiid Standalone Server
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3121?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3121:
---------------------------------------
Thanks Tom. The pull request has been committed with a minor change to put the install directory into the target directory so that it's not seen as a working file also it's now referenced by the README.md. We can leave this open if you're still looking into the maven approach.
> Teiid Standalone Server
> -----------------------
>
> Key: TEIID-3121
> URL: https://issues.jboss.org/browse/TEIID-3121
> Project: Teiid
> Issue Type: Feature Request
> Components: Build/Kits
> Reporter: Tom Arnold
> Fix For: Open To Community
>
>
> Perform the server installation steps as part of the build and add the result to the downloads page. It seems like this is something that everyone who isn't using the embedded kit has to do anyways, and would hopefully eliminate confusion caused by people trying to deploy the runtime in unsupported versions of JBoss.
> * Teiid Runtime
> * Teiid Web Console
> * JBoss EAP 6.1 Alpha
> * Resteasy JAX-RS Patch
> End result would simplify the installation process to:
> 1. Unzip Teiid server.
> 2. Run `bin/add-user.sh` script.
> 3. Deploy custom translators, VDB, etc.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 3 months
[JBoss JIRA] (TEIID-3121) Teiid Standalone Server
by Tom Arnold (JIRA)
[ https://issues.jboss.org/browse/TEIID-3121?page=com.atlassian.jira.plugin... ]
Tom Arnold commented on TEIID-3121:
-----------------------------------
Submitted PR.
> Teiid Standalone Server
> -----------------------
>
> Key: TEIID-3121
> URL: https://issues.jboss.org/browse/TEIID-3121
> Project: Teiid
> Issue Type: Feature Request
> Components: Build/Kits
> Reporter: Tom Arnold
> Fix For: Open To Community
>
>
> Perform the server installation steps as part of the build and add the result to the downloads page. It seems like this is something that everyone who isn't using the embedded kit has to do anyways, and would hopefully eliminate confusion caused by people trying to deploy the runtime in unsupported versions of JBoss.
> * Teiid Runtime
> * Teiid Web Console
> * JBoss EAP 6.1 Alpha
> * Resteasy JAX-RS Patch
> End result would simplify the installation process to:
> 1. Unzip Teiid server.
> 2. Run `bin/add-user.sh` script.
> 3. Deploy custom translators, VDB, etc.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 3 months
[JBoss JIRA] (TEIID-3121) Teiid Standalone Server
by Tom Arnold (JIRA)
[ https://issues.jboss.org/browse/TEIID-3121?page=com.atlassian.jira.plugin... ]
Tom Arnold updated TEIID-3121:
------------------------------
Git Pull Request: https://github.com/teiid/teiid/pull/337
> Teiid Standalone Server
> -----------------------
>
> Key: TEIID-3121
> URL: https://issues.jboss.org/browse/TEIID-3121
> Project: Teiid
> Issue Type: Feature Request
> Components: Build/Kits
> Reporter: Tom Arnold
> Fix For: Open To Community
>
>
> Perform the server installation steps as part of the build and add the result to the downloads page. It seems like this is something that everyone who isn't using the embedded kit has to do anyways, and would hopefully eliminate confusion caused by people trying to deploy the runtime in unsupported versions of JBoss.
> * Teiid Runtime
> * Teiid Web Console
> * JBoss EAP 6.1 Alpha
> * Resteasy JAX-RS Patch
> End result would simplify the installation process to:
> 1. Unzip Teiid server.
> 2. Run `bin/add-user.sh` script.
> 3. Deploy custom translators, VDB, etc.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 3 months
[JBoss JIRA] (TEIID-3141) Bad result of query with GROUB BY clause (underlying sybase15 datasource)
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3141?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3141:
---------------------------------------
TEIID-3160 resolves the issue I was mentioned, which ensures that we won't inappropriately narrow.
> Bad result of query with GROUB BY clause (underlying sybase15 datasource)
> -------------------------------------------------------------------------
>
> Key: TEIID-3141
> URL: https://issues.jboss.org/browse/TEIID-3141
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1
> Environment: OS: fedora20
> arch: x86_64
> java: sun 1.7
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> Description:
> There is sybase15 database with table named SmallA and table named SmallA in VDB which is mapped to sybase table (see tables definition below).
> I am trying to run query against VDB:
> SELECT
> INTKEY, STRINGKEY, INTNUM, STRINGNUM, FLOATNUM, LONGNUM, DOUBLENUM, BYTENUM, DATEVALUE, TIMEVALUE, TIMESTAMPVALUE, BOOLEANVALUE, CHARVALUE, SHORTVALUE, BIGINTEGERVALUE, BIGDECIMALVALUE
> FROM
> BQT1.SMALLA
> GROUP BY
> INTKEY, STRINGKEY, INTNUM, STRINGNUM, FLOATNUM, LONGNUM, DOUBLENUM, BYTENUM, DATEVALUE, TIMEVALUE, TIMESTAMPVALUE, BOOLEANVALUE, CHARVALUE, SHORTVALUE, BIGINTEGERVALUE, BIGDECIMALVALUE
> Result is table which misses some values (the other values are OK):
> FloatNum: always 0
> ByteNum: always 0
> DateValue: always 1900-01-01
> TimeValue: always 00:00:00
> BooleanValue: always 'false'
> CharValue: always empty character
> ShortValue: always 0
> BigIntegerValue: always 0
> BigDecimalValue: always 0
> After removing 'INTKEY' and 'STRINGKEY' from the query is result OK (sybase15 has indices only for these two columns).
> ///////////////////
> Table definition
> ///////////////////
> SmallA (sybase) has these columns (name:type):
> IntKey:int -> PRIMARY KEY, HAS INDEX
> StringKey:varchar -> HAS INDEX
> IntNum:int
> StringNum:varchar
> FloatNum:float
> LongNum:numeric
> DoubleNum:float
> ByteNum:real
> DateValue:datetime
> TimeValue:datetime
> TimestampValue:datetime
> BooleanValue:tinyint
> CharValue:char
> ShortValue:numeric
> BigIntegerValue:numeric
> BigDecimalValue:numeric
> ObjectValue:text
> SmallA (VDB) has these columns (name:type):
> IntKey:integer
> StringKey:string
> IntNum:integer
> StringNum:string
> FloatNum:float
> LongNum:long
> DoubleNum:double
> ByteNum:byte
> DateValue:date
> TimeValue:time
> TimestampValue:timestamp
> BooleanValue:boolean
> CharValue:char
> ShortValue:short
> BigIntegerValue:biginteger
> BigDecimalValue:bigdecimal
> ObjectValue:object
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 3 months
[JBoss JIRA] (TEIID-3159) Rename sap-nw-gateway Translator
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3159?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3159.
-----------------------------------
Fix Version/s: 8.9
Resolution: Done
Renamed the sap-nw-gateway to sap-gateway and added a deprecated sap-nw-gateway. There's now a translator annotation property deprecated that is added to the property set to indicate that a given translator is no longer valid and what should be used instead.
> Rename sap-nw-gateway Translator
> --------------------------------
>
> Key: TEIID-3159
> URL: https://issues.jboss.org/browse/TEIID-3159
> Project: Teiid
> Issue Type: Quality Risk
> Components: Misc. Connectors
> Affects Versions: 8.8
> Reporter: Ted Jones
> Assignee: Steven Hawkins
> Fix For: 8.9
>
>
> SAP has dropped NetWeaver for the name of their OData server product. We should rename the translator to sap-gateway.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 3 months
[JBoss JIRA] (TEIID-3121) Teiid Standalone Server
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3121?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3121:
---------------------------------------
Can you create a pull request against master?
> Teiid Standalone Server
> -----------------------
>
> Key: TEIID-3121
> URL: https://issues.jboss.org/browse/TEIID-3121
> Project: Teiid
> Issue Type: Feature Request
> Components: Build/Kits
> Reporter: Tom Arnold
> Fix For: Open To Community
>
>
> Perform the server installation steps as part of the build and add the result to the downloads page. It seems like this is something that everyone who isn't using the embedded kit has to do anyways, and would hopefully eliminate confusion caused by people trying to deploy the runtime in unsupported versions of JBoss.
> * Teiid Runtime
> * Teiid Web Console
> * JBoss EAP 6.1 Alpha
> * Resteasy JAX-RS Patch
> End result would simplify the installation process to:
> 1. Unzip Teiid server.
> 2. Run `bin/add-user.sh` script.
> 3. Deploy custom translators, VDB, etc.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 3 months
[JBoss JIRA] (TEIID-3162) Class files checked into Git
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3162?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3162:
---------------------------------------
The commits looked quite old. Most would have come from svn from people using a none eclipse ide such that class files weren't built into a separate folder. We can double check that .gitignore is setup correctly though.
> Class files checked into Git
> ----------------------------
>
> Key: TEIID-3162
> URL: https://issues.jboss.org/browse/TEIID-3162
> Project: Teiid
> Issue Type: Bug
> Components: Common
> Reporter: Tom Arnold
> Assignee: Steven Hawkins
> Fix For: 8.9
>
>
> It looks like a large number of class files were accidentally checked into Git. This is generally considered bad practice. The files are in the salesforce-api and google-api modules.
> Can verify using the Github file search. https://github.com/teiid/teiid/find/master (type ".class", not sure how to link to it).
> Can do something like this to remove them:
> {code}
> find . -name '*.class' -exec git rm {} \;
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 3 months