diff options
| -rw-r--r-- | src/iso19111/factory.cpp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/iso19111/factory.cpp b/src/iso19111/factory.cpp index 5eb6d012..cea0759c 100644 --- a/src/iso19111/factory.cpp +++ b/src/iso19111/factory.cpp @@ -3252,9 +3252,9 @@ DatabaseContext::getTransformationsForGridName( const DatabaseContextNNPtr &databaseContext, const std::string &gridName) { auto sqlRes = databaseContext->d->run( "SELECT auth_name, code FROM grid_transformation " - "WHERE grid_name = ? OR grid_name = " + "WHERE grid_name = ? OR grid_name IN " "(SELECT original_grid_name FROM grid_alternatives " - "WHERE proj_grid_name = ?)", + "WHERE proj_grid_name = ?) ORDER BY auth_name, code", {gridName, gridName}); std::vector<operation::CoordinateOperationNNPtr> res; for (const auto &row : sqlRes) { |