Changeset: fbaa5b03981a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/fbaa5b03981a
Modified Files:
sql/backends/monet5/vaults/shp/shp.c
Branch: geo-update
Log Message:
Fixed a bug in shapefile loading regarding upper case table names.
diffs (23 lines):
diff --git a/sql/backends/monet5/vaults/shp/shp.c
b/sql/backends/monet5/vaults/shp/shp.c
--- a/sql/backends/monet5/vaults/shp/shp.c
+++ b/sql/backends/monet5/vaults/shp/shp.c
@@ -214,7 +214,7 @@ str createSHPtable(Client cntxt, str sch
//Build the CREATE TABLE command
snprintf(buf, size, CRTTBL, schemaTable, temp_buf);
-
+ //And execute it
msg = SQLstatementIntern(cntxt, buf, "shp.load", TRUE, FALSE, NULL);
GDKfree(buf);
@@ -483,6 +483,10 @@ str SHPload(Client cntxt, MalBlkPtr mb,
spatial_info = GDALWGetSpatialInfo(shp_conn);
field_definitions = GDALWGetSimpleFieldDefinitions(shp_conn);
+ /* Convert schema and table name to lower case*/
+ schemaname = toLower(schemaname);
+ tablename = toLower(tablename);
+
/* Create table for outputting shapefile data */
if ((msg = createSHPtable(cntxt, schemaname, tablename, shp_conn,
field_definitions)) != MAL_SUCCEED)
{
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
