Re: [Gnumed-bugs] GNUmed 1.5.0 - needs one more fixup relating to test orgs?

[Karsten Hilbert]

On Fri, Jan 16, 2015 at 07:40:32AM +0100, Karsten Hilbert wrote:

>               insert into clin.test_org (fk_org_unit, comment)
>               select
>                       (select 1 from dem.org_unit where
>                               description = 'branch of unknown laboratory'
>                                       and
>                               fk_org = (select pk from dem.org where 
> description = 'unknown laboratory')
>                       ),
>                       'auto-generated by v20-clin-test_type-dynamic.sql'::text
>               where not exists (
>                       select 1 from clin.test_org where fk_org_unit = (
> =>                            select 1 from dem.org_unit where
>                                       description = 'branch of unknown 
> laboratory'
>                                               and
>                                       fk_org = (select pk from dem.org where 
> description = 'unknown laboratory')
>                       )
>               )
> 
> => this must be "select pk from dem.org_unit where" ...
> 
> That's why I always hope for people to test the upgrade with
> their respective databases. It worked in all three of mine
> (deploy, devel, public) since all of them do have a
> clin.test_org the fk_org_unit of which just so happens to be 1 :-)
> 
> Fixed for 1.5.2 to be released today.

Anyone needing a quicker fix can use the attached file.

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

v20-clin-test_type-dynamic.sql
Description: application/sql