CoCalc -- test.sql

GitHub Repository: singlestore-labs/singlestoredb-python
Path: blob/main/singlestoredb/tests/test.sql
⁴⁶⁹ views
1

2
CREATE ROWSTORE TABLE IF NOT EXISTS data (
3
    id VARCHAR(255) NOT NULL,
4
    name VARCHAR(255) NOT NULL,
5
    value BIGINT NOT NULL,
6
    PRIMARY KEY (id) USING HASH
7
) DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;
8

9
INSERT INTO data SET id='a', name='antelopes', value=2;
10
INSERT INTO data SET id='b', name='bears', value=2;
11
INSERT INTO data SET id='c', name='cats', value=5;
12
INSERT INTO data SET id='d', name='dogs', value=4;
13
INSERT INTO data SET id='e', name='elephants', value=0;
14

15
COMMIT;
16

17
CREATE ROWSTORE TABLE IF NOT EXISTS longer_data (
18
    id VARCHAR(255) NOT NULL,
19
    name VARCHAR(255) NOT NULL,
20
    value BIGINT NOT NULL,
21
    PRIMARY KEY (id) USING HASH
22
) DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;
23

24
INSERT INTO longer_data SET id='a', name='antelopes', value=2;
25
INSERT INTO longer_data SET id='b', name='bears', value=2;
26
INSERT INTO longer_data SET id='c', name='cats', value=5;
27
INSERT INTO longer_data SET id='d', name='dogs', value=4;
28
INSERT INTO longer_data SET id='e', name='elephants', value=0;
29
INSERT INTO longer_data SET id='f', name='ferrets', value=2;
30
INSERT INTO longer_data SET id='g', name='gorillas', value=4;
31
INSERT INTO longer_data SET id='h', name='horses', value=6;
32
INSERT INTO longer_data SET id='i', name='iguanas', value=2;
33
INSERT INTO longer_data SET id='j', name='jaguars', value=0;
34
INSERT INTO longer_data SET id='k', name='kiwis', value=0;
35
INSERT INTO longer_data SET id='l', name='leopards', value=1;
36

37
COMMIT;
38

39
CREATE ROWSTORE TABLE IF NOT EXISTS data_with_nulls (
40
    id VARCHAR(255) NOT NULL,
41
    name VARCHAR(255),
42
    value BIGINT,
43
    PRIMARY KEY (id) USING HASH
44
) DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;
45

46
INSERT INTO data_with_nulls SET id='a', name='antelopes', value=2;
47
INSERT INTO data_with_nulls SET id='b', name=NULL, value=2;
48
INSERT INTO data_with_nulls SET id='c', name=NULL, value=5;
49
INSERT INTO data_with_nulls SET id='d', name='dogs', value=NULL;
50
INSERT INTO data_with_nulls SET id='e', name='elephants', value=0;
51

52
COMMIT;
53

54
CREATE OR REPLACE PROCEDURE get_animal(nm VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci) AS
55
BEGIN
56
    ECHO SELECT value FROM data WHERE name = nm; --
57
    ECHO SELECT 1, 2, 3; --
58
END;
59

60
CREATE OR REPLACE PROCEDURE no_args() AS
61
BEGIN
62
    ECHO SELECT 4, 5, 6; --
63
END;
64

65
CREATE OR REPLACE PROCEDURE return_int() RETURNS BIGINT AS
66
BEGIN
67
    RETURN 1234567890; --
68
END;
69

70
CREATE OR REPLACE PROCEDURE result_set_and_return_int() RETURNS BIGINT AS
71
BEGIN
72
    ECHO SELECT value FROM data WHERE name = 'cats'; --
73
    ECHO SELECT 1, 2, 3; --
74
    RETURN 1234567890; --
75
END;
76

77
COMMIT;
78

