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.
Summary: | SELECT * INTO statement updates only first 20 rows | ||
---|---|---|---|
Product: | db | Reporter: | Petr Blaha <blaha> |
Component: | Show Data | Assignee: | Jiri Rechtacek <jrechtacek> |
Status: | RESOLVED FIXED | ||
Severity: | blocker | CC: | nleck |
Priority: | P3 | ||
Version: | 6.x | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | DEFECT | Exception Reporter: | |
Attachments: | patch |
Description
Petr Blaha
2009-07-20 13:31:26 UTC
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. |