BIT_AND not found
-----------------
Key: CORE-4329
URL: http://tracker.firebirdsql.org/browse/CORE-4329
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.5.2 Update 1
Environment: .NET Provider 4.1, Firebird embedded 2.5.2
Reporter: Firebird User unter Windows7
Defining a view using BIT_AND does not work:
CREATE VIEW MyView AS SELECT CAST(BIT_AND(BIN_SHR(max(SRC3.StepVersion), 48),
0xFFFF) as varchar(32)) || '.' || CAST(BIT_AND(BIN_SHR(max(SRC3.StepVersion),
32), 0xFFFF) as varchar(32)) || CASE BIT_AND(BIN_SHR(max(SRC3.StepVersion),
16), 0xFFFF) WHEN 0xFFFF THEN '' ELSE '.' ||
CAST(BIT_AND(BIN_SHR(max(SRC3.StepVersion), 16), 0xFFFF) as varchar(32)) END ||
CASE BIT_AND(max(SRC3.StepVersion), 0xFFFF) WHEN 0xFFFF THEN '' ELSE '.' ||
CAST(BIT_AND(max(SRC3.StepVersion), 0xFFFF) as varchar(32)) END AS
CurrentVersionInfo FROM MyTable AS SRC3
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -804
Function unknown
BIT_AND ---> FirebirdSql.Data.Common.IscException: Dynamic SQL Error
SQL error code = -804
Function unknown
BIT_AND
This works:
select BIN_AND(BIN_SHR(max(3454654546546544), 48), 0xFFFF) from rdb$database
I thought BIT_AND is a internal function and is available for INT and BIGINT.
--
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
------------------------------------------------------------------------------
WatchGuard Dimension instantly turns raw network data into actionable
security intelligence. It gives you real-time visual feedback on key
security issues and trends. Skip the complicated setup - simply import
a virtual appliance and go from zero to informed in seconds.
http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
