The syscs_diag.error_log_reader() vti does not work on derby error logs created 
since 10.7.1
--------------------------------------------------------------------------------------------

                 Key: DERBY-5391
                 URL: https://issues.apache.org/jira/browse/DERBY-5391
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.8.1.2, 10.7.1.1, 10.9.0.0
            Reporter: Rick Hillegas


The format of timestamps in Derby logs seems to have changed. As a result, the 
ErrorLogReader vti can't parse the text of derby.log. That vti is looking for 
the literal string "GMT" in order to locate timestamps.

To reproduce the problem, run ij with -Dderby.language.logStatementText=true 
and issue the following query:

  select * from table (syscs_diag.error_log_reader( )) as t1;

You will get an empty result.

This regression was not caught by our tests because SysDiagVTIMappingTest uses 
a hardcoded derby.log created by version "10.3.0.0 alpha".

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Reply via email to