Issue Details (XML | Word | Printable)

Key: CORE-5870
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 0
Watchers: 1

If you were logged in you would be able to see more operations.
Firebird Core

ISQL's "show database" command works wrong with 64-bit numbers

Created: 10/Jul/18 04:49 PM   Updated: 08/Jun/19 08:11 PM
Component/s: ISQL
Affects Version/s: 4.0 Initial, 3.0.0, 3.0.1, 3.0.2, 4.0 Alpha 1, 3.0.3
Fix Version/s: 3.0.4, 4.0 Beta 1

QA Status: Cannot be tested
Test Details:
It is not big problem to open fdb file and write into its header needed big values for Tx counters.
The real difficulty is to create multiple pages with type = TIP, with filling them and also to add references to them in RDB$PAGES (one *need* to create such pages otherwise bugcheck "cannot find tip page (165)" will raise).
This task looks impracticable, at least for nowadays.

 Description  « Hide
\firebird>gstat -h s:\temp\tx.30.fdb

Database "S:\TEMP\TX.30.FDB"
Gstat execution time Tue Jul 10 18:32:41 2018

Database header page information:
        Flags 0
        Generation 1977120
        System Change Number 0
        Page size 16384
        ODS version 12.0
        Oldest transaction 4294965022
        Oldest active 4294985534
        Oldest snapshot 4294985534
        Next transaction 4294985534

while isql show zero's:

\firebird>isql s:\temp\tx.30.fdb
Database: s:\temp\tx.30.fdb, User: SYSDBA
SQL> show database;
Database: s:\temp\tx.30.fdb
        Owner: SYSDBA
Number of DB pages allocated = 68818
Number of DB pages used = 66037
Number of DB pages free = 2781
Sweep interval = 0
Forced Writes are OFF
Transaction - oldest = 0
Transaction - oldest active = 0
Transaction - oldest snapshot = 0
Transaction - Next = 0
ODS = 12.0
Database not encrypted
Default Character set: NONE

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.