ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '499281' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '499281' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '499281']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 499281 AND InstitucionPropia = 'S'
UNION
SELECT Adscripciones.Entidad FROM PublicacionesObras
JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion
JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado
WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 499281]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Proceedings Of The Annual Acm Symposium On Principles Of Distributed Computing Título del capítulo: Separating Lock-Freedom from Wait-Freedom
A long-standing open question has been whether lock-freedom and
wait-freedom are fundamentally different progress conditions, namely,
can the former be provided in situations where the latter cannot? This
paper answers the question in the affirmative, by proving that there are
objects with lock-free implementations, but without wait-free
implementations-using objects of any finite power.
We precisely define an object called n-process long-lived approximate
agreement (n-LLAA), in which two sets of processes associated with two
sides, 0 or 1, need to decide on a sequence of increasingly closer
outputs. We prove that 2-LLAA has a lock-free implementation using reads
and writes only, while n-LLAA has a lock-free implementation using
reads, writes and (n - 1)-process consensus objects. In contrast, we
prove that there is no wait-free implementation of the n-LLAA object
using reads, writes and specific (n - 1)-process consensus objects,
called (n - 1)-window registers.
Entidades citadas de la UNAM:
Fuente:
ISBN: 9781450357951 Editorial: Association for Computing Machinery