On Wed, Mar 5, 2014 at 4:36 PM, Esteban A. Maringolo <emaringolo@gmail.com> wrote:

[I'm cross posting Pharo-dev mailing list too]

Hi Pharo developers,

I'm having an issue while performing a not so common db query (but not
esoteric either).
And it seems the version I'm using in Pharo is outdated compared with
the latest version they're using in VW.

Is there an official maintaner and/or updater of the Glorp port for Pharo?

No. The first time, we did ir (me, Esteban Lorenzano, Guillermo Polito, etc). We took certain version of the VW version. I will try to search which one. After that, no one that I am aware of did a another port again.�

�

I'm using the GlorpDriverPostgreSQL, and the Glorp package from
SmalltalkHub (Glorp-MarianoMartinezPeck.88).
I don't have any DBXTalk stuff in my image.

So you are using Glorp + native postgres driver.�

�

Do we know how old is the Pharo branch from VisualWorks?

Quite a bit. let me see if I find which one...

�

Regards!

Esteban A. Maringolo


2014-03-05 15:50 GMT-03:00 Alan Knight <knight@acm.org>:
> I think that whatever version it is it's an old one, because that looks like
> a bug that was fixed some while ago. It's not putting in the subselect table
> in the from clause. I would hope that the Pharo port would list somewhere
> which Glorp version it was built from. �There's code to generate a
> Squeak/Pharo port from the VisualWorks version, and the code tries to be
> entirely portable in the core, but I never got fixes back from the last
> porting effort to incorporate, so there are probably some divergences.
>
>
> On 5 March 2014 10:31, Esteban A. Maringolo <emaringolo@gmail.com> wrote:
>>
>> Hi Tom,
>>
>> It might have to do with the Pharo version of Glorp. I get the exact
>> same error as with Alan's suggestion.
>> ...
>> I there any way I can know which version of Glorp I'm running in Pharo?

>> 2014-03-03 18:21 GMT-03:00 Tom Robinson <zxrobinson@gmail.com>:
>> > Hi Esteban,
>> >
>> > I was able to execute the following query, equivalent to what you're
>> > trying
>> > to do on the current dev build of VisualWorks connected to a Store
>> > repository running in PostgreSQL.
>> >
>> > � � | session query |
>> > � � session := StoreLoginFactory currentStoreSession.
>> > � � query read: StorePackage
>> > � � � � where: [:each | | subQuery |
>> > � � � � � � subQuery := Query read: StorePackage
>> > � � � � � � � � where: [:eachPkg| �eachPkg name = each name].
>> > � � � � � � subQuery retrieveMax: [:eachPkg | eachPkg timestamp ].
>> > � � � � � � each timestamp = subQuery].
>> > � � session execute: query.
>> >
>> > This appears to be what you're trying to do.

--
You received this message because you are subscribed to the Google Groups "glorp-group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to glorp-group+unsubscribe@googlegroups.com.
To post to this group, send email to glorp-group@googlegroups.com.
Visit this group at http://groups.google.com/group/glorp-group.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mariano
http://marianopeck.wordpress.com