db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5974) Convert TIMESTAMP metadata columns to TIMESTAMP WITH TIMEZONE after we implement that datatype.
Date Wed, 31 Oct 2012 15:51:12 GMT
Rick Hillegas created DERBY-5974:
------------------------------------

             Summary: Convert TIMESTAMP metadata columns to TIMESTAMP WITH TIMEZONE after
we implement that datatype.
                 Key: DERBY-5974
                 URL: https://issues.apache.org/jira/browse/DERBY-5974
             Project: Derby
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 10.10.0.0
            Reporter: Rick Hillegas


After we implement TIMESTAMP WITH TIMEZONE, we should consider converting our existing TIMESTAMP
metadata columns to be TIMESTAMP WITH TIMEZONE. This may insulate us from the hiccups around
shifts between winter and summer time as seen, for instance, on DERBY-5966.

The current TIMEZONE metadata columns are:

SYSSTATEMENTS.LASTCOMPILED                                                               
                                      
SYSSTATISTICS.CREATIONTIMESTAMP                                                          
                                      
SYSTRIGGERS.CREATIONTIMESTAMP                                                            
                                      
SYSUSERS.LASTMODIFIED                                                                    
                                      

as seen by running the following script (which uses the DBMDWrapper routines attached to DERBY-3973):

connect 'jdbc:derby:memory:db;create=true';

create procedure registerPublicStaticMethods( in connectionURL varchar( 200 ), in printSQL
boolean )
language java parameter style java modifies sql data
external name 'DBMDWrapper.registerPublicStaticMethods';

call registerPublicStaticMethods( 'jdbc:default:connection', false );

select table_name || '.' || column_name
from table ( getColumns( null, null, '%', '%' ) ) s
where data_type = 93;


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message