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: | New line before LIMIT of OFFSET is not interpreted as whitespace. | ||
---|---|---|---|
Product: | db | Reporter: | nbphpuser <nbphpuser> |
Component: | SQL Editor | Assignee: | Jiri Rechtacek <jrechtacek> |
Status: | RESOLVED FIXED | ||
Severity: | normal | ||
Priority: | P3 | ||
Version: | 6.x | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | DEFECT | Exception Reporter: |
Description
nbphpuser
2010-05-22 10:30:22 UTC
Reproducible in NB6.9RC2. I guess it was fixed some time ago. Try again with NB7.0Beta. Thanks I still have error. IDE LOG: Failed to execute SQL Statement [select * from mytable where name like 'Me%' limit 1], cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 20 OFFSET 0' at line 2 Failed to execute SQL Statement [select * from mytable where name like 'Me%' limit 1], cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 20 OFFSET 0' at line 2 Product Version: NetBeans IDE Dev (Build 2010-12-09_15-04-45 ) Java: 1.6.0_22; Java HotSpot(TM) Client VM 17.1-b03 System: Windows 7 version 6.1 running on x86; Cp1252; de_DE (nb) It happens only with limit clause: select * from mytable where name like 'Me%' limit 1; Following works> select * from mytable where name like 'Me%' order by name asc; I confirms the bug is still here. Will be fixed in NB7.0 Thank you for the report. core-main/rev/c58ea32d9145 Integrated into 'main-golden', will be available in build *201012110001* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main/rev/c58ea32d9145 User: Jiri Rechtacek <jrechtacek@netbeans.org> Log: #186537: New line before LIMIT or OFFSET is not interpreted as whitespace. |