Firebird-2.5.0.26074_1_Win32 Arithmetic overflow when use VIEW with UNION
-------------------------------------------------------------------------
Key: CORE-3697
URL: http://tracker.firebirdsql.org/browse/CORE-3697
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.5.0
Environment: Версия FB 2.5 Firebird-2.5.0.26074_1_Win32.exe ODS 11.2
BD in UTF-8 cod
OS Win 2003
Reporter: JNA
First
create view TREE_TEST (
ID, TEXT, PARENTID, CONDITIONS, STMT, RULFNAME )
as
select uidorg , nameorg
, '0' , ' G.UIDORG = ' || '''' || uidorg || ''''
, '' , 'KODORG'
from org_delivery;
select ID, TEXT, PARENTID, CONDITIONS, STMT, RULFNAME
from TREE_TEST - All result OK
Second. And now i add UNION clause
create view TREE_TEST (
ID, TEXT, PARENTID, CONDITIONS,
STMT, RULFNAME )
as
select 0, 'Организации', NULL, '', ''
, 'KODORG'
from rdb$database
union
select uidorg
, nameorg
, '0'
, ' G.UIDORG = ' || '''' || uidorg || ''''
, ''
, 'KODORG'
from org_delivery
select ID, TEXT, PARENTID, CONDITIONS, STMT, RULFNAME
from TREE_TEST
ERROR
Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation.
string right truncation.
--
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
------------------------------------------------------------------------------
Cloud Computing - Latest Buzzword or a Glimpse of the Future?
This paper surveys cloud computing today: What are the benefits?
Why are businesses embracing it? What are its payoffs and pitfalls?
http://www.accelacomm.com/jaw/sdnl/114/51425149/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
