Changeset: 7dc739bfd77a for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7dc739bfd77a
Modified Files:
sql/backends/monet5/datacell/Tests/durac00.sql
Branch: default
Log Message:
Hack to deal with 3-way column denotations.
diffs (18 lines):
diff --git a/sql/backends/monet5/datacell/Tests/durac00.sql
b/sql/backends/monet5/datacell/Tests/durac00.sql
--- a/sql/backends/monet5/datacell/Tests/durac00.sql
+++ b/sql/backends/monet5/datacell/Tests/durac00.sql
@@ -36,10 +36,10 @@ create procedure datacell.monitor()
begin
declare avgtemp float;
set avgtemp =
- (select average(value)
- from datacell.temperature , datacell.alarm
- where datacell.temperature.tag > now() - interval '2' minute
- and datacell.temperature.area = datacell.alarm.area );
+ (select avg(A.value)
+ from datacell.temperature as A, datacell.alarm as B
+ where A.tag > now() - interval '2' minute
+ and A.area = B.area );
-- notify the emergency room
insert into datacell.emergency select now(), avgtemp, value from
datacell.alarm;
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