79
CREATE TABLE IF NOT EXISTS alltypes (
80
    `id` INT(11),
81
    `tinyint` TINYINT,
82
    `unsigned_tinyint` TINYINT UNSIGNED,
83
    `bool` BOOL,
84
    `boolean` BOOLEAN,
85
    `smallint` SMALLINT,
86
    `unsigned_smallint` SMALLINT UNSIGNED,
87
    `mediumint` MEDIUMINT,
88
    `unsigned_mediumint` MEDIUMINT UNSIGNED,
89
    `int24` MEDIUMINT,
90
    `unsigned_int24` MEDIUMINT UNSIGNED,
91
    `int` INT,
92
    `unsigned_int` INT UNSIGNED,
93
    `integer` INTEGER,
94
    `unsigned_integer` INTEGER UNSIGNED,
95
    `bigint` BIGINT,
96
    `unsigned_bigint` BIGINT UNSIGNED,
97
    `float` FLOAT,
98
    `double` DOUBLE,
99
    `real` REAL,
100
    `decimal` DECIMAL(20,6),
101
    `dec` DEC(20,6),
102
    `fixed` FIXED(20,6),
103
    `numeric` NUMERIC(20,6),
104
    `date` DATE,
105
    `time` TIME,
106
    `time_6` TIME(6),
107
    `datetime` DATETIME,
108
    `datetime_6` DATETIME(6),
109
    `timestamp` TIMESTAMP,
110
    `timestamp_6` TIMESTAMP(6),
111
    `year` YEAR,
112
    `char_100` CHAR(100),
113
    `binary_100` BINARY(100),
114
    `varchar_200` VARCHAR(200),
115
    `varbinary_200` VARBINARY(200),
116
    `longtext` LONGTEXT,
117
    `mediumtext` MEDIUMTEXT,
118
    `text` TEXT,
119
    `tinytext` TINYTEXT,
120
    `longblob` LONGBLOB,
121
    `mediumblob` MEDIUMBLOB,
122
    `blob` BLOB,
123
    `tinyblob` TINYBLOB,
124
    `json` JSON,
125
--  `geographypoint` GEOGRAPHYPOINT,
126
--  `geography` GEOGRAPHY,
127
    `enum` ENUM('one', 'two', 'three'),
128
    `set` SET('one', 'two', 'three'),
129
    `bit` BIT
130
)
131
COLLATE='utf8_unicode_ci';
132

133
INSERT INTO alltypes SET
134
    `id`=0,
135
    `tinyint`=80,
136
    `unsigned_tinyint`=85,
137
    `bool`=0,
138
    `boolean`=1,
139
    `smallint`=-27897,
140
    `unsigned_smallint`=27897,
141
    `mediumint`=104729,
142
    `unsigned_mediumint`=120999,
143
    `int24`=-200899,
144
    `unsigned_int24`=407709,
145
    `int`=-1295369311,
146
    `unsigned_int`=3872362332,
147
    `integer`=-1741727421,
148
    `unsigned_integer`=3198387363,
149
    `bigint`=-266883847,
150
    `unsigned_bigint`=980007287362,
151
    `float`=-146486683.754744,
152
    `double`=-474646154.719356,
153
    `real`=-901409776.279346,
154
    `decimal`=28111097.610822,
155
    `dec`=389451155.931428,
156
    `fixed`=-143773416.044092,
157
    `numeric`=866689461.300046,
158
    `date`='8524-11-10',
159
    `time`='00:07:00',
160
    `time_6`='01:10:00.000002',
161
    `datetime`='9948-03-11 15:29:22',
162
    `datetime_6`='1756-10-29 02:02:42.000008',
163
    `timestamp`='1980-12-31 01:10:23',
164
    `timestamp_6`='1991-01-02 22:15:10.000006',
165
    `year`=1923,
166
    `char_100`='This is a test of a 100 character column.',
167
    `binary_100`=x'000102030405060708090A0B0C0D0E0F',
168
    `varchar_200`='This is a test of a variable character column.',
169
    `varbinary_200`=x'000102030405060708090A0B0C0D0E0F000102030405060708090A0B0C0D0E0F',
170
    `longtext`='This is a longtext column.',
171
    `mediumtext`='This is a mediumtext column.',
172
    `text`='This is a text column.',
173
    `tinytext`='This is a tinytext column.',
174
    `longblob`=x'000102030405060708090A0B0C0D0E0F000102030405060708090A0B0C0D0E0F000102030405060708090A0B0C0D0E0F',
175
    `mediumblob`=x'000102030405060708090A0B0C0D0E0F000102030405060708090A0B0C0D0E0F',
