[sql] create a view for air - Cacher Snippet

3/3/2016 - 12:10 AM

[sql] create a view for air

create_a_view_for_air

create_view_air.sql

CREATE VIEW air_a630_g3_latest_compiler_release AS SELECT * FROM air_promote_records WHERE project = 'a630' AND air_group = 3 AND component = 'compiler' AND status_info = 'REL_DONE' AND air_promote_vid > (SELECT MAX(air_promote_vid) FROM air_promote_records WHERE project = 'a630' AND air_group = 3 AND component = 'compiler' AND status_info = 'REL_USED' ) ORDER BY air_promote_vid ASC LIMIT 1