Changeset: c6152e684632 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/c6152e684632
Removed Files:
sql/test/proto_loader/odbc/Tests/chinook.db
sql/test/proto_loader/odbc/Tests/libsqlite3odbc-0.99991.so
Modified Files:
sql/test/proto_loader/odbc/Tests/All
sql/test/proto_loader/odbc/Tests/sqlite3odbc_local.test.in
Branch: Mar2025
Log Message:
We do not want to have random binary data in our repository: move to external.
diffs (147 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
@@ -2,4 +2,4 @@ incomplete_uri
NOT_WIN32?monetodbc
!NOT_WIN32?monetodbc-Windows
# NOT_WIN32?sqlite3odbc # test requires SQLite ODBC driver to be
installed on test servers (/usr/lib64/libsqlite3odbc.so)
-NOT_WIN32?sqlite3odbc_local
+NOT_WIN32&HAVE_DATA_PATH?sqlite3odbc_local
diff --git a/sql/test/proto_loader/odbc/Tests/chinook.db
b/sql/test/proto_loader/odbc/Tests/chinook.db
deleted file mode 100644
index
38a98b391b7a6e8e740cae9681b5f0b295848fcc..0000000000000000000000000000000000000000
GIT binary patch
literal 0
Hc$@<O00001
diff --git a/sql/test/proto_loader/odbc/Tests/libsqlite3odbc-0.99991.so
b/sql/test/proto_loader/odbc/Tests/libsqlite3odbc-0.99991.so
deleted file mode 100755
index
687c5a42487dfc9fbd02abfcafc013e7e09d1f3c..0000000000000000000000000000000000000000
GIT binary patch
literal 0
Hc$@<O00001
diff --git a/sql/test/proto_loader/odbc/Tests/sqlite3odbc_local.test.in
b/sql/test/proto_loader/odbc/Tests/sqlite3odbc_local.test.in
--- a/sql/test/proto_loader/odbc/Tests/sqlite3odbc_local.test.in
+++ b/sql/test/proto_loader/odbc/Tests/sqlite3odbc_local.test.in
@@ -2,24 +2,24 @@
-- test with
'odbc:DRIVER=/home/dinther/dev/dev/MonetDB/sql/test/proto_loader/odbc/Tests/libsqlite3odbc-0.99991.so;Database=/home/dinther/dev/dev/MonetDB/sql/test/proto_loader/odbc/Tests/chinook.db;QUERY=SELECT
...' protocol specification
statement error 42000!SELECT: proto_loader function failed 'odbc_loader Could
not connect. SQLDriverConnect failed. SQLstate HY000, Errnr 14, Message
[SQLite]connect failed'
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;QUERY=SELECT *
FROM INFORMATION_SCHEMA.TABLES')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;QUERY=SELECT
* FROM INFORMATION_SCHEMA.TABLES')
statement error 42000!SELECT: proto_loader function failed 'odbc_loader Could
not connect. SQLDriverConnect failed. SQLstate HY000, Errnr 14, Message
[SQLite]connect failed'
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;Database=~/Downloads/sqlite_dbs/chinook.db;QUERY=SELECT
* FROM INFORMATION_SCHEMA.TABLES')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;Database=~/Downloads/sqlite_dbs/chinook.db;QUERY=SELECT
* FROM INFORMATION_SCHEMA.TABLES')
statement error 42000!SELECT: proto_loader function failed 'odbc_loader
SQLExecDirect query failed. SQLstate HY000, Errnr 1, Message [SQLite]no such
table: INFORMATION_SCHEMA.TABLES (1)'
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;Database=odbc_loader_test.db;QUERY=SELECT
* FROM INFORMATION_SCHEMA.TABLES')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;Database=odbc_loader_test.db;QUERY=SELECT
* FROM INFORMATION_SCHEMA.TABLES')
query TTT nosort
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;Database=odbc_loader_test.db;QUERY=SELECT
type, name, tbl_name FROM sqlite_schema ORDER BY 1,2,3')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;Database=odbc_loader_test.db;QUERY=SELECT
type, name, tbl_name FROM sqlite_schema ORDER BY 1,2,3')
----
query TTTIT nosort
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;Database=odbc_loader_test.db;QUERY=SELECT
* FROM sqlite_schema ORDER BY 1,2,3')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;Database=odbc_loader_test.db;QUERY=SELECT
* FROM sqlite_schema ORDER BY 1,2,3')
----
query TTTT nosort
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;Database=$TSTSRCDIR/chinook.db;QUERY=SELECT
tbl_name, type, name, sql FROM sqlite_schema ORDER BY 1,2 DESC,3')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;Database=$TSTDATAPATH/sqlite3odbc/chinook.db;QUERY=SELECT
tbl_name, type, name, sql FROM sqlite_schema ORDER BY 1,2 DESC,3')
----
albums
table
@@ -119,7 +119,7 @@ IFK_TrackMediaTypeId
CREATE INDEX [IFK_TrackMediaTypeId] ON "tracks" ([MediaTypeId])
query TI nosort
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;Database=$TSTSRCDIR/chinook.db;QUERY=SELECT
* FROM sqlite_sequence')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;Database=$TSTDATAPATH/sqlite3odbc/chinook.db;QUERY=SELECT
* FROM sqlite_sequence')
----
genres
25
@@ -143,7 +143,7 @@ playlists
18
query TTT nosort
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;Database=$TSTSRCDIR/chinook.db;QUERY=SELECT
* FROM sqlite_stat1')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;Database=$TSTDATAPATH/sqlite3odbc/chinook.db;QUERY=SELECT
* FROM sqlite_stat1')
----
tracks
IFK_TrackMediaTypeId
@@ -192,22 +192,22 @@ IFK_InvoiceLineInvoiceId
2240 6
query ITI nosort
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;Database=$TSTSRCDIR/chinook.db;QUERY=SELECT
* FROM albums')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;Database=$TSTDATAPATH/sqlite3odbc/chinook.db;QUERY=SELECT
* FROM albums')
----
1041 values hashing to 5629d90611e126ef86cf716bffff1fe9
query IT nosort
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;Database=$TSTSRCDIR/chinook.db;QUERY=SELECT
* FROM artists')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;Database=$TSTDATAPATH/sqlite3odbc/chinook.db;QUERY=SELECT
* FROM artists')
----
550 values hashing to f6d93e6eefe9276280048f02224c4b2f
query ITTTTTTTTTTTI nosort
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;Database=$TSTSRCDIR/chinook.db;QUERY=SELECT
* FROM customers')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;Database=$TSTDATAPATH/sqlite3odbc/chinook.db;QUERY=SELECT
* FROM customers')
----
767 values hashing to ac1c25f0abde32d6a592ad4c74375e6c
query IT nosort
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;Database=$TSTSRCDIR/chinook.db;QUERY=SELECT
* FROM genres')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;Database=$TSTDATAPATH/sqlite3odbc/chinook.db;QUERY=SELECT
* FROM genres')
----
1
Rock
@@ -261,17 +261,17 @@ 25
Opera
query IIIRI nosort
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;Database=$TSTSRCDIR/chinook.db;QUERY=SELECT
* FROM invoice_items')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;Database=$TSTDATAPATH/sqlite3odbc/chinook.db;QUERY=SELECT
* FROM invoice_items')
----
11200 values hashing to a9e3a705e7d0f104f12537d7a4452fc8
query IITTTTTTR nosort
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;Database=$TSTSRCDIR/chinook.db;QUERY=SELECT
* FROM invoices')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;Database=$TSTDATAPATH/sqlite3odbc/chinook.db;QUERY=SELECT
* FROM invoices')
----
3708 values hashing to 6468e5558d61ab41f736750792ceb3a0
query IT nosort
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;Database=$TSTSRCDIR/chinook.db;QUERY=SELECT
* FROM media_types')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;Database=$TSTDATAPATH/sqlite3odbc/chinook.db;QUERY=SELECT
* FROM media_types')
----
1
MPEG audio file
@@ -285,12 +285,12 @@ 5
AAC audio file
query II nosort
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;Database=$TSTSRCDIR/chinook.db;QUERY=SELECT
* FROM playlist_track')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;Database=$TSTDATAPATH/sqlite3odbc/chinook.db;QUERY=SELECT
* FROM playlist_track')
----
17430 values hashing to b3662845bff3c7fd8568b8b25033d188
query IT nosort
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;Database=$TSTSRCDIR/chinook.db;QUERY=SELECT
* FROM playlists')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;Database=$TSTDATAPATH/sqlite3odbc/chinook.db;QUERY=SELECT
* FROM playlists')
----
1
Music
@@ -330,7 +330,7 @@ 18
On-The-Go 1
query ITIIITIIR nosort
-select * from
proto_loader('odbc:DRIVER=$TSTSRCDIR/libsqlite3odbc-0.99991.so;Database=$TSTSRCDIR/chinook.db;QUERY=SELECT
* FROM tracks')
+select * from
proto_loader('odbc:DRIVER=$TSTDATAPATH/sqlite3odbc/libsqlite3odbc-0.99991.so;Database=$TSTDATAPATH/sqlite3odbc/chinook.db;QUERY=SELECT
* FROM tracks')
----
31527 values hashing to 9bdd4fdb9d8b354b75169ce5bddbda76
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