176
    `blob`=x'000102030405060708090A0B0C0D0E0F',
177
    `tinyblob`=x'0A0B0C0D0E0F',
178
    `json`='{"a": 10, "b": 2.75, "c": "hello world"}',
179
    `enum`='one',
180
    `set`='two',
181
    `bit`=128
182
;
183

184
INSERT INTO alltypes SET
185
    `id`=1,
186
    `tinyint`=NULL,
187
    `bool`=NULL,
188
    `boolean`=NULL,
189
    `smallint`=NULL,
190
    `mediumint`=NULL,
191
    `int24`=NULL,
192
    `int`=NULL,
193
    `integer`=NULL,
194
    `bigint`=NULL,
195
    `float`=NULL,
196
    `double`=NULL,
197
    `real`=NULL,
198
    `decimal`=NULL,
199
    `dec`=NULL,
200
    `fixed`=NULL,
201
    `numeric`=NULL,
202
    `date`=NULL,
203
    `time`=NULL,
204
    `time_6`=NULL,
205
    `datetime`=NULL,
206
    `datetime_6`=NULL,
207
    `timestamp`=NULL,
208
    `timestamp_6`=NULL,
209
    `year`=NULL,
210
    `char_100`=NULL,
211
    `binary_100`=NULL,
212
    `varchar_200`=NULL,
213
    `longtext`=NULL,
214
    `mediumtext`=NULL,
215
    `text`=NULL,
216
    `tinytext`=NULL,
217
    `longblob`=NULL,
218
    `mediumblob`=NULL,
219
    `blob`=NULL,
220
    `tinyblob`=NULL,
221
    `json`=NULL,
222
    `enum`=NULL,
223
    `set`=NULL,
224
    `bit`=NULL
225
;
226

227
-- Minimum values
228
INSERT INTO alltypes SET
229
    `id`=2,
230
    `tinyint`=-128,
231
    `unsigned_tinyint`=0,
232
    `bool`=-128,
233
    `boolean`=-128,
234
    `smallint`=-32768,
235
    `unsigned_smallint`=0,
236
    `mediumint`=-8388608,
237
    `unsigned_mediumint`=0,
238
    `int24`=-8388608,
239
    `unsigned_int24`=0,
240
    `int`=-2147483648,
241
    `unsigned_int`=0,
242
    `integer`=-2147483648,
243
    `unsigned_integer`=0,
244
    `bigint`=-9223372036854775808,
245
    `unsigned_bigint`=0,
246
    `float`=0,
247
    `double`=-1.7976931348623158e308,
248
    `real`=-1.7976931348623158e308,
249
    `decimal`=-99999999999999.999999,
250
    `dec`=-99999999999999.999999,
251
    `fixed`=-99999999999999.999999,
252
    `numeric`=-99999999999999.999999,
253
    `date`='1000-01-01',
254
    `time`='-838:59:59',
255
    `time_6`='-838:59:59.000000',
256
    `datetime`='1000-01-01 00:00:00',
257
    `datetime_6`='1000-01-01 00:00:00.000000',
258
    `timestamp`='1970-01-01 00:00:01',
259
    `timestamp_6`='1970-01-01 00:00:01.000000',
260
    `year`=1901,
261
    `char_100`='',
262
    `binary_100`=x'',
263
    `varchar_200`='',
264
    `varbinary_200`=x'',
265
    `longtext`='',
266
    `mediumtext`='',
267
    `text`='',
268
    `tinytext`='',
269
    `longblob`=x'',
270
    `mediumblob`=x'',
271
    `blob`=x'',
272
    `tinyblob`=x'',
273
    `json`='{}',
274
    `enum`='one',
275
    `set`='two',
276
    `bit`=0
277
;
278

279
-- Maximum values
280
INSERT INTO alltypes SET
281
    `id`=3,
282
    `tinyint`=127,
283
    `unsigned_tinyint`=255,
284
    `bool`=127,
285
    `boolean`=127,
286
    `smallint`=32767,
287
    `unsigned_smallint`=65535,
288
    `mediumint`=8388607,
289
    `unsigned_mediumint`=16777215,
290
    `int24`=8388607,
291
    `unsigned_int24`=16777215,
