Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.15, 10.0.17, 10.0.21
-
Windows Server 2008 R2; Windows 7
Description
CONNECT's CSV table type does not return matching result for `date` type on an equal match. It does return the matching results on greater-than matches, but not on less-than matches.
Welcome to the MariaDB monitor. Commands end with ; or \g. |
Your MariaDB connection id is 5 |
Server version: 10.0.21-MariaDB mariadb.org binary distribution |
|
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others. |
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. |
|
MariaDB [(none)]> use test |
Database changed |
MariaDB [test]> create table foo_csv(col1 date) engine=CONNECT table_type=CSV fi |
le_name='C:/temp/foo.csv'; |
Query OK, 0 rows affected (0.00 sec) |
|
MariaDB [test]>
|
MariaDB [test]> insert into foo_csv(col1) |
-> values ('2015-01-01'), |
-> ('2015-02-01'), |
-> ('2015-03-01'), |
-> ('2015-04-01'); |
Query OK, 4 rows affected (0.00 sec) |
Records: 4 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> select * from foo_csv\G |
*************************** 1. row ***************************
|
col1: 2015-01-01
|
*************************** 2. row ***************************
|
col1: 2015-02-01
|
*************************** 3. row ***************************
|
col1: 2015-03-01
|
*************************** 4. row ***************************
|
col1: 2015-04-01
|
4 rows in set (0.00 sec) |
|
MariaDB [test]> select * from foo_csv where col1 = '2015-02-01'\G |
Empty set (0.00 sec) |
|
MariaDB [test]> select * from foo_csv where col1 > '2015-02-01'\G |
*************************** 1. row ***************************
|
col1: 2015-03-01
|
*************************** 2. row ***************************
|
col1: 2015-04-01
|
2 rows in set (0.00 sec) |
|
MariaDB [test]>
|