[C++][Integration] `libarrow_c_data_integration.so` isn't built with `ARROW_BUILD_TESTS=ON` and `ARROW_BUILD_INTEGRATION=ON`

[kou]

Describe the bug, including details regarding any error messages, version, and platform.

GH-47888 added libarrow_c_data_integaration.so but it's not built with ARROW_BUILD_TESTS=ON and ARROW_BUILD_INTEGRATION=ON. So integration test is failed with:

##########################################################
C Data Interface: C++ exporting, C++ importing
##########################################################
Traceback (most recent call last):
  File "/data/arrow/verify-rc/arrow-23.0.0.5QcOA/venv-source/bin/archery", line 7, in <module>
    sys.exit(archery())
             ~~~~~~~^^
  File "/data/arrow/verify-rc/arrow-23.0.0.5QcOA/venv-source/lib/python3.13/site-packages/click/core.py", line 1485, in __call__
    return self.main(*args, **kwargs)
           ~~~~~~~~~^^^^^^^^^^^^^^^^^
  File "/data/arrow/verify-rc/arrow-23.0.0.5QcOA/venv-source/lib/python3.13/site-packages/click/core.py", line 1406, in main
    rv = self.invoke(ctx)
  File "/data/arrow/verify-rc/arrow-23.0.0.5QcOA/venv-source/lib/python3.13/site-packages/click/core.py", line 1873, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
                           ~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^
  File "/data/arrow/verify-rc/arrow-23.0.0.5QcOA/venv-source/lib/python3.13/site-packages/click/core.py", line 1269, in invoke
    return ctx.invoke(self.callback, **ctx.params)
           ~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/arrow/verify-rc/arrow-23.0.0.5QcOA/venv-source/lib/python3.13/site-packages/click/core.py", line 824, in invoke
    return callback(*args, **kwargs)
  File "/data/arrow/verify-rc/arrow-23.0.0.5QcOA/apache-arrow-23.0.0/dev/archery/archery/cli.py", line 813, in integration
    run_all_tests(testers, other_testers, **args)
    ~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/data/arrow/verify-rc/arrow-23.0.0.5QcOA/apache-arrow-23.0.0/dev/archery/archery/integration/runner.py", line 740, in run_all_tests
    runner.run_c_data()
    ~~~~~~~~~~~~~~~~~^^
  File "/data/arrow/verify-rc/arrow-23.0.0.5QcOA/apache-arrow-23.0.0/dev/archery/archery/integration/runner.py", line 161, in run_c_data
    self._compare_c_data_implementations(producer, consumer)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^
  File "/data/arrow/verify-rc/arrow-23.0.0.5QcOA/apache-arrow-23.0.0/dev/archery/archery/integration/runner.py", line 472, in _compare_c_data_implementations
    with producer.make_c_data_exporter() as exporter:
         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^
  File "/data/arrow/verify-rc/arrow-23.0.0.5QcOA/apache-arrow-23.0.0/dev/archery/archery/integration/tester_cpp.py", line 145, in make_c_data_exporter
    return CppCDataExporter(self.debug, self.args)
  File "/data/arrow/verify-rc/arrow-23.0.0.5QcOA/apache-arrow-23.0.0/dev/archery/archery/integration/tester_cpp.py", line 181, in __init__
    self.dll = _load_ffi(self.ffi)
               ~~~~~~~~~^^^^^^^^^^
  File "/data/arrow/verify-rc/arrow-23.0.0.5QcOA/apache-arrow-23.0.0/dev/archery/archery/integration/tester_cpp.py", line 170, in _load_ffi
    dll = ffi.dlopen(lib_path)
  File "/data/arrow/verify-rc/arrow-23.0.0.5QcOA/venv-source/lib/python3.13/site-packages/cffi/api.py", line 150, in dlopen
    lib, function_cache = _make_ffi_library(self, name, flags)
                          ~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^
  File "/data/arrow/verify-rc/arrow-23.0.0.5QcOA/venv-source/lib/python3.13/site-packages/cffi/api.py", line 834, in _make_ffi_library
    backendlib = _load_backend_lib(backend, libname, flags)
  File "/data/arrow/verify-rc/arrow-23.0.0.5QcOA/venv-source/lib/python3.13/site-packages/cffi/api.py", line 829, in _load_backend_lib
    raise OSError(msg)
OSError: cannot load library '/data/arrow/verify-rc/arrow-23.0.0.5QcOA/cpp-build/release/libarrow_c_data_integration.so': /data/arrow/verify-rc/arrow-23.0.0.5QcOA/cpp-build/release/libarrow_c_data_integration.so: cannot open shared object file: No such file or directory.  Additionally, ctypes.util.find_library() did not manage to locate a library called '/data/arrow/verify-rc/arrow-23.0.0.5QcOA/cpp-build/release/libarrow_c_data_integration.so'
Failed to verify release candidate. See /data/arrow/verify-rc/arrow-23.0.0.5QcOA for details.

Component(s)

C++, Integration

[raulcd]

Yes, I don't think this is a release blocker.I did ran INTEGRATION and TEST separately:

TEST_DEFAULT=0 TEST_SOURCE=0 TEST_SOURCE_REPRODUCIBLE=0 TEST_INTEGRATION=1 ./dev/release/verify-release-candidate.sh 23.0.0 2

This was successful for me.