Changeset: 1174204c9c26 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/1174204c9c26
Modified Files:
sql/test/proto_loader/odbc/Tests/monetodbc.test
Branch: Mar2025
Log Message:
Change tests
diffs (33 lines):
diff --git a/sql/test/proto_loader/odbc/Tests/monetodbc.test
b/sql/test/proto_loader/odbc/Tests/monetodbc.test
--- a/sql/test/proto_loader/odbc/Tests/monetodbc.test
+++ b/sql/test/proto_loader/odbc/Tests/monetodbc.test
@@ -1,4 +1,4 @@
--- test with 'odbc:DRIVER=/usr/lib64/libMonetODBC.so;' protocol specification
+-- test with 'odbc:DSN=MonetDB-Test;' 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:Dsn=MonetDB-Test')
@@ -7,16 +7,18 @@ statement error 42000!CATALOG: no such t
select * from proto_loader('odbc:DSN=MonetDB-Test', 'monetdb', 'monetdb',
'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
[unixODBC][Driver Manager]Data source name not found and no default driver
specified'
-select * from proto_loader('odbc:DSN=MonetDB-Test;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
[unixODBC][Driver Manager]Data source name not found and no default driver
specified'
select * from proto_loader('odbc:FILEDSN=MonetDB-Test;QUERY=SELECT * FROM
INFORMATION_SCHEMA.TABLES')
statement error 42000!SELECT: proto_loader function failed 'odbc_loader Could
not connect. SQLDriverConnect failed. SQLstate 01000, Errnr 0, Message
[unixODBC][Driver Manager]Can't open lib 'libMonetODBC' : file not found'
select * from proto_loader('odbc:DRIVER=libMonetODBC;QUERY=SELECT * FROM
INFORMATION_SCHEMA.TABLES')
-statement error 42000!SELECT: proto_loader function failed 'odbc_loader Could
not connect. SQLDriverConnect failed. SQLstate 01000, Errnr 0, Message
[unixODBC][Driver Manager]Can't open lib '/usr/lib64/libMonetODBC.so' : file
not found'
-select * from
proto_loader('odbc:DSN=MonetDB-Test;UID=monetdb;PWD=monetdb;QUERY=SELECT * FROM
INFORMATION_SCHEMA.TABLES')
+query II
+select * from
proto_loader('odbc:DSN=MonetDB-Test;UID=monetdb;PWD=monetdb;QUERY=SELECT
schema_id, table_id FROM INFORMATION_SCHEMA.TABLES WHERE table_name =
''_tables'' order by 1,2')
+----
+2000
+2067
+2114
+2115
query I
select id from 'odbc:DSN=MonetDB-Test;QUERY=select id from sys._tables where
name = ''_tables'' order by id'
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
