[Vasileios Thanasias Has successfully completed the online course Basics (100)]

1 year ago #38275

Hi, I have noticed that the orders of column are not kept, during a package transport.
We have the schema below

But when we packaged it and transport it to another system (Prod), I have the schema below (columns sorted alphabetically?)

So I needed to define the column names on Insert query, to insert the values on the correct column.

Is that a known issue?

 

Attachments:

You must be logged in to view attached files.

[Jennifer Häfner Has successfully completed the online course Intermediate (200)Has successfully completed the online course Advanced (300)Has successfully completed the online course Basics (100)Has successfully completed the online course Advanced (310)Has successfully completed the online course Advanced (320)Has successfully completed the Intermediate CertificationHas successfully completed the Advanced Certification]

1 year ago #38307

Up

0

Down

::

Hi Vasileios,

Thanks for pointing that out! We will look into this issue. Since I cannot say when this issue will be resolved, it’s best to always specify the column names when inserting values. This way, you can be sure that the values will be inserted into the correct column.