tracker issue : CF-3519030

select a category, or use search below
(searches all categories and all time range)
Title:

There seems to be regression for "select where between" clause in Query of Query.

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/NotABug

Reporter/Name(from Bugbase): / ext-user (Gaurav Tiwari)

Created: 03/13/2013

Components: Database, Query-of-Query(IMQ)

Versions: 11.0

Failure Type:

Found In Build/Fixed In Build: CF Alpha /

Priority/Frequency: Major / Most users will encounter

Locale/System: English / Mac 10 All,Win XP All

Vote Count: 1

Problem:
There seems to be regression for "select where between" clause in Query of Query.

Consider following query :
<CFQUERY NAME="queryfromquery" DBTYPE="QUERY"> 
select * from queryfromdb where id between '160' and '163'
</cfquery>

The above used to return all entries whose id lies between 160 and 163 also including id=163 but with new behavior its not returning id=163. Run test case for more details



Method:

Result:

Expected:

Workaround:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3519030

External Customer Info:
External Company:  
External Customer Name:  
External Customer Email:

Attachments:

Comments:

Moving to Beta , this is a user issue .We will see how many customers encounter this issue in alpha based on that we will take a call.The data in the database is of type varchar and using numbers so the space the end was not getting trimmed and hence the issue is caused.
Comment by Asha K.
16022 | March 18, 2013 02:24:27 AM GMT
This happened because of changelist 283871. Previously, Query of Query was trimming strings which led to bug CF-3180467. So we fixed that by not trimming strings. The value coming from db in this case is '163 ' The problem that arises now is that '163 ' is greater than '163' when you compare them as strings. I think this is valid and we shouldn't fix it. The testcase needs to be changed.
Comment by Himavanth R.
16023 | October 24, 2013 05:30:14 AM GMT
Experiencing the exact same issue. We have the same source that has been in a production eCommerce site using CF9, CF10, but after upgrading our test environment to CF11, we are unable to get query results as the issue as stated in bug CF-3950189 and as stated here.
Vote by External U.
16024 | January 27, 2016 02:12:26 PM GMT