292
    `int`=2147483647,
293
    `unsigned_int`=4294967295,
294
    `integer`=2147483647,
295
    `unsigned_integer`=4294967295,
296
    `bigint`=9223372036854775807,
297
    `unsigned_bigint`=18446744073709551615,
298
    `float`=0,
299
    `double`=1.7976931348623158e308,
300
    `real`=1.7976931348623158e308,
301
    `decimal`=99999999999999.999999,
302
    `dec`=99999999999999.999999,
303
    `fixed`=99999999999999.999999,
304
    `numeric`=99999999999999.999999,
305
    `date`='9999-12-31',
306
    `time`='838:59:59',
307
    `time_6`='838:59:59.999999',
308
    `datetime`='9999-12-31 23:59:59',
309
    `datetime_6`='9999-12-31 23:59:59.999999',
310
    `timestamp`='2038-01-18 21:14:07',
311
    `timestamp_6`='2038-01-18 21:14:07.999999',
312
    `year`=2155,
313
    `char_100`='',
314
    `binary_100`=x'',
315
    `varchar_200`='',
316
    `varbinary_200`=x'',
317
    `longtext`='',
318
    `mediumtext`='',
319
    `text`='',
320
    `tinytext`='',
321
    `longblob`=x'',
322
    `mediumblob`=x'',
323
    `blob`=x'',
324
    `tinyblob`=x'',
325
    `json`='{}',
326
    `enum`='one',
327
    `set`='two',
328
    `bit`=18446744073709551615
329
;
330

331
-- Zero values
332
--
333
-- Note that v8 of SingleStoreDB does not allow zero date/times by
334
-- default, so they are set to NULL here.
335
--
336
INSERT INTO alltypes SET
337
    `id`=4,
338
    `tinyint`=0,
339
    `unsigned_tinyint`=0,
340
    `bool`=0,
341
    `boolean`=0,
342
    `smallint`=0,
343
    `unsigned_smallint`=0,
344
    `mediumint`=0,
345
    `unsigned_mediumint`=0,
346
    `int24`=0,
347
    `unsigned_int24`=0,
348
    `int`=0,
349
    `unsigned_int`=0,
350
    `integer`=0,
351
    `unsigned_integer`=0,
352
    `bigint`=0,
353
    `unsigned_bigint`=0,
354
    `float`=0,
355
    `double`=0.0,
356
    `real`=0.0,
357
    `decimal`=0.0,
358
    `dec`=0.0,
359
    `fixed`=0.0,
360
    `numeric`=0.0,
361
    `date`=NULL,
362
    `time`='00:00:00',
363
    `time_6`='00:00:00.000000',
364
    `datetime`=NULL,
365
    `datetime_6`=NULL,
366
    `timestamp`=NULL,
367
    `timestamp_6`=NULL,
368
    `year`=NULL,
369
    `char_100`='',
370
    `binary_100`=x'',
371
    `varchar_200`='',
372
    `varbinary_200`=x'',
373
    `longtext`='',
374
    `mediumtext`='',
375
    `text`='',
376
    `tinytext`='',
377
    `longblob`=x'',
378
    `mediumblob`=x'',
379
    `blob`=x'',
380
    `tinyblob`=x'',
381
    `json`='{}',
382
    `enum`='one',
383
    `set`='two',
384
    `bit`=0
385
;
386

387

