Bugs item #1907060, was opened at 2008-03-04 15:52
Message generated for change (Comment added) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1907060&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: join tables with floats...
Initial Comment:
The following statements show the problem:
>create table t2 (id float);
>create table t1 (age float);
>select age from t1, t2 where id < 0.0 limit 10;
!TypeException:user.s0_0[29]:'algebra.join' undefined in: _42:any :=
algebra.join(_22:bat[:oid,:dbl], _41:bat[:oid,:oid])
!TypeException:user.s0_0[31]:'algebra.markT' undefined in: _45:any :=
algebra.markT(_42:any, _43:oid)
!TypeException:user.s0_0[32]:'bat.reverse' undefined in: _46:any :=
bat.reverse(_45:any)
!TypeException:user.s0_0[33]:'algebra.join' undefined in: _47:any :=
algebra.join(_46:any, _16:bat[:oid,:dbl])
&1 4 1 1 1
% sys.t1 # table_name
% age # name
% double # type
% 22 # length
[ 747 ]
>
Romulo
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2008-03-09 00:23
Message:
Logged In: YES
user_id=1498628
Originator: YES
Fixed:
[Monetdb-sql-checkins] sql/src/server sql_mvc.mx, SQL_2-22, 1.195.2.1,
1.195.2.2
Modified Files:
Tag: SQL_2-22
sql_mvc.mx
Log Message:
fixed bug [ 1907858 ] declaration of the second table in the function
body
cased columns sometimes have no schema defined (declared tables). So we
cannot reuse the schema from it.
test added in:
sql/src/test/BugTracker/Tests/join_table_with_floats.SF-1907060.sql
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1907060&group_id=56967
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
