Opened 7 years ago

Closed 7 years ago

Last modified 7 years ago

#1754 closed defect (duplicate)

Midgard Collector produces invalid SQL

Reported by: tepehe Owned by: piotras
Priority: major Milestone:
Component: Midgard Core Version: 9.09 Mjolnir
Keywords: Cc:

Description

If an empty array is given to collector (in following example) you'll end up having malformed SQL.

$mc = new midgard_collector('someobject', 'active',  true);
$mc->add_constraint('id', 'IN', $empty_array_or_null);
$mc->set_key_property('guid');
$mc->execute();

This should return empty resultset or throw an exception that empty array has been given for IN constraint. http://static.qaiku.com/dd8/6f6/ca4/dd86f6ca46bc11df83b0b7855095acc8acc8.gif

Change History (3)

comment:1 Changed 7 years ago by piotras

  • Milestone changed from 9.09.3 Mjolnir to 10.05.1 Ratatoskr
  • Status changed from new to assigned

Should be fixed with MidgardQueryData? class implementation.

comment:2 Changed 7 years ago by bergie

  • Resolution set to duplicate
  • Status changed from assigned to closed

comment:3 Changed 7 years ago by anonymous

  • Milestone 10.05.1 Ratatoskr deleted

Milestone 10.05.1 Ratatoskr deleted

Note: See TracTickets for help on using tickets.