Details

    Description

      This bug is the same as below and was fixed in MySQL 5.7.0
      http://bugs.mysql.com/bug.php?id=45346
      http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-0.html

      It still occurs in Maria though.

      [root@kc1060 ~]# mysql -u root
      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 804
      Server version: 10.0.15-MariaDB-log MariaDB Server
       
      Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [(none)]> use test;
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A
       
      Database changed
      MariaDB [test]> SELECT INTERVAL(55,10) AS my_col;
      +--------+
      | my_col |
      +--------+
      |      1 |
      +--------+
      1 row in set (0.01 sec)
       
      MariaDB [test]> CREATE OR REPLACE VIEW v1 AS SELECT INTERVAL(55,10) AS my_col;
      Query OK, 0 rows affected (0.03 sec)
       
      MariaDB [test]> SHOW CREATE VIEW v1;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `my_col`' at line 1
      MariaDB [test]> SELECT * FROM v1;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `my_col`' at line 1

      Attachments

        Activity

          Can this bug be fixed?
          It is crucial since I have to write all INTERVALS in VIEWS as a CASE sentence.

          takuya Takuya Aoki (Inactive) added a comment - Can this bug be fixed? It is crucial since I have to write all INTERVALS in VIEWS as a CASE sentence.
          EdNett Ed Jackson added a comment -

          I have the same error trying to restore a db in mariadb 10.0.16: is this related or is this a separate issue?:

          server1:~# mysql
          Welcome to the MariaDB monitor. Commands end with ; or \g.
          Your MariaDB connection id is 6085
          Server version: 10.0.16-MariaDB-1~wheezy-log mariadb.org binary distribution

          Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

          Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

          MariaDB [(none)]> mysql -e "source /data/disk/arch/sql/server1.domain.biz-150209-0008/xnlasocitgyabcom.sql.gz" xnlas
          ocitgyabc_0 ;
          ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server ve
          rsion for the right syntax to use near 'mysql -e "source /data/disk/arch/sql/server1.domain.biz-150209-0008/xnlasoci
          tgy' at line 1
          MariaDB [(none)]> mysql xnlasocitygyabc_0 < /data/disk/arch/sql/server1.domain.biz-150209-0008/xnlasocitgyabcom.sql.
          gz
          -> ;
          ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server ve
          rsion for the right syntax to use near 'mysql xnlasocitygyabc_0 < /data/disk/arch/sql/server1.domain.biz-150209-0008
          /xn' at line 1
          MariaDB [(none)]>

          EdNett Ed Jackson added a comment - I have the same error trying to restore a db in mariadb 10.0.16: is this related or is this a separate issue?: server1:~# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 6085 Server version: 10.0.16-MariaDB-1~wheezy-log mariadb.org binary distribution Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)] > mysql -e "source /data/disk/arch/sql/server1.domain.biz-150209-0008/xnlasocitgyabcom.sql.gz" xnlas ocitgyabc_0 ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server ve rsion for the right syntax to use near 'mysql -e "source /data/disk/arch/sql/server1.domain.biz-150209-0008/xnlasoci tgy' at line 1 MariaDB [(none)] > mysql xnlasocitygyabc_0 < /data/disk/arch/sql/server1.domain.biz-150209-0008/xnlasocitgyabcom.sql. gz -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server ve rsion for the right syntax to use near 'mysql xnlasocitygyabc_0 < /data/disk/arch/sql/server1.domain.biz-150209-0008 /xn' at line 1 MariaDB [(none)] >

          People

            serg Sergei Golubchik
            takuya Takuya Aoki (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.