From c44a3008b0edb5197b0efa584d3f5f7e18d79b0b Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Mon, 24 May 2021 13:59:32 +0200
Subject: DatabaseContext::getTransformationsForGridName(): make it work
 properly when different EPSG grid names map to the same PROJ grid name

---
 src/iso19111/factory.cpp | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'src')

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) {
-- 
cgit v1.2.3