388
CREATE TABLE IF NOT EXISTS alltypes_no_nulls (
389
    `id` INT(11) NOT NULL,
390
    `tinyint` TINYINT NOT NULL,
391
    `unsigned_tinyint` TINYINT UNSIGNED NOT NULL,
392
    `bool` BOOL NOT NULL,
393
    `boolean` BOOLEAN NOT NULL,
394
    `smallint` SMALLINT NOT NULL,
395
    `unsigned_smallint` SMALLINT UNSIGNED NOT NULL,
396
    `mediumint` MEDIUMINT NOT NULL,
397
    `unsigned_mediumint` MEDIUMINT UNSIGNED NOT NULL,
398
    `int24` MEDIUMINT NOT NULL,
399
    `unsigned_int24` MEDIUMINT UNSIGNED NOT NULL,
400
    `int` INT NOT NULL,
401
    `unsigned_int` INT UNSIGNED NOT NULL,
402
    `integer` INTEGER NOT NULL,
403
    `unsigned_integer` INTEGER UNSIGNED NOT NULL,
404
    `bigint` BIGINT NOT NULL,
405
    `unsigned_bigint` BIGINT UNSIGNED NOT NULL,
406
    `float` FLOAT NOT NULL,
407
    `double` DOUBLE NOT NULL,
408
    `real` REAL NOT NULL,
409
    `decimal` DECIMAL(20,6) NOT NULL,
410
    `dec` DEC(20,6) NOT NULL,
411
    `fixed` FIXED(20,6) NOT NULL,
412
    `numeric` NUMERIC(20,6) NOT NULL,
413
    `date` DATE NOT NULL,
414
    `time` TIME NOT NULL,
415
    `time_6` TIME(6) NOT NULL,
416
    `datetime` DATETIME NOT NULL,
417
    `datetime_6` DATETIME(6) NOT NULL,
418
    `timestamp` TIMESTAMP NOT NULL,
419
    `timestamp_6` TIMESTAMP(6) NOT NULL,
420
    `year` YEAR NOT NULL,
421
    `char_100` CHAR(100) NOT NULL,
422
    `binary_100` BINARY(100) NOT NULL,
423
    `varchar_200` VARCHAR(200) NOT NULL,
424
    `varbinary_200` VARBINARY(200) NOT NULL,
425
    `longtext` LONGTEXT NOT NULL,
426
    `mediumtext` MEDIUMTEXT NOT NULL,
427
    `text` TEXT NOT NULL,
428
    `tinytext` TINYTEXT NOT NULL,
429
    `longblob` LONGBLOB NOT NULL,
430
    `mediumblob` MEDIUMBLOB NOT NULL,
431
    `blob` BLOB NOT NULL,
432
    `tinyblob` TINYBLOB NOT NULL,
433
    `json` JSON NOT NULL,
434
--  `geographypoint` GEOGRAPHYPOINT NOT NULL,
435
--  `geography` GEOGRAPHY NOT NULL,
436
    `enum` ENUM('one', 'two', 'three') NOT NULL,
437
    `set` SET('one', 'two', 'three') NOT NULL,
438
    `bit` BIT NOT NULL
439
)
440
COLLATE='utf8_unicode_ci';
441

442
INSERT INTO alltypes_no_nulls SET
443
    `id`=0,
444
    `tinyint`=80,
445
    `unsigned_tinyint`=85,
446
    `bool`=0,
447
    `boolean`=1,
448
    `smallint`=-27897,
449
    `unsigned_smallint`=27897,
450
    `mediumint`=104729,
451
    `unsigned_mediumint`=120999,
452
    `int24`=-200899,
453
    `unsigned_int24`=407709,
454
    `int`=-1295369311,
455
    `unsigned_int`=3872362332,
456
    `integer`=-1741727421,
457
    `unsigned_integer`=3198387363,
458
    `bigint`=-266883847,
459
    `unsigned_bigint`=980007287362,
460
    `float`=-146486683.754744,
461
    `double`=-474646154.719356,
462
    `real`=-901409776.279346,
463
    `decimal`=28111097.610822,
464
    `dec`=389451155.931428,
465
    `fixed`=-143773416.044092,
466
    `numeric`=866689461.300046,
467
    `date`='8524-11-10',
468
    `time`='00:07:00',
469
    `time_6`='01:10:00.000002',
470
    `datetime`='9948-03-11 15:29:22',
471
    `datetime_6`='1756-10-29 02:02:42.000008',
472
    `timestamp`='1980-12-31 01:10:23',
473
    `timestamp_6`='1991-01-02 22:15:10.000006',
474
    `year`=1923,
475
    `char_100`='This is a test of a 100 character column.',
476
    `binary_100`=x'000102030405060708090A0B0C0D0E0F',
477
    `varchar_200`='This is a test of a variable character column.',
478
    `varbinary_200`=x'000102030405060708090A0B0C0D0E0F000102030405060708090A0B0C0D0E0F',
479
    `longtext`='This is a longtext column.',
