tracker issue : CF-4122530

Duplicate ID:	CF-4126391

Problem Description:

Having a cachedWithin argument with a non-zero value in a cfquery, query.cfc or queryExecute() results in an empty query object when duplicate() is used.

Steps to Reproduce:

Run this:

  tempQuery = queryNew( "id,name", "integer,varchar" );
  queryAddRow( tempQuery );
  querySetCell( tempQuery, "id", 1, 1 );
  querySetCell( tempQuery, "name", "test", 1 );

  q1 = duplicate( tempQuery );

  sql = "SELECT * FROM q1";
  options = {
    dbType = "query"
    , cachedWithin = createTimeSpan( 0, 0, 3, 0 )
  };

  q2 = duplicate( queryExecute( sql, [], options ));

  q1recordCount = q1.recordCount;
  q2recordCount = q2.recordCount;

  writeDump( q1 );
  writeDump( q1recordCount );

  writeDump( q2 );
  writeDump( q2recordCount );


Actual Result:

query
 	ID	NAME
1	1	test
1
query
1

Expected Result:

query
 	ID	NAME
1	1	test
1
query
 	ID	NAME
1	1	test
1

Any Workarounds:

Don't use duplicate() or remove the cachedWithin argument (or set it to 0)

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

Watson Bug ID:	4122530

External Customer Info:
External Company:  
External Customer Name: Mingo Hagen
External Customer Email:  
External Test Config: My Hardware and Environment details:

CF2016 on Windows 10

Attachments:

Comments: