[teiid-issues] [JBoss JIRA] Commented: (TEIID-933) AdminShell taking exception to a query that's executing in the Designer

AdminShell taking exception to a query that's executing in the Designer ----------------------------------------------------------------------- Key: TEIID-933 URL: https://jira.jboss.org/jira/browse/TEIID-933 Project: Teiid Issue Type: Bug Components: Tools Affects Versions: 7.0 Environment: Fedora 12, OpenJDK Server VM (build 14.0-b16, mixed mode), Teiid build 1/19/2010 Reporter: Paul Nittel Assignee: Steven Hawkins Attachments: E2eTpcrTextMetadataTestScript.odt, TpcrTest.vdb, TpcrTextMetadataFiles.zip I'm executing the TPCR quesier and #7 is failing in AdminShell. It does successfully execute in SQL Explorer. The query being executed is: select * from vTpcr.Q07 ORDER BY supp_nation, cust_nation, l_year The transformation behind the query is: SELECT supp_nation, cust_nation, l_year, SUM(volume) AS revenue FROM (SELECT n1.N_NAME AS supp_nation, n2.N_NAME AS cust_nation, YEAR(L_SHIPDATE) AS l_year, (L_EXTENDEDPRICE * (1 - L_DISCOUNT)) AS volume FROM TPCR.SUPPLIER, TPCR.LINEITEM, TPCR.ORDERS, TPCR.CUSTOMER, TPCR.NATION AS n1, TPCR.NATION AS n2 WHERE (S_SUPPKEY = L_SUPPKEY) AND (O_ORDERKEY = L_ORDERKEY) AND (C_CUSTKEY = O_CUSTKEY) AND (S_NATIONKEY = n1.N_NATIONKEY) AND (C_NATIONKEY = n2.N_NATIONKEY) AND (((n1.N_NAME = 'FRANCE') AND (n2.N_NAME = 'GERMANY')) OR ((n1.N_NAME = 'GERMANY') AND (n2.N_NAME = 'FRANCE'))) AND (L_SHIPDATE BETWEEN {ts'1995-01-01 00:00:00.0'} AND {ts'1996-12-31 00:00:00.0'})) AS shipping GROUP BY supp_nation, cust_nation, l_year Executing the transformation query in AdminShell also fails. AdminShell provides this error information: select * from vTpcr.Q07; // Error: // Uncaught Exception: TargetError : at Line: 241 : in file: URL: jar:file:/home/pnittel/Teiid0119/teiid-adminshell-7.0.0-SNAPSHOT/lib/teiid-adminshell-7.0.0-SNAPSHOT.jar!/scripts/jdbc.bsh : throw e ; Called from method: execute : at Line: 4 : in file: <unknown file> : execute ( "select * from vTpcr.Q07" ) Target exception: com.metamatrix.jdbc.MMSQLException: com.metamatrix.api.exception.MetaMatrixComponentException Many files will be attached.