Ticket #427 (closed Bug: fixed)

Opened 9 months ago

Last modified 9 months ago

Bug in $db->in()

Reported by: allain Owned by: Shadowhand
Priority: critical Milestone: 2.2
Component: Libraries:Database Version: SVN HEAD
Keywords: database not in ternary Cc:

Description

$this->db->select('DISTINCT id, content_type, filepath');

->from('blocks_resources'); ->join('resources', 'blocks_resources.resource_id = resources.id'); ->in('blocks_resources.block_id', array(0=>1));

Doesn't generate valid SQL for mysql.

Attachments

Database.php.patch (457 bytes) - added by allain 9 months ago.

Change History

Changed 9 months ago by allain

Changed 9 months ago by allain

Seems it was an order of operations bug.

Changed 9 months ago by Shadowhand

  • keywords database not in ternary added
  • owner changed from zombor to Shadowhand
  • status changed from new to assigned

Changed 9 months ago by Shadowhand

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

Fixed in r2122.

Changed 9 months ago by Shadowhand

  • milestone changed from 2.1.2 to 2.2

This depends on r2058, which cannot be merged into a point release.

Note: See TracTickets for help on using tickets.