Bug report #17719
Dragging and dropping MS SQL table in browser window causes overwriting of existing table
|Affected QGIS version:||2.18.14||Regression?:||No|
|Operating System:||WINDOWS 7||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||duplicate|
|Crashes QGIS or corrupts data:||Yes||Copied to github as #:||25615|
Today I experienced a very strange behaviour from the browser window working with tables in my MS SQL connection.
I inadvertently dragged and dropped a layer into the same connection/schema. The table was dropped and re-created with the same name, but all the data lost, and instead of the OBJECTID field I had created in the original SQL, it had created a QGISID (or similar) field.
In addition to this issue, I have great concerns with abilities within the browser window in regards to dragging and dropping layers and how new tables are created. This applies to PostGIS tables as well.
I'm not sure if this is a bug, or a feature request, but when working with database tables such as MS SQL, PostGIS, etc., why does the browser window have these abilities when the DB manager GUI such as MSSQL or PGAdmin, or other tools such as DataGrip, should be where these actions take place?