SELECT 1; is not a valid query to test connection for DB2 iseries ODBC connection

[ThiccPan]

Bug Description

using
SELECT 1;
is not a valid query to test the connection in db2. Is it possible to use this query instead if the connected database is a db2 database
select 1 from sysibm.sysdummy1;

Minimal Reproduction

1. Initialized connection to a db2 using odbc.
2. Wait until ping_blocking function is called

Info

• SQLx version: [0.6]
• SQLx features enabled: [ "runtime-tokio-native-tls" , "mssql" , "odbc" , "chrono" ]
• Database server and version: (ODBC connection to db2 iseries database)
• Operating system: [windows 10]
• rustc --version: [rustc 1.90.0 (1159e78c4 2025-09-14)]

[lovasoa]

Thank you for reporting this ! Do you want to try and open a pull request ? I can guide you if you need. db2 is paid and proprietary, so I will need to trust you to test your changes locally

[lovasoa]

the offending code is here

sqlx-oldapi/sqlx-core/src/odbc/connection/mod.rs

Lines 123 to 129 in 645fd0d

	pub(crate) async fn ping_blocking(&mut self) -> Result<(), Error> {
	self.with_conn("ping", move |conn| {
	conn.execute("SELECT 1", (), None)?;
	Ok(())
	})
	.await
	}

and if you just want to work around the issue temporarily, you should be able to use test_before_acquire(false) https://docs.rs/sqlx-oldapi/latest/sqlx_oldapi/pool/struct.PoolOptions.html#method.test_before_acquire