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

Case sensitive column names not preserved in PK with ysql_dump #6368

Closed
fitcs01 opened this issue Nov 13, 2020 · 2 comments
Closed

Case sensitive column names not preserved in PK with ysql_dump #6368

fitcs01 opened this issue Nov 13, 2020 · 2 comments
Labels
area/ysql Yugabyte SQL (YSQL)

Comments

@fitcs01
Copy link
Contributor

fitcs01 commented Nov 13, 2020

CREATE TABLE table1 ( "UpperI" int, c char, PRIMARY KEY ("UpperI"));

table def in ysql_dump output:

--
-- Name: table1; Type: TABLE; Schema: public; Owner: yugabyte

CREATE TABLE public.table1 (
"UpperI" integer NOT NULL,
c character(1),
PRIMARY KEY((UpperI) HASH)
);

table fails to create - any copy command then spews a load of errors ( if nulls then \N is sighted as the problem ) but this is due to table create failure.

@ddorian ddorian added the area/ysql Yugabyte SQL (YSQL) label Nov 13, 2020
@tedyu
Copy link
Contributor

tedyu commented Nov 14, 2020

Have you seen #6061 ?

The column name would be correctly quoted for PRIMARY KEY with commit deae758

@ddorian
Copy link
Contributor

ddorian commented Nov 19, 2020

Hi @fitcs01

This issue has been fixed in 2.5.0.0.
Can you try that https://github.com/yugabyte/yugabyte-db/releases ?

@ddorian ddorian closed this as completed Nov 19, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL)
Projects
None yet
Development

No branches or pull requests

3 participants