Bugs item #2102101, was opened at 2008-09-09 16:06
Message generated for change (Settings changed) made by romulog
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: Closed
>Resolution: Fixed
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;
[gonca...@alviss test]$ mclient current debug algebra sql < test.sql > out
MAPI = mone...@localhost: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])
[gonca...@alviss test]$
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2009-02-09 15:05
Message:
The algebra version became the default one in the stable branch as well.
So the bug is fixed and it can be closed.
----------------------------------------------------------------------
Comment By: Romulo Goncalves (romulog)
Date: 2008-12-01 15:46
Message:
This bug is fixed in the algebra version for the stable and current branch
of M5-SQL.
I can't close the bug until it is fixed in the normal version as well.
To use the algebra version just call mclient with option "-G":
mclient -G
----------------------------------------------------------------------
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
------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