480
    `mediumtext`='This is a mediumtext column.',
481
    `text`='This is a text column.',
482
    `tinytext`='This is a tinytext column.',
483
    `longblob`=x'000102030405060708090A0B0C0D0E0F000102030405060708090A0B0C0D0E0F000102030405060708090A0B0C0D0E0F',
484
    `mediumblob`=x'000102030405060708090A0B0C0D0E0F000102030405060708090A0B0C0D0E0F',
485
    `blob`=x'000102030405060708090A0B0C0D0E0F',
486
    `tinyblob`=x'0A0B0C0D0E0F',
487
    `json`='{"a": 10, "b": 2.75, "c": "hello world"}',
488
    `enum`='one',
489
    `set`='two',
490
    `bit`=128
491
;
492

493
-- Minimum values
494
INSERT INTO alltypes_no_nulls SET
495
    `id`=2,
496
    `tinyint`=-128,
497
    `unsigned_tinyint`=0,
498
    `bool`=-128,
499
    `boolean`=-128,
500
    `smallint`=-32768,
501
    `unsigned_smallint`=0,
502
    `mediumint`=-8388608,
503
    `unsigned_mediumint`=0,
504
    `int24`=-8388608,
505
    `unsigned_int24`=0,
506
    `int`=-2147483648,
507
    `unsigned_int`=0,
508
    `integer`=-2147483648,
509
    `unsigned_integer`=0,
510
    `bigint`=-9223372036854775808,
511
    `unsigned_bigint`=0,
512
    `float`=0,
513
    `double`=-1.7976931348623158e308,
514
    `real`=-1.7976931348623158e308,
515
    `decimal`=-99999999999999.999999,
516
    `dec`=-99999999999999.999999,
517
    `fixed`=-99999999999999.999999,
518
    `numeric`=-99999999999999.999999,
519
    `date`='1000-01-01',
520
    `time`='-838:59:59',
521
    `time_6`='-838:59:59.000000',
522
    `datetime`='1000-01-01 00:00:00',
523
    `datetime_6`='1000-01-01 00:00:00.000000',
524
    `timestamp`='1970-01-01 00:00:01',
525
    `timestamp_6`='1970-01-01 00:00:01.000000',
526
    `year`=1901,
527
    `char_100`='',
528
    `binary_100`=x'',
529
    `varchar_200`='',
530
    `varbinary_200`=x'',
531
    `longtext`='',
532
    `mediumtext`='',
533
    `text`='',
534
    `tinytext`='',
535
    `longblob`=x'',
536
    `mediumblob`=x'',
537
    `blob`=x'',
538
    `tinyblob`=x'',
539
    `json`='{}',
540
    `enum`='one',
541
    `set`='two',
542
    `bit`=0
543
;
544

545
-- Maximum values
546
INSERT INTO alltypes_no_nulls SET
547
    `id`=3,
548
    `tinyint`=127,
549
    `unsigned_tinyint`=255,
550
    `bool`=127,
551
    `boolean`=127,
552
    `smallint`=32767,
553
    `unsigned_smallint`=65535,
554
    `mediumint`=8388607,
555
    `unsigned_mediumint`=16777215,
556
    `int24`=8388607,
557
    `unsigned_int24`=16777215,
558
    `int`=2147483647,
559
    `unsigned_int`=4294967295,
560
    `integer`=2147483647,
561
    `unsigned_integer`=4294967295,
562
    `bigint`=9223372036854775807,
563
    `unsigned_bigint`=18446744073709551615,
564
    `float`=0,
565
    `double`=1.7976931348623158e308,
566
    `real`=1.7976931348623158e308,
567
    `decimal`=99999999999999.999999,
568
    `dec`=99999999999999.999999,
569
    `fixed`=99999999999999.999999,
570
    `numeric`=99999999999999.999999,
571
    `date`='9999-12-31',
572
    `time`='838:59:59',
573
    `time_6`='838:59:59.999999',
574
    `datetime`='9999-12-31 23:59:59',
575
    `datetime_6`='9999-12-31 23:59:59.999999',
576
    `timestamp`='2038-01-18 21:14:07',
577
    `timestamp_6`='2038-01-18 21:14:07.999999',
578
    `year`=2155,
