Menu

#37 [Perl]Result of inserting NULL values into table isn't correct.

open
nobody
None
5
2011-12-22
2011-12-22
Jira Trac
No

Test Build:CUBRID 2008 R4.0 (8.4.0.2019) (64bit release build for linux_gnu)
OS: Linux 64
Description: Result of inserting NULL values into table isn't correct.

Repro Steps:
{noformat}
perl null.pl pl_db
{noformat}

Actual Result:
{noformat}
[perl@NC-XQA-DEV09 DBI_CUBRID_TEST]$ csql -udba pl_db

CUBRID SQL Interpreter

Type `;help' for help messages.

csql select * from tbl;

=== Result of SELECT Command in Line 1 ===

id name age

1 'zhangsan ' 30
1 'Joe ' 0

2 rows selected.

Current transaction has been committed.

1 command(s) successfully processed.
csql
{noformat}

Expect Result:
{noformat}
[perl@NC-XQA-DEV09 DBI_CUBRID_TEST]$ csql -udba pl_db

CUBRID SQL Interpreter

Type `;help' for help messages.

csql select * from tbl;

=== Result of SELECT Command in Line 1 ===

id name age

1 'zhangsan ' 30
1 'Joe ' NULL

2 rows selected.

Current transaction has been committed.

1 command(s) successfully processed.
csql
{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.