odbc_scan_oracle.test

# # name: test/sql/odbc_scan_oracle.test
# # description: test odbc_scanner extension
# # group: [odbc_scan]
#
# # Before we load the extension, this will fail
# # statement error
# # SELECT * FROM odbc_scan(
# #   'Driver=/nix/store/03d2ih9gj622raq02gqzm5971dgvxhwh-oracle-driver-11.5.8/lib/liboracle.dylib;Hostname=localhost;Database=kohls;Uid=oracleinst1;Pwd=password;Port=50000',
# #   'oracleinst1',
# #   'people'
# # );
# # ----
# # statement error
# # SELECT * FROM odbc_scan(
# #   'Driver=/opt/homebrew/Cellar/psqlodbc/15.00.0000/lib/psqlodbca.so;Server=localhost;Database=odbc_scanner_duckdb_extension_test;Uid=postgres;Pwd=password;Port=5432',
# #   'oracleinst1',
# #   'people'
# # );
# # ----
# # Catalog Error: Table Function with name odbc_scan does not exist!
# statement error
# SELECT * FROM odbc_scan(
#   'Driver=/nix/store/py6m0q4ij50pwjk6a5f18qhhahrvf2sk-oracle-driver-11.5.8/lib/liboracle.so;Hostname=localhost;Database=odbctest;Uid=oracleinst1;Pwd=password;Port=50000',
#   'DB2INST1',
#   'PEOPLE'
# );
# ----
# Catalog Error: Table Function with name odbc_scan does not exist!
#
# # Require statement will ensure this test is run with this extension loaded
# require odbc_scanner
#
# # Confirm the extension works
# # query I
# # SELECT * FROM odbc_scan(
# #   'Driver=/nix/store/03d2ih9gj622raq02gqzm5971dgvxhwh-oracle-driver-11.5.8/lib/liboracle.dylib;Hostname=localhost;Database=kohls;Uid=oracleinst1;Pwd=password;Port=50000',
# #   'oracleinst1',
# #   'people'
# # );
# # query I
# # SELECT * FROM odbc_scan(
# #   'Driver=/opt/homebrew/Cellar/psqlodbc/15.00.0000/lib/psqlodbca.so;Server=localhost;Database=odbc_scanner_duckdb_extension_test;Uid=postgres;Pwd=password;Port=5432',
# #   'oracleinst1',
# #   'people'
# # );
# # ----
# query I
# SELECT * FROM odbc_scan(
#   'Driver=/nix/store/py6m0q4ij50pwjk6a5f18qhhahrvf2sk-oracle-driver-11.5.8/lib/liboracle.so;Hostname=localhost;Database=odbctest;Uid=oracleinst1;Pwd=password;Port=50000',
#   'DB2INST1',
#   'PEOPLE'
# );
# ----
# Lebron James    37      100.10
# Spiderman       25      200.20
# Wonder Woman    21      300.30
# David Bowie     68      400.40