github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/comment/comment.sql (about)

     1  -- test create table
     2  drop table if exists t1;
     3  create table t1(
     4  col1 int comment '这是第一列',
     5  col2 float comment '"%$^&*()_+@!',
     6  col3 varchar comment 'KNcR5P2ksILgsZD5lTndyuEzw49gxR2RlfU7nkNhAFOKIhig6roVYgS6yQDBkuzH790peOVKgTKUasKxuepzKqsYqQg3gDtgn0KEkC1TGVh2RU6QcdQolDbnwXsnst4gVCsF1RPp975efCff8gtXKgUtRVPdSM41vtgvKkChcUIaHU9UuLvoy6BhSm9g60VKd8NTxWRiYlzdhGiTTwtqVOq7wE9NHZt8Xq55Tz9PogoGGsgObH5llIcRAQkZUraZcYBwRoHHISouTm5whECuV8X84I0s8gx1DrQulbNCQuPVUsaAFFrsawonlvLKAOYgFPg1CheDMg63wwvY7sg1W8uCNu0ZzwmRlltC8BK1y5L1E690OV84bqNbFlkInxgl9W9CsgbIwKrFXoShkfB6DnBN5khLhH4oafYkTMWh71ZEc70t583PAxZFGNEGCALP482teY4z4Vc18EkKnG5lRg4WPNVgR5lkpFkVxvwtD2GgGvVmwdwgcYG5OlSSQGhOLDDM9sIqOlN5eyIG1kcZB8tmpMicgg7IbaKxW0ACt1OlQiLufPCvsSXlU3STSBfr3HPcbZyIGfMqkxFvpGoCHDB1D0fPlLNWIksGPOXGa6ZuXrpgdqNhFgbWTUgSllMnm59RwTZgazXXLitNVgLYK9zlVv8k6T6N0orPot2V7BvLLvxNzEvfTytliQAy418XHMb3fyR5ko34lia7hZXEqsOuEq0iTgIyHBvYn1iD3wlcnu29UTB1267O8dgL03nMmWHPFqEudVMlxeEoabRSGm2LxIlRYN8peOFBvper4Iomg7qAEaodHU1SctIGuGVTuKK5K6d2rfWs8tEokxbolTG4gxMcVzSgrcvv01eNEfCWgEYXdNShX56Wqods5qgRXNn0EeMTHyBP4tZsr6LGNgqKibYemO58VL4SE5GnGURSGW0AmFg27m1zy9qucbgAyGgDmTYGRBkxDIgSNUbVyRNe1u8RYXpWaaSGg4YwEzcgXzUKSBNS0KPXMI8GzbVM',
     7  col4 bool comment ''
     8  );
     9  
    10  show create table t1;
    11  drop table t1;
    12  
    13  drop table if exists t2;
    14  -- echo Comment for field 'col3' is too long (max = 1024)
    15  create table t2(
    16  col1 int comment '这是第一列',
    17  col2 float comment '"%$^&*()_+@!"',
    18  col3 varchar comment 'KNcR5P2ksILgsZD5lTndyuEzw49gxR2RlfU7nkNhAFOKIhig6roVYgS6yQDBkuzH790peOVKgTKUasKxuepzKqsYqQg3gDtgn0KEkC1TGVh2RU6QcdQolDbnwXsnst4gVCsF1RPp975efCff8gtXKgUtRVPdSM41vtgvKkChcUIaHU9UuLvoy6BhSm9g60VKd8NTxWRiYlzdhGiTTwtqVOq7wE9NHZt8Xq55Tz9PogoGGsgObH5llIcRAQkZUraZcYBwRoHHISouTm5whECuV8X84I0s8gx1DrQulbNCQuPVUsaAFFrsawonlvLKAOYgFPg1CheDMg63wwvY7sg1W8uCNu0ZzwmRlltC8BK1y5L1E690OV84bqNbFlkInxgl9W9CsgbIwKrFXoShkfB6DnBN5khLhH4oafYkTMW3h71ZEc70t583PAxZFGNEGCALP482teY4z4Vc18EkKnG5lRg4WPNVgR5lkpFkVxvwtD2GgGvVmwdwgcYG5OlSSQGhOLDDM9sIqOlN5eyIG1kcZB8tmpMicgg7IbaKxW0ACt1OlQiLufPCvsSXlU3STSBfr3HPcbZyIGfMqkxFvpGoCHDB1D0fPlLNWIksGPOXGa6ZuXrpgdqNhFgbWTUgSllMnm59RwTZgazXXLitNVgLYK9zlVv8k6T6N0orPot2V7BvLLvxNzEvfTytliQAy418XHMb3fyR5ko34lia7hZXEqsOuEq0iTgIyHBvYn1iD3wlcnu29UTB1267O8dgL03nMmWHPFqEudVMlxeEoabRSGm2LxIlRYN8peOFBvper4Iomg7qAEaodHU1SctIGuGVTuKK5K6d2rfWs8tEokxbolTG4gxMcVzSgrcvv01eNEfCWgEYXdNShX56Wqods5qgRXNn0EeMTHyBP4tZsr6LGNgqKibYemO58VL4SE5GnGURSGW0AmFg27m1zy9qucbgAyGgDmTYGRBkxDIgSNUbVyRNe1u8RYXpWaaSGg4YwEzcgXzUKSBNS0KPXMI8GzbVM',
    19  col4 bool comment ''
    20  );
    21  
    22  show create table t2;
    23  drop table t2;
    24  
    25  drop table if exists t3;
    26  create table t3(
    27  col1 int comment '"这是第一列"/',
    28  col2 float comment '"%$^&*()_+@!"',
    29  col3 varchar comment 'KNcR5P2ksILgsZD5lTndyuEzw49gxR2RlU7nkNhAFOKIhig6roVYgS6yQDBkuzH790peOVKgTKUasKxuepzKqsYqQg3gDtgn0KEkC1TGVh2RU6QcdQolDbnwXsnst4gVCsF1RPp975efCff8gtXKgUtRVPdSM41vtgvKkChcUIaHU9UuLvoy6BhSm9g60VKd8NTxWRiYlzdhGiTTwtqVOq7wE9NHZt8Xq55Tz9PogoGGsgObH5llIcRAQkZUraZcYBwRoHHISouTm5whECuV8X84I0s8gx1DrQulbNCQuPVUsaAFFrsawonlvLKAOYgFPg1CheDMg63wwvY7sg1W8uCNu0ZzwmRlltC8BK1y5L1E690OV84bqNbFlkInxgl9W9CsgbIwKrFXoShkfB6DnBN5khLhH4oafYkTMW3h71ZEc70t583PAxZFGNEGCALP482teY4z4Vc18EkKnG5lRg4WPNVgR5lkpFkVxvwtD2GgGvVmwdwgcYG5OlSSQGhOLDDM9sIqOlN5eyIG1kcZB8tmpMicgg7IbaKxW0ACt1OlQiLufPCvsSXlU3STSBfr3HPcbZyIGfMqkxFvpGoCHDB1D0fPlLNWIksGPOXGa6ZuXrpgdqNhFgbWTUgSllMnm59RwTZgazXXLitNVgLYK9zlVv8k6T6N0orPot2V7BvLLvxNzEvfTytliQAy418XHMb3fyR5ko34lia7hZXEqsOuEq0iTgIyHBvYn1iD3wlcnu29UTB1267O8dgL03nMmWHPFqEudVMlxeEoabRSGm2LxIlRYN8peOFBvper4Iomg7qAEaodHU1SctIGuGVTuKK5K6d2rfWs8tEokxbolTG4gxMcVzSgrcvv01eNEfCWgEYXdNShX56Wqods5qgRXNn0EeMTHyBP4tZsr6LGNgqKibYemO58VL4SE5GnGURSGW0AmFg27m1zy9qucbgAyGgDmTYGRBkxDIgSNUbVyRNe1u8RYXpWaaSGg4YwEzcgXzUKSBNS0KPXMI8GzbVM',
    30  col4 bool comment ''
    31  ) comment '这是一个t3表';
    32  
    33  show create table t3;
    34  drop table t3;
    35  
    36  
    37  drop table if exists t4;
    38  create table t4(
    39  col1 int comment '"这是第一列"/',
    40  col2 float comment '"%$^&*()_+@!"',
    41  col3 varchar comment 'KNcR5P2ksILgsZD5lTndyuEzw49gxR2RlU7nkNhAFOKIhig6roVYgS6yQDBkuzH790peOVKgTKUasKxuepzKqsYqQg3gDtgn0KEkC1TGVh2RU6QcdQolDbnwXsnst4gVCsF1RPp975efCff8gtXKgUtRVPdSM41vtgvKkChcUIaHU9UuLvoy6BhSm9g60VKd8NTxWRiYlzdhGiTTwtqVOq7wE9NHZt8Xq55Tz9PogoGGsgObH5llIcRAQkZUraZcYBwRoHHISouTm5whECuV8X84I0s8gx1DrQulbNCQuPVUsaAFFrsawonlvLKAOYgFPg1CheDMg63wwvY7sg1W8uCNu0ZzwmRlltC8BK1y5L1E690OV84bqNbFlkInxgl9W9CsgbIwKrFXoShkfB6DnBN5khLhH4oafYkTMW3h71ZEc70t583PAxZFGNEGCALP482teY4z4Vc18EkKnG5lRg4WPNVgR5lkpFkVxvwtD2GgGvVmwdwgcYG5OlSSQGhOLDDM9sIqOlN5eyIG1kcZB8tmpMicgg7IbaKxW0ACt1OlQiLufPCvsSXlU3STSBfr3HPcbZyIGfMqkxFvpGoCHDB1D0fPlLNWIksGPOXGa6ZuXrpgdqNhFgbWTUgSllMnm59RwTZgazXXLitNVgLYK9zlVv8k6T6N0orPot2V7BvLLvxNzEvfTytliQAy418XHMb3fyR5ko34lia7hZXEqsOuEq0iTgIyHBvYn1iD3wlcnu29UTB1267O8dgL03nMmWHPFqEudVMlxeEoabRSGm2LxIlRYN8peOFBvper4Iomg7qAEaodHU1SctIGuGVTuKK5K6d2rfWs8tEokxbolTG4gxMcVzSgrcvv01eNEfCWgEYXdNShX56Wqods5qgRXNn0EeMTHyBP4tZsr6LGNgqKibYemO58VL4SE5GnGURSGW0AmFg27m1zy9qucbgAyGgDmTYGRBkxDIgSNUbVyRNe1u8RYXpWaaSGg4YwEzcgXzUKSBNS0KPXMI8GzbVM',
    42  col4 bool comment ''
    43  ) comment '这是一个t4表';
    44  
    45  
    46  show create table t4;
    47  drop table t4;
    48  
    49  
    50  drop table if exists t5;
    51  create table t5(
    52  col1 int comment '"这是第一列"/',
    53  col2 float comment '"%$^&*()_+@!"',
    54  col3 varchar comment 'KNcR5P2ksILgsZD5lTndyuEzw49gxR2RlU7nkNhAFOKIhig6roVYgS6yQDBkuzH790peOVKgTKUasKxuepzKqsYqQg3gDtgn0KEkC1TGVh2RU6QcdQolDbnwXsnst5gVCsF1RPp975efCff8gtXKgUtRVPdSM41vtgvKkChcUIaHU9UuLvoy6BhSm9g60VKd8NTxWRiYlzdhGiTTwtqVOq7wE9NHZt8Xq55Tz9PogoGGsgObH5llIcRAQkZUraZcYBwRoHHISouTm5whECuV8X84I0s8gx1DrQulbNCQuPVUsaAFFrsawonlvLKAOYgFPg1CheDMg63wwvY7sg1W8uCNu0ZzwmRlltC8BK1y5L1E690OV84bqNbFlkInxgl9W9CsgbIwKrFXoShkfB6DnBN5khLhH4oafYkTMW3h71ZEc70t583PAxZFGNEGCALP482teY4z4Vc18EkKnG5lRg4WPNVgR5lkpFkVxvwtD2GgGvVmwdwgcYG5OlSSQGhOLDDM9sIqOlN5eyIG1kcZB8tmpMicgg7IbaKxW0ACt1OlQiLufPCvsSXlU3STSBfr3HPcbZyIGfMqkxFvpGoCHDB1D0fPlLNWIksGPOXGa6ZuXrpgdqNhFgbWTUgSllMnm59RwTZgazXXLitNVgLYK9zlVv8k6T6N0orPot2V7BvLLvxNzEvfTytliQAy418XHMb3fyR5ko34lia7hZXEqsOuEq0iTgIyHBvYn1iD3wlcnu29UTB1267O8dgL03nMmWHPFqEudVMlxeEoabRSGm2LxIlRYN8peOFBvper4Iomg7qAEaodHU1SctIGuGVTuKK5K6d2rfWs8tEokxbolTG4gxMcVzSgrcvv01eNEfCWgEYXdNShX56Wqods5qgRXNn0EeMTHyBP4tZsr6LGNgqKibYemO58VL4SE5GnGURSGW0AmFg27m1zy9qucbgAyGgDmTYGRBkxDIgSNUbVyRNe1u8RYXpWaaSGg4YwEzcgXzUKSBNS0KPXMI8GzbVM',
    55  col4 bool comment ''
    56  ) comment 'KNcR5P2ksILgsZD5lTndyuEzw49gxR2RlU7nkNhAFOKIhig6roVYgS6yQDBkuzH790peOVKgTKUasKxuepzKqsYqQg3gDtgn0KEkC1TGVh2RU6QcdQolDbnwXsnst5gVCsF1RPp975efCff8gtXKgUtRVPdSM41vtgvKkChcUIaHU9UuLvoy6BhSm9g60VKd8NTxWRiYlzdhGiTTwtqVOq7wE9NHZt8Xq55Tz9PogoGGsgObH5llIcRAQkZUraZcYBwRoHHISouTm5whECuV8X84I0s8gx1DrQulbNCQuPVUsaAFFrsawonlvLKAOYgFPg1CheDMg63wwvY7sg1W8uCNu0ZzwmRlltC8BK1y5L1E690OV84bqNbFlkInxgl9W9CsgbIwKrFXoShkfB6DnBN5khLhH4oafYkTMW3h71ZEc70t583PAxZFGNEGCALP482teY4z4Vc18EkKnG5lRg4WPNVgR5lkpFkVxvwtD2GgGvVmwdwgcYG5OlSSQGhOLDDM9sIqOlN5eyIG1kcZB8tmpMicgg7IbaKxW0ACt1OlQiLufPCvsSXlU3STSBfr3HPcbZyIGfMqkxFvpGoCHDB1D0fPlLNWIksGPOXGa6ZuXrpgdqNhFgbWTUgSllMnm59RwTZgazXXLitNVgLYK9zlVv8k6T6N0orPot2V7BvLLvxNzEvfTytliQAy418XHMb3fyR5ko34lia7hZXEqsOuEq0iTgIyHBvYn1iD3wlcnu29UTB1267O8dgL03nMmWHPFqEudVMlxeEoabRSGm2LxIlRYN8peOFBvper4Iomg7qAEaodHU1SctIGuGVTuKK5K6d2rfWs8tEokxbolTG4gxMcVzSgrcvv01eNEfCWgEYXdNShX56Wqods5qgRXNn0EeMTHyBP4tZsr6LGNgqKibYemO58VL4SE5GnGURSGW0AmFg27m1zy9qucbgAyGgDmTYGRBkxDIgSNUbVyRNe1u8RYXpWaaSGg4YwEzcgXzUKSBNS0KPXMI8GzbVM';
    57  
    58  
    59  show create table t5;
    60  drop table t5;
    61  
    62  drop table if exists t6;
    63  create table t6(
    64  col1 int comment '"这是第一列"/',
    65  col2 float comment '"%$^&*()_+@!"',
    66  col3 varchar comment 'KNcR5P2ksILgsZD5lTndyuEzw49gxR2RlU7nkNhAFOKIhig6roVYgS6yQDBkuzH790peOVKgTKUasKxuepzKqsYqQg3gDtgn0KEkC1TGVh2RU6QcdQolDbnwXsnst6gVCsF1RPp975efCff8gtXKgUtRVPdSM41vtgvKkChcUIaHU9UuLvoy6BhSm9g60VKd8NTxWRiYlzdhGiTTwtqVOq7wE9NHZt8Xq55Tz9PogoGGsgObH5llIcRAQkZUraZcYBwRoHHISouTm5whECuV8X84I0s8gx1DrQulbNCQuPVUsaAFFrsawonlvLKAOYgFPg1CheDMg63wwvY7sg1W8uCNu0ZzwmRlltC8BK1y5L1E690OV84bqNbFlkInxgl9W9CsgbIwKrFXoShkfB6DnBN5khLhH4oafYkTMW3h71ZEc70t683PAxZFGNEGCALP482teY4z4Vc18EkKnG5lRg4WPNVgR5lkpFkVxvwtD2GgGvVmwdwgcYG5OlSSQGhOLDDM9sIqOlN5eyIG1kcZB8tmpMicgg7IbaKxW0ACt1OlQiLufPCvsSXlU3STSBfr3HPcbZyIGfMqkxFvpGoCHDB1D0fPlLNWIksGPOXGa6ZuXrpgdqNhFgbWTUgSllMnm59RwTZgazXXLitNVgLYK9zlVv8k6T6N0orPot2V7BvLLvxNzEvfTytliQAy418XHMb3fyR5ko34lia7hZXEqsOuEq0iTgIyHBvYn1iD3wlcnu29UTB1267O8dgL03nMmWHPFqEudVMlxeEoabRSGm2LxIlRYN8peOFBvper4Iomg7qAEaodHU1SctIGuGVTuKK5K6d2rfWs8tEokxbolTG4gxMcVzSgrcvv01eNEfCWgEYXdNShX56Wqods5qgRXNn0EeMTHyBP4tZsr6LGNgqKibYemO58VL4SE5GnGURSGW0AmFg27m1zy9qucbgAyGgDmTYGRBkxDIgSNUbVyRNe1u8RYXpWaaSGg4YwEzcgXzUKSBNS0KPXMI8GzbVM',
    67  col4 bool comment ''
    68  ) comment 'KNcR5P2ksILgsZD5lTndyuEzw49gxR2RlU7nkNhAFOKIhig6roVYgS6yQDBkuzH790peOVKgTKUasKxuepzKqsYqQg3gDtgn0KEkC1TGVh2RU6QcdQolDbnwXsnst6gVCsF1RPp975efCff8gtXKgUtRVPdSM41vtgvKkChcUIaHU9UuLvoy6BhSm9g60VKd8NTxWRiYlzdhGiTTwtqVOq7wE9NHZt8Xq55Tz9PogoGGsgObH5llIcRAQkZUraZcYBwRoHHISouTm5whECuV8X84I0s8gx1DrQulbNCQuPVUsaAFFrsawonlvLKAOYgFPg1CheDMg63wwvY7sg1W8uCNu0ZzwmRlltC8BK1y5L1E690OV84bqNbFlkInxgl9W9CsgbIwKrFXoShkfB6DnBN5khLhH4oafYkTMW3h71ZEc70t683PAxZFGNEGCALP482teY4z4Vc18EkKnG5lRg4WPNVgR5lkpFkVxvwtD2GgGvVmwdwgcYG5OlSSQGhOLDDM9sIqOlN5eyIG1kcZB8tmpMicgg7IbaKxW0ACt1OlQiLufPCvsSXlU3STSBfr3HPcbZyIGfMqkxFvpGoCHDB1D0fPlLNWIksGPOXGa6ZuXrpgdqNhFgbWTUgSllMnm59RwTZgazXXLitNVgLYK9zlVv8k6T6N0orPot2V7BvLLvxNzEvfTytliQAy418XHMb3fyR5ko34lia7hZXEqsOuEq0iTgIyHBvYn1iD3wlcnu29UTB1267O8dgL03nMmWHPFqEudVMlxeEoabRSGm2LxIlRYN8peOFBvper4Iomg7qAEaodHU1SctIGuGVTuKK5K6d2rfWs8tEokxbolTG4gxMcVzSgrcvv01eNEfCWgEYXdNShX56Wqods5qgRXNn0EeMTHyBP4tZsr6LGNgqKibYemO58VL4SE5GnGURSGW0AmFg27m1zy9qucbgAyGgDmTYGRBkxDIgSNUbVyRNe1u8RYXpWaaSGg4YwEzcgXzUKSBNS0KPXMI8GzbVMKNcR5P2ksILgsZD5lTndyuEzw49gxR2RlU7nkNhAFOKIhig6roVYgS6yQDBkuzH790peOVKgTKUasKxuepzKqsYqQg3gDtgn0KEkC1TGVh2RU6QcdQolDbnwXsnst6gVCsF1RPp975efCff8gtXKgUtRVPdSM41vtgvKkChcUIaHU9UuLvoy6BhSm9g60VKd8NTxWRiYlzdhGiTTwtqVOq7wE9NHZt8Xq55Tz9PogoGGsgObH5llIcRAQkZUraZcYBwRoHHISouTm5whECuV8X84I0s8gx1DrQulbNCQuPVUsaAFFrsawonlvLKAOYgFPg1CheDMg63wwvY7sg1W8uCNu0ZzwmRlltC8BK1y5L1E690OV84bqNbFlkInxgl9W9CsgbIwKrFXoShkfB6DnBN5khLhH4oafYkTMW3h71ZEc70t683PAxZFGNEGCALP482teY4z4Vc18EkKnG5lRg4WPNVgR5lkpFkVxvwtD2GgGvVmwdwgcYG5OlSSQGhOLDDM9sIqOlN5eyIG1kcZB8tmpMicgg7IbaKxW0ACt1OlQiLufPCvsSXlU3STSBfr3HPcbZyIGfMqkxFvpGoCHDB1D0fPlLNWIksGPOXGa6ZuXrpgdqNhFgbWTUgSllMnm59RwTZgazXXLitNVgLYK9zlVv8k6T6N0orPot2V7BvLLvxNzEvfTytliQAy418XHMb3fyR5ko34lia7hZXEqsOuEq0iTgIyHBvYn1iD3wlcnu29UTB1267O8dgL03nMmWHPFqEudVMlxeEoabRSGm2LxIlRYN8peOFBvper4Iomg7qAEaodHU1SctIGuGVTuKK5K6d2rfWs8tEokxbolTG4gxMcVzSgrcvv01eNEfCWgEYXdNShX56Wqods5qgRXNn0EeMTHyBP4tZsr6LGNgqKibYemO58VL4SE5GnGURSGW0AmFg27m1zy9qucbgAyGgDmTYGRBkxDIgSNUbVyRNe1u8RYXpWaaSGg4YwEzcgXzUKSBNS0KPXMI8GzbVM';
    69  
    70  
    71  show create table t6;
    72  drop table t6;
    73  
    74  
    75  drop table if exists t7;
    76  -- Comment for table 't7' is too long (max = 2048)
    77  create table t7(
    78  col1 int comment '"这是第一列"/',
    79  col2 float comment '"%$^&*()_+@!"',
    80  col3 varchar comment 'KNcR5P2ksILgsZD5lTndyuEzw49gxR2RlU7nkNhAFOKIhig6roVYgS6yQDBkuzH790peOVKgTKUasKxuepzKqsYqQg3gDtgn0KEkC1TGVh2RU6QcdQolDbnwXsnst6gVCsF1RPp975efCff8gtXKgUtRVPdSM41vtgvKkChcUIaHU9UuLvoy6BhSm9g60VKd8NTxWRiYlzdhGiTTwtqVOq7wE9NHZt8Xq55Tz9PogoGGsgObH5llIcRAQkZUraZcYBwRoHHISouTm5whECuV8X84I0s8gx1DrQulbNCQuPVUsaAFFrsawonlvLKAOYgFPg1CheDMg63wwvY7sg1W8uCNu0ZzwmRlltC8BK1y5L1E690OV84bqNbFlkInxgl9W9CsgbIwKrFXoShkfB6DnBN5khLhH4oafYkTMW3h71ZEc70t683PAxZFGNEGCALP482teY4z4Vc18EkKnG5lRg4WPNVgR5lkpFkVxvwtD2GgGvVmwdwgcYG5OlSSQGhOLDDM9sIqOlN5eyIG1kcZB8tmpMicgg7IbaKxW0ACt1OlQiLufPCvsSXlU3STSBfr3HPcbZyIGfMqkxFvpGoCHDB1D0fPlLNWIksGPOXGa6ZuXrpgdqNhFgbWTUgSllMnm59RwTZgazXXLitNVgLYK9zlVv8k6T6N0orPot2V7BvLLvxNzEvfTytliQAy418XHMb3fyR5ko34lia7hZXEqsOuEq0iTgIyHBvYn1iD3wlcnu29UTB1267O8dgL03nMmWHPFqEudVMlxeEoabRSGm2LxIlRYN8peOFBvper4Iomg7qAEaodHU1SctIGuGVTuKK5K6d2rfWs8tEokxbolTG4gxMcVzSgrcvv01eNEfCWgEYXdNShX56Wqods5qgRXNn0EeMTHyBP4tZsr6LGNgqKibYemO58VL4SE5GnGURSGW0AmFg27m1zy9qucbgAyGgDmTYGRBkxDIgSNUbVyRNe1u8RYXpWaaSGg4YwEzcgXzUKSBNS0KPXMI8GzbVM',
    81  col4 bool comment ''
    82  ) comment 'KNcR5dP2ksILgsZD5lTndyuEzw49gxR2RlU7nkNhAFOKIhig6roVYgS6yQDBkuzH790peOVKgTKUasKxuepzKqsYqQg3gDtgn0KEkC1TGVh2RU6QcdQolDbnwXsnst6gVCsF1RPp975efCff8gtXKgUtRVPdSM41vtgvKkChcUIaHU9UuLvoy6BhSm9g60VKd8NTxWRiYlzdhGiTTwtqVOq7wE9NHZt8Xq55Tz9PogoGGsgObH5llIcRAQkZUraZcYBwRoHHISouTm5whECuV8X84I0s8gx1DrQulbNCQuPVUsaAFFrsawonlvLKAOYgFPg1CheDMg63wwvY7sg1W8uCNu0ZzwmRlltC8BK1y5L1E690OV84bqNbFlkInxgl9W9CsgbIwKrFXoShkfB6DnBN5khLhH4oafYkTMW3h71ZEc70t683PAxZFGNEGCALP482teY4z4Vc18EkKnG5lRg4WPNVgR5lkpFkVxvwtD2GgGvVmwdwgcYG5OlSSQGhOLDDM9sIqOlN5eyIG1kcZB8tmpMicgg7IbaKxW0ACt1OlQiLufPCvsSXlU3STSBfr3HPcbZyIGfMqkxFvpGoCHDB1D0fPlLNWIksGPOXGa6ZuXrpgdqNhFgbWTUgSllMnm59RwTZgazXXLitNVgLYK9zlVv8k6T6N0orPot2V7BvLLvxNzEvfTytliQAy418XHMb3fyR5ko34lia7hZXEqsOuEq0iTgIyHBvYn1iD3wlcnu29UTB1267O8dgL03nMmWHPFqEudVMlxeEoabRSGm2LxIlRYN8peOFBvper4Iomg7qAEaodHU1SctIGuGVTuKK5K6d2rfWs8tEokxbolTG4gxMcVzSgrcvv01eNEfCWgEYXdNShX56Wqods5qgRXNn0EeMTHyBP4tZsr6LGNgqKibYemO58VL4SE5GnGURSGW0AmFg27m1zy9qucbgAyGgDmTYGRBkxDIgSNUbVyRNe1u8RYXpWaaSGg4YwEzcgXzUKSBNS0KPXMI8GzbVMKNcR5P2ksILgsZD5lTndyuEzw49gxR2RlU7nkNhAFOKIhig6roVYgS6yQDBkuzH790peOVKgTKUasKxuepzKqsYqQg3gDtgn0KEkC1TGVh2RU6QcdQolDbnwXsnst6gVCsF1RPp975efCff8gtXKgUtRVPdSM41vtgvKkChcUIaHU9UuLvoy6BhSm9g60VKd8NTxWRiYlzdhGiTTwtqVOq7wE9NHZt8Xq55Tz9PogoGGsgObH5llIcRAQkZUraZcYBwRoHHISouTm5whECuV8X84I0s8gx1DrQulbNCQuPVUsaAFFrsawonlvLKAOYgFPg1CheDMg63wwvY7sg1W8uCNu0ZzwmRlltC8BK1y5L1E690OV84bqNbFlkInxgl9W9CsgbIwKrFXoShkfB6DnBN5khLhH4oafYkTMW3h71ZEc70t683PAxZFGNEGCALP482teY4z4Vc18EkKnG5lRg4WPNVgR5lkpFkVxvwtD2GgGvVmwdwgcYG5OlSSQGhOLDDM9sIqOlN5eyIG1kcZB8tmpMicgg7IbaKxW0ACt1OlQiLufPCvsSXlU3STSBfr3HPcbZyIGfMqkxFvpGoCHDB1D0fPlLNWIksGPOXGa6ZuXrpgdqNhFgbWTUgSllMnm59RwTZgazXXLitNVgLYK9zlVv8k6T6N0orPot2V7BvLLvxNzEvfTytliQAy418XHMb3fyR5ko34lia7hZXEqsOuEq0iTgIyHBvYn1iD3wlcnu29UTB1267O8dgL03nMmWHPFqEudVMlxeEoabRSGm2LxIlRYN8peOFBvper4Iomg7qAEaodHU1SctIGuGVTuKK5K6d2rfWs8tEokxbolTG4gxMcVzSgrcvv01eNEfCWgEYXdNShX56Wqods5qgRXNn0EeMTHyBP4tZsr6LGNgqKibYemO58VL4SE5GnGURSGW0AmFg27m1zy9qucbgAyGgDmTYGRBkxDIgSNUbVyRNe1u8RYXpWaaSGg4YwEzcgXzUKSBNS0KPXMI8GzbVM';
    83  
    84  
    85  show create table t7;
    86  drop table t7;
    87  
    88  
    89  drop table if exists t8;
    90  create table t8(
    91  col1 int comment '这是第一列',
    92  col2 float comment '"%$^&*()_+@!\'',
    93  col3 varchar comment 'KNcR5P2ksILgsZD5lTndyuEzw49gxR2RlfU7nkNhAFOKIhig6roVYgS6yQDBkuzH790peOVKgTKUasKxuepzKqsYqQg3gDtgn0KEkC1TGVh2RU6QcdQolDbnwXsnst4gVCsF1RPp975efCff8gtXKgUtRVPdSM41vtgvKkChcUIaHU9UuLvoy6BhSm9g60VKd8NTxWRiYlzdhGiTTwtqVOq7wE9NHZt8Xq55Tz9PogoGGsgObH5llIcRAQkZUraZcYBwRoHHISouTm5whECuV8X84I0s8gx1DrQulbNCQuPVUsaAFFrsawonlvLKAOYgFPg1CheDMg63wwvY7sg1W8uCNu0ZzwmRlltC8BK1y5L1E690OV84bqNbFlkInxgl9W9CsgbIwKrFXoShkfB6DnBN5khLhH4oafYkTMWh71ZEc70t583PAxZFGNEGCALP482teY4z4Vc18EkKnG5lRg4WPNVgR5lkpFkVxvwtD2GgGvVmwdwgcYG5OlSSQGhOLDDM9sIqOlN5eyIG1kcZB8tmpMicgg7IbaKxW0ACt8OlQiLufPCvsSXlU3STSBfr3HPcbZyIGfMqkxFvpGoCHDB1D0fPlLNWIksGPOXGa6ZuXrpgdqNhFgbWTUgSllMnm59RwTZgazXXLitNVgLYK9zlVv8k6T6N0orPot2V7BvLLvxNzEvfTytliQAy418XHMb3fyR5ko34lia7hZXEqsOuEq0iTgIyHBvYn1iD3wlcnu29UTB1267O8dgL03nMmWHPFqEudVMlxeEoabRSGm2LxIlRYN8peOFBvper4Iomg7qAEaodHU1SctIGuGVTuKK5K6d2rfWs8tEokxbolTG4gxMcVzSgrcvv01eNEfCWgEYXdNShX56Wqods5qgRXNn0EeMTHyBP4tZsr6LGNgqKibYemO58VL4SE5GnGURSGW0AmFg27m1zy9qucbgAyGgDmTYGRBkxDIgSNUbVyRNe1u8RYXpWaaSGg4YwEzcgXzUKSBNS0KPXMI8GzbVM',
    94  col4 bool comment ''
    95  );
    96  
    97  show create table t8;
    98  drop table t8;