[ARROW-17013] [C++][CI] Ubuntu cpp 22.04 nightly tests fail to build flight_sql_test

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 9.0.0
• Component/s: C++
• Labels: Nightly pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/32325
• Assignee: Raúl Cumplido
• Reporter: Raúl Cumplido
• Created: 08/Jul/22 08:53
• Updated: 11/Jan/23 11:48
• Resolved: 08/Jul/22 20:54

Description

https://github.com/ursacomputing/crossbow/runs/7243793233?check_suite_focus=true

Nightly tests build test-ubuntu-22.04-cpp is failing with the following error:

 -- Linking Arrow Flight tests statically due to static gRPC
-- Found SQLite3Alt: /usr/lib/x86_64-linux-gnu/libsqlite3.so  
CMake Error at src/arrow/flight/sql/CMakeLists.txt:122 (target_compile_definitions):
  Cannot specify compile definitions for target "flight_sql_test" which is
  not built by this project. 

This seems to have been introduced by:

https://github.com/apache/arrow/commit/9c93f82a06ecae4d0e51f64b25fc63d32701d734#diff-4468e915a60403c2fd3bbfcc296580954fe7e992520b5f63af0592dddf08fee0

It can be reproduced locally with:

UBUNTU=22.04 docker-compose run ubuntu-cpp 

Issue Links

• links to: GitHub Pull Request #13547