title: What if tablespace is not defined(PARTITION)
body: <p>I create partition by list, but not define tablespaces for each <code>PARTITION</code>. What happens then?:</p>
  
  <pre><code>CREATE TABLE movie_genres (
      movie_genre_id INT NOT NULL,
      movie_id INT NOT NULL,
      genre_id INT NOT NULL,
      PRIMARY KEY (movie_genre_id),
      FOREIGN KEY (movie_id) REFERENCES movies(movie_id),
      FOREIGN KEY (genre_id) REFERENCES GENRES(genre_id),
      UNIQUE (movie_id, genre_id)
  )
    PARTITION BY LIST(GENRE_ID)
    ( PARTITION Drama VALUES (8),
      PARTITION Comedy VALUES (5)
    );
  </code></pre>