Ticket #973 (closed defect: fixed)

Opened 15 months ago

Last modified 10 months ago

Missing IN() when used in Where clauses

Reported by: duoduo Owned by: romanb
Priority: blocker Milestone:
Component: Query/Hydration Version: 2.0-DEV
Severity: Keywords: where clause in
Cc: Has Test: no
Status: Pending Core Response Has Patch: no

Description

Running a query 

$conn->query("FROM TABLE t WHERE t.firstId = 1 AND t.secondId IN(46) AND t.complete = 1");

Produces the where clause (From Dumped Doctrine_Connection_Mysql_Exception) 

WHERE (v.websiteid = 1 AND  AND v.encodecomplete = 1)

The IN(46) is complete removed. I can do this with a Doctrine Query also, same results. The example all imply that IN() is valid.

Change History

Changed 15 months ago by romanb

What if you insert a space before the opening parenthesis? $conn->query("FROM TABLE t WHERE t.firstId = 1 AND t.secondId IN (46) AND t.complete = 1");

Changed 15 months ago by duoduo

  • status changed from new to closed
  • resolution set to fixed

romanb, That actually did it. It now works, but is it valid to be whitespace sensitive between the ()?

Thanks again.

Changed 15 months ago by duoduo

  • status changed from closed to reopened
  • resolution fixed deleted

Changed 15 months ago by duoduo

Sorry closed it by accident. romanb please close this if it is not a valid bug.

Changed 15 months ago by jwage

  • version changed from 0.10 to 0.11
  • milestone set to 1.0.0

Changed 14 months ago by jwage

  • version changed from 0.11 to Trunk
  • milestone changed from 1.0.0 to 2.0.0

Changed 11 months ago by guilhermeblanco

  • status changed from reopened to closed
  • mystatus set to Pending Core Response
  • has_patch unset
  • resolution set to fixed
  • has_test unset

Fixed in trunk

Changed 11 months ago by guilhermeblanco

  • milestone changed from 2.0.0 to 1.0.0-RC1

This ticket was addressed in an early stage in a revision I cannot find. Moving to 1.0 branch and marking it as fixed. Added coverage to this situation in changesets r4797 and r4798.

Changed 10 months ago by anonymous

  • milestone New deleted

Milestone New deleted

Note: See TracTickets for help on using tickets.