text: -- start_ignore
  SET gp_create_table_random_default_distribution=off;
  -- end_ignore
  --
  --RENAME Column
  --
  
            ALTER TABLE sync1_ao_all_alter_column_table1 RENAME COLUMN phase TO after_rename_col;
  
  INSERT INTO sync1_ao_all_alter_column_table1 VALUES ('sync1_ao1',generate_series(1,10),'a',11,true,'111', '1_one', '{1,2,3,4,5}', 'Hello .. how are you 1', 'Hello .. how are you 1',    '{one,two,three,four,five}',  12345678, 1, 111.1111,  11,  '1_one_11',   'd',
  '2001-12-13 01:51:15+1359',  '11',   '0.0.0.0', '0.0.0.0', 'AA:AA:AA:AA:AA:AA',   '34.23',   '00:00:00+1359',  '((2,2),1)',   '((1,2),(2,1))',   'hello', '((1,2),(2,1))', 11,   '010101',   '2001-12-13', '((1,1),(2,2))', '(1,1)', '((1,2),(2,3),(3,4),(4,3),(3,2),(2,1))',    111111, '23:00:00',   '2001-12-13 01:51:15'
  );
  
  select count(*) from sync1_ao_all_alter_column_table1;
  --
  --ALTER column TYPE type
  --
  
            ALTER TABLE sync1_ao_all_alter_column_table1 ALTER COLUMN col002 TYPE int4;
  
  INSERT INTO sync1_ao_all_alter_column_table1 VALUES ('sync1_ao1',generate_series(1,10),'a',11,true,'111', '1_one', '{1,2,3,4,5}', 'Hello .. how are you 1', 'Hello .. how are you 1',    '{one,two,three,four,five}',  12345678, 1, 111.1111,  11,  '1_one_11',   'd',
  '2001-12-13 01:51:15+1359',  '11',   '0.0.0.0', '0.0.0.0', 'AA:AA:AA:AA:AA:AA',   '34.23',   '00:00:00+1359',  '((2,2),1)',   '((1,2),(2,1))',   'hello', '((1,2),(2,1))', 11,   '010101',   '2001-12-13', '((1,1),(2,2))', '(1,1)', '((1,2),(2,3),(3,4),(4,3),(3,2),(2,1))',    111111, '23:00:00',   '2001-12-13 01:51:15'
  );
  select count(*) from sync1_ao_all_alter_column_table1;
  
  --
  --ALTER column SET DEFAULT expression
  --
  
            ALTER TABLE sync1_ao_all_alter_column_table1 ALTER COLUMN col010 SET DEFAULT 0;
  
  INSERT INTO sync1_ao_all_alter_column_table1 VALUES ('sync1_ao1',generate_series(1,10),'a',11,true,'111', '1_one', '{1,2,3,4,5}', 'Hello .. how are you 1', 'Hello .. how are you 1',    '{one,two,three,four,five}',  12345678, 1, 111.1111,  11,  '1_one_11',   'd',
  '2001-12-13 01:51:15+1359',  '11',   '0.0.0.0', '0.0.0.0', 'AA:AA:AA:AA:AA:AA',   '34.23',   '00:00:00+1359',  '((2,2),1)',   '((1,2),(2,1))',   'hello', '((1,2),(2,1))', 11,   '010101',   '2001-12-13', '((1,1),(2,2))', '(1,1)', '((1,2),(2,3),(3,4),(4,3),(3,2),(2,1))',    111111, '23:00:00',   '2001-12-13 01:51:15'
  );
  select count(*) from sync1_ao_all_alter_column_table1;
  
            ALTER TABLE sync1_ao_all_alter_column_table1 ALTER COLUMN  after_rename_col SET DEFAULT 'stages' ;
  
  
  INSERT INTO sync1_ao_all_alter_column_table1 VALUES ('sync1_ao1',generate_series(1,10),'a',11,true,'111', '1_one', '{1,2,3,4,5}', 'Hello .. how are you 1', 'Hello .. how are you 1',    '{one,two,three,four,five}',  12345678, 1, 111.1111,  11,  '1_one_11',   'd',
  '2001-12-13 01:51:15+1359',  '11',   '0.0.0.0', '0.0.0.0', 'AA:AA:AA:AA:AA:AA',   '34.23',   '00:00:00+1359',  '((2,2),1)',   '((1,2),(2,1))',   'hello', '((1,2),(2,1))', 11,   '010101',   '2001-12-13', '((1,1),(2,2))', '(1,1)', '((1,2),(2,3),(3,4),(4,3),(3,2),(2,1))',    111111, '23:00:00',   '2001-12-13 01:51:15'
  );
  
  select count(*) from sync1_ao_all_alter_column_table1;
  
  --
  --ALTER column [ SET | DROP ] NOT NULL
  --
            ALTER TABLE sync1_ao_all_alter_column_table1 ALTER COLUMN a SET NOT NULL;
  
  INSERT INTO sync1_ao_all_alter_column_table1 VALUES ('sync1_ao1',generate_series(1,10),'a',11,true,'111', '1_one', '{1,2,3,4,5}', 'Hello .. how are you 1', 'Hello .. how are you 1',    '{one,two,three,four,five}',  12345678, 1, 111.1111,  11,  '1_one_11',   'd',
  '2001-12-13 01:51:15+1359',  '11',   '0.0.0.0', '0.0.0.0', 'AA:AA:AA:AA:AA:AA',   '34.23',   '00:00:00+1359',  '((2,2),1)',   '((1,2),(2,1))',   'hello', '((1,2),(2,1))', 11,   '010101',   '2001-12-13', '((1,1),(2,2))', '(1,1)', '((1,2),(2,3),(3,4),(4,3),(3,2),(2,1))',    111111, '23:00:00',   '2001-12-13 01:51:15'
  );
  
  select count(*) from sync1_ao_all_alter_column_table1;
  
            ALTER TABLE sync1_ao_all_alter_column_table1 ALTER COLUMN a DROP NOT NULL;
  
  INSERT INTO sync1_ao_all_alter_column_table1 VALUES ('sync1_ao1',generate_series(1,10),'a',11,true,'111', '1_one', '{1,2,3,4,5}', 'Hello .. how are you 1', 'Hello .. how are you 1',    '{one,two,three,four,five}',  12345678, 1, 111.1111,  11,  '1_one_11',   'd',
  '2001-12-13 01:51:15+1359',  '11',   '0.0.0.0', '0.0.0.0', 'AA:AA:AA:AA:AA:AA',   '34.23',   '00:00:00+1359',  '((2,2),1)',   '((1,2),(2,1))',   'hello', '((1,2),(2,1))', 11,   '010101',   '2001-12-13', '((1,1),(2,2))', '(1,1)', '((1,2),(2,3),(3,4),(4,3),(3,2),(2,1))',    111111, '23:00:00',   '2001-12-13 01:51:15'
  );
  
  select count(*) from sync1_ao_all_alter_column_table1;
  
  --
  --ALTER column SET STATISTICS integer
  --
            ALTER TABLE sync1_ao_all_alter_column_table1 ALTER a SET STATISTICS 1;
  
  INSERT INTO sync1_ao_all_alter_column_table1 VALUES ('sync1_ao1',generate_series(1,10),'a',11,true,'111', '1_one', '{1,2,3,4,5}', 'Hello .. how are you 1', 'Hello .. how are you 1',    '{one,two,three,four,five}',  12345678, 1, 111.1111,  11,  '1_one_11',   'd',
  '2001-12-13 01:51:15+1359',  '11',   '0.0.0.0', '0.0.0.0', 'AA:AA:AA:AA:AA:AA',   '34.23',   '00:00:00+1359',  '((2,2),1)',   '((1,2),(2,1))',   'hello', '((1,2),(2,1))', 11,   '010101',   '2001-12-13', '((1,1),(2,2))', '(1,1)', '((1,2),(2,3),(3,4),(4,3),(3,2),(2,1))',    111111, '23:00:00',   '2001-12-13 01:51:15'
  );
  
  select count(*) from sync1_ao_all_alter_column_table1;
  
  --
  --ALTER column SET STORAGE
  --
           ALTER TABLE sync1_ao_all_alter_column_table1 ALTER col007 SET STORAGE PLAIN;
  
  INSERT INTO sync1_ao_all_alter_column_table1 VALUES ('sync1_ao1',generate_series(1,10),'a',11,true,'111', '1_one', '{1,2,3,4,5}', 'Hello .. how are you 1', 'Hello .. how are you 1',    '{one,two,three,four,five}',  12345678, 1, 111.1111,  11,  '1_one_11',   'd',
  '2001-12-13 01:51:15+1359',  '11',   '0.0.0.0', '0.0.0.0', 'AA:AA:AA:AA:AA:AA',   '34.23',   '00:00:00+1359',  '((2,2),1)',   '((1,2),(2,1))',   'hello', '((1,2),(2,1))', 11,   '010101',   '2001-12-13', '((1,1),(2,2))', '(1,1)', '((1,2),(2,3),(3,4),(4,3),(3,2),(2,1))',    111111, '23:00:00',   '2001-12-13 01:51:15'
  );
  
  select count(*) from sync1_ao_all_alter_column_table1;
  
  
  
  