579
    `char_100`='',
580
    `binary_100`=x'',
581
    `varchar_200`='',
582
    `varbinary_200`=x'',
583
    `longtext`='',
584
    `mediumtext`='',
585
    `text`='',
586
    `tinytext`='',
587
    `longblob`=x'',
588
    `mediumblob`=x'',
589
    `blob`=x'',
590
    `tinyblob`=x'',
591
    `json`='{}',
592
    `enum`='one',
593
    `set`='two',
594
    `bit`=18446744073709551615
595
;
596

597

598
--
599
-- Table of extended data types
600
--
601
CREATE ROWSTORE TABLE IF NOT EXISTS `extended_types` (
602
    `id` INT(11),
603
    `geography` GEOGRAPHY,
604
    `geographypoint` GEOGRAPHYPOINT,
605
    `vectors` BLOB,
606
    `dt` DATETIME,
607
    `d` DATE,
608
    `t` TIME,
609
    `td` TIME,
610
    `testkey` LONGTEXT
611
)
612
COLLATE='utf8_unicode_ci';
613

614

615
--
616
-- Invalid utf8 table
617
--
618
-- These sequences were breaking during fetch on a customer's machine
619
-- however, they seem to work fine in our tests.
620
--
621
CREATE TABLE IF NOT EXISTS `badutf8` (
622
    `text` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
623
)
624
COLLATE='utf8_unicode_ci';
625

626

627
INSERT INTO `badutf8` VALUES ('🥷🧙👻.eth');
628
INSERT INTO `badutf8` VALUES ('🥒rick.eth');
629

630

631
CREATE TABLE IF NOT EXISTS `f32_vectors` (
632
    id INT(11),
633
    a VECTOR(3)
634
);
635
INSERT INTO f32_vectors VALUES(1, '[0.267261237,0.534522474,0.801783681]');
636
INSERT INTO f32_vectors VALUES(2, '[0.371390671,0.557085991,0.742781341]');
637
INSERT INTO f32_vectors VALUES(3, '[-0.424264073,-0.565685451,0.707106829]');
638

639
CREATE TABLE IF NOT EXISTS `f64_vectors` (
640
    id INT(11),
641
    a VECTOR(3, F64)
642
);
643
INSERT INTO f64_vectors VALUES(1, '[0.267261237,0.534522474,0.801783681]');
644
INSERT INTO f64_vectors VALUES(2, '[0.371390671,0.557085991,0.742781341]');
645
INSERT INTO f64_vectors VALUES(3, '[-0.424264073,-0.565685451,0.707106829]');
646

647
CREATE TABLE `i8_vectors` (
648
    id INT(11),
649
    a VECTOR(3, I8)
650
);
651
INSERT INTO i8_vectors VALUES(1, '[1, 2, 3]');
652
INSERT INTO i8_vectors VALUES(2, '[4, 5, 6]');
653
INSERT INTO i8_vectors VALUES(3, '[-1, -4, 8]');
654

655
CREATE TABLE `i16_vectors` (
656
    id INT(11),
657
    a VECTOR(3, I16)
658
);
659
INSERT INTO i16_vectors VALUES(1, '[1, 2, 3]');
660
INSERT INTO i16_vectors VALUES(2, '[4, 5, 6]');
661
INSERT INTO i16_vectors VALUES(3, '[-1, -4, 8]');
662

663
CREATE TABLE `i32_vectors` (
664
    id INT(11),
665
    a VECTOR(3, I32)
666
);
667
INSERT INTO i32_vectors VALUES(1, '[1, 2, 3]');
668
INSERT INTO i32_vectors VALUES(2, '[4, 5, 6]');
669
INSERT INTO i32_vectors VALUES(3, '[-1, -4, 8]');
670

671
CREATE TABLE `i64_vectors` (
672
    id INT(11),
673
    a VECTOR(3, I64)
674
);
675
INSERT INTO i64_vectors VALUES(1, '[1, 2, 3]');
676
INSERT INTO i64_vectors VALUES(2, '[4, 5, 6]');
677
INSERT INTO i64_vectors VALUES(3, '[-1, -4, 8]');
678

679

680
COMMIT;
681

682
Product

Resources

Company
