Bugs item #2789976, was opened at 2009-05-11 11:07
Message generated for change (Comment added) made by skinkie
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2789976&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: MonetDB Common CVS Head
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Stefan de Konink (skinkie)
Assigned to: Niels Nes (nielsnes)
Summary: TypeException upon insert
Initial Comment:
CREATE TABLE "sys"."segments" (
"way" int,
"node1" int,
"node2" int
);
sql>select count(*) from segments;
+-----------+
| L4 |
+===========+
| 343983657 |
+-----------+
CREATE TABLE "sys"."mytemp" (
"row" int,
"way" int,
"long1" double,
"lat1" double,
"long2" double,
"lat2" double
);
insert into mytemp select row_number() over (order by way) as row, way,
n1.long, n1.lat, n2.long, n2.lat from nodes_legacy as n1, nodes_legacy as n2,
segments where node1 = n1.id and node2 = n2.id;
!TypeException:user.s10_1[110]:'calc.mark_grp' undefined in: _300:any :=
calc.mark_grp(_298:int)
!TypeException:user.s10_1[111]:'bat.insert' undefined in: _301:any :=
bat.insert(_292:bat[:oid,:int], _297:oid, _300:any)
0 tuples
Rows affected 343980665
sql>select count(*) from mytemp;
+----+
| L3 |
+====+
| 0 |
+----+
1 tuple
I find the output curious, and the error is actually scary.
----------------------------------------------------------------------
>Comment By: Stefan de Konink (skinkie)
Date: 2009-05-13 12:57
Message:
CREATE TABLE "sys"."nodes_legacy" (
"id" int,
"long" double,
"lat" double,
"uid" int,
"timestamp" timestamptz(7)
);
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2789976&group_id=56967
------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image
processing features enabled. http://p.sf.net/sfu/kodak-com
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
