Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.9.2, 10.3(EOL), 10.4(EOL), 10.5(EOL), 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
Steps to reproduce.
SET SESSION sql_mode = "NO_BACKSLASH_ESCAPES"; |
SELECT NULL, 0, '' INTO OUTFILE 'data-server.csv'; |
CREATE
|
OR REPLACE TABLE loading (col1 VARCHAR(255) NULL, col2 INT, col3 VARCHAR(255)); |
|
|
LOAD DATA LOCAL INFILE 'data-server.csv' INTO TABLE loading; |
|
|
SELECT
|
*
|
FROM
|
loading
|
WHERE
|
col1 IS NULL; |
It reads NULL as a string.