[Firebird-devel] [FB-Tracker] Created: (CORE-1355) Zero display instead of NULL

[Philippe M. (JIRA) <tr...@fi...>]

Zero display instead of NULL
----------------------------

                 Key: CORE-1355
                 URL: http://tracker.firebirdsql.org/browse/CORE-1355
             Project: Firebird Core
          Issue Type: Bug
          Components: Engine
    Affects Versions: 2.1 Beta 1, 2.1 Alpha 1, 2.0.1, 1.5.4
         Environment: tests made under Windows, Linux, MacOsx, with isql and DatabaseWorkbench, with same result
            Reporter: Philippe Makowski
            Priority: Trivial


After adding a new field, value is reported as zero instead of null, but the "value" is correct (null)
here the test :
SQL> CREATE database 'test.fdb';
SQL> create table test (test_value integer);
SQL> insert into test(test_value) values (9);
SQL> commit;
SQL> alter table test add test_id integer not null;
SQL> select * from test;

  TEST_VALUE      TEST_ID
============ ============

           9            0
SQL> select count(*) from test where TEST_ID=0;

       COUNT
============

           0

SQL> select count(*) from test where TEST_ID IS NULL;

       COUNT
============

           1


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira