September 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5075) Couchbase incorrect update count returned

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5075?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5075: --------------------------------------- > update row count is 1 even though all 4 rows are inserted correctly into database. There is an issue with the contract of the ExecutionFactory. It needs to advertise returnsSingleUpdateCount true as it only returns a single update count even in a batch scenario. > returned 'deleted number of rows' is 0, though the row was deleted from database. The translator is looking in the wrong spot for that information. The allRows result is empty for deletes, but it looks like there is a mutation count in the metrics that matches what we need. > Couchbase incorrect update count returned > ----------------------------------------- > > Key: TEIID-5075 > URL: https://issues.jboss.org/browse/TEIID-5075 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.x-6.4 > Reporter: Jan Stastny > Assignee: Steven Hawkins > > # For a bulk insert query: > {code:sql} > INSERT INTO SmallA (IntKey, StringKey) VALUES (100, '100'),(101, '101'),(102, '102'),(103, '103') > {code} > update row count is 1 even though all 4 rows are inserted correctly into database. > # For a delete query: > {code:sql} > DELETE FROM SmallA WHERE StringKey=101; > {code} > returned 'deleted number of rows' is 0, though the row was deleted from database. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5075) Couchbase incorrect update count returned

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5075?page=com.atlassian.jira.plugin... ] Work on TEIID-5075 started by Steven Hawkins. --------------------------------------------- > Couchbase incorrect update count returned > ----------------------------------------- > > Key: TEIID-5075 > URL: https://issues.jboss.org/browse/TEIID-5075 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.x-6.4 > Reporter: Jan Stastny > Assignee: Steven Hawkins > > # For a bulk insert query: > {code:sql} > INSERT INTO SmallA (IntKey, StringKey) VALUES (100, '100'),(101, '101'),(102, '102'),(103, '103') > {code} > update row count is 1 even though all 4 rows are inserted correctly into database. > # For a delete query: > {code:sql} > DELETE FROM SmallA WHERE StringKey=101; > {code} > returned 'deleted number of rows' is 0, though the row was deleted from database. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5076) Couchbase update syntax error

by Jan Stastny (JIRA)

Jan Stastny created TEIID-5076: ---------------------------------- Summary: Couchbase update syntax error Key: TEIID-5076 URL: https://issues.jboss.org/browse/TEIID-5076 Project: Teiid Issue Type: Bug Components: Misc. Connectors Reporter: Jan Stastny Assignee: Steven Hawkins Priority: Blocker There is an issue with UPDATE queries. For a query: {code:sql} UPDATE SmallA SET StringNum = NULL WHERE IntNum > 0 {code} following error is returned: {code} Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: Query did not complete successfully: [{"msg":"syntax error - at (","code":3000}], error code: fatal {code} The query being pushed is invalid: {code:sql} UPDATE `dvqe_crud` USE KEYS '1' SET META(`dvqe_crud`).id = '1', `StringKey` = '1', `IntNum` = 1417293, `StringNum` = NULL, `FloatNum` = 14735.7998046875, `LongN um` = 826580, `DoubleNum` = -1098869.04, `ByteNum` = 15, `DateValue` = '2006-03-06', `TimeValue` = '10:57:23', `TimestampValue` = NULL, `BooleanValue` = TRUE, `CharValue` = '2', `ShortValue` = 5303, `BigIn tegerValue` = 608932, `BigDecimalValue` = 1229956.01, `ObjectValue` = '-70' WHERE `dvqe_crud`.`type` = 'nullSmallA' RETURNING META(`dvqe_crud`).id AS PK {code} Couchbase complains about a '('. And from what I found, it is the first use of META() function in the command. On that topic I've found a note in Couchbase docs: bq. Every document is identified by a document ID, which can be automatically generated (as a UUID) or determined by the application; the only constraints are that it must be unique within the database, and it can't be changed. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5074) Support a way provide SEQUENCE in TeiidDialect

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5074?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5074: --------------------------------------- > I updated the code to return an expression and updated the document to create the function as non-deterministic. Actually the dialect change that was just committed is incorrect. The call needs to be nested in parens to be a valid scalar subquery. Taking a step back, if we could just use a function you'd ideally use a convention like: {code} @Override public String getSequenceNextValString(String sequenceName) { return "select " + getSelectSequenceNextValString( sequenceName ); } @Override public String getSelectSequenceNextValString(String sequenceName) { return sequenceName + "_nextval()"; } {code} Such that with an import option turned on for oracle/postgresql/etc., we'd automatically create the functions sequence_nextval and sequence_curval. Note that using the _nextval convention matches the other places in our docs where we mention sequence support. A small issue is that in the SequenceGenerator annotation it would be best to have the name fully qualified. > Support a way provide SEQUENCE in TeiidDialect > ---------------------------------------------- > > Key: TEIID-5074 > URL: https://issues.jboss.org/browse/TEIID-5074 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Driver > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 10.0 > > > Currently, the sequence based Table identity generation support is not available in current TeiidDialect. The support will not be direct, but with additional constructs in VDB, we can make this available. Teiid needs to provide a way to call in source specific of way to insert a layer in Teiid to accomplish this. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4896) Two VDB's referencing same teiid_ispn:cache is not using the same cache

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4896?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4896: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1492809|https://bugzilla.redhat.com/show_bug.cgi?id=1492809] from NEW to MODIFIED > Two VDB's referencing same teiid_ispn:cache is not using the same cache > ----------------------------------------------------------------------- > > Key: TEIID-4896 > URL: https://issues.jboss.org/browse/TEIID-4896 > Project: Teiid > Issue Type: Bug > Components: Infinispan > Affects Versions: 9.3 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Fix For: 10.0, 8.12.x-6.4, 9.3.1 > > Attachments: jdg-remote-cache-ddl-vdb.xml, jdg-remote-cache-registered-pb-vdb.xml > > > I have 2 VDB's where they both reference the same cache using OPTIONS property: > "teiid_ispn:cache" 'datasourceCache' > However, when I insert into one VDB, its not seen by the other VDB. > This was testing out the translators ability to use an already registered protobuf in Infinispan. > The first VDB (jdg-remote-cache-vdb.xml) was deployed and then inserted and selected the results. This registered the protobuf. > The second VDB (jdg-remote-cache-registered-pb-vdb.xml) was then deployed and was expecting to be able to read the same cache. The metadata was derived correctly, but it appears that one of the two are using the default cache, not the specified cache. > I'll attach the vdb's. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5074) Support a way provide SEQUENCE in TeiidDialect

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-5074?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-5074: ------------------------------------- Thanks [~shawkins]. I updated the code to return an expression and updated the document to create the function as non-deterministic. > Support a way provide SEQUENCE in TeiidDialect > ---------------------------------------------- > > Key: TEIID-5074 > URL: https://issues.jboss.org/browse/TEIID-5074 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Driver > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 10.0 > > > Currently, the sequence based Table identity generation support is not available in current TeiidDialect. The support will not be direct, but with additional constructs in VDB, we can make this available. Teiid needs to provide a way to call in source specific of way to insert a layer in Teiid to accomplish this. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4812) Processor is not exiting the join as soon as it's determined one side contains 0 rows

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4812?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4812: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1492825|https://bugzilla.redhat.com/show_bug.cgi?id=1492825] from MODIFIED to CLOSED > Processor is not exiting the join as soon as it's determined one side contains 0 rows > ------------------------------------------------------------------------------------- > > Key: TEIID-4812 > URL: https://issues.jboss.org/browse/TEIID-4812 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.12.8.6_3, 8.7.11.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.3, 8.12.10.6_3, 8.12.x-6.4, 9.2.2 > > > There is an issue with the processor during a join, it doesn't exit the join as soon as it's determined that one side of the join returns 0 rows. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5075) Couchbase incorrect update count returned

