You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
After adding a new integer field not nullable we found that Firebird didn´t updated old rows with a default value.
When we querying values with NULL appears some old rows showing zero value but it were NULL
Example:
SELECT * FROM TABLE WHERE newfield IS NULL
It shows many rows with newfield equal to ZERO (0) value but conditional were NULL
We expected Firebird has updated those old rows but it didn´t happened
The text was updated successfully, but these errors were encountered:
Submitted by: Yanpol (yanpol)
Duplicates CORE1518
Duplicates CORE2696
After adding a new integer field not nullable we found that Firebird didn´t updated old rows with a default value.
When we querying values with NULL appears some old rows showing zero value but it were NULL
Example:
SELECT * FROM TABLE WHERE newfield IS NULL
It shows many rows with newfield equal to ZERO (0) value but conditional were NULL
We expected Firebird has updated those old rows but it didn´t happened
The text was updated successfully, but these errors were encountered: