[#IDEADEV-27075] SQL: MySQL escape sequence for NULL value is reported as error

IDEA: Development

Created: 03 Jun 08 22:08 Updated: 03 Jun 08 22:08

Component/s:

SQL

Fix Version/s:

None

Original Estimate:

Unknown

Remaining Estimate:

Unknown

Time Spent:

Unknown

Build:

8,433

Description

« Hide

MySQL supports 'backslash + N' escape sequence for NULL value. I.e. the following statement:

 select \N;

is the same as

 select NULL;

and it's valid. IDEA highlights the first case as an error.

Notice that this sequence is case-sensitive. Small 'n' does not work this way.
http://dev.mysql.com/doc/refman/6.0/en/null-values.html

All

Comments

Work Log

Change History

Sort Order:

There are no comments yet on this issue.