SELECT (sometimes) returning Zero Rows?
От | Matt Friedman |
---|---|
Тема | SELECT (sometimes) returning Zero Rows? |
Дата | |
Msg-id | 006a01c095f7$68865a30$e8804318@mattq3h8budilr обсуждение исходный текст |
Ответы |
Re: SELECT (sometimes) returning Zero Rows?
|
Список | pgsql-general |
We are having what seems like a baffling problem to me. On occasion, our SELECTs will return zero rows when we know with certainty that they should be returning at least some rows. No error occurs, the select just behaves as if the db is empty or something. The queries on the page are all selects. No inserts or updates so I didn't see the need for a transaction. I can't see why that would help anyway. I've included the selects from the page below. Anyone have an experience like this? Please let me know if more info is req'd. SELECT pr_article.title, pr_article.article_id FROM pr_article WHERE pr_article.article_id = pr_article_age.article_id AND pr_article_age.age_id = 1 AND pr_article.is_active = true AND pr_article.is_approved = true AND pr_article.release_date < 982093578 AND ((pr_article.end_date = 0) or (pr_article.end_date > 982093578 )) ORDER BY pr_article.release_date DESC LIMIT 2 SELECT pr_article.title, pr_article.article_id FROM pr_article WHERE pr_article.article_id = pr_article_age.article_id AND pr_article_age.age_id = 1 AND pr_article.is_active = true AND pr_article.is_approved = true AND pr_article.release_date < 982093578 AND ((pr_article.end_date = 0) or (pr_article.end_date > 982093578 )) ORDER BY pr_article.release_date DESC LIMIT 3 SELECT DISTINCT ON (release_date, article_id) pr_article.title, pr_article.article_id, pr_cat.prog_name FROM pr_article WHERE pr_article.article_id = pr_article_age.article_id AND pr_article_age.age_id = 1 AND pr_article_cat.cat_id=pr_cat.cat_id AND pr_article.article_id = pr_article_cat.article_id AND pr_article.is_active = true AND pr_article.is_approved = true AND pr_article.release_date < 982093578 AND ((pr_article.end_date = 0) or (pr_article.end_date > 982093578 )) ORDER BY pr_article.release_date DESC LIMIT 5 SELECT DISTINCT ON (pr_cat.name) pr_cat.name, pr_cat.prog_name FROM pr_article, pr_article_age, pr_article_cat, pr_cat WHERE pr_article_age.age_id = 1 AND pr_article_age.article_id = pr_article.article_id AND pr_article.article_id = pr_article_cat.article_id AND pr_article_cat.cat_id = pr_cat.cat_id AND pr_article.is_active = true AND pr_article.is_audio = false AND pr_article.is_approved = true AND pr_article.release_date < 982093578 AND ((pr_article.end_date = 0) or (pr_article.end_date > 982093578 )) Matt Friedman
В списке pgsql-general по дате отправления: