Bug found - SQL 2012

Question

I just want to report a bug I found.  I've recently updated a database from SQL 2008 to SQL 2012.  This morning a daily procedure failed.  Upon further investigation I found a view had been updated as follows: 

SELECT     PolicyKey, Policy, PolicyStartDate, Sequence, Amendment, Status, RatingStatus, OldPolicy, ClientNumber, TransactionType, EffectiveDate, BillingType, NextBillingType, Reversed, BusinessLine, BranchCode, GroupCode, BrokerCode, PolicyEndDate, PreviousInsurerCode, PreviousPolicy, RequestLetter, RenewalCode, RenewalBusinessLine, NonRenewalRemark, AmendmentCode, AmendmentRemark, InsuredSince, InceptionDate, DatePrinted, PostDate, DatePosted, ShortRate, Subscription, LeadPolicyNumber, PrintPolicy, BusinessType, BrokersCancelDate, UploadedFromBroker, BrokerIDForInsured, IneligibleforPHIX AS HeldBy, HeldBy AS DateHeld, DateHeld AS HeldByUniID, HeldByUniID AS AddedBy, AddedBy AS DateAdded, DateAdded AS ChangedBy, ChangedBy AS DateChanged, DateChanged

FROM         GIMS.dbo.Policies

Please note the section where a field had been added to the table (IneligibleforPHIX) and SQL tried to compensate by adding the AS keyword to retain position.  This ultimately offset the entire result set by 1.  IE: 1 as 2, 2 as 3, 3 as 4, 4 as 5...  etc. and completely screwed up the data selection from it.

Answer 1

Please look at http://connect.microsoft.com for reporting bugs and issues.

---

Mohit K. Gupta --- MCTS, MCITP, MCC2011
My Blog OpsVault My MSDN Blog Twitter @SQLCAN