[
https://issues.apache.org/jira/browse/NETBEANS-5308?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chris McGee updated NETBEANS-5308:
----------------------------------
Description:
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.
{code}
[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.
{code}
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 10.4 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
was:
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.
{code}
[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.
{code}
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
> 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
> Priority: Major
> 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.
> {code}
> [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.
> {code}
> 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 10.4 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: commits-unsubscr...@netbeans.apache.org
For additional commands, e-mail: commits-h...@netbeans.apache.org
For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
