| Subject | Re: [firebird-support] update all records |
|---|---|
| Author | |
| Post date | 2016-05-05T16:38:38Z |
Hi,
one of possible reason is that records are not visible to transaction with
this update statement.
e.g.
1. you start transansction (tr1)
2. someone start transaction 2(tr2)
3. tr2 insert some records
4. tr1 run update
5. tr2 commit
6. tr1 commit
all records inserted by tr2 are not updated if tr1 is e.g. snapshot
or during tr1 update there are inserts.
regards,
Karol Bieniaszewski
Sent: Wednesday, May 4, 2016 8:45 PM
Subject: [firebird-support] update all records
hello! I've been googling but found nothing about it.
Why this sentence does not update all the records in the table? (FB 2.5)
update stock set actualizar = 0 where 1=1
Thanks!!
Sergio