if (column.isGenerated && column.generationStrategy === "increment") // don't use skipPrimary here since updates can update already exist primary without auto inc.

c += " AUTO_INCREMENT";

if (column.comment)

c += ` COMMENT '${column.comment}'`;

c += ` COMMENT '${column.comment.replace("'", "''")}'`;

if (column.default !== undefined && column.default !== null)

c += ` DEFAULT ${column.default}`;

if (column.onUpdate)

import {Entity, PrimaryColumn} from "../../../../src";

@Entity()

export class Session {

@PrimaryColumn({

comment: "That's the way the cookie crumbles"

})

cookie: string = "";

}

import "reflect-metadata";

import {createTestingConnections, closeTestingConnections} from "../../utils/test-utils";

import {QueryFailedError, Connection} from "../../../src";

import {Session} from "./entity/Session";

import {expect} from "chai";

describe("github issues > #6066 Column comment string is not escaped during synchronization", () => {

let connections: Connection[];

before(async () => connections = await createTestingConnections({

entities: [Session],

enabledDrivers: ["mysql", "mariadb"],

schemaCreate: false,

dropSchema: true,

}));

after(() => closeTestingConnections(connections));

it("should synchronize", () => Promise.all(connections.map(connection => {

return expect(connection.synchronize()).to.not.be.rejectedWith(QueryFailedError);

})));

});