| # |
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? |
| # |
Mar 17th 2019, 10:31 |
birdy247 |
@lorenzo any ideas? |