[teiid-issues] [JBoss JIRA] (TEIID-3686) OData DELETE nonexisting row - wrong response code

[Johnathon Lee (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Johnathon Lee updated TEIID-3686:
---------------------------------
    Fix Version/s: 8.7.2.6_2


> OData DELETE nonexisting row - wrong response code
> --------------------------------------------------
>
>                 Key: TEIID-3686
>                 URL: https://issues.jboss.org/browse/TEIID-3686
>             Project: Teiid
>          Issue Type: Bug
>          Components: OData
>    Affects Versions: 8.7.1.6_2
>            Reporter: Michal Sanitrak
>            Assignee: Ramesh Reddy
>              Labels: CR1
>             Fix For: 8.12, 8.7.2.6_2
>
>
> I deployed VDB that can be accessed with OData. When I perform DELETE request to remove row for first time response code is 200 OK (maybe it should be 204) but when I repeat the same DELETE request and tried to delete already deleted entry, response is again 200 OK, but it should be 404 Not Found. Same thing happens even I when tried to delete entry with id that doesn't exist at all.
> Only indication of this problem is in the server log:
> {code:plain}INFO  [org.teiid.ODATA] (http-/127.0.0.1:8080-1) no entity to delete in =  BooksMySQL.BOOKS  with key= ('1')
> {code}
> I think that response code for deleting row that doesn't exist should be different than 200 OK.
> For example the service at odata.org returns following content with response code 404 Not Found:
> {code:xml}
> <?xml version="1.0" encoding="utf-8" standalone="yes"?>
> <error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
>     <code></code>
>     <message xml:lang="en-US">Resource not found for the segment 'Products'.</message>
> </error>
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)