CurtHagenlocher commented on code in PR #2698:
URL: https://github.com/apache/arrow-adbc/pull/2698#discussion_r2047088929
##########
csharp/test/Drivers/BigQuery/DriverTests.cs:
##########
@@ -346,5 +346,43 @@ public void QueryTimeoutTest()
}
}
}
+
+ /// <summary>
+ /// Validates if the driver can connect to a live server and
+ /// parse the results of multi-statements.
+ /// </summary>
+ [SkippableFact, Order(9)]
+ public void CanExecuteMultiStatementQuery()
+ {
+ foreach (BigQueryTestEnvironment environment in _environments)
+ {
+ AdbcConnection adbcConnection =
GetAdbcConnection(environment.Name);
+ AdbcStatement statement = adbcConnection.CreateStatement();
+ string query1 = "SELECT " +
+ "CAST(1 as INT64) as id, " +
+ "CAST(1.23 as FLOAT64) as number, " +
+ "PARSE_NUMERIC(\"4.56\") as decimal, " +
+
"PARSE_BIGNUMERIC(\"7.89000000000000000000000000000000000000\") as big_decimal,
" +
+ "CAST(True as BOOL) as is_active, " +
+ "'John Doe' as name, " +
+ "FROM_BASE64('YWJjMTIz') as data, " +
+ "CAST('2023-09-08' as DATE) as date, " +
+ "CAST('12:34:56' as TIME) as time, " +
+ "CAST('2023-09-08 12:34:56' as DATETIME) as datetime,
" +
+ "CAST('2023-09-08 12:34:56+00:00' as TIMESTAMP) as
timestamp, " +
+ "ST_GEOGPOINT(1, 2) as point, " +
+ "ARRAY[1, 2, 3] as numbers, " +
+ "STRUCT('John Doe' as name, 30 as age) as person," +
+ "PARSE_JSON('{\"name\":\"Jane Doe\",\"age\":29}') as
json";
+ string query2 = "SELECT " +
+ "CAST(1.7976931348623157e+308 as FLOAT64) as number,
" +
+
"PARSE_NUMERIC(\"9.99999999999999999999999999999999E+28\") as decimal, " +
+
"PARSE_BIGNUMERIC(\"5.7896044618658097711785492504343953926634992332820282019728792003956564819968E+37\")
as big_decimal";
+ string combinedQuery = query1 + ";" + query2 + ";";
+ statement.SqlQuery = combinedQuery;
+ QueryResult queryResult = statement.ExecuteQuery();
+ Tests.DriverTests.CanExecuteQuery(queryResult, 1,
environment.Name);
Review Comment:
I would expect this test to validate which of the two results is being
returned as this seems a critical part of the driver contract.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscr...@arrow.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
