Changeset: a530e0ef7d93 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a530e0ef7d93
Modified Files:
sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.stable.out
sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.view1.sql
sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.view2.sql
Branch: Jan2014
Log Message:
Fix order of result.
diffs (47 lines):
diff --git
a/sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.stable.out
b/sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.stable.out
---
a/sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.stable.out
+++
b/sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.stable.out
@@ -138,8 +138,9 @@ Ready.
% value, type, prob # name
% varchar, char, double # type
% 2, 4, 24 # length
+[ "A1", "term", 1 ]
[ "A2", "term", 1 ]
-[ "A1", "term", 1 ]
+#ROLLBACK;
# 23:06:18 >
# 23:06:18 > Mtimeout -timeout 60 mclient -lsql -umonetdb -Pmonetdb
--host=localhost --port=31419
/home/wouter/opt/MonetDB-Aug2009/mTests/src/test/BugTracker-2009/old_views_incorrectly_reused.SF-2863804.view2.sql
@@ -168,8 +169,9 @@ Ready.
% value, type, prob # name
% varchar, char, double # type
% 4, 4, 24 # length
+[ "2000", "term", 1 ]
[ "2001", "term", 1 ]
-[ "2000", "term", 1 ]
+#ROLLBACK;
# 23:06:18 >
# 23:06:18 > Done.
diff --git
a/sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.view1.sql
b/sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.view1.sql
---
a/sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.view1.sql
+++
b/sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.view1.sql
@@ -22,6 +22,6 @@ CREATE VIEW find_TERM_from_DOC_attribute
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;
+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, value
LIMIT 50 OFFSET 0;
ROLLBACK;
diff --git
a/sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.view2.sql
b/sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.view2.sql
---
a/sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.view2.sql
+++
b/sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.view2.sql
@@ -22,6 +22,6 @@ CREATE VIEW find_TERM_from_DOC_attribute
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;
+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, value
LIMIT 50 OFFSET 0;
ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
