text: --many List(have no NULL value) partition creating test with some char type values.
  create table list_test(id int ,
  			test_char char(50),
  			test_varchar varchar(2000),
  			test_bit bit(16),
  			test_varbit bit varying(20),
  			test_nchar nchar(50),
  			test_nvarchar nchar varying(2000),
  			test_string string,
  			test_datetime timestamp, primary key(id,test_char))
  PARTITION BY LIST (test_char) (
      PARTITION p0 VALUES IN ('aaa','bbb','ddd'),
      PARTITION p1 VALUES IN ('fff','ggg','hhh'),
      PARTITION p2 VALUES IN ('kkk','lll','mmm')
  );
  
  
  select * from db_class where class_name like 'list%' order by class_name;
  
  
  drop table list_test;
  