Re: BUG #13442: ISBN doesn't always roundtrip with text

Поиск
Список
Период
Сортировка
От B.Z
Тема Re: BUG #13442: ISBN doesn't always roundtrip with text
Дата
Msg-id CADY-w5Vi-7P+0gP8VvTQZg5RpYe0HBTyboHc=dDzAyOumLpeOQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #13442: ISBN doesn't always roundtrip with text  (bz@mailinator.com)
Список pgsql-bugs
(I'm the original reporter).

I think this gets to the crux of the matter, although I disagree that no
bug exists.

ISBN10s, i.e. 10-digit ISBNs, can be converted to ISBN13s, and back again.
i.e. they round-trip. ISBN13s with the 979 prefix can't be converted to
ISBN10s. (Evidence includes http://pcn.loc.gov/isbncnvt.html failing on
ISBN13s with 979- prefixes with "This 13-digit ISBN does not begin with
"978"
It cannot be converted to a 10-digit ISBN.", and
https://247pearsoned.custhelp.com/app/answers/detail/a_id/6922/~/isbn-converter
stating "The revised ISBN standard does not provide rules for converting or
assigning 10-digit ISBNs to 13-digit ISBNs prefixed with "979". There is no
industry approved method for converting ISBN-13s prefixed with "979" to an
ISBN-10. Thirteen-digit ISBNs prefixed with "979" should not be represented
to trading partners as 10-digit ISBNs. ").

The key bug, then, is that the isn extension attempts to make this illegal
conversion:

  select '9791020902573'::isbn; --gives 10-209-0257-4

I suspect the correct behaviour is raising an exception in these
circumstances.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: BUG #13440: unaccent does not remove all diacritics
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: BUG #13442: ISBN doesn't always roundtrip with text