Subject | Weird RDB$DB_KEY printing in ISQL |
---|---|
Author | Milan Babuskov |
Post date | 2007-09-06T20:23:38Z |
Hi,
I'm trying to figure out the following ISQL behavior:
SQL> select rdb$db_key, substring(rdb$db_key from 1 for 8)
CON> from rdb$database;
DB_KEY SUBSTRING
================ ================
0000000100000001 0100000001000000
Does db_key get some special treatment? What is the real order of
bytes in that field?
Also, does anyone know why is RDB$ stripped from the column name?
Thanks,
Milan Babuskov
http://fbexport.sourceforge.net
I'm trying to figure out the following ISQL behavior:
SQL> select rdb$db_key, substring(rdb$db_key from 1 for 8)
CON> from rdb$database;
DB_KEY SUBSTRING
================ ================
0000000100000001 0100000001000000
Does db_key get some special treatment? What is the real order of
bytes in that field?
Also, does anyone know why is RDB$ stripped from the column name?
Thanks,
Milan Babuskov
http://fbexport.sourceforge.net