Bug 1301540

Summary: Accumulo translator: select rowid returns empty resultset
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Jan Stastny <jstastny>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED CURRENTRELEASE QA Contact: Filip Elias <felias>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.3.0CC: aszczucz, blafond, jolee, mbaluch, thauser, vhalbert
Target Milestone: ER1   
Target Release: 6.3.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-08-24 11:39:15 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Jan Stastny 2016-01-25 10:52:13 UTC
Description of problem:
When running following query:
SELECT rowid FROM User;
against a foreign table like following:
CREATE FOREIGN TABLE "User" (

    rowid string OPTIONS (UPDATABLE FALSE, SEARCHABLE 'All_Except_Like'),

    name_age string OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'age', "teiid_accumulo:VALUE-IN" '{VALUE}'),

    name_firstname string OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'firstname', "teiid_accumulo:VALUE-IN" '{VALUE}'),

    name_lastname string OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_accumulo:CF" 'name', "teiid_accumulo:CQ" 'lastname', "teiid_accumulo:VALUE-IN" '{VALUE}'),

    CONSTRAINT PK0 PRIMARY KEY(rowid)

) OPTIONS (UPDATABLE TRUE);

An empty result-set is returned.
See linked JIRA.

Comment 1 JBoss JIRA Server 2016-01-29 16:43:35 UTC
Ramesh Reddy <rareddy> updated the status of jira TEIID-3930 to Coding In Progress

Comment 2 JBoss JIRA Server 2016-01-30 19:54:59 UTC
Ramesh Reddy <rareddy> updated the status of jira TEIID-3930 to Resolved