[jira] [Created] (METAMODEL-1203) GetColumns() listing other tables column for MS SQL DB

["Tej Kiran Sharma (JIRA)" <ji...@apache.org>]

Tej Kiran Sharma created METAMODEL-1203:
-------------------------------------------

             Summary: GetColumns() listing other tables column for MS SQL DB
                 Key: METAMODEL-1203
                 URL: https://issues.apache.org/jira/browse/METAMODEL-1203
             Project: Apache MetaModel
          Issue Type: Bug
    Affects Versions: 4.5.5
            Reporter: Tej Kiran Sharma


Hello, 

I  am using Apache Metamodel 4.5.5 version. Recently I was trying to extract MS SQL db into csv using it.

I have these two tables which are quite similar in name just difference of dot (.) and underscore (_) and its column name are different.
{code:java}
CREATE TABLE [dbo].[temp.table1](
[id] [nchar](10) NULL,
[nametemp] [nchar](10) NULL,
[sample] [nchar](10) NULL
) ON [PRIMARY]{code}
 
{code:java}
CREATE TABLE [dbo].[temp_table1](
[srno] [nchar](10) NULL,
[idea] [nchar](10) NULL,
[classified] [nchar](10) NULL
) ON [PRIMARY]{code}
 
When I try to extract these tables I got a issue that in JDBCStructuredObject.java class  getRows()

 
{code:java}
dataContext.query().from(table).as("ct").selectAll().toQuery();{code}
 

returns 
{code:java}
The query is SELECT ct."id", ct."nametemp", ct."sample", ct."srno", ct."idea", ct."classified" FROM dbo."temp_table1" ct{code}
Even the id, nametemp and sample fields are not belonging to temp_table1

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)