Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Uppercased columns for Airtable FDW never return a value #171

Open
2 tasks done
imor opened this issue Oct 11, 2023 · 1 comment
Open
2 tasks done

Uppercased columns for Airtable FDW never return a value #171

imor opened this issue Oct 11, 2023 · 1 comment
Labels
bug Something isn't working

Comments

@imor
Copy link
Contributor

imor commented Oct 11, 2023

Bug report

  • I confirm this is a bug with Supabase, not with my own application.
  • I confirm I have searched the Docs, GitHub Discussions, and Discord.

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

@imor imor added the bug Something isn't working label Oct 11, 2023
@janbaykara
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants