Ability to query Firebird configuration using SQL
-------------------------------------------------
Key: CORE-6444
URL: http://tracker.firebirdsql.org/browse/CORE-6444
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Reporter: Vlad Khorsun
It will be nice to have ability to query configuration settings using SQL
language.
Configuration here is contents of firebird.conf, databases.conf and settings
passed via DPB when applicable.
Proposed solution is to introduce new virtual table to expose settings values.
Table defined as
CREATE TABLE RDB$CONFIG
(
RDB$CONFIG_ID INTEGER NOT NULL,
RDB$CONFIG_NAME VARCHAR(63) CHARACTER SET UTF8 NOT NULL,
RDB$CONFIG_VALUE VARCHAR(255) CHARACTER SET UTF8,
RDB$CONFIG_DEFAULT VARCHAR(255) CHARACTER SET UTF8,
RDB$CONFIG_IS_SET BOOLEAN NOT NULL,
RDB$CONFIG_SOURCE VARCHAR(255) CHARACTER SET UTF8
);
where
- RDB$CONFIG_ID
unique row identifier, no special meaning
- RDB$CONFIG_NAME
setting name, such as "DefaultDbCachePages", "TempCacheLimit" and so on
- RDB$CONFIG_VALUE
actual value of setting, could be set in configuration and, if necessary,
"fixed" by the engine (in case of wrong value)
- RDB$CONFIG_DEFAULT
default value of setting, fixed at Firebird code
- RDB$CONFIG_IS_SET
TRUE, if value was set by user
- RDB$CONFIG_SOURCE
name of configuration file where setting was set, relative to the firebird
root folder, for example: "firebird.conf", "databases.conf"
or special value "DPB" if setting was set in DPB,
If setting value was not set, this field contains NULL
Table RDB$CONFIG is populated from in-memory structures when required and
instance is kept at SQL query level.
For security reasons access is allowed to the SYSDBA/OWNER only (it could be
changed before release).
Non-privileged user see empty content, no error is raised (also could be
changed).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
