Online validation can take in account VIEWS and EXTERNAL table
--------------------------------------------------------------
Key: CORE-4962
URL: http://tracker.firebirdsql.org/browse/CORE-4962
Project: Firebird Core
Issue Type: Bug
Components: Engine
Reporter: Pavel Zotov
Priority: Minor
Attachments: online-validation-checks-views-and-external-table.fbk.7z
Unpack attached .7z and restore database from .fbk
Then run:
$fb_home/bin/fbsvcmgr service_mgr action_validate dbname
<restored-database-name.fdb>
- with redirection to some log.
In that log one may see following lines:
===
17:03:08.61 Relation 137 (EXT_STOPTEST)
17:03:08.61 Relation 137 (EXT_STOPTEST) is ok
. . .
17:03:08.65 Relation 191 (V_QDISTR_SOURCE)
17:03:08.65 Relation 191 (V_QDISTR_SOURCE) is ok
17:03:08.65 Relation 192 (V_QSTORNED_SOURCE)
17:03:08.65 Relation 192 (V_QSTORNED_SOURCE) is ok
===
First relation is external table. Second and third - VIEWS with DDL like:
'select * from T1 union all select * from T2 union all ...'.
Validation should skip such kinds of DB objects.
PS. Also (IMHO) validation should always skip checking GTT because their data
will be stored in unknown places - AFAIK, this is so at least for CS.
--
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
