[Lsb-infrastructure] need query to pick library names

Denis Silakov silakov at ispras.ru
Thu Apr 17 00:42:06 PDT 2008


Wichmann, Mats D wrote:
> I'm sort of getting this to work, but there are overlaps
> and unclarities in the data that are confusing me.
> For example, I get libcrypt both arch-specific and
> arch-generic, while I get libc only arch-specific.
> The ArchLib.ALaid=1 entry for the former has a filled
> in ALrunname while for the latter it does not.
> For this exercise, because of what's done with the
> data, I need a library to appear in only one list.
>   
As far as I understand, those libs that have the same runname everywhere
should appear in the generic list only?

In this case you can simply use additional check when selecting runnames
for a specific arch, something like this:

SELECT * FROM ArchLib WHERE ALaid=2 AND ALlid NOT IN (SELECT ALlid FROM
ArchLib WHERE ALaid=1 AND ALrunname>'');

This will give us three libs (libc, libm and linker) that really have
different runnames on different architectures.
> Meanwhile, some libraries have all eight entries and
> I don't understand why - for example libQtSql.so.4 has
> eight otherwise identical entries - there's neither a
> difference in ALappearedin or ALrunname that would
> seem to justify having the separate entries.  There
> are few cases where the ALrunname is really different -
> mainly this the glibc set where there's a difference
> on IA64 (.so.6.1 instead of .so.6) plus the dynamic linker.
>   
The thing is that different lsbspec scripts (at least) require look for
a record for a specific architecture to be present in the ArchLib table
when generating stuff for that architecture.
It's a known problem and we plan to modify the scripts and remove the
extra records in future. However, we haven't consider this as a high
priority, since all generators and Navigator work fine at the current
state of art.
> I don't know if it's more helpful to start from the
> sql query I'm using or ignore my scratchings and
> produce one fresh...  I can mail it if anyone wants
> a look at it.
>   
Yes, I think I can help with this.

-- 
Regards,
Denis.



More information about the lsb-infrastructure mailing list