Test Build: CUBRID 2008 R4.1 (8.4.1.1018) (64bit release build for linux_gnu)
OS: Linux 64
Description: Return value of cubrid_field_flags() is not_null when using BLOB_TO_BIT to querying blob type
Repro steps:
1. execute: php flags_blob_test1.phpt
statements in flags_blob_test1.phpt
{noformat}
cubrid_execute($conn,CREATE TABLE blob_tb(id int, c10 clob,c11 blob););
cubrid_execute($conn,insert into blob_tb values( 1, CHAR_TO_CLOB('This is a Dog'), BIT_TO_BLOB(X'000001')));
$result=cubrid_execute($conn,select id as int_t, c10, BLOB_TO_BIT(c11) from blob_tb);
$col_num = cubrid_num_cols($result);
for($i = 0; $i $col_num; $i++) {
printf(%-30s %s\n, cubrid_field_name($result, $i), cubrid_field_flags($result, $i));
}
{noformat}
Actual result:
Return value is not_null using statement select id, c10, BLOB_TO_BIT(c11) from blob_tb
Return value is empty using statement select id, c10, c11 from blob_tb. this value is expect value.
{noformat}
int_t
c10
blob_to_bit(c11) not_null
{noformat}
Expect result:
{noformat}
int_t
c10
blob_to_bit(c11)
{noformat}