RachelJones
7 years agoNew Contributor
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