cubrid_fetch_field() return default value as empty string instead of NULL

Details

  • Type: Improvement Improvement
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: PHP-8.4.1
  • Fix Version/s: PHP-8.4.1, PHP-Apricot
  • Component/s: PHPDriver
  • Labels:
    None

Description

Assume there is a table which has "id INTEGER AUTO_INCREMENT NOT NULL". It has no DEFAULT value, which means it should be NULL, however, "" (empty string) is returned. Moreover, integer cannot have an empty string default value. Is it CUBRID specification or can you change this value?

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
李成龙[이성룡] added a comment -

In the case "id INTEGER AUTO_INCREMENT NOT NULL", the value cannot be null.
The values should be starts from 1 and 2, 3, 4, ... so on.

Can you give me more detail information or test cases that returns null values or empty string on Integer column?

Show
李成龙[이성룡] added a comment - In the case "id INTEGER AUTO_INCREMENT NOT NULL", the value cannot be null. The values should be starts from 1 and 2, 3, 4, ... so on. Can you give me more detail information or test cases that returns null values or empty string on Integer column?
Hide
Permalink
Esen Sagynov added a comment -

Just create any integer column which can be NULL, then run cubrid_fetch_field() on it. It will return empty string instead of NULL.

Show
Esen Sagynov added a comment - Just create any integer column which can be NULL , then run cubrid_fetch_field() on it. It will return empty string instead of NULL.
Hide
Permalink
张慧 added a comment -

Commit rev: 462

Show
张慧 added a comment - Commit rev: 462
Hide
Permalink
张慧 added a comment -

We have resolved this issue on PHP-8.4.1 and PHP-Apricot.

If you have any problem, please let me know.

Thank you!

Show
张慧 added a comment - We have resolved this issue on PHP-8.4.1 and PHP-Apricot. If you have any problem, please let me know. Thank you!

People

  • Assignee:
    张慧
    Reporter:
    Esen Sagynov
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: