Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Duplicate
    • Affects Version/s: 1.2
    • Fix Version/s: 2.0
    • Labels:
      None
    • Environment:
      MySQL 5.0.13-rc-standard

      Description

      When running the import of the roller schema into MySQL 5.0 one of the tables has a reserved word as a column name the reserved word is "condition"
      mysql> create database roller;
      Query OK, 1 row affected (0.00 sec)

      mysql>use roller
      Database changed
      mysql> \. /home/akruger/createdb.sql
      [...]
      Query OK, 0 rows affected (0.07 sec)

      Query OK, 0 rows affected (0.09 sec)
      Records: 0 Duplicates: 0 Warnings: 0

      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition integer default 0 not null,
      lastsuccess timestamp null
      )' at line 6
      ERROR 1146 (42S02): Table 'investologist_roller.pingtarget' doesn't exist
      Query OK, 0 rows affected (0.07 sec)
      [...]
      Query OK, 0 rows affected (0.07 sec)
      Records: 0 Duplicates: 0 Warnings: 0

      ERROR 1146 (42S02): Table 'investologist_roller.pingtarget' doesn't exist
      Query OK, 0 rows affected (0.07 sec)
      Records: 0 Duplicates: 0 Warnings: 0

      Query OK, 0 rows affected (0.09 sec)
      Records: 0 Duplicates: 0 Warnings: 0

      Query OK, 0 rows affected (0.12 sec)
      Records: 0 Duplicates: 0 Warnings: 0

      Query OK, 0 rows affected (0.08 sec)
      Records: 0 Duplicates: 0 Warnings: 0

      mysql>

        Activity

          People

          • Assignee:
            Anil Gangolli
            Reporter:
            Andre Kruger
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development