Bugs item #2836863, was opened at 2009-08-13 13:47
Message generated for change (Tracker Item Submitted) made by stmane
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2836863&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL "stable"
Status: Open
Resolution: None
Priority: 6
Private: No
Submitted By: Stefan Manegold (stmane)
Assigned to: Niels Nes (nielsnes)
Summary: SQL: ORDER BY tests fail on 64-bit systems with 32-bit OIDs
Initial Comment:
Most probably since this checkin
===================================================================
2009/06/09 - nielsnes: sql/src/backends/monet5/sql_gencode.mx,1.319.2.4
sql/src/backends/monet5/sql_optimizer.mx,1.218.2.2
sql/src/server/rel_bin.mx,1.78.2.1
sql/src/server/sql_rel2bin.mx,1.132.2.1
sql/src/server/sql_statement.mx,1.184.2.1
ng problems with 'order' dependend statements (such as mkey xor and batcalc*
)
this solves problems with alter_table_drop_constraint as well as
SQL: test type_dump_test.SF-989257.SQL.sh fails since Feb 28
projection joins are now handled by leftjoins
===================================================================
order-by tests fail on 64-bit systems with 32-bit OIDs (the advised default
used with our 64-bit Windows installers); cf.
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/Int.64.32.d.1-Windows5.2/src_benchmarks_ATIS/select_group.out.00.html
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.32.d.1-Fedora10/src_test_ADT2006/slam.out.00.html
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.32.d.1-Fedora10/src_test_Dependencies/Dependencies.out.00.html
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.32.d.1-Fedora10/src_test_UserDump/create.out.00.html
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.32.d.1-Fedora10/src_test_bugs/subselect_multiple_unionall_where_1=1-bug-sf-1005596.out.00.html
The problem might be related to these comments in the above checkin in
sql/src/server/sql_rel2bin.mx
"
/* TODO the semijoin may break the order!! */
/* TODO semijoin may break order */
"
maybe, we need to introduce an order-preserving "left"-semijoin?
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2836863&group_id=56967
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
