NB 6.7.1 & NB 6.7
1) try to invoke statement SELECT * INTO table2 FROM table1
ERROR: only first 21 rows are updated.
Workaround: create table1 and invoke statement INSERT INTO table2 SELECT * FROM table1
The construct SELECT ... INTO TABLE is a SQL extension of SQL standard. Only some databases supports such Transact-SQL
extentions (eg.PostgreSQL, Sybase, MS SQL). IMHO I don't think it meets the P2 quality level but I'm going to fix it
regardless the priority anyway.
Workaround: create table2 and invoke statement INSERT INTO table2 SELECT * FROM table1
BTW: SELECT INTO is implemented in all databases that I've used including Oracle, Sybase, My SQL, MS SQL, HSQLDB,
Firebird and Derby
I attached the fix for the issue.
Created attachment 84972 [details]
> ------- Additional comments from email@example.com Mon Jul 20 20:44:26 +0000 2009 -------
> BTW: SELECT INTO is implemented in all databases that I've used including Oracle, Sybase, My SQL, MS SQL, HSQLDB,
> Firebird and Derby
No, Oracle nor MySQL support such statement. See http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-select-into-table.html.
Output from SQL*Plus:
SQL> select * into locations_backup from locations;
select * into locations_backup from locations
ERROR at line 1:
ORA-00905: missing keyword
pblaha: the patch looks good. I'll applay it. Thanks
Integrated into 'main-golden', will be available in build *200907230201* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
User: Jiri Rechtacek <firstname.lastname@example.org>
Log: #168812: SELECT * INTO statement updates only first 20 rows (applied blaha's patch)
*** Issue 169430 has been marked as a duplicate of this issue. ***
Removing RELNOTE keyword.