From: | "B(dot)Z" <joejob357(at)gmail(dot)com> |
---|---|
To: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #13442: ISBN doesn't always roundtrip with text |
Date: | 2015-06-15 19:43:42 |
Message-ID: | CADY-w5Vi-7P+0gP8VvTQZg5RpYe0HBTyboHc=dDzAyOumLpeOQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Fabien COELHO | 2015-06-15 20:02:54 | Re: BUG #13442: ISBN doesn't always roundtrip with text |
Previous Message | Jeff Janes | 2015-06-15 19:30:07 | Re: BUG #13443: master will remove dead rows when hot standby(use slot) disconnect |