|
1548.4.42
by Zimin
add test case select with separators to test col/row separators |
1 |
DROP TABLE IF EXISTS t1;
|
2 |
CREATE TABLE t1 (c1 INT, c2 VARCHAR(20),
|
|
3 |
c3 INT, c4 VARCHAR(20),
|
|
4 |
c5 DECIMAL(3, 2))
|
|
|
1786.3.2
by Monty Taylor
Cleaned up the initial pass at this. It's not perfect, but it does work. |
5 |
ENGINE=FILESYSTEM,FILE="../../filesystem_ln/select_with_separators.data",COL_SEPARATOR="|/",ROW_SEPARATOR=";\n";
|
|
1548.4.42
by Zimin
add test case select with separators to test col/row separators |
6 |
SELECT * FROM t1;
|
7 |
c1 c2 c3 c4 c5
|
|
8 |
111 aaa 222 bbb 4.32
|
|
9 |
333 zzz 888 yyy 1.89
|
|
10 |
555 xxx 999 ppp 5.67
|
|
11 |
777 ddd 100 qqq 7.15
|
|
12 |
999 eee 231 ooo 9.11
|
|
13 |
DROP TABLE t1;
|