Chris McGee created NETBEANS-5308:
-------------------------------------
Summary: Problems using SQL files with UTF-8 Byte Order Mark (BOM)
Key: NETBEANS-5308
URL: https://issues.apache.org/jira/browse/NETBEANS-5308
Project: NetBeans
Issue Type: Bug
Components: db - SQL Editor
Affects Versions: 12.1
Environment: *Product Version:* Apache NetBeans IDE 12.1
*Java:* 15.0.1; OpenJDK 64-Bit Server VM 15.0.1+9
*Runtime:* OpenJDK Runtime Environment 15.0.1+9
*System:* Mac OS X version 10.15.7 running on x86_64; UTF-8; en_CA (nb)
Reporter: Chris McGee
Attachments: 386.sql
While using NetBeans for doing database development work there are files that
have UTF-8 BOM (Byte Order Mark) at the beginning that cause execution to fail
mysteriously due to the invisible characters.
```
[1:1] Failed in 0 s.
[Exception, Error code 0, SQLState 42601] ERROR: syntax error at or near "DO"
Position: 1
Line 1, column 1
Execution finished after 0.004 s, 7 errors occurred.
```
Retyping the first line after backspacing it away doesn't remove the
characters. Selecting the very first character to the end of the file doesn't
help either. Checking View->Show non printable characters shows whitespace
characters, but not the BOM. the Only visual clue what's happening is that the
syntax highlighter isn't highlighting the first line correctly. Viewing the
file with a hex editor is what revealed the BOM at the beginning causing all of
the problems.
The BOM is stripped away when opening the file in the editor or running it from
the Projects panel (Right-click -> Run File). It is debatable whether the BOM
should be stripped or preserved on save of the file.
Steps to reproduce the problem:
* Import the attached UTF-8 (+BOM) SQL file into a project that is set to
UTF-8 encoding (Right-click -> Properties -> Sources -> Encoding)
* Open the SQL editor
* Pick a database connection (PostgreSQL in my case)
* Click the Run SQL button at the top
** Query fails similarly above due to a problem at line1 column 1
* Select all in the file, right-click -> Run Selection
** Query fails similarly
* Try putting a new line at the beginning, select just the first SQL command
to the end of the file and Run Selection
** Query fails similarly
* Try running the SQL file from the Projects panels, right-click -> Run File
** Query fails similarly
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
