GeometryDDL does not consider table schema in Oracle

[perliedman]

I'm using Oracle 11g and have mapped a table like this:

        geometry_table = Table('Geometry', metadata,
            Column('id', Integer, primary_key=True),
            GeometryExtensionColumn('geometry', Geometry(srid=3006)),
            schema='test'
        )
        GeometryDDL(geometry_table)

The table is created properly with the expected schema ("test"), but when GeometryDDL adds the geometry column, it executes this statement:

ALTER TABLE Geometry ADD geometry SDO_GEOMETRY

Note that it's missing both proper quoting and schema. I would expect the statement to be:

ALTER TABLE "test"."Geometry" ADD "geometry" SDO_GEOMETRY

Looking at the code, it appears to ignore schemas and quoting issues all together.

Is this a known issue? Is there some way to work around this?

[elemoine]

Probably a bug. Oracle hasn't received much attention and testing. Patch welcome.

[perliedman]

Can't promise anything, since I don't use Oracle on a regular basis, and I don't know that much about it, but I'll try to find some time for this.