BIT_AND not found [CORE4329] #4652
Comments
|
Commented by: @hvlad > I thought BIT_AND is a internal function |
|
Commented by: Firebird User unter Windows7 (winfire) Sorry, than change your Documentation: http://www.firebirdsql.org/refdocs/langrefupd21-intfunc-bin_and.html BIN_AND() Available in: DSQL, PSQL Added in: 2.1 Description: Returns the result of the bitwise AND operation on the argument(s). Result type: INTEGER or BIGINT --- How can I use it for INTEGER and BIGINT? |
Modified by: Firebird User unter Windows7 (winfire)description: 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 This works: I thought BIT_AND is a internal function and is available for INT and BIGINT. => Defining a view using BIT_AND does not work: StepVersion is BIGINT, embedded Firebird Database Dlls are 32 Bit. 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 This works: I thought BIT_AND is a internal function and is available for INT and BIGINT. |
|
Commented by: @hvlad What should we change ? Are you see the difference between BIT_AND (non-existing) and BIN_AND (existing and working) ? |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
|
Commented by: Firebird User unter Windows7 (winfire) Oh, thanks. I come from Oracle (BITAND) and so I really haven't seen the small but important difference. |
Submitted by: Firebird User unter Windows7 (winfire)
Defining a view using BIT_AND does not work:
StepVersion is BIGINT, embedded Firebird Database Dlls are 32 Bit.
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.
The text was updated successfully, but these errors were encountered: