[JBoss JIRA] (TEIID-3177) Enforce SSL connections over ODBC when Encryption Mode is enabled
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3177?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-3177:
------------------------------------
According to Okuda and the PR's that he identified (which appear to be chaining the pg related classes), are they not related to fixing their ODBC issue?
> Enforce SSL connections over ODBC when Encryption Mode is enabled
> -----------------------------------------------------------------
>
> Key: TEIID-3177
> URL: https://issues.jboss.org/browse/TEIID-3177
> Project: Teiid
> Issue Type: Feature Request
> Components: ODBC
> Affects Versions: 8.8
> Reporter: Cristiano Nicolai
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 8.9
>
>
> When connecting via ODBC transport, even if the encryption mode is set to enabled is still possible to establish non ssl connections. This allows clients to connect via insecure method. We would like that the Teiid transport could reject connections if they are not properly set up using SSL transport.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 11 months
[JBoss JIRA] (TEIID-3281) MongoDB: EmptyStackException when joining tables
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3281?page=com.atlassian.jira.plugin... ]
Ramesh Reddy updated TEIID-3281:
--------------------------------
Fix Version/s: 8.10
> MongoDB: EmptyStackException when joining tables
> ------------------------------------------------
>
> Key: TEIID-3281
> URL: https://issues.jboss.org/browse/TEIID-3281
> Project: Teiid
> Issue Type: Bug
> Components: Connector API
> Affects Versions: 8.7
> Reporter: Filip Elias
> Assignee: Ramesh Reddy
> Fix For: 8.10
>
> Attachments: mongodb-vdb.xml, server.log
>
>
> Teiid throws java.util.EmptyStackException when joining data from table which has teiid_mongo:MERGE property enabled.
> Example:
> {code}
> insert into customer2 values(1,'Pepa', 'Koukal');
> insert into customer2 values(2,'Jan', 'Tlemil');
> insert into Address values(1,1,'Pepas Street','Pepas City','Pepas State', 'Pepas zipcode');
> insert into Address values(2,2,'Jans Street','Pepa','Jans State', 'Jans zipcode');
> {code}
> {code}
> select a.*,b.* from customer2 a inner join Address b on a.CustomerId=b.CustomerId order by a.customerID
> {code}
> {code}
> Error:
> java.util.EmptyStackException
> at java.util.Stack.peek(Stack.java:102)
> at java.util.Stack.pop(Stack.java:84)
> at org.teiid.translator.mongodb.MongoDBSelectVisitor.visit(MongoDBSelectVisitor.java:993)
> at org.teiid.language.SortSpecification.acceptVisitor(SortSpecification.java:53)
> at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51)
> at org.teiid.translator.mongodb.MongoDBSelectVisitor.append(MongoDBSelectVisitor.java:112)
> {code}
> VDB and log are in the attachment.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 11 months
[JBoss JIRA] (TEIID-3282) inconsistencies with the week function
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3282?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3282:
---------------------------------------
dayofweek is similarly affected.
h2 has undocumented iso_week and iso_day_of_week functions that can be used.
> inconsistencies with the week function
> --------------------------------------
>
> Key: TEIID-3282
> URL: https://issues.jboss.org/browse/TEIID-3282
> Project: Teiid
> Issue Type: Sub-task
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.10
>
>
> For consistency we could enforce a standard iso behavior for the week function by default.
> For mysql there is the weekofyear function that matches the iso behavior.
> hsql uses iso by default
> oracle should use iw, not ww
> However:
> h2 uses the locale (the current teiid behavior)
> sqlserver/sybase you can use SET DATEFIRST to move the first day of the week to monday, but the return values are still not fully iso.
> And there are still several others to verify
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 11 months
[JBoss JIRA] (TEIID-3282) inconsistencies with the week function
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3282?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3282:
----------------------------------
Description:
For consistency we could enforce a standard iso behavior for the week function by default.
For mysql there is the weekofyear function that matches the iso behavior.
hsql uses iso by default
oracle should use iw, not ww
However:
h2 uses the locale (the current teiid behavior)
sqlserver/sybase you can use SET DATEFIRST to move the first day of the week to monday, but the return values are still not fully iso.
And there are still several others to verify
was:
For consistency we could enforce a standard iso behavior for the week function by default.
For mysql there is the weekofyear function that matches the iso behavior.
hsql uses iso by default
oracle should use iw, not ww
However:
h2 uses the locale (the current teiid behavior)
sqlserver/sybase you can use SET DATEFIRST to move the first day of the week to monday, but the return values are still not fully iso. So by default
And there are still several others to verify
> inconsistencies with the week function
> --------------------------------------
>
> Key: TEIID-3282
> URL: https://issues.jboss.org/browse/TEIID-3282
> Project: Teiid
> Issue Type: Sub-task
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.10
>
>
> For consistency we could enforce a standard iso behavior for the week function by default.
> For mysql there is the weekofyear function that matches the iso behavior.
> hsql uses iso by default
> oracle should use iw, not ww
> However:
> h2 uses the locale (the current teiid behavior)
> sqlserver/sybase you can use SET DATEFIRST to move the first day of the week to monday, but the return values are still not fully iso.
> And there are still several others to verify
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 11 months
[JBoss JIRA] (TEIID-3282) inconsistencies with the week function
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3282:
-------------------------------------
Summary: inconsistencies with the week function
Key: TEIID-3282
URL: https://issues.jboss.org/browse/TEIID-3282
Project: Teiid
Issue Type: Sub-task
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.10
For consistency we could enforce a standard iso behavior for the week function by default.
For mysql there is the weekofyear function that matches the iso behavior.
hsql uses iso by default
oracle should use iw, not ww
However:
h2 uses the locale (the current teiid behavior)
sqlserver/sybase you can use SET DATEFIRST to move the first day of the week to monday, but the return values are still not fully iso. So by default
And there are still several others to verify
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 11 months
[JBoss JIRA] (TEIID-3281) MongoDB: EmptyStackException when joining tables
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3281?page=com.atlassian.jira.plugin... ]
Ramesh Reddy reassigned TEIID-3281:
-----------------------------------
Assignee: Ramesh Reddy (was: Steven Hawkins)
> MongoDB: EmptyStackException when joining tables
> ------------------------------------------------
>
> Key: TEIID-3281
> URL: https://issues.jboss.org/browse/TEIID-3281
> Project: Teiid
> Issue Type: Bug
> Components: Connector API
> Affects Versions: 8.7
> Reporter: Filip Elias
> Assignee: Ramesh Reddy
> Attachments: mongodb-vdb.xml, server.log
>
>
> Teiid throws java.util.EmptyStackException when joining data from table which has teiid_mongo:MERGE property enabled.
> Example:
> {code}
> insert into customer2 values(1,'Pepa', 'Koukal');
> insert into customer2 values(2,'Jan', 'Tlemil');
> insert into Address values(1,1,'Pepas Street','Pepas City','Pepas State', 'Pepas zipcode');
> insert into Address values(2,2,'Jans Street','Pepa','Jans State', 'Jans zipcode');
> {code}
> {code}
> select a.*,b.* from customer2 a inner join Address b on a.CustomerId=b.CustomerId order by a.customerID
> {code}
> {code}
> Error:
> java.util.EmptyStackException
> at java.util.Stack.peek(Stack.java:102)
> at java.util.Stack.pop(Stack.java:84)
> at org.teiid.translator.mongodb.MongoDBSelectVisitor.visit(MongoDBSelectVisitor.java:993)
> at org.teiid.language.SortSpecification.acceptVisitor(SortSpecification.java:53)
> at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51)
> at org.teiid.translator.mongodb.MongoDBSelectVisitor.append(MongoDBSelectVisitor.java:112)
> {code}
> VDB and log are in the attachment.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 11 months
[JBoss JIRA] (TEIID-3281) MongoDB: EmptyStackException when joining tables
by Filip Elias (JIRA)
[ https://issues.jboss.org/browse/TEIID-3281?page=com.atlassian.jira.plugin... ]
Filip Elias updated TEIID-3281:
-------------------------------
Attachment: mongodb-vdb.xml
VDB
> MongoDB: EmptyStackException when joining tables
> ------------------------------------------------
>
> Key: TEIID-3281
> URL: https://issues.jboss.org/browse/TEIID-3281
> Project: Teiid
> Issue Type: Bug
> Components: Connector API
> Affects Versions: 8.7
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Attachments: mongodb-vdb.xml, server.log
>
>
> Teiid throws java.util.EmptyStackException when joining data from table which has teiid_mongo:MERGE property enabled.
> Example:
> {code}
> insert into customer2 values(1,'Pepa', 'Koukal');
> insert into customer2 values(2,'Jan', 'Tlemil');
> insert into Address values(1,1,'Pepas Street','Pepas City','Pepas State', 'Pepas zipcode');
> insert into Address values(2,2,'Jans Street','Pepa','Jans State', 'Jans zipcode');
> {code}
> {code}
> select a.*,b.* from customer2 a inner join Address b on a.CustomerId=b.CustomerId order by a.customerID
> {code}
> {code}
> Error:
> java.util.EmptyStackException
> at java.util.Stack.peek(Stack.java:102)
> at java.util.Stack.pop(Stack.java:84)
> at org.teiid.translator.mongodb.MongoDBSelectVisitor.visit(MongoDBSelectVisitor.java:993)
> at org.teiid.language.SortSpecification.acceptVisitor(SortSpecification.java:53)
> at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51)
> at org.teiid.translator.mongodb.MongoDBSelectVisitor.append(MongoDBSelectVisitor.java:112)
> {code}
> VDB and log are in the attachment.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 11 months
[JBoss JIRA] (TEIID-3281) MongoDB: EmptyStackException when joining tables
by Filip Elias (JIRA)
[ https://issues.jboss.org/browse/TEIID-3281?page=com.atlassian.jira.plugin... ]
Filip Elias updated TEIID-3281:
-------------------------------
Attachment: server.log
Server log.
> MongoDB: EmptyStackException when joining tables
> ------------------------------------------------
>
> Key: TEIID-3281
> URL: https://issues.jboss.org/browse/TEIID-3281
> Project: Teiid
> Issue Type: Bug
> Components: Connector API
> Affects Versions: 8.7
> Reporter: Filip Elias
> Assignee: Steven Hawkins
> Attachments: server.log
>
>
> Teiid throws java.util.EmptyStackException when joining data from table which has teiid_mongo:MERGE property enabled.
> Example:
> {code}
> insert into customer2 values(1,'Pepa', 'Koukal');
> insert into customer2 values(2,'Jan', 'Tlemil');
> insert into Address values(1,1,'Pepas Street','Pepas City','Pepas State', 'Pepas zipcode');
> insert into Address values(2,2,'Jans Street','Pepa','Jans State', 'Jans zipcode');
> {code}
> {code}
> select a.*,b.* from customer2 a inner join Address b on a.CustomerId=b.CustomerId order by a.customerID
> {code}
> {code}
> Error:
> java.util.EmptyStackException
> at java.util.Stack.peek(Stack.java:102)
> at java.util.Stack.pop(Stack.java:84)
> at org.teiid.translator.mongodb.MongoDBSelectVisitor.visit(MongoDBSelectVisitor.java:993)
> at org.teiid.language.SortSpecification.acceptVisitor(SortSpecification.java:53)
> at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51)
> at org.teiid.translator.mongodb.MongoDBSelectVisitor.append(MongoDBSelectVisitor.java:112)
> {code}
> VDB and log are in the attachment.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 11 months
[JBoss JIRA] (TEIID-3281) MongoDB: EmptyStackException when joining tables
by Filip Elias (JIRA)
Filip Elias created TEIID-3281:
----------------------------------
Summary: MongoDB: EmptyStackException when joining tables
Key: TEIID-3281
URL: https://issues.jboss.org/browse/TEIID-3281
Project: Teiid
Issue Type: Bug
Components: Connector API
Affects Versions: 8.7
Reporter: Filip Elias
Assignee: Steven Hawkins
Teiid throws java.util.EmptyStackException when joining data from table which has teiid_mongo:MERGE property enabled.
Example:
{code}
insert into customer2 values(1,'Pepa', 'Koukal');
insert into customer2 values(2,'Jan', 'Tlemil');
insert into Address values(1,1,'Pepas Street','Pepas City','Pepas State', 'Pepas zipcode');
insert into Address values(2,2,'Jans Street','Pepa','Jans State', 'Jans zipcode');
{code}
{code}
select a.*,b.* from customer2 a inner join Address b on a.CustomerId=b.CustomerId order by a.customerID
{code}
{code}
Error:
java.util.EmptyStackException
at java.util.Stack.peek(Stack.java:102)
at java.util.Stack.pop(Stack.java:84)
at org.teiid.translator.mongodb.MongoDBSelectVisitor.visit(MongoDBSelectVisitor.java:993)
at org.teiid.language.SortSpecification.acceptVisitor(SortSpecification.java:53)
at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51)
at org.teiid.translator.mongodb.MongoDBSelectVisitor.append(MongoDBSelectVisitor.java:112)
{code}
VDB and log are in the attachment.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 11 months