Your sandbox server was installed in /Users/andrii/sandboxes/msb_5_1_52 dhcp-ballerup-10-172-86-201:~ andrii$ ~/sandboxes/msb_5_1_52/use Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.1.52-enterprise-gpl-advanced MySQL Enterprise Server - Advanced Edition (GPL) Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql [localhost] {msandbox} ((none)) > use test Database changed mysql [localhost] {msandbox} (test) > drop table if exists t1;Query OK, 0 rows affected, 1 warning (0.00 sec) mysql [localhost] {msandbox} (test) > drop table if exists t1; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql [localhost] {msandbox} (test) > create table t1(a text)engine=myisam; Query OK, 0 rows affected (0.04 sec) mysql [localhost] {msandbox} (test) > select 'aaaaaaaaaaaaaa' into outfile 'in.txt'; Query OK, 1 row affected (0.00 sec) mysql [localhost] {msandbox} (test) > load data infile 'in.txt' into table t1; Query OK, 1 row affected (0.00 sec) Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 mysql [localhost] {msandbox} (test) > show warnings; Empty set (0.00 sec) mysql [localhost] {msandbox} (test) > select load_file(substring((0x26),('98/12/31'),(1))); +-----------------------------------------------+ | load_file(substring((0x26),('98/12/31'),(1))) | +-----------------------------------------------+ | NULL | +-----------------------------------------------+ 1 row in set, 2 warnings (0.00 sec) mysql [localhost] {msandbox} (test) > show warnings; +---------+------+-----------------------------------------------+ | Level | Code | Message | +---------+------+-----------------------------------------------+ | Warning | 1292 | Truncated incorrect INTEGER value: '98/12/31' | | Warning | 1292 | Truncated incorrect INTEGER value: '98/12/31' | +---------+------+-----------------------------------------------+ 2 rows in set (0.00 sec) mysql [localhost] {msandbox} (test) > select linefromwkb(insert((substring_index((0xfa),('xm4x'),('E\\Rm'))),((('') <= -> (''))),(degrees(';PvD')),(@@global.auto_increment_increment))); +------------------------------------------------------------------------------------------------------------------------------------------+ | linefromwkb(insert((substring_index((0xfa),('xm4x'),('E\\Rm'))),((('') <= (''))),(degrees(';PvD')),(@@global.auto_increment_increment))) | +------------------------------------------------------------------------------------------------------------------------------------------+ | NULL | +------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set, 2 warnings (0.00 sec) mysql [localhost] {msandbox} (test) > show warnings; +---------+------+-------------------------------------------+ | Level | Code | Message | +---------+------+-------------------------------------------+ | Warning | 1292 | Truncated incorrect INTEGER value: 'E\Rm' | | Warning | 1292 | Truncated incorrect DOUBLE value: ';PvD' | +---------+------+-------------------------------------------+ 2 rows in set (0.00 sec) mysql [localhost] {msandbox} (test) > load data infile 'in.txt' into table t1; Query OK, 0 rows affected (0.00 sec) Records: 0 Deleted: 0 Skipped: 0 Warnings: 0 mysql [localhost] {msandbox} (test) > show warnings; Empty set (0.00 sec) mysql [localhost] {msandbox} (test) > sbester|kitchen: could you paste me full stacktrace -> ; ERROR 1064 (42000): 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 'sbester|kitchen: could you paste me full stacktrace' at line 1 mysql [localhost] {msandbox} (test) > drop table if exists t1; Query OK, 0 rows affected (0.00 sec) mysql [localhost] {msandbox} (test) > create table t1(a text)engine=myisam; Query OK, 0 rows affected (0.08 sec) mysql [localhost] {msandbox} (test) > select 'aaaaaaaaaaaaaa' into outfile 'in.txt'; ERROR 1086 (HY000): File 'in.txt' already exists mysql [localhost] {msandbox} (test) > load data infile 'in.txt' into table t1; Query OK, 0 rows affected (0.00 sec) Records: 0 Deleted: 0 Skipped: 0 Warnings: 0 mysql [localhost] {msandbox} (test) > show warnings; Empty set (0.00 sec) mysql [localhost] {msandbox} (test) > select load_file(substring((0x26),('98/12/31'),(1))); +-----------------------------------------------+ | load_file(substring((0x26),('98/12/31'),(1))) | +-----------------------------------------------+ | NULL | +-----------------------------------------------+ 1 row in set, 2 warnings (0.00 sec) mysql [localhost] {msandbox} (test) > show warnings; +---------+------+-----------------------------------------------+ | Level | Code | Message | +---------+------+-----------------------------------------------+ | Warning | 1292 | Truncated incorrect INTEGER value: '98/12/31' | | Warning | 1292 | Truncated incorrect INTEGER value: '98/12/31' | +---------+------+-----------------------------------------------+ 2 rows in set (0.00 sec) mysql [localhost] {msandbox} (test) > select linefromwkb(insert((substring_index((0xfa),('xm4x'),('E\\Rm'))),((('') <= -> (''))),(degrees(';PvD')),(@@global.auto_increment_increment))); +------------------------------------------------------------------------------------------------------------------------------------------+ | linefromwkb(insert((substring_index((0xfa),('xm4x'),('E\\Rm'))),((('') <= (''))),(degrees(';PvD')),(@@global.auto_increment_increment))) | +------------------------------------------------------------------------------------------------------------------------------------------+ | NULL | +------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set, 2 warnings (0.00 sec) mysql [localhost] {msandbox} (test) > show warnings; +---------+------+-------------------------------------------+ | Level | Code | Message | +---------+------+-------------------------------------------+ | Warning | 1292 | Truncated incorrect INTEGER value: 'E\Rm' | | Warning | 1292 | Truncated incorrect DOUBLE value: ';PvD' | +---------+------+-------------------------------------------+ 2 rows in set (0.00 sec) mysql [localhost] {msandbox} (test) > load data infile 'in.txt' into table t1; ERROR 1083 (42000): Field separator argument is not what is expected; check the manual mysql [localhost] {msandbox} (test) > show warnings; +-------+------+--------------------------------------------------------------------+ | Level | Code | Message | +-------+------+--------------------------------------------------------------------+ | Error | 1083 | Field separator argument is not what is expected; check the manual | +-------+------+--------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql [localhost] {msandbox} (test) > select 1 into outfile '/tmp/sdfsadfsd'; ERROR 1083 (42000): Field separator argument is not what is expected; check the manual