[MacPorts] #68970: libreoffice @7.6.3.2_1: depends unconditionally on unixODBC, which can lead to build conflicts

[MacPorts]

#68970: libreoffice @7.6.3.2_1: depends unconditionally on unixODBC, which can lead
to build conflicts
--------------------------+--------------------
  Reporter:  cooljeanius  |      Owner:  (none)
      Type:  defect       |     Status:  new
  Priority:  Normal       |  Milestone:
 Component:  ports        |    Version:  2.8.1
Resolution:               |   Keywords:
      Port:  libreoffice  |
--------------------------+--------------------

Comment (by ryandesign):

 Replying to [ticket:68970 cooljeanius]:
 > I'm wondering if this dependency could be switched to be a `path:`-style
 dependency instead?

 My initial thought is that I don't think it can, because I don't think
 unixODBC and libiodbc are drop-in replacements for one another. Of all the
 ports that depend on unixODBC today, only one does so using a
 `path:`-style dependency, and it's pure-odbc, and I'm not sure why I did
 it that way when I created that port, but that might have been during a
 brief period when I was trying to use `path:` dependencies for everything.
 But I am remembering, for example, the php*-odbc ports where a different
 patchfile and different configure args need to be used depending on
 whether unixODBC or libiodbc is selected by variant.

 Normally a port for a program that supports either unixODBC or libiodbc
 ''should'' have variants so that the user can choose which library will be
 used and if one is to be used by default it would be a good idea if all
 ports could agree on what that default should be.

 libreoffice only has unixODBC as a build dependency, which makes me think
 it does not use the library. I'm not sure what part of unixODBC it does
 use. Possibly that port is the same between the two ports and a `path:`
 dependency could be used.

 It might be nice if unixODBC and libiodbc didn't conflict. Whichever of
 them is "best" might stay where it is and the other one could move to a
 subdirectory of /opt/local/libexec. All ports that depend on it would have
 to change following that move.

-- 
Ticket URL: <https://trac.macports.org/ticket/68970#comment:1>
MacPorts <https://www.macports.org/>
Ports system for macOS