Changeset: e70da4733b42 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/e70da4733b42
Added Files:
sql/test/proto_loader/odbc/Tests/monetodbc-Windows.test
Modified Files:
sql/test/proto_loader/odbc/Tests/All
Branch: Mar2025
Log Message:
Add a MS Windows specific test.
diffs (46 lines):
diff --git a/sql/test/proto_loader/odbc/Tests/All
b/sql/test/proto_loader/odbc/Tests/All
--- a/sql/test/proto_loader/odbc/Tests/All
+++ b/sql/test/proto_loader/odbc/Tests/All
@@ -1,3 +1,4 @@
incomplete_uri
-monetodbc
+NOT_WIN32?monetodbc
+!NOT_WIN32?monetodbc-Windows
# sqlite3odbc # test requires SQLite ODBC driver to be installed on test
servers (/usr/lib64/libsqlite3odbc.so)
diff --git a/sql/test/proto_loader/odbc/Tests/monetodbc-Windows.test
b/sql/test/proto_loader/odbc/Tests/monetodbc-Windows.test
new file mode 100644
--- /dev/null
+++ b/sql/test/proto_loader/odbc/Tests/monetodbc-Windows.test
@@ -0,0 +1,32 @@
+-- test with 'odbc:DSN=MonetDB;' protocol specification
+
+statement error 42000!SELECT: proto_loader function failed 'Invalid ODBC
connection string. Should start with 'DSN=' or 'DRIVER=' or 'FILEDSN='.'
+select * from proto_loader('odbc:Driver=/usr/lib64/libMonetODBC.so')
+
+statement error 42000!CATALOG: no such table returning function 'proto_loader'
+select * from proto_loader('odbc:DRIVER=/usr/lib64/libMonetODBC.so',
'monetdb', 'monetdb', 'SELECT * FROM INFORMATION_SCHEMA.TABLES')
+
+statement error 42000!SELECT: proto_loader function failed 'odbc_loader Could
not connect. SQLDriverConnect failed. SQLstate 08001, Errnr 0, Message
[MonetDB][ODBC Driver 11.51.5]could not connect: Connection refused'
+select * from proto_loader('odbc:DSN=MonetDB;QUERY=SELECT * FROM
INFORMATION_SCHEMA.TABLES')
+
+statement error 42000!SELECT: proto_loader function failed 'odbc_loader Could
not connect. SQLDriverConnect failed. SQLstate HY000, Errnr 556, Message
General error: Invalid file dsn '''
+select * from proto_loader('odbc:FILEDSN=MonetDB;QUERY=SELECT * FROM
INFORMATION_SCHEMA.TABLES')
+
+statement error 42000!SELECT: proto_loader function failed 'odbc_loader Could
not connect. SQLDriverConnect failed. SQLstate IM002, Errnr 0, Message
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified'
+select * from proto_loader('odbc:DRIVER=MonetODBC.dll;QUERY=SELECT * FROM
INFORMATION_SCHEMA.TABLES')
+
+statement error 42000!SELECT: proto_loader function failed 'odbc_loader Could
not connect. SQLDriverConnect failed. SQLstate IM002, Errnr 0, Message
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified'
+select * from
proto_loader('odbc:DRIVER=/usr/lib64/libMonetODBC.so;UID=monetdb;PWD=monetdb;QUERY=SELECT
* FROM INFORMATION_SCHEMA.TABLES')
+
+statement error 42000!SELECT: proto_loader function failed 'odbc_loader Could
not connect. SQLDriverConnect failed. SQLstate 08001, Errnr 0, Message
[MonetDB][ODBC Driver 11.51.5]could not connect: Connection refused'
+select * from
proto_loader('odbc:DSN=MonetDB;UID=monetdb;PWD=monetdb;QUERY=SELECT * FROM
INFORMATION_SCHEMA.TABLES')
+
+statement error 42000!SELECT: proto_loader function failed 'odbc_loader Could
not connect. SQLDriverConnect failed. SQLstate 08001, Errnr 0, Message
[MonetDB][ODBC Driver 11.51.5]could not connect: Connection refused'
+select * from
proto_loader('odbc:DSN=MonetDB;Database=demo;UID=monetdb;PWD=monetdb;QUERY=SELECT
* FROM INFORMATION_SCHEMA.TABLES')
+
+statement error 42000!SELECT: proto_loader function failed 'odbc_loader Could
not connect. SQLDriverConnect failed. SQLstate 08001, Errnr 0, Message
[MonetDB][ODBC Driver 11.51.5]could not connect: Connection refused'
+select * from
proto_loader('odbc:DSN=MonetDB;Database=mTests_sql_test_proto_loader_odbc;UID=monetdb;PWD=monetdb;QUERY=SELECT
* FROM INFORMATION_SCHEMA.TABLES')
+
+statement error 42000!SELECT: proto_loader function failed 'odbc_loader Could
not connect. SQLDriverConnect failed. SQLstate 08001, Errnr 0, Message
[MonetDB][ODBC Driver 11.51.5]could not connect: Connection refused'
+select * from
proto_loader('odbc:DSN=MonetDB;Database=mTests_sql_test_proto_loader_odbc;Port=40655;UID=monetdb;PWD=monetdb;QUERY=SELECT
* FROM INFORMATION_SCHEMA.TABLES')
+
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
