Home Dashboard Directory Help
Search

order by datetime in ODBC fails for clean SQL statements by myMDSNdn


Status: 

Closed
 as Won't Fix Help for as Won't Fix


2
0
Sign in
to vote
Type: Bug
ID: 767196
Opened: 10/12/2012 8:39:25 AM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

Please read my post here:
http://dba.stackexchange.com/questions/25761/sql-server-2008-datetime-index-performance-bug

Basically we can put a SQL comment in front of a query using an indexed datetime order by clause and get something to work that is otherwise not working through ODBC. See samples below.

We can reproduce, and can upload a sample database we created (privately) to MS for testing and verification of this bug.

Attached is a zip file. You will need to change the destination directory for the database and the location of the text file to load, both are commented in the sql file within.
Details
Sign in to post a comment.
Posted by Microsoft on 2/8/2013 at 8:24 AM
Thanks for your feedback. Unfortunately we will not be able to address this because of other priority work.
Posted by myMDSNdn on 2/7/2013 at 12:29 PM
Where you able to reproduce with the data provided? Was this a duplicate? I'd appreciate any additional information you can provide. This is still an issue for our production server.
Posted by Microsoft on 11/30/2012 at 8:12 AM
Thanks for your feedback. Our developers are looking into the issue.
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
bug_sample_data.zip (restricted) 10/12/2012 -