https://issues.qgis.org/https://issues.qgis.org/favicon.ico2014-07-24T13:15:59ZQGIS Issue TrackingQGIS Application - Feature request #10946: Non-integer key columns in MSSQLhttps://issues.qgis.org/issues/10946?journal_id=546932014-07-24T13:15:59ZJürgen Fischerjef@norbit.de
<ul><li><strong>Tracker</strong> changed from <i>Bug report</i> to <i>Feature request</i></li></ul> QGIS Application - Feature request #10946: Non-integer key columns in MSSQLhttps://issues.qgis.org/issues/10946?journal_id=546942014-07-24T13:37:11ZNathan Woodrow
<ul></ul><blockquote><blockquote>
<p>I've also noticed that "STIntersects()" is used to query the currently visible elements - I think you should consider using "Filter()" to get (much) better performance.</p>
</blockquote></blockquote>
<p>Can you open a new ticket for this.</p> QGIS Application - Feature request #10946: Non-integer key columns in MSSQLhttps://issues.qgis.org/issues/10946?journal_id=546962014-07-24T13:50:37ZMarkus Woehling
<ul></ul><p>I've opened two new tickets <a class="issue tracker-1 status-5 priority-4 priority- closed" href="https://issues.qgis.org/issues/11076" title="MSSQL vector layer filtering problem (Closed)">#11076</a> and <a class="issue tracker-2 status-1 priority-4 priority-" href="https://issues.qgis.org/issues/10948" title="Use SELECT query as data source in MSSQL (Open)">#10948</a></p> QGIS Application - Feature request #10946: Non-integer key columns in MSSQLhttps://issues.qgis.org/issues/10946?journal_id=598382015-03-06T03:51:01ZJürgen Fischerjef@norbit.de
<ul></ul><p>Support for arbitrary keys was added to the postgresql provider in <a class="changeset" href="https://issues.qgis.org/projects/qgis/repository/revisions/ce4fc1daa5b49d053790b258d1361a2203282453" title="[FEATURE][API] postgres provider refactoring: - use m prefix for member variables and s prefix fo...">ce4fc1da</a>. The oracle provider also implements <code>pktFidMap</code> type keys.</p> QGIS Application - Feature request #10946: Non-integer key columns in MSSQLhttps://issues.qgis.org/issues/10946?journal_id=616562015-05-31T20:22:52ZNathan Woodrow
<ul><li><strong>Assignee</strong> set to <i>Nathan Woodrow</i></li></ul> QGIS Application - Feature request #10946: Non-integer key columns in MSSQLhttps://issues.qgis.org/issues/10946?journal_id=634482015-08-31T10:39:33ZAli Dibaadiba@spatialwave.com
<ul></ul><p>You should allow for supporting Global Unique <abbr title="entifier">ID</abbr> which is a unique 16 byte number. This is refereed to as GUID and UNIQUEIDENTIFIER within the SQL Server community. GUIDs are very important when it comes to data collection from multiple disconnected devices. This is the only way to guarantee merging of the data from all devices while avoiding conflicts.</p> QGIS Application - Feature request #10946: Non-integer key columns in MSSQLhttps://issues.qgis.org/issues/10946?journal_id=766602017-04-30T22:47:47ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Easy fix?</strong> set to <i>No</i></li></ul>