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
do not delete * from mytable (21 records) [CORE5459] #5730
Comments
Modified by: Hossein Daneshvar (daneshvar)description: Firebird 3.0.1.32609-0 SuperServer 32bit on Windows 7 1."select * from mytable order by pk" = 6864 records 2.execute "delete * from mytable" 3.after execute delete all : after backup and restore : => Firebird 3.0.1.32609-0 SuperServer 32bit on Windows 7 1."select * from "StudentPay" order by pk" = 6864 records 2.execute "delete * from "StudentPay"" 3.after execute delete all : after backup and restore : |
Modified by: Hossein Daneshvar (daneshvar)description: Firebird 3.0.1.32609-0 SuperServer 32bit on Windows 7 1."select * from "StudentPay" order by pk" = 6864 records 2.execute "delete * from "StudentPay"" 3.after execute delete all : after backup and restore : => Firebird 3.0.1.32609-0 SuperServer 32bit on Windows 7 Download Link Database "VSPRING95" : https://goo.gl/PJDS0l 1."select * from "StudentPay" order by pk" = 6864 records 2.execute "delete * from "StudentPay"" 3.after execute delete all : after backup and restore : |
Modified by: Hossein Daneshvar (daneshvar)description: Firebird 3.0.1.32609-0 SuperServer 32bit on Windows 7 Download Link Database "VSPRING95" : https://goo.gl/PJDS0l 1."select * from "StudentPay" order by pk" = 6864 records 2.execute "delete * from "StudentPay"" 3.after execute delete all : after backup and restore : => Firebird 3.0.1.32609-0 SuperServer 32bit on Windows 7 Download Link Database "VSPRING95" : https://goo.gl/PJDS0l 1."select * from "StudentPay" order by "Key"" = 6864 records 2.execute "delete from "StudentPay"" 3.after execute delete all : after backup and restore : |
Modified by: @hvladassignee: Vlad Khorsun [ hvlad ] |
Commented by: @hvlad Database have some inconsistencies at pointer pages (gfix show it) |
Commented by: Hossein Daneshvar (daneshvar) Yes, FW always On at this database. |
Modified by: Hossein Daneshvar (daneshvar)security: Developers [ 10012 ] => |
Commented by: @hvlad With current snapshot build you can fix the corruption using gfix -v -full To find and fix the reason i need a steps to reproduce this corruption. |
Commented by: Hossein Daneshvar (daneshvar) Thanks, gfix in Firebird 3.0.2.32673 can fix the corruption. But should the firebird engine to detecting the problem I during the 1 transaction : this actions repeate several times in day |
Commented by: @hvlad > this actions repeate several times in day So, could you provide me with a test case ? |
Commented by: @hvlad Is it still reproducible ? If yes, would you like to test special build with fix for this issue ? |
Submitted by: Hossein Daneshvar (daneshvar)
Firebird 3.0.1.32609-0 SuperServer 32bit on Windows 7
Download Link Database "VSPRING95" : https://goo.gl/PJDS0l
1."select * from "StudentPay" order by "Key"" = 6864 records
2.execute "delete from "StudentPay""
3.after execute delete all :
result of "select * from "StudentPay"" = 0 record
result of "select * from "StudentPay" order by "Key"" = 21 records (do not delete this 21 records)
after backup and restore :
result of "select * from "StudentPay"" = 0 record
result of "select * from "StudentPay" order by "Key"" = 0
Commits: e954777 ddd5d04
The text was updated successfully, but these errors were encountered: