'Primary Key and Index error when selecting data'

def test_issue_8(self):

    conn = self.connections[0]
    c = conn.cursor()
    with warnings.catch_warnings():
        warnings.filterwarnings('ignore')
        c.execute('drop    table    if    exists    test')
    c.execute("CREATE    TABLE    `test`    (`station`    int(10)    NOT    NULL    DEFAULT    '0',    `dh`\ndatetime    NOT    NULL    DEFAULT    '2015-01-01    00:00:00',    `echeance`    int(1)    NOT    NULL\nDEFAULT    '0',    `me`    double    DEFAULT    NULL,    `mo`    double    DEFAULT    NULL,    PRIMARY\nKEY    (`station`,`dh`,`echeance`))    ENGINE=MyISAM    DEFAULT    CHARSET=latin1;")
    try:
        self.assertEqual(0, c.execute('SELECT    *    FROM    test'))
        c.execute('ALTER    TABLE    `test`    ADD    INDEX    `idx_station`    (`station`)')
        self.assertEqual(0, c.execute('SELECT    *    FROM    test'))
    finally:
        c.execute('drop    table    test')
