Oracle compatibility mode does not support create table with "at time zone " syntax

[GoogleCodeExporter]

Steps to reproduce:
What is the expected output? What do you see instead?

Following is valid oracle syntax:

create table testtable (somecolumn varchar2(10 char), mytimestamp timestamp 
default systimestamp at time zone '+01:00')

which should successfully create a table.  subsequently running

insert into testtable (somecolumn) values ('hi');
select * from testtable;

should return one row with the mytimestamp column automatically set to serves 
timestamp in the given time zone (here UTC+1).

What version of the product are you using? On what operating system, file
system, and virtual machine?

Version:  H2 1.3.151
Operating system:  Windows7 and RHEL5

How important/urgent is the problem for you?

Reduces effectiveness of using H2, can't use to load existing schema.

In your view, is this a defect or a feature request?
Defect, incompatibility with Oracle

Original issue reported on code.google.com by zarb...@googlemail.com on 8 Mar 2011 at 10:41

[GoogleCodeExporter]

btw, also affects select statement, e.g.

select myTimestamp at time zone '+02:00' from testtable

Original comment by zarb...@googlemail.com on 8 Mar 2011 at 10:43

[GoogleCodeExporter]

This is not a "defect". H2 doesn't claim to be 100% compatible with Oracle. If 
"incompatibility with Oracle" is a "defect" then all databases except Oracle 
are defective. 

I will add this feature request to the roadmap, but I don't think I will 
implement it anytime soon. If you need this feature, I suggest to provide a 
patch.

Original comment by thomas.t...@gmail.com on 11 Mar 2011 at 2:43

• Changed state: InRoadmap