Base URLhttp://0.0.0.0:40075Spechttp://0.0.0.0:40075/Commandstrunhttp://0.0.0.0:40075/--urlhttp://0.0.0.0:40075--report-html-pathschemathesis-report--max-time3600--request-timeout30--continue-on-failure--no-shrink--suppress-health-checkall--output-sanitizefalseSeed225073416969193757854793334258406456243Phases
{"code":"PGRST100","details":"unexpected end of input expecting field name (* or [a..z0..9_$])","hint":null,"message":"\"failed to parse order ()\" (line 1, column 1)"}
null is not of type "string"
Validated against the response schema for status code 200.
Schema at /definitions/authors/properties/website:
{
"type": "string",
"format": "text"
}
Value:
null
Response200 OK
[{"id":1,"name":"Ursula K. Le Guin","born":"1929-10-21","country":"US","website":null},
{"id":2,"name":"Stanislaw Lem","born":"1921-09-12","country":"PL","website":null},
{"id":0,"name":"{}","born":"2000-01-01","country":" ","website":""}]
Expected 401 or 403, got `200 OK` for `GET /authors`
Response200 OK
[{"id":1,"name":"Ursula K. Le Guin","born":"1929-10-21","country":"US","website":null},
{"id":2,"name":"Stanislaw Lem","born":"1921-09-12","country":"PL","website":null},
{"id":0,"name":"{}","born":"2000-01-01","country":" ","website":""}]
Got 400 when missing required 'Authorization' header, expected 401
Response400 Bad Request
{"code":"PGRST100","details":"unexpected end of input expecting field name (* or [a..z0..9_$])","hint":null,"message":"\"failed to parse order ()\" (line 1, column 1)"}
null is not of type "string"
Validated against the response schema for status code 200.
Schema at /definitions/authors/properties/country:
{
"type": "string",
"format": "character",
"maxLength": 2
}
Value:
null
Response200 OK
[{"id":1,"name":"Ursula K. Le Guin","born":"1929-10-21","country":"US","website":null},
{"id":2,"name":"Stanislaw Lem","born":"1921-09-12","country":"PL","website":null},
{"id":0,"name":"{}","born":"2000-01-01","country":" ","website":""},
{"id":-9223372036854775808,"name":"𝓶¾`óN","born":"3573-01-13","country":null,"website":"¶á鸏Û𡀉@"},
{"id":4,"name":"𝓶¾`óN","born":"3573-01-13","country":null,"website":"¶á鸏Û𡀉@"},
{"id":5,"name":"𝓶¾`óN","born":"3573-01-13","country":null,"website":" // Output truncated...
Reproduce
curl -X GET -H 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJyb2xlIjoid2ViX3VzZXIifQ.hwWsbWFXukM_f0EnNbV2jijiVqWickzT75Eeg5GvLuM' http://0.0.0.0:40075/authors
null is not of type "string"
Validated against the response schema for status code 200.
Schema at /definitions/authors/properties/born:
{
"type": "string",
"format": "date"
}
Value:
null
{"code":"PGRST100","details":"unexpected end of input expecting field name (* or [a..z0..9_$])","hint":null,"message":"\"failed to parse order ()\" (line 1, column 1)"}
null is not of type "string"
Validated against the response schema for status code 200.
Schema at /definitions/books/properties/published_at:
{
"type": "string",
"format": "timestamp with time zone"
}
Value:
null
Got 400 when missing required 'Authorization' header, expected 401
Response400 Bad Request
{"code":"PGRST100","details":"unexpected end of input expecting field name (* or [a..z0..9_$])","hint":null,"message":"\"failed to parse order ()\" (line 1, column 1)"}
null is not of type "integer"
Validated against the response schema for status code 200.
Schema at /definitions/books/properties/pages:
{
"type": "integer",
"format": "int32"
}
Value:
null
null is not of type "number"
Validated against the response schema for status code 200.
Schema at /definitions/books/properties/price:
{
"type": "number",
"format": "numeric"
}
Value:
null
null is not of type "string"
Validated against the response schema for status code 200.
Schema at /definitions/books/properties/isbn:
{
"type": "string",
"format": "text"
}
Value:
null
{"code":"PGRST100","details":"unexpected end of input expecting field name (* or [a..z0..9_$])","hint":null,"message":"\"failed to parse order ()\" (line 1, column 1)"}
Expected 401 or 403, got `200 OK` for `GET /books_with_authors`
Response200 OK
[{"id":1,"title":"The Dispossessed","genre":"fiction","price":9.99,"author":"Ursula K. Le Guin"},
{"id":2,"title":"Solaris","genre":"science","price":12.50,"author":"Stanislaw Lem"}]
Got 400 when missing required 'Authorization' header, expected 401
Response400 Bad Request
{"code":"PGRST100","details":"unexpected end of input expecting field name (* or [a..z0..9_$])","hint":null,"message":"\"failed to parse order ()\" (line 1, column 1)"}
Invalid data should have been rejected
Expected: 400, 401, 403, 404, 405, 406, 409, 415, 422, 428, 429, 5xx
Invalid component: parameter `Authorization` in header - violates `required` (was Authorization)
Response200 OK
[{"id":1,"title":"The Dispossessed","genre":"fiction","price":9.99,"author":"Ursula K. Le Guin"},
{"id":2,"title":"Solaris","genre":"science","price":12.50,"author":"Stanislaw Lem"}]
Reproduce
curl -X GET http://0.0.0.0:40075/books_with_authors
null is not of type "number"
Validated against the response schema for status code 200.
Schema at /definitions/books_with_authors/properties/price:
{
"type": "number",
"format": "numeric"
}
Value:
null
{"code":"PGRST100","details":"unexpected end of input expecting field name (* or [a..z0..9_$])","hint":null,"message":"\"failed to parse order ()\" (line 1, column 1)"}
Got 400 when missing required 'Authorization' header, expected 401
Response400 Bad Request
{"code":"PGRST100","details":"unexpected end of input expecting field name (* or [a..z0..9_$])","hint":null,"message":"\"failed to parse order ()\" (line 1, column 1)"}
{"code":"PGRST100","details":"unexpected end of input expecting field name (* or [a..z0..9_$])","hint":null,"message":"\"failed to parse order ()\" (line 1, column 1)"}
Got 400 when missing required 'Authorization' header, expected 401
Response400 Bad Request
{"code":"PGRST100","details":"unexpected end of input expecting field name (* or [a..z0..9_$])","hint":null,"message":"\"failed to parse order ()\" (line 1, column 1)"}
{"code":"PGRST100","details":"unexpected end of input expecting field name (* or [a..z0..9_$])","hint":null,"message":"\"failed to parse order ()\" (line 1, column 1)"}
Got 400 when missing required 'Authorization' header, expected 401
Response400 Bad Request
{"code":"PGRST100","details":"unexpected end of input expecting field name (* or [a..z0..9_$])","hint":null,"message":"\"failed to parse order ()\" (line 1, column 1)"}
{"code":"PGRST202","details":"Searched for the function api.author_stats without parameters or with a single unnamed json/jsonb parameter, but no matches were found in the schema cache.","hint":null,"message":"Could not find the function api.author_stats without parameters in the schema cache"}
Reproduce
curl -X POST -H 'Prefer;' -H 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJyb2xlIjoid2ViX3VzZXIifQ.hwWsbWFXukM_f0EnNbV2jijiVqWickzT75Eeg5GvLuM' http://0.0.0.0:40075/rpc/author_stats
Invalid data should have been rejected
Expected: 400, 401, 403, 404, 405, 406, 409, 415, 422, 428, 429, 5xx
Invalid component: Missing `Authorization` at header
{"code":"PGRST202","details":"Searched for the function api.search_books without parameters or with a single unnamed json/jsonb parameter, but no matches were found in the schema cache.","hint":null,"message":"Could not find the function api.search_books without parameters in the schema cache"}
Reproduce
curl -X POST -H 'Prefer;' -H 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJyb2xlIjoid2ViX3VzZXIifQ.hwWsbWFXukM_f0EnNbV2jijiVqWickzT75Eeg5GvLuM' http://0.0.0.0:40075/rpc/search_books
Invalid data should have been rejected
Expected: 400, 401, 403, 404, 405, 406, 409, 415, 422, 428, 429, 5xx
Invalid component: Missing `Authorization` at header
{"code":"PGRST202","details":"Searched for the function api.author_stats without parameters, but no matches were found in the schema cache.","hint":null,"message":"Could not find the function api.author_stats without parameters in the schema cache"}
Reproduce
curl -X GET -H 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJyb2xlIjoid2ViX3VzZXIifQ.hwWsbWFXukM_f0EnNbV2jijiVqWickzT75Eeg5GvLuM' http://0.0.0.0:40075/rpc/author_stats
Invalid data should have been rejected
Expected: 400, 401, 403, 404, 405, 406, 409, 415, 422, 428, 429, 5xx
Invalid component: Missing `Authorization` at header
{"code":"PGRST202","details":"Searched for the function api.search_books with parameter max_price, but no matches were found in the schema cache.","hint":"Perhaps you meant to call the function api.search_books(max_price, query)","message":"Could not find the function api.search_books(max_price) in the schema cache"}
Reproduce
curl -X GET -H 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJyb2xlIjoid2ViX3VzZXIifQ.hwWsbWFXukM_f0EnNbV2jijiVqWickzT75Eeg5GvLuM' 'http://0.0.0.0:40075/rpc/search_books?max_price=0'
Invalid data should have been rejected
Expected: 400, 401, 403, 404, 405, 406, 409, 415, 422, 428, 429, 5xx
Invalid component: Missing `Authorization` at header
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
Got 400 when missing required 'Authorization' header, expected 401
Response400 Bad Request
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
The following media types are documented in the schema:
- `application/json`
- `application/vnd.pgrst.object+json;nulls=stripped`
- `application/vnd.pgrst.object+json`
- `text/csv`
Invalid data should have been rejected
Expected: 400, 401, 403, 404, 405, 406, 409, 415, 422, 428, 429, 5xx
Invalid component: parameter `Prefer` in header - violates `enum` at /properties/Prefer
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
Got 400 when missing required 'Authorization' header, expected 401
Response400 Bad Request
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
The following media types are documented in the schema:
- `application/json`
- `application/vnd.pgrst.object+json;nulls=stripped`
- `application/vnd.pgrst.object+json`
- `text/csv`
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
Got 400 when missing required 'Authorization' header, expected 401
Response400 Bad Request
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
The following media types are documented in the schema:
- `application/json`
- `application/vnd.pgrst.object+json;nulls=stripped`
- `application/vnd.pgrst.object+json`
- `text/csv`
Invalid data should have been rejected
Expected: 400, 401, 403, 404, 405, 406, 409, 415, 422, 428, 429, 5xx
Invalid component: parameter `Prefer` in header - violates `enum` at /properties/Prefer
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
Got 400 when missing required 'Authorization' header, expected 401
Response400 Bad Request
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
The following media types are documented in the schema:
- `application/json`
- `application/vnd.pgrst.object+json;nulls=stripped`
- `application/vnd.pgrst.object+json`
- `text/csv`
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
Got 400 when missing required 'Authorization' header, expected 401
Response400 Bad Request
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
The following media types are documented in the schema:
- `application/json`
- `application/vnd.pgrst.object+json;nulls=stripped`
- `application/vnd.pgrst.object+json`
- `text/csv`
Invalid data should have been rejected
Expected: 400, 401, 403, 404, 405, 406, 409, 415, 422, 428, 429, 5xx
Invalid component: parameter `Prefer` in header - violates `enum` at /properties/Prefer
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
Got 400 when missing required 'Authorization' header, expected 401
Response400 Bad Request
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
The following media types are documented in the schema:
- `application/json`
- `application/vnd.pgrst.object+json;nulls=stripped`
- `application/vnd.pgrst.object+json`
- `text/csv`
Invalid data should have been rejected
Expected: 400, 401, 403, 404, 405, 406, 409, 415, 422, 428, 429, 5xx
Invalid component: parameter `Prefer` in header - violates `enum` at /properties/Prefer
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
Got 400 when missing required 'Authorization' header, expected 401
Response400 Bad Request
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
The following media types are documented in the schema:
- `application/json`
- `application/vnd.pgrst.object+json;nulls=stripped`
- `application/vnd.pgrst.object+json`
- `text/csv`
Invalid data should have been rejected
Expected: 400, 401, 403, 404, 405, 406, 409, 415, 422, 428, 429, 5xx
Invalid component: parameter `Prefer` in header - violates `enum` at /properties/Prefer
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
Got 400 when missing required 'Authorization' header, expected 401
Response400 Bad Request
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
The following media types are documented in the schema:
- `application/json`
- `application/vnd.pgrst.object+json;nulls=stripped`
- `application/vnd.pgrst.object+json`
- `text/csv`
Response204 No Content
<EMPTY>
Reproduce
GET/loans
curl -X GET -H 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJyb2xlIjoid2ViX3VzZXIifQ.hwWsbWFXukM_f0EnNbV2jijiVqWickzT75Eeg5GvLuM' http://0.0.0.0:40075/loans
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
Got 400 when missing required 'Authorization' header, expected 401
Response400 Bad Request
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
The following media types are documented in the schema:
- `application/json`
- `application/vnd.pgrst.object+json;nulls=stripped`
- `application/vnd.pgrst.object+json`
- `text/csv`
Invalid data should have been rejected
Expected: 400, 401, 403, 404, 405, 406, 409, 415, 422, 428, 429, 5xx
Invalid component: parameter `Prefer` in header - violates `enum` at /properties/Prefer
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
Got 400 when missing required 'Authorization' header, expected 401
Response400 Bad Request
{"code":"PGRST100","details":"unexpected end of input expecting \"not\" or operator (eq, gt, ...)","hint":null,"message":"\"failed to parse filter ()\" (line 1, column 1)"}
The following media types are documented in the schema:
- `application/json`
- `application/vnd.pgrst.object+json;nulls=stripped`
- `application/vnd.pgrst.object+json`
- `text/csv`
Response204 No Content
<EMPTY>
Reproduce
GET/tags
curl -X GET -H 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJyb2xlIjoid2ViX3VzZXIifQ.hwWsbWFXukM_f0EnNbV2jijiVqWickzT75Eeg5GvLuM' 'http://0.0.0.0:40075/tags?limit=5'
Invalid data should have been rejected
Expected: 400, 401, 403, 404, 405, 406, 409, 415, 422, 428, 429, 5xx
Invalid component: in body - invalid syntax: random bytes
Invalid data should have been rejected
Expected: 400, 401, 403, 404, 405, 406, 409, 415, 422, 428, 429, 5xx
Invalid component: in body - incorrect type
The following media types are documented in the schema:
- `application/json`
- `application/vnd.pgrst.object+json;nulls=stripped`
- `application/vnd.pgrst.object+json`
- `text/csv`
{"code":"23503","details":"Key (book_id)=(0) is not present in table \"books\".","hint":null,"message":"insert or update on table \"book_tags\" violates foreign key constraint \"book_tags_book_id_fkey\""}
Invalid data should have been rejected
Expected: 400, 401, 403, 404, 405, 406, 409, 415, 422, 428, 429, 5xx
Invalid component: in body - incorrect type
The following media types are documented in the schema:
- `application/json`
- `application/vnd.pgrst.object+json;nulls=stripped`
- `application/vnd.pgrst.object+json`
- `text/csv`
Invalid data should have been rejected
Expected: 400, 401, 403, 404, 405, 406, 409, 415, 422, 428, 429, 5xx
Invalid component: in body - incorrect type
The following media types are documented in the schema:
- `application/json`
- `application/vnd.pgrst.object+json;nulls=stripped`
- `application/vnd.pgrst.object+json`
- `text/csv`
Invalid data should have been rejected
Expected: 400, 401, 403, 404, 405, 406, 409, 415, 422, 428, 429, 5xx
Invalid component: in body - incorrect type
The following media types are documented in the schema:
- `application/json`
- `application/vnd.pgrst.object+json;nulls=stripped`
- `application/vnd.pgrst.object+json`
- `text/csv`
The following media types are documented in the schema:
- `application/json`
- `application/vnd.pgrst.object+json;nulls=stripped`
- `application/vnd.pgrst.object+json`
- `text/csv`
Invalid data should have been rejected
Expected: 400, 401, 403, 404, 405, 406, 409, 415, 422, 428, 429, 5xx
Invalid component: in body - incorrect type
{"code":"PGRST202","details":"Searched for the function api.lend_book without parameters or with a single unnamed json/jsonb parameter, but no matches were found in the schema cache.","hint":null,"message":"Could not find the function api.lend_book without parameters in the schema cache"}
Reproduce
curl -X POST -H 'Prefer;' -H 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJyb2xlIjoid2ViX3VzZXIifQ.hwWsbWFXukM_f0EnNbV2jijiVqWickzT75Eeg5GvLuM' http://0.0.0.0:40075/rpc/lend_book
{"code":"23503","details":"Key (book_id)=(0) is not present in table \"books\".","hint":null,"message":"insert or update on table \"loans\" violates foreign key constraint \"loans_book_id_fkey\""}
`Allow: OPTIONS,GET,HEAD,POST,PUT,PATCH,DELETE` does not match the schema. Undocumented methods advertised: PUT
List exactly the methods this resource supports in `Allow`
`Allow: OPTIONS,GET,HEAD,POST,PUT,PATCH,DELETE` does not match the schema. Undocumented methods advertised: PUT
List exactly the methods this resource supports in `Allow`
Unsupported method PUT returned 400, expected 405 Method Not Allowed
Return 405 for methods not listed in the OpenAPI spec
Response400 Bad Request
{"code":"PGRST100","details":"unexpected end of input expecting field name (* or [a..z0..9_$])","hint":null,"message":"\"failed to parse order ()\" (line 1, column 1)"}
`Allow: OPTIONS,GET,HEAD,POST,PUT,PATCH,DELETE` does not match the schema. Undocumented methods advertised: PUT
List exactly the methods this resource supports in `Allow`
`Allow: OPTIONS,GET,HEAD,POST,PUT,PATCH,DELETE` does not match the schema. Undocumented methods advertised: PUT
List exactly the methods this resource supports in `Allow`
`Allow: OPTIONS,GET,HEAD,POST,PUT,PATCH,DELETE` does not match the schema. Undocumented methods advertised: PUT
List exactly the methods this resource supports in `Allow`
Unsupported method GET returned 404, expected 405 Method Not Allowed
Return 405 for methods not listed in the OpenAPI spec
Response404 Not Found
{"code":"PGRST202","details":"Searched for the function api.lend_book without parameters, but no matches were found in the schema cache.","hint":null,"message":"Could not find the function api.lend_book without parameters in the schema cache"}