Bugs item #2807341, was opened at 2009-06-16 21:39
Message generated for change (Tracker Item Submitted) made by skinkie
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2807341&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: Open
Resolution: None
Priority: 5
Private: Yes
Submitted By: Stefan de Konink (skinkie)
Assigned to: Niels Nes (nielsnes)
Summary: INSERT INTO doesn't match number of columns
Initial Comment:
sql>select naam, vestigingsplaats, beschikking, intrekking, kvk.kvk from
kvk,anbi where lower(naam) = lower(bedrijfsnaam) and lower(plaats) =
lower(vestigingsplaats) limit 10;
+------------------------------------------+------------------+-------------+------------+-------------+
| naam | vestigingsplaats | beschikking |
intrekking | kvk |
+==========================================+==================+=============+============+=============+
| WERELDWINKEL HEERENVEEN | HEERENVEEN | 2008-01-01 |
null | 10702640000 |
| STICHTING MONUMENTENZORG LEEUWARDERADEEL | STIENS | 2009-01-01 |
null | 1079853 |
| STICHTING FRIES NATUURHISTORISCH MUSEUM | LEEUWARDEN | 2008-01-01 |
null | 1079917 |
| STICHTING VRIENDEN VAN ZIENN | OENTSJERK | 2008-01-01 |
null | 1080218 |
| NEDERLANDSE HOOFDPIJN STICHTING | DOKKUM | 2008-01-01 |
null | 1081350 |
| STICHTING SEBO DETMERS | OOSTERWOLDE FR | 2008-01-01 |
null | 1081838 |
| STICHTING AMBULANCE DIER IN NOOD | PEINS | 2008-01-01 |
null | 1082006 |
| STICHTING ORANJECOMITE JOURE | JOURE | 2008-01-01 |
null | 1082094 |
| STICHTING O.S.G. PITER JELLES | LEEUWARDEN | 2008-01-01 |
null | 1082181 |
| STICHTING VOORZIENINGEN OLMENES | APPELSCHA | 2008-01-01 |
null | 1082205 |
+------------------------------------------+------------------+-------------+------------+-------------+
10 tuples
sql>insert into anbikvk values (select naam, vestigingsplaats, beschikking,
intrekking, kvk.kvk from kvk,anbi where lower(naam) = lower(bedrijfsnaam) and
lower(plaats) = lower(vestigingsplaats));
!INSERT INTO: number of values doesn't match number of columns of table
'anbikvk'
0 tuples
sql>\d anbikvk
CREATE TABLE "sys"."anbikvk" (
"naam" varchar(256),
"vestigingsplaats" varchar(32),
"beschikking" date,
"intrekking" date,
"kvk" bigint
);
sql>insert into anbikvk (naam, vestigingsplaats, beschikking, intrekking, kvk)
values (select naam, vestigingsplaats, beschikking, intrekking, kvk.kvk from
kvk,anbi where lower(naam) = lower(bedrijfsnaam) and lower(plaats) =
lower(vestigingsplaats));
!INSERT INTO: number of values doesn't match number of columns of table
'anbikvk'
0 tuples
Today it was mentioned to 'read' error messages, but counting is also an
ability that I seem to lack :\
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2807341&group_id=56967
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
