incorrect update of newly added column from older connection - column value is
changed to null even if not included in update statement
---------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-5113
URL: http://tracker.firebirdsql.org/browse/CORE-5113
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.5
Environment: Windows 7 professional 64b, FB 2.5.5.26952 64b installed
as classic (tested on 2.5.2.26539 32b with same result too)
Reporter: tvr
Priority: Critical
I tried it with to isql instances:
1. Open first instance
2. Open second instance, add new column to table and change its value
3. Return to first instance and change value of some old column. By this is
value in new column is set to NULL, even though new column is not mentioned in
update statement.
Steps to reproduce:
Create test table and fill one row:
CREATE TABLE FBTEST
(
CONE VARCHAR(10)
);
FIRST ISQL CONNECTION:
SQL> select * from fbtest; commit;
CONE
==========
kuktest
SECOND ISQL CONNECTION:
SQL> select * from fbtest; commit;
CONE
==========
kuktest
SQL> alter table fbtest add ctwo varchar(10); commit;
SQL> update fbtest set cone='kuk1', ctwo='kuk2'; commit;
SQL> select * from fbtest; commit;
CONE CTWO
========== ==========
kuk1 kuk2
FIRST ISQL CONNECTION:
SQL> update fbtest set cone='hi'; commit;
SQL>
SECOND ISQL CONNECTION:
SQL> select * from fbtest; commit;
CONE CTWO
========== ==========
hi <null> ---------------------------> expected
to see hi kuk2
SQL>
--
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
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
