Skip to content

Column unquote bug #1587

@RuslanSibgatulin

Description

@RuslanSibgatulin

My application uses gorm to communicate with clickhouse database. The model has nested field. And when the data is inserted, the following query is generated:

INSERT INTO `table1` (`directory`.`id`,`directory`.`type`,`directory`.`path`) VALUES ((?,?),(?,?),(?,?))

But in function extractNormalizedInsertQueryAndColumns i see such column names, because it just trims them

["directory`.`id","directory`.`type","directory`.`path"]

columns[i] = strings.Trim(strings.Trim(strings.TrimSpace(columns[i]), "\""), "`")

As a result in function SortColumns i got error here

missing := difference(b.names, columns)
	if len(missing) > 0 {
		return fmt.Errorf("block cannot be sorted - missing columns in requested order: %v", missing)
	}

Please fix!

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No fields configured for Bug.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions