Forum Discussion

RachelJones's avatar
RachelJones
New Contributor
7 years ago

PostgreSQL not able to remove tableName appended to columnName in ReadyAPI2.2

If my query "Select Tablename.ID AS VALUE, 'ID' AS key From Schema.TableName Where Schema.Tablename.location = '${#TestCase#Doc}'

runs in Oracle it gives me resultset as 

<Results>
<ResultSet fetchSize="0">
<Row rowNumber="1">
<.VALUE>5955</.VALUE>
<KEY>ID</KEY>
</Row>
</ResultSet>
</Results>

 

 

but when it runs on PostgreSql it gives me 

<Results>
<ResultSet fetchSize="0">
<Row rowNumber="1">
<Tablename.VALUE>5955</Tablename.VALUE>
<KEY>ImageID</KEY>
</Row>
</ResultSet>
</Results>.

 

Can anyone comment on this or the possible solution