by Jan Stastny (JIRA)

[ https://issues.jboss.org/browse/TEIID-5075?page=com.atlassian.jira.plugin... ] Jan Stastny updated TEIID-5075: ------------------------------- Description: # For a bulk insert query: {code:sql} INSERT INTO SmallA (IntKey, StringKey) VALUES (100, '100'),(101, '101'),(102, '102'),(103, '103') {code} update row count is 1 even though all 4 rows are inserted correctly into database. # For a delete query: {code:sql} DELETE FROM SmallA WHERE StringKey=101; {code} returned 'deleted number of rows' is 0, though the row was deleted from database. was: For a bulk insert query: {code:sql} INSERT INTO SmallA (IntKey, StringKey) VALUES (100, '100'),(101, '101'),(102, '102'),(103, '103') {code} update row count is 1 even though all 4 rows are inserted correctly into database. > Couchbase incorrect update count returned > ----------------------------------------- > > Key: TEIID-5075 > URL: https://issues.jboss.org/browse/TEIID-5075 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.x-6.4 > Reporter: Jan Stastny > Assignee: Steven Hawkins > > # For a bulk insert query: > {code:sql} > INSERT INTO SmallA (IntKey, StringKey) VALUES (100, '100'),(101, '101'),(102, '102'),(103, '103') > {code} > update row count is 1 even though all 4 rows are inserted correctly into database. > # For a delete query: > {code:sql} > DELETE FROM SmallA WHERE StringKey=101; > {code} > returned 'deleted number of rows' is 0, though the row was deleted from database. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5075) Couchbase incorrect update count returned

by Jan Stastny (JIRA)

Jan Stastny created TEIID-5075: ---------------------------------- Summary: Couchbase incorrect update count returned Key: TEIID-5075 URL: https://issues.jboss.org/browse/TEIID-5075 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.x-6.4 Reporter: Jan Stastny Assignee: Steven Hawkins For a bulk insert query: {code:sql} INSERT INTO SmallA (IntKey, StringKey) VALUES (100, '100'),(101, '101'),(102, '102'),(103, '103') {code} update row count is 1 even though all 4 rows are inserted correctly into database. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4543) Rewrite parse/format of standard formats to cast instead

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4543?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4543. ----------------------------------- Resolution: Done See also TEIID-4667 > Rewrite parse/format of standard formats to cast instead > -------------------------------------------------------- > > Key: TEIID-4543 > URL: https://issues.jboss.org/browse/TEIID-4543 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12.x-6.4, 8.7.11.6_2, 8.12.9.6_3, 9.2 > > > Since parse/format functions have limited pushdown support, it would be better to treat the standard formats as casts instead. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2017