supabase / wrappers

Postgres Foreign Data Wrapper development framework in Rust.
http://fdw.dev
Apache License 2.0
557 stars 54 forks source link

Uppercased columns for Airtable FDW never return a value #171

Open imor opened 1 year ago

imor commented 1 year ago

Bug report

Describe the bug

Quoted column names with uppercase letters do not return a value for Airtable wrapper.

To Reproduce

  1. Create a foreign data table with a quoted column name with an uppercase letter:
create foreign table my_foreign_table (
  "Full Name" text
)
server airtable_server
options (
  base_id 'appXXXX',
  table_id 'tblXXXX'
);
  1. Run select * from my_foreign_table.
  2. Note that the Full Name column never returns a value.

Expected behavior

The Full Name column should return a value.

Screenshots

N/A

System information

Reproducible on latest wrappers ref.

Additional context

N/A

janbaykara commented 8 months ago

I'm also encountering this! A hilarious bug but quite a blocker for big established Airtable bases whose column names can't easily be changed without many things breaking.