InboundTableMapper::queueData() error with hashes of lists

[davidnich]

mapper fields that do not have any input data (ex: a closure that does not process input data for example) cause the following exception to be raised: User exception: /Users/david/src/qore/git/qore/qlib/Mapper.qm:1186: MAPPER-FIELD-LIST-ERROR: datasource "oracle:omquser@el7": field "dte" value passed is "nothing" in list mode; expecting "list"

this bug was introduced in Qore 0.8.12.6 with the fix for #1620

[pavelkveton]

some more info from David about when the problem manifests itself:

[11:58:05 AM] David Nichols: most of the "code" closures don't use any input value - meaning the first argument
[11:58:17 AM] David Nichols: meaning that the output field has a different name than the input field
[11:58:46 AM] David Nichols: however the bug will only be seen when you submit data in "hash of lists" format to InboundTableMapper::queueData()
[11:58:51 AM] David Nichols: so normally this happens with DB input
[11:59:14 AM] David Nichols: so in other words, when you have DB input and then pass that input to an InboundTableMapper object with queueData() - you will see the bug

about the impacted structures of the mapper:

[12:44:52 PM] David Nichols: no it doesn't affect constants
[12:45:04 PM] David Nichols: because they were separated out and not passed to Mapper::mapFieldIntern()
[12:45:17 PM] David Nichols: it affects any output field that has no input field
[12:45:26 PM] David Nichols: so I think closure might be the only one

[pavelkveton]

so if I understand it well, it affects all the mappers with a closure used for DB->DB mapping with Bulk operations.

Mind that M_DATE is also a closure.

[davidnich]

@pavelkveton yes as long as bulk DML is used for both input and output