internal Firebird consistency check ((CMP) copy: cannot remap (221), file:
cmp.cpp line: 3085).
-----------------------------------------------------------------------------------------------
Key: CORE-5596
URL: http://tracker.firebirdsql.org/browse/CORE-5596
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.6
Environment: Dialect 1. Database file in attachment/
Reporter: Oleg Matveyev
Prepare query with error:
internal Firebird consistency check ((CMP) copy: cannot remap (221), file:
cmp.cpp line: 3085).
___________________________________
SELECT mg.dbBrutto_Full
, COALESCE(
Round((
IIF( exists(select g.id from c_goodSpec gs, c_good g where gs.id =
mg.idGoodspec and g.id = gs.idGood and g.idMera0 = 2)
, mg.dbBrutto_Count0 * (mg.dbCount0 - (select count(mgi.id) from
c_move_good_item mgi where mgi.idMoveGood = mg.id /*and mgi.iNumber <> 0*/ and
mgi.dbBrutto > 0.001))
, mg.dbBrutto_Count0 * (mg.dbCount0 - COALESCE((select
sum(mgi.dbCountList) from c_move_good_item mgi where mgi.idMoveGood = mg.id
/*and mgi.iNumber <> 0*/ and mgi.dbBrutto > 0.001), 0e0))
)
+ (select (CASE(3)
WHEN g.idMera0 THEN mg.dbCount0
WHEN g.idMera1 THEN mg.dbCount1
WHEN g.idMera2 THEN mg.dbCount2
WHEN g.idMera3 THEN mg.dbCount3
ELSE 0.0
END) from c_goodSpec gs, c_good g
where gs.id = mg.idGoodspec
and g.id = gs.idGood
) * 28.58
+ COALESCE((select sum(mgi.dbBrutto) from C_Move_Good_Item mgi where
mgi.idMoveGood = mg.id /*and mgi.iNumber <> 0*/ and mgi.dbBrutto > 0.001), 0e0)
),0)
, 0)
FROM C_Move_Good mg
JOIN C_move m ON m.id=mg.idMove
WHERE m.dtDay >= '01.01.2017' AND m.iRouteType=2
AND mg.ibRekv=0
AND (mg.dbBrutto_Full - COALESCE(
Round((IIF( exists(select g.id from c_goodSpec
gs, c_good g where gs.id = mg.idGoodspec and g.id = gs.idGood and g.idMera0 =
:idMera_Pack)
, mg.dbBrutto_Count0 * (mg.dbCount0 - (select
count(mgi.id) from c_move_good_item mgi where mgi.idMoveGood = mg.id and
mgi.dbBrutto > 0.001))
, mg.dbBrutto_Count0 * (mg.dbCount0 -
COALESCE((select sum(mgi.dbCountList) from c_move_good_item mgi where
mgi.idMoveGood = mg.id and mgi.dbBrutto > 0.001), 0e0))
)
+ (select (CASE(3)
WHEN g.idMera0 THEN mg.dbCount0
WHEN g.idMera1 THEN mg.dbCount1
WHEN g.idMera2 THEN mg.dbCount2
WHEN g.idMera3 THEN mg.dbCount3
ELSE 0.0
END) from c_goodSpec gs, c_good g
where gs.id = mg.idGoodspec
and g.id = gs.idGood
) * 28.58
+ COALESCE((select sum(mgi.dbBrutto) from
C_Move_Good_Item mgi where mgi.idMoveGood = mg.id and mgi.dbBrutto > 0.001),
0e0)
),0)
, 0)
)
BETWEEN -0.001 AND 0.001
AND EXISTS( select * from c_goodSpec gs, c_good g
where gs.id = mg.idGoodspec
and g.id = gs.idGood
and (g.idMera0 = 3 OR g.idMera1 = 3
OR g.idMera2 = 3 OR g.idMera3 = 3));
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
