Log message #4180046

# At Username Text
# Mar 17th 2019, 11:12 birdy247 @edgaras.jan ok, will give it a go
# Mar 17th 2019, 11:06 edgaras.jan group+order doesn't work on mysql, you need group+having max
# Mar 17th 2019, 11:05 edgaras.jan try this sql `GROUP by CurrentPrices.id HAVING MAX(effective_from)=effective_from`
# Mar 17th 2019, 10:57 edgaras.jan check what queries are generated, with DebugKit or query logging
# Mar 17th 2019, 10:54 birdy247 but... I am then not sure what hapens if I find an entity and contain many entities, each with a current_proce
# Mar 17th 2019, 10:54 birdy247 if I am a limit(1) it works
# Mar 17th 2019, 10:54 birdy247 this is the select startegy
# Mar 17th 2019, 10:52 birdy247 Its taking the last on the list
# Mar 17th 2019, 10:52 birdy247 My test fails
# Mar 17th 2019, 10:52 edgaras.jan ok
# Mar 17th 2019, 10:52 slackebot2 <birdy247>
# Mar 17th 2019, 10:51 edgaras.jan and revert to orderDesc
# Mar 17th 2019, 10:51 birdy247 thats what we want
# Mar 17th 2019, 10:51 birdy247 and orderDesc
# Mar 17th 2019, 10:51 edgaras.jan after orderAsc add group()
# Mar 17th 2019, 10:51 birdy247 so add a group in there?
# Mar 17th 2019, 10:50 slackebot2 <birdy247>
# Mar 17th 2019, 10:50 slackebot2 <birdy247>
# Mar 17th 2019, 10:49 edgaras.jan group('hasoneTable.primary.key')
# Mar 17th 2019, 10:48 birdy247 @edgaras.jan how do you mean groupByKey
# Mar 17th 2019, 10:47 edgaras.jan Adding gruop by key should return 1 result for each key
# Mar 17th 2019, 10:46 birdy247 ok tahnks
# Mar 17th 2019, 10:45 savant im headed to bed for now, but hopefulluy someone else can help
# Mar 17th 2019, 10:45 savant i wonder if we have a test for this
# Mar 17th 2019, 10:45 savant ooo that might be it
# Mar 17th 2019, 10:44 edgaras.jan https://github.com/cakephp/cakephp/blob/master/src/ORM/Association/Loader/SelectLoader.php#L474 I think here last latter duplicate result with same key overwrites former
# Mar 17th 2019, 10:44 birdy247 I am using the select strategy
# Mar 17th 2019, 10:43 savant please show the queries being produced
# Mar 17th 2019, 10:43 savant I wonder if its just unordered
# Mar 17th 2019, 10:43 savant thats for a first() call
# Mar 17th 2019, 10:43 savant well maybe it’ll call limit 1
# Mar 17th 2019, 10:43 savant whats the query it produces?
# Mar 17th 2019, 10:43 savant https://github.com/cakephp/cakephp/blob/master/src/Datasource/QueryTrait.php#L465
# Mar 17th 2019, 10:43 savant seems it’ll call limit(1) on it
# Mar 17th 2019, 10:41 birdy247 I amde a unit test to prove it
# Mar 17th 2019, 10:41 birdy247 It is always the last
# Mar 17th 2019, 10:41 savant I’ve never done this though
# Mar 17th 2019, 10:41 savant probably the first one
# Mar 17th 2019, 10:40 birdy247 the hasOne scenario I wrote above
# Mar 17th 2019, 10:40 savant wat
# Mar 17th 2019, 10:37 birdy247 @savant any ideas?