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

Schema name must start with lower case #430

Open
bartkrekelberg opened this issue Mar 17, 2023 · 2 comments
Open

Schema name must start with lower case #430

bartkrekelberg opened this issue Mar 17, 2023 · 2 comments
Labels
awaiting-triage Issues awaiting proper priority/milestone assignment. bug

Comments

@bartkrekelberg
Copy link

Bug Report

Description

A schema name that starts with an upper case character (MySchema) will be created fine and works for the most part, but

  1. an edr cannot be generated (the regexp in edr.m searching for data tiers enforces lower case)
  2. creates confusing errors for joins, because the search for foreignkeys in dj.Table returns duplicate entries and ultimately generates spurious error messages about duplicate fields that need to be projected out. These errors disappear after clear classes, but reappear on the second run of the same query;

Reproducibility

Include:

Expected Behavior

Probably the easiest fix is to enforce a lower-case letter at the start of a schema name when the schema is first created.

@bartkrekelberg bartkrekelberg added awaiting-triage Issues awaiting proper priority/milestone assignment. bug labels Mar 17, 2023
@guzman-raphael
Copy link
Collaborator

@bartkrekelberg Good catch! Yes, this seems like a bug. It used to be that MySQL treated schema names as case-insensitive so we defaulted to lower-case but seems like that policy was not 100%.

@bartkrekelberg
Copy link
Author

Point 2 is a red herring. It had nothing to do with the case of the schema.. I'll file a different issue report for the underlying cause there later.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
awaiting-triage Issues awaiting proper priority/milestone assignment. bug
Projects
None yet
Development

No branches or pull requests

2 participants