[prev in list] [next in list] [prev in thread] [next in thread] 

List:       fdo-commits
Subject:    [fdo-commits] r7700 - sandbox/adsk/4.2.Q/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph
From:       svn_fdo () osgeo ! org
Date:       2018-06-21 7:43:34
Message-ID: 20180621074334.7FA0E390200 () trac ! osgeo ! org
[Download RAW message or body]

Author: christinebao
Date: 2018-06-21 00:43:34 -0700 (Thu, 21 Jun 2018)
New Revision: 7700

Modified:
   sandbox/adsk/4.2.Q/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/ColumnGeom.cpp
Log:
MySQL: Spatial function SRID() is deprecated in MySQL 5.7.6. Use ST_SRID() instead.

Modified: sandbox/adsk/4.2.Q/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/ColumnGeom.cpp
 ===================================================================
--- sandbox/adsk/4.2.Q/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/ColumnGeom.cpp	2018-06-20 \
                02:28:09 UTC (rev 7699)
+++ sandbox/adsk/4.2.Q/Providers/GenericRdbms/Src/MySQL/SchemaMgr/Ph/ColumnGeom.cpp	2018-06-21 \
07:43:34 UTC (rev 7700) @@ -1,5 +1,5 @@
 /*
- * Copyright (C) 2004-2006  Autodesk, Inc.
+ * Copyright (C) 2004-2018  Autodesk, Inc.
  * 
  * This library is free software; you can redistribute it and/or
  * modify it under the terms of version 2.1 of the GNU Lesser
@@ -26,7 +26,7 @@
 	{
 		FdoSmPhDbObjectP dbObject = this->GetContainingDbObject();
 		FdoStringP sqlStmt = FdoStringP::Format(
-			L"select SRID(%ls) as srid from %ls", (FdoString*)this->GetDbName(), \
(FdoString*)dbObject->GetDbName()); +			L"select ST_SRID(%ls) as srid from %ls", \
(FdoString*)this->GetDbName(), (FdoString*)dbObject->GetDbName());  FdoSmPhMySqlMgrP \
mgr = this->GetManager()->SmartCast<FdoSmPhMySqlMgr>();  GdbiConnection* gdbiConn = \
mgr->GetGdbiConnection();  GdbiQueryResult *gdbiResult = \
gdbiConn->ExecuteQuery((const char*)sqlStmt);

_______________________________________________
fdo-commits mailing list
fdo-commits@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/fdo-commits


[prev in list] [next in list] [prev in thread] [next in thread]