Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv10393/src/test/BugTracker-2009/Tests
Added Files:
old_views_incorrectly_reused.SF-2863804.view1.sql
Log Message:
propagated changes of Monday Sep 21 2009 - Tuesday Sep 22 2009
from the Aug2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/09/21 - vzzzbx:
src/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.view1.sql,1.1.2.1
adding test for bug SF-2863804 (manually corrected output)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: old_views_incorrectly_reused.SF-2863804.view1.sql ---
START TRANSACTION;
CREATE VIEW DATA_docDict AS SELECT ALL docID AS a1, doc AS a2, type AS a3, prob
FROM docDict;
CREATE VIEW DATA_doc_string AS SELECT ALL docID AS a1, attribute AS a2, value
AS a3, prob FROM doc_string;
CREATE VIEW DATA_result AS SELECT ALL a1, prob FROM DATA_docDict;
CREATE VIEW find_TERM_from_DOC_attribute_1_RESULT_result_3 AS
SELECT ALL DATA_doc_string.a1 AS a1, DATA_doc_string.a2 AS a2,
DATA_doc_string.a3 AS a3, DATA_result.a1 AS a4,
DATA_doc_string.prob * DATA_result.prob AS prob
FROM DATA_doc_string, DATA_result
WHERE DATA_doc_string.a1=DATA_result.a1;
CREATE VIEW find_TERM_from_DOC_attribute_1_RESULT_result_2 AS
SELECT ALL a1, a2, a3, a4, prob
FROM find_TERM_from_DOC_attribute_1_RESULT_result_3
WHERE find_TERM_from_DOC_attribute_1_RESULT_result_3.a2='kind';
CREATE VIEW find_TERM_from_DOC_attribute_1_RESULT_result_1 AS
SELECT ALL a3 AS a1, prob FROM
find_TERM_from_DOC_attribute_1_RESULT_result_2;
CREATE VIEW find_TERM_from_DOC_attribute_1_RESULT_result AS
SELECT ALL a1, 1-prod(1-prob) AS prob FROM
find_TERM_from_DOC_attribute_1_RESULT_result_1 GROUP BY a1;
SELECT a.a1 as value, 'term' as type, a.prob FROM
find_TERM_from_DOC_attribute_1_RESULT_result as a ORDER BY "prob" DESC LIMIT 50
OFFSET 0;
ROLLBACK;
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
