#5 Bug - When use multiquery and type="column"

[Levi Pereira]

When use multiquery and type="column" it does not work.

Example:

<parms type="oracle" prefix="oracle.">
<server>
<multiquery time="60" items="name|curr_val" type="column">
select 'test_item','0' from dual
</multiquery>
</server>
</parms>

Logs output:
2016-11-11 15:40:04 INFO Sending item[2] oracle. =

[Paulina Cosio]

Its True

With this xml configuration

<multiquery time="30" items="replication.adminrequest|replication.globalname|replication.status|replication.tran|replication.errors|replication.complete" type="column" trim="yes">SELECT TO_NUMBER(d.admin_requests),g.global_name,TO_NUMBER(e.status),TO_NUMBER(dt.tran),TO_NUMBER(de.errors),TO_NUMBER(c.complete)
FROM (SELECT GLOBAL_NAME FROM GLOBAL_NAME) G,
(SELECT COUNT(ID) ADMIN_REQUESTS FROM DBA_REPCATLOG) D,
(SELECT COUNT(STATUS) STATUS FROM DBA_REPCATLOG WHERE STATUS = 'ERROR') E,
(SELECT COUNT() TRAN FROM DEFTRANDEST) DT,
(SELECT COUNT() ERRORS FROM DEFERROR) DE,
(SELECT COUNT(A.DEFERRED_TRAN_ID) COMPLETE FROM DEFTRAN A
WHERE A.Deferred_Tran_Id Not In (
SELECT B.DEFERRED_TRAN_ID
FROM DEFTRANDEST B)
) C
</multiquery>

I get this response in dababix.log

2017-07-17 11:30:06 INFO Sending item[0] oracle. =
2017-07-17 11:30:06 WARN Failed to send oriora01_fdbe:oracle. item ()