Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8926

Date type column of CONNECT CSV table type fails to return result on equal matches

    Details

      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]>

        Attachments

          Activity

            People

            • Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              Tuco Tuco
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: