Debian Codegraph @

mysql-test/suite/ndb/t/ndb_large_metadata.test

raw
1 --source include/have_ndb.inc
2
3 # Create a table that will have metadata larger than 6,000 bytes even
4 # when compressed. We do this by specifying more than 6,000 characters
5 # of uncompressible random default values.
6 #
7 # Prior to wl#10665, expect error 1296:
8 # "Got error 1229 'Too long frm data supplied' from NDBCLUSTER"
9 # After wl#10665, expect the statement to succeed.
10 #
11 # There is no point to copying the large statement to the result file,
12 # so the query log is disabled.
13
14 --disable_query_log
15 CREATE TABLE t_big_metadata(
16 i int primary key not null,
17 j int,
18 c1 VARCHAR(800) NOT NULL DEFAULT
19 "8uA4CsAQmqiX5W3bmYyQY8KREPeBDEiZfMpCmxkD2eYnhVlrs2UEKn3KwPRG"
20 "iIOq7otFdFiYlcAkAIQcvg8cxEc0xb86bTUcxhuhbvPFBxNjvEv5lH3Ji7wo"
21 "5oiLkrOAXCEODPoMQDwaupT5AJdwthwKREwSNj20C7Eh08RsdoerIxtLswgC"
22 "imF7CQzAx7TYzE5rMSYu3Hf7FiYTFxnOruF4lWytFd6pvZamz9cMKUNIO614"
23 "pfycA1vCphFtwAY7x0b8M1IAEjD83K0PYfFPLRGyHfE1aS7OPLGNo0VVSOV6"
24 "2vKDg8hcjoTgXsYNJoalE9obfdIiWh7fwIka0ZDSFRpNAfr1rahnd1ZBRaYU"
25 "imuY5IzvyUqi4nRotdh1XVhluyxxAkMCSgx6iEonWh1pCdm7tkdWtPOoulMZ"
26 "mODaCe5JCk7ERHMFlNGwQuSctcOM97s85cVXGhpeB8jvppWklC8zxd7hwmGm"
27 "6nqf1DreGyKxVBJR5P7ly3WqWDOCUu9voyoPdxjsZQkqaZQUeCXy46XLj1Te"
28 "w2emE6x5IO42SrSYMKwj71mtGwn3YuuQQQVPoW5gxdlCHMnMzlOTyCVTqtz3"
29 "KWljegqnZYgwSSNtTCGm45i48pAytkZ6oXHKNzfCczx7Rwz59LWcOJOO8x4z"
30 "KKpKtqMVWUX0Ip5Dh37S5fdcC3PJ23qxo6aVdFZXQqEdH0Lh9FsHZw6hKIfw"
31 "hMx8BGFQViCsgUQVU6dMVQdlHD7NteKnCNU2Ahj5VE3R24vFm2BltC2wsLuc"
32 "biND6a2rjh4wbI3y0ttD",
33
34 c2 VARCHAR(800) NOT NULL DEFAULT
35 "00E1HfjKnBe0yUWFw5XdICrnKEL58I4wIpXfKvhcVPduBqpYaKXYiH1fsgMa"
36 "f4U8mETOczkt6foNFo1zuf11TO65TBGhba9JOsAwGCBW2f9CFexMcUMgCLPF"
37 "nxny0mtnsVggKycyZRAcZE5RMo3XubRGlcBCY4W4OPAcYKeplBr0RPCOVojS"
38 "3MZ4RK7qmJjyZ9Av5Psh9p1c6gQav75nduRic0mgkiRXySVC6oKgsexn6kKr"
39 "tqAJKYFUKcFbrOlglrF39azbLMW6svGDcPC17FER4NJ6M7nWc214ZFNhwuNX"
40 "1YHQQzrSsEl4LL4SBUvMMlcjDnBhZTApNQWXZaIAw2gMhKPFwzTObAeKNURR"
41 "3jT3rHVk9bGuj20n0mvo9G1WbjOr0Nq4S3vhsoQtPI7mPFoFBcWBNHKB8zbI"
42 "z1JwoqmS4cDM6eEVcM7bGhMxbNq07f5CADlLIwDNixYkwqIvTpNxPCoimNKx"
43 "vpGyUVnFsdcbdEmCrwuzk5QwgzkTpAwiylu4eJh1eqUDbDRpGtAVp8SxaMek"
44 "Bc0Zo04sTMyXRBilW47OCiOr5Zp4V6VsIUefukYRKHA1st6GeTrfed7AE6tM"
45 "sQj2OPsq8yast0XHDmJFpwHqkcBKEm0Ng67hi50z8tcMKGD1IYZWN5Bu4Ury"
46 "iOqaexc5Ba21VijFWqjR17oTpFipjJEu1m51cKrZuRjKs1bmbL0hAHF4pwLk"
47 "WSJpeVhp3kPyCu0PMpHpfdJGLIxviAYh2Y5tMB6AGr8xTONnngwlMmwgRjTH"
48 "JRLEJf63OLjW5rhvCoKA",
49
50 c3 VARCHAR(800) NOT NULL DEFAULT
51 "xxOB6sCllhh7NKuu7SS2yE02s0Hj2LpQuaY24tCmjN7vvaAp3tOnBSnEsR9Y"
52 "Sr7Pf3C4gVBWNMdnsThgtvcbDt92BlKXlHuyCaDaFgxLB3qaFcLJODTfAKUv"
53 "bvSBSRG3raW8PmdJ9yGE3kfyLC9prqq9QAtwZM77FLNCUfLQyDyIHojUyYk9"
54 "ayCPXIrnEkcFADU8hYhojYipZ2BAyfe0odZWUNdmAhKMuANEqgzhsCHMl58u"
55 "o213woGC8YsifbgEs2tMQjOUgcXDyeMZmyvFJw6QbbQBwJjT5YDkRFGln9Fr"
56 "kRn4fOw0o2swNQYqU10h8ucSelMgyJRL7WQHu0872PLfJ3HraBI1YFb9kl6t"
57 "OPTI9iZgkEssnwL0SYgj9mYC0kQeFNtaEJaTdnBGmv925IjsysnZ7SsD7q0o"
58 "jYHEHryfXAjDrlxxsMQyS1kQG215TGalSueG985ZkpKQi69MNLfrXTRJcrF2"
59 "Lwqrs1sJoUoL3m7itYozKWEw0MCBXvP4AuZ82XFwjDNC587vW1gpLiaSDyu0"
60 "E1RuOIP9wGqCU6jOJ4W8wxOnpjOLRSjaIhTIOkwxa3KvPKqHnD0i2exQphK7"
61 "tVvhQM5F7IFgmjHOOO3WjlIpvTd3WwTjzQKZWaylvjn00eielZGinPcoemG3"
62 "2YLnjkweB8gpTar6Lkj8AKPNvAvYjGLSn0baNTyBSErxYIBg3pPkKrhPl1EG"
63 "bBkZu4hRK6mgbUqdpsT9fptMqjD2DLOg6JwNQVcMl7NFuqUa3YTuQkGK6wa6"
64 "QMtwwDX6BHYC4HhqJpv5",
65
66 c4 VARCHAR(800) NOT NULL DEFAULT
67 "YJhn9RjAG9iOKZruiwxy30avbjZ6VZ8VPLKquD15WmmAijO3gwlPT8lOBG2W"
68 "cZkZibAsTvz94ARJUjzB4Gxj8SSBxr8thAYTPdNVItdJhcVVs8LUtD9nYC7e"
69 "HYbtfwYmb8oRDqFhAD7X6IMDFEVVPxBTg74tLW8tZXLjjMEAf5JnfcTlVIX9"
70 "gAAo8R8KDHVIe4GeJmN2VCeDvl1FfS4mdnOTutxzhsB1HuVk6xRDMr3c9c0J"
71 "GCYTSbmPXvkjhywu1tqzFhcGCSsyZtDGmkD0BZR88zKGvwOe0RrHg4L2Pw2N"
72 "OaXLDvRDI45HredtqKYfmkJjjfOYlhPLfE1mrLVYlnKEB7OFuqjByNPJvkhn"
73 "ysEsMLd3G0arFbQ45pNHe00WRVAI015HhzUE4MBaT8k6XNts14Yxznol4YVz"
74 "4LGT2wrQsxyaxkzM2n5kMy0kGtQbKjLkHEL8cS5VkraXsQrb44kwJl25seKd"
75 "dWpEXKyvvY2l0OGjpHcfXvKuW4TdRNg1H3cvkzT5VgGPqfLkm5Vlr1jnjvmC"
76 "BTeNQK5zGzEmQOuJmtnRdaWDWOTcaCnwWEbUiWLVQ31KpaxvHrpcr4545RZy"
77 "wavZFVZ3oDQDABBg2v7HuHBxQlDrE8htN53pvc5JYhTAsNt08zYY6ttZFqfz"
78 "Gx3oltyG1R3X5zUzyyLx9gyhQ3HDmYdnjEvgm4yjAxbJ6HpIm2JfzlY9TA1o"
79 "l8XU8riVI0u6RqEpGGLoaXhWb02NXhuTnmr7Qy5Z4xjaeJjxc4Tqqgn59wZ7"
80 "z6z70NtAqYwZcivGmLqo",
81
82 c5 VARCHAR(800) NOT NULL DEFAULT
83 "sCLcebb0JGmBGz9H5t1QOwqKFDuGdhFeT8oGW4PSu1OdyGRLFEkVy4hKB74M"
84 "coOPubnqkBiGUYhYMHtPcMNUMuHz1KS8VUGoEMZbzrV41fPd60hCYWnw503Q"
85 "zoFHSonDAzCYBfqM6I3OnWCFXR0pphNtKvuI3qYTONNKeQWaOLszjNzuoDPL"
86 "KawsDhuwMM29trzi3mV5Dgw9vkJGntYhWSjrtOd6nSoZ5ogGYDb3VI35dH8F"
87 "TArGUSvknTS3yds1m5x56kHhbXAW653hgJ2FadvRJHlv7WKBUdFxS8qHQQZN"
88 "PpzPYsKS4PKgLFK7i6EDcz3gt23nnBUAUixH9sokOAvjM6IihKMIdMZywgzI"
89 "NMZUSxvu3ECuMOzJ15RQGQK2dEEzQB84iOu8JzXnhw40rjHz1faFhfDeCLHO"
90 "8D3xIUkWvVVruR8OvjzYmNX5S94XeFE3I9t6cb2RXW90mAAqfsYFFN535nLj"
91 "lY0K7dUXfvgfPnmXaDx6lM1tp9CP43YAnzGUQjzOkpdT4gkxc25DxJU3nRZj"
92 "On5UHf0tUvGYR4ClPU7HTD5Aa79RXKbh7YJ25o1pO7FAIIWhCPrzvvdQ8zMs"
93 "RLMhO8HbXaDN5qBHXeqkftjIx7RZQxvbOtfAHOF9mMgtcWitcbvvTZPacpZ5"
94 "zOUohma0Z3TOn9cAHVECOktxUZIHfwgBXOOkoBHGk7s9L8BWGN1aaE9dcP6H"
95 "OTDaNKooBZdCXK4xGIIf77BAUL9LX2VvvrfNHMs2q5oYgydF1XKQUbuON6BJ"
96 "4MuStZPPezNYdZxGPQJ7",
97
98 c6 VARCHAR(800) NOT NULL DEFAULT
99 "9fdN6pZRCD9CYgQ4fNsGykyO9RVfbMQ4MyZnd9ZzHHDbclGIf7IefoigJFf6"
100 "STy4valMeol6K5uGBFf5UgT2rmtDlWtkUKbmbSDz75V0wgFNXa0KBJh8SsaR"
101 "nZAeDYU4Z6DYVKNrEOmxamxL79N1OoSsuqKZW4wPGT8r6ZSjQS7ctSETQ7R9"
102 "gCAfIeONsfNqa8nR4ubaE9ifVq7CUtIeesK744IcoT8ElDI4VkTEfQ4KSC0g"
103 "SbDWMMBp7ozcSsZ5EMwuIBiOsACF6zJldghV1AFD28XBze7wm5qncliW2xwL"
104 "sFdTrkk4BMvNNaC06X47ODg8Cxs8g8pPlGo6dZRi8LipkRanslHvnkew5QBH"
105 "4ZIRcbTuoxDi2LlLK5u1ElBk6sWb7qQZJkbk7OHGkcjNRq8AA9ZJq3yr75dr"
106 "d7msvmyqrUvjitBDxoBORXVCrqdtwaiJXf0mVPGEwsBRUW66wC4cSGsZAulh"
107 "BRVjT4wi68XJ0wreY9i5P9Z9rdlBqiYVSMInv9n50k0vxNEQ7qYKMqkNpf7Y"
108 "cyotmgm80cNxHEtAIDdNy0F7eKn9zzPfKt0xmt7XSZ1PQto00dBYmUFokp61"
109 "eKkiKfCHflDR4ph7pUWctpwsJMxyYKYxVVDvCA1mTLDGdPtgdKSwB8vHE3sw"
110 "A65qBCSHG5XbTaMkHTgEwZ2zGY4SA9l3oFZgJuzbNW3p1x6UoCY7KHBJmIRP"
111 "7UFbPzDIdkEjPOuvcVgcN0wjAWChiAKKqtJKVaQLlpvuIUM2M2edpMkav6po"
112 "2c7ivfYujEukYDkmBqnV",
113
114 c7 VARCHAR(800) NOT NULL DEFAULT
115 "xQnPyIwCmbR0HFA6mZGwE1DEBlxyC6wGMtmh6GMEulbRO3JnpJvdZ4fyFljM"
116 "i9JZMzE8IvIbEnV0CyHqO1jFg6Ab1o4i3ld4W1LffRoyWesNo89MBflpn5SN"
117 "SVypsDXje71et9LDTrp4QfByW2SRtcUTDRm2bnsCmzVXtnZf7V8ZyZ6CKTgq"
118 "kQOysLMOYsxAcEd5MN2ahwnF4VDKx0KTXIXzrLzYwTvSpM2jMC2PvbK4bZtI"
119 "zNc2oZdVOu763FnJ2a9d2JVTbGDl2m7Cj86k31vJPM1CnWiNmp3pa1iwReLz"
120 "Fr5wYJdB2ApxCy3zzmHHe2YIrKjceZMjVj3ZqWHrhEqmVFld9C26MXoeo91L"
121 "9LI2frpktk47gHlBPL5Inv5Tk43ILgRS96ZTWcXcAaCqDOa47cbSnXJNBpL2"
122 "PoRh4ZFlmL2BfnAd4g8HpQIHOjIOLm1RrT5si6Zzs6tUKe9A3KLPyb1Y21e2"
123 "JQiAwjVFVYhhbt2JYnucCNkIWz6eGobKm7b088GAfqcS5IvX2KK0ksc690xf"
124 "8QcAsqr2bLOlBWYs0VoZQDZJ3DYyttsC52KwwE5o0nbPPQJoudc2WhKGLQBb"
125 "6EZ0AmZdGAkmnxyDTqMw1p0yugDD7WVItEPvJIMMEKfpyfdxdKogqksAKzv8"
126 "OtBzSxAZrJ4GI2xJLZnvvXVwNrmJC18k4ANvvHb6scrock7r2Np7yA2QVhvJ"
127 "oz4HnY3QW5d6NWqXKM5816NTT6uMAOK521whF8XeN22W0aKAKviNylqSryXn"
128 "0zf6myR7wdBthYzDg6vw",
129
130 c8 VARCHAR(800) NOT NULL DEFAULT
131 "ZckjR1tNoJllwUL7xp0pNre7qbqjENkSLcTAn7UX5dQ5ST4BVG7iRSwoAsHX"
132 "J29CVs0PlpZq9dVOqGimnGxuc5QUK4U6rqyfqTAPHxIPlgXcF24chNNS5EQ4"
133 "USgZJHiEmB4OKjB0fbhcUbscrXK76LjcF58JAeIXZ6KN5scowHy9SrFufI9M"
134 "Ulc4WtW9aRpEwqo83CAkAsYWCxwhc4MDF6XV0gErNCsg6f0Jfr39nt6b75rr"
135 "u5AFTOXM1zc8altKSrO3DU6JrPCFnqEMmsxfc8mXaNDncMSL5pWaCkZpoOML"
136 "HUMgaAzaxEZNxpbOmcPej5t26jjUrR8ATocB3iqmGX4xEnpHhk4ZBwk9Kr6t"
137 "XF4wyY0Bsr8fvfDfQSO2R7Z8L0IqsAZalzbJ3ODyD4sOB1twF56n8Q3Ciepk"
138 "cj1lSmq9g8BUj6jXgqppRLUllqnk92ji8ja5lGBwrvxJqA8qrdYV6kCkVgop"
139 "XN16sCvzSsL2CrHdPFxeCEEUx4vSBfWjzHHV6UgW3abCv7AlcQ04mcq6YrQi"
140 "lckkyWpFPN2hWWcQXdxtHGOMzg1Rbe3vWOtRpxw1EGndkn8EV3R5U2ENDIdG"
141 "8qxZg75GJr4sPmbGHPznvq3TjdkIeNlzChxWG4rfBRyV3XHjVu14KTsfQNJy"
142 "pbiz9gqn6h33D3pYDCnOZavM7B8nKamRgb5L5blbCUFCoLPM421fcLgLBhYz"
143 "7a3wmzn8UDE38m8ttJEq2dwlsu401Oftr9gar2vQEjxZpGzPuiPzTQPzElxC"
144 "e0Wzc7xhhBMY9tOcTJFJ"
145 ) character set latin1 engine=ndb;
146 --enable_query_log
147
148 ## Insert some rows
149 #
150 insert into t_big_metadata(i,j) values (1,101) , (2,102) , (3,103) ;
151
152 ## Delete a row
153 #
154 delete from t_big_metadata where i = 2;
155
156 ## Query against the table
157 #
158 select i,j from t_big_metadata where i = 1;
159
160 ## INPLACE ALTER TABLE
161 #
162 alter table t_big_metadata add index(j), algorithm=inplace;
163
164 ## COPYING ALTER TABLE
165 #
166 alter table t_big_metadata drop column c8, add column k int, algorithm=copy;
167
168 ## Index scan query
169 #
170 select i,j,k from t_big_metadata where j < 103;
171
172 ## DROP the table to clean up
173 #
174 drop table t_big_metadata;