Not certain how this can be fixed. Followed steps in the build instructions, but am concerned that 27% of the test passed.
Any suggestions on how to fix this?
`Test project /Users/<>/clickhouse-odbc/build
Start 1: clickhouse-odbc-ut
1/22 Test #1: clickhouse-odbc-ut ................. Passed 0.12 sec
Start 2: clickhouse-odbc-load-ut
2/22 Test #2: clickhouse-odbc-load-ut ............ Passed 0.07 sec
Start 3: clickhouse-odbc-load-ut-w
3/22 Test #3: clickhouse-odbc-load-ut-w .......... Passed 0.04 sec
Start 4: clickhouse-odbc-client-it-dsn-0
4/22 Test #4: clickhouse-odbc-client-it-dsn-0 ....***Failed 1.15 sec
Start 5: clickhouse-odbc-client-it-dsn-1
5/22 Test #5: clickhouse-odbc-client-it-dsn-1 ....***Failed 1.09 sec
Start 6: clickhouse-odbc-nano-it-dsn-0
6/22 Test #6: clickhouse-odbc-nano-it-dsn-0 ......***Failed 0.02 sec
Start 7: clickhouse-odbc-nano-it-dsn-1
7/22 Test #7: clickhouse-odbc-nano-it-dsn-1 ......***Failed 0.02 sec
Start 8: clickhouse-odbcw-ut
8/22 Test #8: clickhouse-odbcw-ut ................ Passed 0.08 sec
Start 9: clickhouse-odbcw-load-ut
9/22 Test #9: clickhouse-odbcw-load-ut ........... Passed 0.03 sec
Start 10: clickhouse-odbcw-load-ut-w
10/22 Test #10: clickhouse-odbcw-load-ut-w ......... Passed 0.02 sec
Start 11: clickhouse-odbcw-client-it-dsn-0
11/22 Test #11: clickhouse-odbcw-client-it-dsn-0 ...***Failed 1.10 sec
Start 12: clickhouse-odbcw-client-it-dsn-1
12/22 Test #12: clickhouse-odbcw-client-it-dsn-1 ...***Failed 1.07 sec
Start 13: clickhouse-odbcw-nano-it-dsn-0
13/22 Test #13: clickhouse-odbcw-nano-it-dsn-0 .....***Failed 0.03 sec
Start 14: clickhouse-odbcw-nano-it-dsn-1
14/22 Test #14: clickhouse-odbcw-nano-it-dsn-1 .....***Failed 0.02 sec
Start 15: iodbctest-dsn-0
15/22 Test #15: iodbctest-dsn-0 ....................***Failed 0.03 sec
Start 16: test.sh-iodbctest-dsn-0
16/22 Test #16: test.sh-iodbctest-dsn-0 ............***Failed 0.02 sec
Start 17: iodbctestw-dsn-0
17/22 Test #17: iodbctestw-dsn-0 ...................***Failed 0.03 sec
Start 18: test.sh-iodbctestw-dsn-0
18/22 Test #18: test.sh-iodbctestw-dsn-0 ...........***Failed 0.02 sec
Start 19: iodbctest-dsn-1
19/22 Test #19: iodbctest-dsn-1 ....................***Failed 0.01 sec
Start 20: test.sh-iodbctest-dsn-1
20/22 Test #20: test.sh-iodbctest-dsn-1 ............***Failed 0.02 sec
Start 21: iodbctestw-dsn-1
21/22 Test #21: iodbctestw-dsn-1 ...................***Failed 0.01 sec
Start 22: test.sh-iodbctestw-dsn-1
22/22 Test #22: test.sh-iodbctestw-dsn-1 ...........***Failed 0.02 sec
27% tests passed, 16 tests failed out of 22
Total Test time (real) = 5.08 sec
The following tests FAILED:
4 - clickhouse-odbc-client-it-dsn-0 (Failed)
5 - clickhouse-odbc-client-it-dsn-1 (Failed)
6 - clickhouse-odbc-nano-it-dsn-0 (Failed)
7 - clickhouse-odbc-nano-it-dsn-1 (Failed)
11 - clickhouse-odbcw-client-it-dsn-0 (Failed)
12 - clickhouse-odbcw-client-it-dsn-1 (Failed)
13 - clickhouse-odbcw-nano-it-dsn-0 (Failed)
14 - clickhouse-odbcw-nano-it-dsn-1 (Failed)
15 - iodbctest-dsn-0 (Failed)
16 - test.sh-iodbctest-dsn-0 (Failed)
17 - iodbctestw-dsn-0 (Failed)
18 - test.sh-iodbctestw-dsn-0 (Failed)
19 - iodbctest-dsn-1 (Failed)
20 - test.sh-iodbctest-dsn-1 (Failed)
21 - iodbctestw-dsn-1 (Failed)
22 - test.sh-iodbctestw-dsn-1 (Failed)
Errors while running CTest
gmake: *** [Makefile:149: test] Error 8`
Looks like all of the failed tests are those that require a reachable ClickHouse server and properly configured DSNs.
By default, tests will be run for DSNs listed in TEST_DSN_LIST cmake option which is set to ${CH_ODBC_DEFAULT_DSN_ANSI};${CH_ODBC_DEFAULT_DSN_UNICODE} by default, where:
CH_ODBC_DEFAULT_DSN_ANSI cmake option is set to ClickHouse DSN (ANSI) by default, and it is -dsn-0 here,CH_ODBC_DEFAULT_DSN_UNICODE cmake option is set to ClickHouse DSN (Unicode) by default, and it is -dsn-1 here.
Do you have these DSNs configured in your system? Do they point to a running ClickHouse instance (preferably, version 20.3+)? Do they specifically point to these your freshly built driver binaries (one to ANSI, other to Unicode variants of the driver binary)?
Note this:
https://github.com/ClickHouse/clickhouse-odbc/blob/41201cd54914fc3bba4447299845f942fd13a6e5/README.md#L547-L549
ClickHouse
