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 = '384179' 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 = '384179' 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 = '384179']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 384179 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= 384179]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Simultech 2012 - Proceedings Of The 2nd International Conference On Simulation And Modeling Methodologies, Technologies And Applications Título del capítulo: Simulation of shallow-water flows in complex bay-like domains
Computational domains; Finite difference scheme; Open boundaries; Shallow-water flow; Simulation of fluid dynamics problems; Finite difference method; Flow of water; Hydraulics; Numerical methods; Waterworks; Computer simulation
Resumen:
A new numerical method for the simulation of shallow-water flows in a bay-like domain is suggested. The method is based on the splitting of the original nonlinear operator by physical processes and by coordinates. An essential advantage of our finite difference splitting-based method versus others in the field is that it leads to a model allowing accurate simulation of shallow-water flows in a domain of an arbitrary shape with both closed and open boundaries, which besides may contain onshore parts inside (interior isles in the bay); the model also takes into account irregular bottom topography. Specially constructed approximations of the temporal and spatial derivatives result in second-order unconditionally stable finite difference schemes that conserve the mass and the total energy of the discrete inviscid unforced shallow-water system. Moreover, the potential enstrophy results to be bounded, oscillating in time within a narrow range. Therefore, the numerical solution, aside from being accurate from the mathematical point of view, appears to be physically adequate, inheriting a number of substantial properties of the original differential shallow-water system. Furthermore, the method can straightforwardly be implemented for distributed simulation of shallow-water flows on high-performance parallel computers. To test the method numerically, we start with the inviscid shallow-water model and verify the conservatism of the schemes in a simple computational domain. Then we introduce a domain with a more complex boundary consisting of closed and open segments, and consider more realistic viscous wind-driven shallow-water flows. Numerical experiments presented confirm the skills of the developed method.