Skip to content

Sometimes the INSERT statement comes out out of order #25

@jjmontes

Description

@jjmontes

Describe the bug

With some tables or datasets, the lines are mixed up when generating the INSERT statement. For example, when executing this:

[dbo].[GenerateInsert] 
	@ObjectName = 'CLIENTE',
	@PopulateIdentityColumn = 1,
	@SearchCondition = 'clienteId IN (26)'

This result is generated:

--INSERTs generated by GenerateInsert (Build 6)
--Project page: http://github.com/drumsta/sql-generate-insert
SET NOCOUNT ON
SET IDENTITY_INSERT CLIENTE ON
INSERT INTO CLIENTE
VALUES
 (26,'AD51D492-79DD-434B-88E4-AAAA',NULL,1,0,NULL)
SET IDENTITY_INSERT CLIENTE OFF
([clienteId],[token],[IdGDS],[informa],[bloqueado],[idMigra])

When it should generate this:

--INSERTs generated by GenerateInsert (Build 6)
--Project page: http://github.com/drumsta/sql-generate-insert
SET NOCOUNT ON
SET IDENTITY_INSERT CLIENTE ON
INSERT INTO CLIENTE
([clienteId],[token],[IdGDS],[informa],[bloqueado],[idMigra])
VALUES
 (26,'AD51D492-79DD-434B-88E4-AAAA',NULL,1,0,NULL)
SET IDENTITY_INSERT CLIENTES OFF

To Reproduce

I couldn't find a criterion where this occurs

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions