#!/bin/sh -e

DATABASE="$1";
TABLE="$2";

MYSQL="mysql -N --show-warnings -n -v -v -v $DATABASE";

$MYSQL << EOF
DROP TABLE IF EXISTS $TABLE;
CREATE TABLE $TABLE (id INT NOT NULL) ENGINE=MyISAM;
SELECT @@SQL_MODE;
EOF

# This one works with warning
namedpipe="/tmp/$TABLE.$$";
[ -p $namedpipe ] && rm $namedpipe;
mkfifo --mode=0666 $namedpipe;
cat << EOF > $namedpipe & $MYSQL -e "LOAD DATA INFILE '$namedpipe' INTO TABLE $TABLE";
1
\N
EOF
[ -p $namedpipe ] && rm $namedpipe;

# This one fails with error
namedpipe="/tmp/$TABLE.$$";
[ -p $namedpipe ] && rm $namedpipe;
mkfifo --mode=0666 $namedpipe;
cat << EOF > $namedpipe & $MYSQL -e "LOAD DATA INFILE '$namedpipe' INTO TABLE $TABLE";
\N
1
EOF
[ -p $namedpipe ] && rm $namedpipe;

$MYSQL << EOF
SELECT * FROM $TABLE;
EOF