[Functional] Identical book query deviates from specification

oscarngncc / COMP4111_project

COMP4111 project

0 stars 0 forks source link

[Functional] Identical book query deviates from specification #8

Closed elise-ng closed 4 years ago

elise-ng commented 4 years ago

According to specification (Q&A in tutorial), books with same titles are counted as duplicates (Both the book ID and title are unique in your database.). However, in SqlHelpers FindIdenticalBook method, the query was written to compare title, author, publish and year. which deviates from the spec.

comp4111ta commented 4 years ago

TA-verified: Valid Security Issues: Data inconsistency Comments: It may cause data inconsistency when the HTTP request asks for the duplicated title book.