This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
NB 6.7.1 & NB 6.7 Steps: 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] patch
> ------- Additional comments from nleck@netbeans.org 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
core-main/rev/a3110f186887
Integrated into 'main-golden', will be available in build *200907230201* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-golden/rev/a3110f186887 User: Jiri Rechtacek <jrechtacek@netbeans.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.