Bug 24029 - marcrecord2csv.t displays a SQL error "Truncated incorrect DOUBLE value: '01e'"
Summary: marcrecord2csv.t displays a SQL error "Truncated incorrect DOUBLE value: '01e'"
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Test Suite (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low minor (vote)
Assignee: Jonathan Druart
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks: 24002
  Show dependency treegraph
 
Reported: 2019-11-13 09:50 UTC by Jonathan Druart
Modified: 2021-06-14 21:29 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
19.11.00


Attachments
Bug 24029: Remove "Truncated incorrect DOUBLE value: '01e'" from marcrecord2csv.t (1.47 KB, patch)
2019-11-13 10:09 UTC, Jonathan Druart
Details | Diff | Splinter Review
Bug 24029: Remove "Truncated incorrect DOUBLE value: '01e'" from marcrecord2csv.t (1.54 KB, patch)
2019-11-13 13:22 UTC, Martin Renvoize
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Jonathan Druart 2019-11-13 09:50:35 UTC
t/db_dependent/Record/marcrecord2csv.t .. 1/12 DBD::mysql::db do failed: Truncated incorrect DOUBLE value: '01e' [for Statement "DELETE FROM marc_subfield_structure WHERE tagfield=998 and ( tagsubfield='8' or tagsubfield='9')"] at t/db_dependent/Record/marcrecord2csv.t line 104.
Comment 1 Jonathan Druart 2019-11-13 10:09:02 UTC
Created attachment 95355 [details] [review]
Bug 24029: Remove "Truncated incorrect DOUBLE value: '01e'" from marcrecord2csv.t

marc_subfield_structure.tagfield is a varchar(3)
Comment 2 Martin Renvoize 2019-11-13 13:21:38 UTC
Obvious correction, tiny patch.. Passing QA
Comment 3 Martin Renvoize 2019-11-13 13:22:34 UTC
Created attachment 95376 [details] [review]
Bug 24029: Remove "Truncated incorrect DOUBLE value: '01e'" from marcrecord2csv.t

marc_subfield_structure.tagfield is a varchar(3)

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Comment 4 Martin Renvoize 2019-11-13 13:26:22 UTC
Nice work!

Pushed to master for 19.11.00