4.0.2 : bin_and not avaiable

[drcrck]

Hi, i have error with last stable release versione with "bin_and" command. it seems not available. (it's used by Firedac in Delphi in some way to get metadata.)

in 4.0.1 it's all ok.

[hvlad]

Works OK:

SQL> show version;
ISQL Version: WI-V4.0.2.2816 Firebird 4.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V4.0.2.2816 Firebird 4.0"
on disk structure version 13.0
SQL>
SQL> select bin_and(15, 3) from rdb$database;

     BIN_AND
============
           3

Do you have a test case ?

[drcrck]

Hi, it seems related to some of out FDB files. with some DBs it works, with others no

ISQL Version: WI-V4.0.1.2692 Firebird 4.0
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect db;
Server version:
WI-V4.0.1.2692 Firebird 4.0
Database: db, User: DIEGO
SQL> select bin_and(15, 3) from rdb$database;
Statement failed, SQLSTATE = 39000
invalid request BLR at offset 36
-function BIN_AND is not defined
-module name or entrypoint could not be found
SQL>

SQL> connect c:\db\xxx\xxxx.fdb;
Server version:
WI-V4.0.1.2692 Firebird 4.0
Database: c:\db\xxx\xxxx.fdb, User: DIEGO
SQL> select bin_and(15, 3) from rdb$database;

     BIN_AND
============
           3

[dyemanov]

You have BIN_AND defined as UDF in some databases, thus the issue.

[drcrck]

You have BIN_AND defined as UDF in some databases, thus the issue.

i'll check thanks!