Views
#2320: translate constraints with availability_status any fails mysteriously
View
(Anonymous)
issuedata
Topic:
D0
Classification:
User Problem
Importance:
Medium
Assigned to: herber
Created by: illingwo
Created at: 2006-10-24
contact
Name:
Robert Illingworth
E-Mail:
illingwo@fnal.gov
Description:
> sam translate constraints --count --dim='__set__ already_in_cache and availability_status any' ORA-00942: table or view does not exist . This is somehow generating a SQL query ending with "and (data_files.file_id) in (select xxx from xxx where 'join'='join'))". It also fails if I manually paste the already_in_cache defintion dimensions into my query string, so __set__ isn't the cause, but if I remove all the parentheses then it works as expected. . (The already_in_cache definition is effectively obsolete, but this might also affect other, more useful, queries.)
Transcript
#6:
2008-02-28 04:26 PM (malik)
status: "accepted" ->
"resolved"
#5:
2007-04-18 04:41 PM (herber)
Leave this problem open. - It is a real problem and the pending fix for a related problem does NOT fix this problem. Have been able to reconstruct the problem with the new code. - Randolph J. Herber <herber@fnal.gov> Untrusted issue submission: no verification possible
#4:
2007-04-18 03:01 PM (herber)
I never worked on this problem. The problem still exists. There is a fix coming for a related problem and that fix may fix this problem as well. - I suggest leaving it open. - Randolph J. Herber <herber@fnal.gov> Untrusted issue submission: no verification possible
#3:
2007-04-18 01:57 PM (lima)
Hi, Just checking whether this issue could be closed. Can it, Randolph? Thanks, Guilherme D0 SAM shifter
#2:
2006-10-26 10:41 AM (swhite)
assignees: "['SamCore']" ->
"['herber']"
#1:
2006-10-24 12:30 PM (illingwo)
status: "pending" ->
"accepted"
assignees: "[]" ->
"['SamCore']"
topic: "" ->
"D0"
title: "" ->
"translate constraints with availability_status any fails mysteriously "
description: "" ->
"> sam translate constraints --count --dim='__set__ already_in_cache and availability_status any'
ORA-00942: table or view does not exist
.
This is somehow generating a SQL query ending with "and (data_files.file_id) in (select xxx from xxx where 'join'='join'))". It also fails if I manually paste the already_in_cache defintion dimensions into my query string, so __set__ isn't the cause, but if I remove all the parentheses then it works as expected.
.
(The already_in_cache definition is effectively obsolete, but this might also affect other, more useful, queries.)
"
PloneCollectorNG (C) 2003-2004 by ZOPYX - Software Development and Consulting Andreas Jung