Bugs item #2807609, was opened at 2009-06-17 09:25
Message generated for change (Comment added) made by nielsnes
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2807609&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: Stefan de Konink (skinkie)
Assigned to: Niels Nes (nielsnes)
Summary: !INSERT INTO: number of values doesn't match number of colum

Initial Comment:
sql>create table test (a integer, b integer);
0 tuples
sql>insert into test (a) values (select 2);
Rows affected 1
sql>insert into test (a,b) values (select 2, 2);
!INSERT INTO: number of values doesn't match number of columns of table
'test'
0 tuples


----------------------------------------------------------------------

>Comment By: Niels Nes (nielsnes)
Date: 2009-08-06 20:08

Message:
added test to BugTracker-2009/insert_into_values_bug.SF-2807609.sql
Bug fixed by correctly disallowing all selects within values() lists.

----------------------------------------------------------------------

Comment By: Martin Kersten (mlkersten)
Date: 2009-08-06 14:07

Message:
See BugTracker-2009/ insert_ambiguity.SF-2807609.sql

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2807609&group_id=56967

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs

Reply via email to