Bug 24029

Summary: marcrecord2csv.t displays a SQL error "Truncated incorrect DOUBLE value: '01e'"
Product: Koha Reporter: Jonathan Druart <jonathan.druart+koha>
Component: Test SuiteAssignee: Jonathan Druart <jonathan.druart+koha>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: minor    
Priority: P5 - low CC: martin.renvoize
Version: unspecified   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
19.11.00
Bug Depends on:    
Bug Blocks: 24002    
Attachments: Bug 24029: Remove "Truncated incorrect DOUBLE value: '01e'" from marcrecord2csv.t
Bug 24029: Remove "Truncated incorrect DOUBLE value: '01e'" from marcrecord2csv.t

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