Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Adding a new integer field not nullable but it didn´t updated old rows with new field [CORE3298] #3665

Closed
firebird-automations opened this issue Dec 29, 2010 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue duplicates CORE1518 [ CORE1518 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Duplicates CORE1518 and CORE2696.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue duplicates CORE2696 [ CORE2696 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Duplicate [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

security: Managers [ 10013 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant