ompharate commented on issue #36305:
URL: https://github.com/apache/superset/issues/36305#issuecomment-3588829628
I can reproduce a hard failure on current `master` related to CSV upload
when `schema` is left empty.
### Steps to reproduce
1. Upload a CSV
2. Enter a table name
3. Leave **Schema** empty
4. Click **Upload**
### Actual behavior
Superset generates invalid SQL:
```sql
CREATE TABLE undefined.algoritham1 (
"Algorithm" TEXT,
"Purpose / Application" TEXT
);
````
PostgreSQL fails with:
```
psycopg2.errors.InvalidSchemaName: schema "undefined" does not exist
```
### Expected behavior
Either:
* default to the database default schema (e.g. `public`), or
* mark the schema field as required and block submission, or
* omit schema entirely when not provided.
### Notes
* The Schema field is not marked as required in the UI and shows no
validation error.
* Selecting an explicit schema (e.g. `public`) works correctly.
* This appears to be a frontend → backend contract mismatch when `schema` is
undefined.
<img width="1011" height="728" alt="Image"
src="https://github.com/user-attachments/assets/1c59c025-9c03-436c-935e-12fc97004cc3";
/>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
