Menu

#107 [PHP]Return value of cubrid_field_flags() is not_null when using BLOB_TO_BIT to querying blob type

open
nobody
None
5
2012-03-07
2012-03-07
Jira Trac
No

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}

Discussion

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.