Bugs item #2102101, was opened at 2008-09-09 16:06
Message generated for change (Comment added) made by stmane
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2102101&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 CVS Head
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: between without columns
Initial Comment:
The following sql crashes M5-SQL no-algebra version....
create table t1(id int);
select id from t1 where 5 between 4 and 6;
drop table t1;
and it give the following error message in the algebra version:
mdb>#EOD
mdb># _21;
[EMAIL PROTECTED] test]$ mclient current debug algebra sql < test.sql > out
MAPI = [EMAIL PROTECTED]:50000
QUERY = select id from t1 where 5 between 4 and 6;
ERROR = !TypeException:user.s0_3[4]:'algebra.uselect' undefined in: _7:any :=
algebra.uselect(_4:bte, _5:bte, _6:bte, _8:bit, _8:bit)
!TypeException:user.s0_3[6]:'algebra.markT' undefined in: _11:any :=
algebra.markT(_7:any, _9:oid)
!TypeException:user.s0_3[7]:'bat.reverse' undefined in: _12:any :=
bat.reverse(_11:any)
!TypeException:user.s0_3[17]:'algebra.join' undefined in: _28:any :=
algebra.join(_12:any, _27:bat[:oid,:int])
[EMAIL PROTECTED] test]$
----------------------------------------------------------------------
>Comment By: Stefan Manegold (stmane)
Date: 2008-11-17 16:16
Message:
Neither can I:
$ find sql -type f | grep 2102101
$ find sql -type f | grep between_no_columns
$ find sql -type f | grep between
sql/src/test/bugs/innerjoin_between-bug-sf-960672.sql
sql/src/test/BugTracker/Tests/between_having_problem.SF-1959391.sql
sql/src/test/BugTracker/Tests/between_having_problem.SF-1959391.stable.err
sql/src/test/BugTracker/Tests/between_having_problem.SF-1959391.stable.err.Algebra
sql/src/test/BugTracker/Tests/between_having_problem.SF-1959391.stable.out
sql/src/test/BugTracker/Tests/between_on_strings.SF-2021508.sql
sql/src/test/BugTracker/Tests/between_on_strings.SF-2021508.stable.err
sql/src/test/BugTracker/Tests/between_on_strings.SF-2021508.stable.out
sql/src/test/BugTracker/Tests/between_with_column.SF-1959410.sql
sql/src/test/BugTracker/Tests/between_with_column.SF-1959410.stable.err
sql/src/test/BugTracker/Tests/between_with_column.SF-1959410.stable.out
sql/src/test/BugTracker-2008/Tests/select_between_wrong_result.SF-2080189.sql
sql/src/test/BugTracker-2008/Tests/select_between_wrong_result.SF-2080189.stable.err
sql/src/test/BugTracker-2008/Tests/select_between_wrong_result.SF-2080189.stable.out
sql/src/test/bugs/Tests/innerjoin_between-bug-sf-960672.sql.src
sql/src/test/bugs/Tests/innerjoin_between-bug-sf-960672.stable.err
sql/src/test/bugs/Tests/innerjoin_between-bug-sf-960672.stable.out
----------------------------------------------------------------------
Comment By: Romulo Goncalves (romulog)
Date: 2008-11-17 16:07
Message:
Martin,
I can't find the test file....
If someone had's a test for a bug, please add the complete path until the
top directory of the module.
Because not all the bugs tests are added to sql/src/test/BugTracker/Tests
;)
----------------------------------------------------------------------
Comment By: Martin Kersten (mlkersten)
Date: 2008-09-14 22:46
Message:
Added the test file
between_no_columns.SF2102101.sql
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2102101&group_id=56967
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
