Details
-
Bug
-
Resolution: Duplicate
-
Blocker
-
None
-
8.12.11.6_4
-
None
Description
There is loss of data when performing update on Google Spreadsheet.
Initial data:
INSERT INTO SmallA_Direct (IntKey, StringKey, IntNum, StringNum) VALUES (1, '1', 1, '1'), (2, '2', 2, '2'), (3, '3', 3, '3'), (4, '4', 4, '4'), (5, '5', 5, '5')
Then a
SELECT * FROM SmallA_Direct
results in:
1 | 1 | 1 | 1 |
2 | 2 | 2 | 2 |
3 | 3 | 3 | 3 |
4 | 4 | 4 | 4 |
5 | 5 | 5 | 5 |
Following update:
UPDATE SmallA_Direct SET IntNum = NULL WHERE IntNum >= 3
Results in following data returned by
SELECT * FROM SmallA_Direct
:
1 | <null> | 1 | <null> |
2 | <null> | 2 | <null> |
3 | 3.0 | <null> | 3.0 |
4 | 4.0 | <null> | 4.0 |
5 | 5.0 | <null> | 5.0 |