Open zaneselvans opened 2 years ago
I came up against this issue. I don't have time to file a PR yet (though it looks like there hasn't been recent activity on this?) but I can share the code change I made to fix this:
src/utils/transforms.lisp
changed:
(defun float-to-string (float)
"Transform a Common Lisp float value into its string representation as
accepted by PostgreSQL, that is 100.0 rather than 100.0d0."
(declare (type (or null fixnum float string) float))
(when float
(cond
((> float most-positive-double-float) "Infinity")
((< float most-negative-double-float) "-Infinity")
(t (typecase float
(double-float (let ((*read-default-float-format* 'double-float))
(princ-to-string float)))
(string float)
(t (princ-to-string float)))))))
[x] pgloader --version
[ ] did you test a fresh compile from the source tree? I did not, tbh.
[x] did you search for other similar issues? I didn't find any issues that seemed related.
[x] how can I reproduce the bug? Download a copy of the source SQLite DB Run e.g.
[x] pgloader output you obtain