Bugs item #1907006, was opened at 2008-03-04 14:29
Message generated for change (Comment added) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1907006&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: range select....
Initial Comment:
The following query is syntatically incorrect:
>select name from tables where 0<id>10;
!TypeException:user.s0_0[45]:'algebra.uselect' undefined in: _62:any :=
algebra.uselect(_59:bat[:oid,:oid], _61:int, _60:int, _48:bit, _48:bit)
!TypeException:user.s0_0[47]:'algebra.markT' undefined in: _64:any :=
algebra.markT(_62:any, _63:oid)
!TypeException:user.s0_0[48]:'bat.reverse' undefined in: _65:any :=
bat.reverse(_64:any)
!TypeException:user.s0_0[61]:'algebra.join' undefined in: _86:any :=
algebra.join(_65:any, _85:bat[:oid,:str])
&1 0 1 1 1
% sys.tables # table_name
% name # name
% varchar # type
% 2 # length
[ 725 ]
>
Romulo
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2008-03-09 00:29
Message:
Logged In: YES
user_id=1498628
Originator: YES
Fixed:
[Monetdb-sql-checkins] sql/src/server sql_psm.mx, SQL_2-22, 1.50, 1.50.2.1
sql_select.mx, SQL_2-22, 1.219.2.5, 1.219.2.6
Modified Files:
Tag: SQL_2-22
sql_psm.mx sql_select.mx
Log Message:
fixes for the bugs
[ 1907905 ] coalesce = coalesce...
(added some more checks for semantic problems)
and
[ 1907006 ] range select....
Properly interpret 0<id>10 as a boolean (0<id) followed by the selection
criteria (bool > 10).
test added in:
sql/src/test/BugTracker/Tests/range_select.SF-1907006.sql
----------------------------------------------------------------------
Comment By: Fabian (mr-meltdown)
Date: 2008-03-04 14:40
Message:
Logged In: YES
user_id=963970
Originator: NO
The output is protocol-wise a violation as well. (Our transaction
semantics define that even in a multi-statement query this cannot happen.)
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1907006&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
