[Spacewalk-list] NVL keyword

Michael Mraka michael.mraka at redhat.com
Wed Jun 27 09:16:23 UTC 2012


Pierre Casenove wrote:
% Hello,
% After commit 69a1bcc647b89c36b35fcd5a735f6b521b612db4, I've looked at
% System_queries.xml file, searching for "NVL((SELECT 1" string.
% I found only one, in query
% 1199	<mode name="config_managed_systems">
% 1200	  <query name="available_to_user" />
% 1201	  <elaborator>
% 1202	SELECT S.id,
% 1203	       NVL((SELECT SCC.config_channel_id
...
% I was not able to find in which page this query is call, but it should
% fail on PGSQL.
% Is this query still used? If so, where in the code?

It's 99% unused.

% Thanks,
% 
% PIerre

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat




More information about the Spacewalk-list mailing list