1SET @tmp=ST_GIS_DEBUG(1);
2DROP TABLE IF EXISTS p1;
3CREATE PROCEDURE p1(dist DOUBLE, geom TEXT)
4BEGIN
5DECLARE g GEOMETRY;
6SET g=GeomFromText(geom);
7SELECT geom AS `-----`;
8SELECT dist, GeometryType(@buf:=ST_Buffer(g, dist)) AS `buffer`, ROUND(ST_AREA(@buf),2) AS buf_area;
9END|
10#
11# Testing ST_BUFFER with positive distance
12#
13-----
14POINT(0 0))
15dist	buffer	buf_area
161	POLYGON	3.14
17-----
18LineString(0 1, 1 1))
19dist	buffer	buf_area
201	POLYGON	5.14
21-----
22LineString(9 9,8 1,1 5,0 0)
23dist	buffer	buf_area
241	POLYGON	44.63
25-----
26Polygon((2 2,2 8,8 8,8 2,2 2))
27dist	buffer	buf_area
281	POLYGON	63.14
29-----
30Polygon((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))
31dist	buffer	buf_area
321	POLYGON	95.14
33-----
34Polygon((0 0, 0 8, 8 8, 8 10, -10 10, -10 0, 0 0))
35dist	buffer	buf_area
361	POLYGON	174.93
37-----
38MultiPoint(9 9,8 1,1 5)
39dist	buffer	buf_area
401	MULTIPOLYGON	9.42
41-----
42MultiLineString((0 0,2 2))
43dist	buffer	buf_area
441	POLYGON	8.80
45-----
46MultiLineString((0 0,2 2,0 4))
47dist	buffer	buf_area
481	POLYGON	14.24
49-----
50MultiLineString((0 0,2 2),(0 2,2 0))
51dist	buffer	buf_area
521	POLYGON	13.59
53-----
54MultiLineString((2 2,2 8,-2 8),(-6 -6, 6 6),(10 10, 14 14))
55dist	buffer	buf_area
561	MULTIPOLYGON	70.06
57-----
58MultiPolygon(((2 2,2 8,8 8,8 2,2 2)), ((9 9,8 1,1 5,9 9)))
59dist	buffer	buf_area
601	POLYGON	73.18
61-----
62MultiPolygon(((2 2,2 8,8 8,8 2,2 2), (4 4,4 6,6 6,6 4,4 4)),((9 9,8 1,1 5,9 9)))
63dist	buffer	buf_area
641	POLYGON	73.18
65-----
66GeometryCollection(Point(0 0))
67dist	buffer	buf_area
681	POLYGON	3.14
69-----
70GeometryCollection(LineString(0 0, 2 2)))
71dist	buffer	buf_area
721	POLYGON	8.80
73-----
74GeometryCollection(Polygon((2 2,2 8,8 8,8 2,2 2))))
75dist	buffer	buf_area
761	POLYGON	63.14
77-----
78GeometryCollection(MultiPoint(9 9,8 1,1 5))
79dist	buffer	buf_area
801	MULTIPOLYGON	9.42
81-----
82GeometryCollection(MultiLineString((0 0,0 1),(3 0,3 1)))
83dist	buffer	buf_area
841	MULTIPOLYGON	10.28
85-----
86GeometryCollection(MultiPolygon(((0 0, 3 0, 3 3, 0 3, 0 0)),((6 6,6 9,9 9,9 6,6 6))))
87dist	buffer	buf_area
881	MULTIPOLYGON	48.28
89-----
90GeometryCollection(Point(9 9),LineString(1 5,0 0),Polygon((2 2,2 8,8 8,8 2,2 2)))
91dist	buffer	buf_area
921	POLYGON	75.92
93#
94# Testing ST_BUFFER with zero distance
95#
96-----
97POINT(0 0))
98dist	buffer	buf_area
990	POINT	0.00
100-----
101LineString(0 1, 1 1))
102dist	buffer	buf_area
1030	LINESTRING	0.00
104-----
105LineString(9 9,8 1,1 5,0 0)
106dist	buffer	buf_area
1070	LINESTRING	0.00
108-----
109Polygon((2 2,2 8,8 8,8 2,2 2))
110dist	buffer	buf_area
1110	POLYGON	36.00
112-----
113Polygon((0 0,0 8,8 8,8 0,0 0),(2 2,6 2,6 6,2 6,2 2))
114dist	buffer	buf_area
1150	POLYGON	48.00
116-----
117Polygon((0 0, 0 8, 8 8, 8 10, -10 10, -10 0, 0 0))
118dist	buffer	buf_area
1190	POLYGON	116.00
120-----
121MultiPoint(9 9,8 1,1 5)
122dist	buffer	buf_area
1230	MULTIPOINT	NULL
124-----
125MultiLineString((0 0,2 2))
126dist	buffer	buf_area
1270	MULTILINESTRING	NULL
128-----
129MultiLineString((0 0,2 2,0 4))
130dist	buffer	buf_area
1310	MULTILINESTRING	NULL
132-----
133MultiLineString((0 0,2 2),(0 2,2 0))
134dist	buffer	buf_area
1350	MULTILINESTRING	NULL
136-----
137MultiLineString((2 2,2 8,-2 8),(-6 -6, 6 6),(10 10, 14 14))
138dist	buffer	buf_area
1390	MULTILINESTRING	NULL
140-----
141MultiPolygon(((2 2,2 8,8 8,8 2,2 2)), ((9 9,8 1,1 5,9 9)))
142dist	buffer	buf_area
1430	MULTIPOLYGON	66.00
144-----
145MultiPolygon(((2 2,2 8,8 8,8 2,2 2), (4 4,4 6,6 6,6 4,4 4)),((9 9,8 1,1 5,9 9)))
146dist	buffer	buf_area
1470	MULTIPOLYGON	62.00
148-----
149GeometryCollection(Point(0 0))
150dist	buffer	buf_area
1510	GEOMETRYCOLLECTION	0.00
152-----
153GeometryCollection(LineString(0 0, 2 2)))
154dist	buffer	buf_area
1550	GEOMETRYCOLLECTION	0.00
156-----
157GeometryCollection(Polygon((2 2,2 8,8 8,8 2,2 2))))
158dist	buffer	buf_area
1590	GEOMETRYCOLLECTION	36.00
160-----
161GeometryCollection(MultiPoint(9 9,8 1,1 5))
162dist	buffer	buf_area
1630	GEOMETRYCOLLECTION	NULL
164-----
165GeometryCollection(MultiLineString((0 0,0 1),(3 0,3 1)))
166dist	buffer	buf_area
1670	GEOMETRYCOLLECTION	NULL
168-----
169GeometryCollection(MultiPolygon(((0 0, 3 0, 3 3, 0 3, 0 0)),((6 6,6 9,9 9,9 6,6 6))))
170dist	buffer	buf_area
1710	GEOMETRYCOLLECTION	18.00
172-----
173GeometryCollection(Point(9 9),LineString(1 5,0 0),Polygon((2 2,2 8,8 8,8 2,2 2)))
174dist	buffer	buf_area
1750	GEOMETRYCOLLECTION	36.00
176#
177# Testing ST_BUFFER with negative distance
178#
179-----
180POINT(0 0))
181dist	buffer	buf_area
182-1	GEOMETRYCOLLECTION	0.00
183-----
184LineString(0 1, 1 1))
185dist	buffer	buf_area
186-1	GEOMETRYCOLLECTION	0.00
187-----
188LineString(9 9,8 1,1 5,0 0)
189dist	buffer	buf_area
190-1	GEOMETRYCOLLECTION	0.00
191-----
192Polygon((2 2,2 8,8 8,8 2,2 2))
193dist	buffer	buf_area
194-1	POLYGON	16.00
195-----
196MultiPoint(9 9,8 1,1 5)
197dist	buffer	buf_area
198-1	GEOMETRYCOLLECTION	0.00
199-----
200MultiLineString((0 0,2 2))
201dist	buffer	buf_area
202-1	GEOMETRYCOLLECTION	0.00
203-----
204MultiLineString((0 0,2 2,0 4))
205dist	buffer	buf_area
206-1	GEOMETRYCOLLECTION	0.00
207-----
208MultiLineString((0 0,2 2),(0 2,2 0))
209dist	buffer	buf_area
210-1	GEOMETRYCOLLECTION	0.00
211-----
212MultiLineString((2 2,2 8,-2 8),(-6 -6, 6 6),(10 10, 14 14))
213dist	buffer	buf_area
214-1	GEOMETRYCOLLECTION	0.00
215-----
216GeometryCollection(Point(0 0))
217dist	buffer	buf_area
218-1	GEOMETRYCOLLECTION	0.00
219-----
220GeometryCollection(LineString(0 0, 2 2)))
221dist	buffer	buf_area
222-1	GEOMETRYCOLLECTION	0.00
223-----
224GeometryCollection(Polygon((2 2,2 8,8 8,8 2,2 2))))
225dist	buffer	buf_area
226-1	POLYGON	16.00
227-----
228GeometryCollection(MultiPoint(9 9,8 1,1 5))
229dist	buffer	buf_area
230-1	GEOMETRYCOLLECTION	0.00
231-----
232GeometryCollection(MultiLineString((0 0,0 1),(3 0,3 1)))
233dist	buffer	buf_area
234-1	GEOMETRYCOLLECTION	0.00
235-----
236GeometryCollection(Point(9 9),LineString(1 5,0 0),Polygon((2 2,2 8,8 8,8 2,2 2)))
237dist	buffer	buf_area
238-1	POLYGON	16.00
239SELECT ST_CONTAINS(
240GeomFromText('MULTIPOLYGON(((0 0, 0 5, 5 5, 5 0, 0 0)),((6 6, 6 11, 11 11, 11 6, 6 6)))'),
241GeomFromText('POINT(5 10)'));
242ST_CONTAINS(
243GeomFromText('MULTIPOLYGON(((0 0, 0 5, 5 5, 5 0, 0 0)),((6 6, 6 11, 11 11, 11 6, 6 6)))'),
244GeomFromText('POINT(5 10)'))
2450
246SELECT AsText(ST_UNION(
247GeomFromText('MULTIPOLYGON(((0 0, 0 5, 5 5, 5 0, 0 0)),((6 6, 6 11, 11 11, 11 6, 6 6)))'),
248GeomFromText('POINT(5 10)')));
249AsText(ST_UNION(
250GeomFromText('MULTIPOLYGON(((0 0, 0 5, 5 5, 5 0, 0 0)),((6 6, 6 11, 11 11, 11 6, 6 6)))'),
251GeomFromText('POINT(5 10)')))
252GEOMETRYCOLLECTION(POLYGON((0 0,0 5,5 5,5 0,0 0)),POLYGON((6 6,6 11,11 11,11 6,6 6)),POINT(5 10))
253DROP PROCEDURE p1;
254#
255# Bug #13833019 ASSERTION `T1->RESULT_RANGE' FAILED IN GCALC_OPERATION_REDUCER::END_COUPLE
256#
257SELECT GeometryType(ST_BUFFER(MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,9 4,3 3,0 0)),((2 2,2 2,8 8,2 3,2 2)))'), 3));
258GeometryType(ST_BUFFER(MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,9 4,3 3,0 0)),((2 2,2 2,8 8,2 3,2 2)))'), 3))
259POLYGON
260#
261# Bug #13832749 	HANDLE_FATAL_SIGNAL IN GCALC_FUNCTION::COUNT_INTERNAL
262#
263SELECT GeometryType(ST_BUFFER(MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((3 5,2 5,2 4,3 4,3 5)),((2 2,2 8,8 8,8 2,2 2), (4 4,4 6,6 6,6 4,4 4)), ((9 9,8 1,1 5,9 9)))'),1));
264GeometryType(ST_BUFFER(MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((3 5,2 5,2 4,3 4,3 5)),((2 2,2 8,8 8,8 2,2 2), (4 4,4 6,6 6,6 4,4 4)), ((9 9,8 1,1 5,9 9)))'),1))
265POLYGON
266#
267# Bug#13358363 - ASSERTION: N > 0 && N < SINUSES_CALCULATED*2+1 | GET_N_SINCOS/ADD_EDGE_BUFFER
268#
269DO ST_BUFFER(ST_GEOMCOLLFROMTEXT('linestring(1 1,2 2)'),'');
270Warnings:
271Warning	1292	Truncated incorrect DOUBLE value: ''
272SELECT ST_WITHIN(
273LINESTRINGFROMTEXT(' LINESTRING(3 8,9 2,3 8,3 3,7 6,4 7,4 7,8 1) '),
274ST_BUFFER(MULTIPOLYGONFROMTEXT(' MULTIPOLYGON(((3 5,2 5,2 4,3 4,3 5)),((2 2,2 8,8 8,8 2,2 2),(4 4,4 6,6 6,6 4,4 4)),((0 5,3 5,3 2,1 2,1 1,3 1,3 0,0 0,0 3,2 3,2 4,0 4,0 5))) '),
275ST_NUMINTERIORRINGS(POLYGONFROMTEXT('POLYGON((3 5,2 4,2 5,3 5)) '))));
276ST_WITHIN(
277LINESTRINGFROMTEXT(' LINESTRING(3 8,9 2,3 8,3 3,7 6,4 7,4 7,8 1) '),
278ST_BUFFER(MULTIPOLYGONFROMTEXT(' MULTIPOLYGON(((3 5,2 5,2 4,3 4,3 5)),((2 2,2 8,8 8,8 2,2 2),(4 4,4 6,6 6,6 4,4 4)),((0 5,3 5,3 2,1 2,1 1,3 1,3 0,0 0,0 3,2 3,2 4,0 4,0 5))) ')
2790
280SELECT ST_DIMENSION(ST_BUFFER(POLYGONFROMTEXT(' POLYGON((3 5,2 5,2 4,3 4,3 5)) '),
281ST_NUMINTERIORRINGS(POLYGONFROMTEXT(' POLYGON((0 0,9 3,4 2,0 0))'))));
282ST_DIMENSION(ST_BUFFER(POLYGONFROMTEXT(' POLYGON((3 5,2 5,2 4,3 4,3 5)) '),
283ST_NUMINTERIORRINGS(POLYGONFROMTEXT(' POLYGON((0 0,9 3,4 2,0 0))'))))
2842
285SELECT ST_NUMINTERIORRINGS(
286ST_ENVELOPE(ST_BUFFER(MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((3 5,2 5,2 4,3 4,3 5))) '),
287SRID(MULTILINESTRINGFROMTEXT('MULTILINESTRING((2 2,4 2,1 2,2 4,2 2)) ')))));
288ST_NUMINTERIORRINGS(
289ST_ENVELOPE(ST_BUFFER(MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((3 5,2 5,2 4,3 4,3 5))) '),
290SRID(MULTILINESTRINGFROMTEXT('MULTILINESTRING((2 2,4 2,1 2,2 4,2 2)) ')))))
2910
292SELECT ASTEXT(ST_BUFFER(POLYGONFROMTEXT(' POLYGON((9 9,5 2,4 5,9 9))'),
293SRID(GEOMETRYFROMTEXT(' MULTIPOINT(8 4,5 0,7 8,6 9,3 4,7 3,5 5) '))));
294ASTEXT(ST_BUFFER(POLYGONFROMTEXT(' POLYGON((9 9,5 2,4 5,9 9))'),
295SRID(GEOMETRYFROMTEXT(' MULTIPOINT(8 4,5 0,7 8,6 9,3 4,7 3,5 5) '))))
296POLYGON((9 9,5 2,4 5,9 9))
297#
298# Start of 10.2 tests
299#
300#
301# MDEV-10134 Add full support for DEFAULT
302#
303CREATE TABLE t1 (a INT DEFAULT ST_GIS_DEBUG(1));
304ERROR HY000: Function or expression 'st_gis_debug()' cannot be used in the DEFAULT clause of `a`
305#
306# End of 10.2 tests
307#
308#
309# Start of 10.3 tests
310#
311#
312# Comparison data type aggregation for pluggable data types
313#
314SET SESSION debug_dbug="+d,Item_func_in";
315SET SESSION debug_dbug="+d,Predicant_to_list_comparator";
316CREATE TABLE t1 (a POINT);
317INSERT INTO t1 VALUES (POINT(1,1)),(POINT(1,2)),(POINT(1,3));
318SELECT COUNT(*) FROM t1 WHERE a IN (POINT(1,1),POINT(10,20),POINT(10,30));
319COUNT(*)
3201
321Warnings:
322Note	1105	DBUG: [0] arg=1 handler=0 (geometry)
323Note	1105	DBUG: [1] arg=2 handler=0 (geometry)
324Note	1105	DBUG: [2] arg=3 handler=0 (geometry)
325Note	1105	DBUG: types_compatible=yes bisect=yes
326SELECT COUNT(*) FROM t1 WHERE a IN (POINT(1,1),POINT(10,20),POINT(10,30),'test');
327COUNT(*)
3281
329Warnings:
330Note	1105	DBUG: [0] arg=1 handler=0 (geometry)
331Note	1105	DBUG: [1] arg=2 handler=0 (geometry)
332Note	1105	DBUG: [2] arg=3 handler=0 (geometry)
333Note	1105	DBUG: [3] arg=4 handler=3 (longblob)
334Note	1105	DBUG: types_compatible=no bisect=no
335SELECT COUNT(*) FROM t1 WHERE a IN ('test','test1');
336COUNT(*)
3370
338Warnings:
339Note	1105	DBUG: [0] arg=1 handler=0 (longblob)
340Note	1105	DBUG: [1] arg=2 handler=0 (longblob)
341Note	1105	DBUG: types_compatible=yes bisect=yes
342DROP TABLE t1;
343CREATE TABLE t1 (a TEXT);
344INSERT INTO t1 VALUES ('test'),('test1'),('test2');
345SELECT * FROM t1 WHERE a IN ('test',POINT(1,1));
346a
347test
348Warnings:
349Note	1105	DBUG: [0] arg=1 handler=0 (longblob)
350Note	1105	DBUG: [1] arg=2 handler=0 (longblob)
351Note	1105	DBUG: types_compatible=yes bisect=yes
352DROP TABLE t1;
353SET SESSION debug_dbug="-d,Predicant_to_list_comparator";
354SET SESSION debug_dbug="-d,Item_func_in";
355#
356# MDEV-12238 Add Type_handler::Item_func_{plus|minus|mul|div|mod}_fix_length_and_dec()
357#
358SET debug_dbug='+d,num_op';
359CREATE TABLE t1 AS SELECT
360POINT(0,0)+POINT(0,0),
361POINT(0,0)-POINT(0,0),
362POINT(0,0)*POINT(0,0),
363POINT(0,0)/POINT(0,0),
364POINT(0,0) MOD POINT(0,0) LIMIT 0;
365SHOW CREATE TABLE t1;
366Table	Create Table
367t1	CREATE TABLE `t1` (
368  `POINT(0,0)+POINT(0,0)` geometry DEFAULT NULL,
369  `POINT(0,0)-POINT(0,0)` geometry DEFAULT NULL,
370  `POINT(0,0)*POINT(0,0)` geometry DEFAULT NULL,
371  `POINT(0,0)/POINT(0,0)` geometry DEFAULT NULL,
372  `POINT(0,0) MOD POINT(0,0)` geometry DEFAULT NULL
373) ENGINE=MyISAM DEFAULT CHARSET=latin1
374DROP TABLE t1;
375CREATE TABLE t1 AS SELECT
376POINT(0,0)+'0',
377POINT(0,0)-'0',
378POINT(0,0)*'0',
379POINT(0,0)/'0',
380POINT(0,0) MOD '0' LIMIT 0;
381SHOW CREATE TABLE t1;
382Table	Create Table
383t1	CREATE TABLE `t1` (
384  `POINT(0,0)+'0'` tinytext DEFAULT NULL,
385  `POINT(0,0)-'0'` tinytext DEFAULT NULL,
386  `POINT(0,0)*'0'` tinytext DEFAULT NULL,
387  `POINT(0,0)/'0'` tinytext DEFAULT NULL,
388  `POINT(0,0) MOD '0'` tinytext DEFAULT NULL
389) ENGINE=MyISAM DEFAULT CHARSET=latin1
390DROP TABLE t1;
391CREATE TABLE t1 AS SELECT
392'0'+POINT(0,0),
393'0'*POINT(0,0) LIMIT 0;
394SHOW CREATE TABLE t1;
395Table	Create Table
396t1	CREATE TABLE `t1` (
397  `'0'+POINT(0,0)` tinytext DEFAULT NULL,
398  `'0'*POINT(0,0)` tinytext DEFAULT NULL
399) ENGINE=MyISAM DEFAULT CHARSET=latin1
400DROP TABLE t1;
401CREATE TABLE t1 AS SELECT '0'-POINT(0,0) LIMIT 0;
402ERROR HY000: Illegal parameter data types varchar and geometry for operation '-'
403CREATE TABLE t1 AS SELECT '0'/POINT(0,0) LIMIT 0;
404ERROR HY000: Illegal parameter data types varchar and geometry for operation '/'
405CREATE TABLE t1 AS SELECT '0' MOD POINT(0,0) LIMIT 0;
406ERROR HY000: Illegal parameter data types varchar and geometry for operation 'MOD'
407SET debug_dbug='-d,num_op';
408#
409# End of 10.3 tests
410#
411#
412# Start of 10.4 tests
413#
414#
415# MDEV-16454 Bad results for IN with ROW
416#
417SET SESSION debug_dbug="+d,cmp_item";
418SET SESSION debug_dbug="+d,Item_func_in";
419SET SESSION debug_dbug="+d,Predicant_to_list_comparator";
420SELECT (POINT(1,1),0) IN ((POINT(1,1),0),((POINT(1,1)),1));
421(POINT(1,1),0) IN ((POINT(1,1),0),((POINT(1,1)),1))
4221
423Warnings:
424Note	1105	DBUG: [0] arg=1 handler=0 (row)
425Note	1105	DBUG: [1] arg=2 handler=0 (row)
426Note	1105	DBUG: ROW(3 args) level=0
427Note	1105	DBUG:  [0,0] handler=geometry
428Note	1105	DBUG:  [0,1] handler=geometry
429Note	1105	DBUG:  [0,2] handler=geometry
430Note	1105	DBUG:  => handler=geometry
431Note	1105	DBUG:  [1,0] handler=int
432Note	1105	DBUG:  [1,1] handler=int
433Note	1105	DBUG:  [1,2] handler=int
434Note	1105	DBUG:  => handler=bigint
435Note	1105	DBUG: types_compatible=yes bisect=no
436SELECT (1,(POINT(1,1),0)) IN ((1,(POINT(1,1),0)),(0,(POINT(1,1),0)));
437(1,(POINT(1,1),0)) IN ((1,(POINT(1,1),0)),(0,(POINT(1,1),0)))
4381
439Warnings:
440Note	1105	DBUG: [0] arg=1 handler=0 (row)
441Note	1105	DBUG: [1] arg=2 handler=0 (row)
442Note	1105	DBUG: ROW(3 args) level=0
443Note	1105	DBUG:  [0,0] handler=int
444Note	1105	DBUG:  [0,1] handler=int
445Note	1105	DBUG:  [0,2] handler=int
446Note	1105	DBUG:  => handler=bigint
447Note	1105	DBUG:  [1,0] handler=row
448Note	1105	DBUG:  [1,1] handler=row
449Note	1105	DBUG:  [1,2] handler=row
450Note	1105	DBUG:  => handler=row
451Note	1105	DBUG:  ROW(3 args) level=1
452Note	1105	DBUG:   [0,0] handler=geometry
453Note	1105	DBUG:   [0,1] handler=geometry
454Note	1105	DBUG:   [0,2] handler=geometry
455Note	1105	DBUG:   => handler=geometry
456Note	1105	DBUG:   [1,0] handler=int
457Note	1105	DBUG:   [1,1] handler=int
458Note	1105	DBUG:   [1,2] handler=int
459Note	1105	DBUG:   => handler=bigint
460Note	1105	DBUG: types_compatible=yes bisect=no
461SELECT (1,0) IN ((POINT(1,1),0),(0,0));
462ERROR HY000: Illegal parameter data types int and geometry for operation 'in'
463SHOW WARNINGS;
464Level	Code	Message
465Note	1105	DBUG: [0] arg=1 handler=0 (row)
466Note	1105	DBUG: [1] arg=2 handler=0 (row)
467Note	1105	DBUG: ROW(3 args) level=0
468Note	1105	DBUG:  [0,0] handler=int
469Note	1105	DBUG:  [0,1] handler=geometry
470Note	1105	DBUG:  [0,2] handler=int
471Error	4078	Illegal parameter data types int and geometry for operation 'in'
472SELECT (1,(0,0)) IN ((1,(POINT(1,1),0)),(0,(0,0)));
473ERROR HY000: Illegal parameter data types int and geometry for operation 'in'
474SHOW WARNINGS;
475Level	Code	Message
476Note	1105	DBUG: [0] arg=1 handler=0 (row)
477Note	1105	DBUG: [1] arg=2 handler=0 (row)
478Note	1105	DBUG: ROW(3 args) level=0
479Note	1105	DBUG:  [0,0] handler=int
480Note	1105	DBUG:  [0,1] handler=int
481Note	1105	DBUG:  [0,2] handler=int
482Note	1105	DBUG:  => handler=bigint
483Note	1105	DBUG:  [1,0] handler=row
484Note	1105	DBUG:  [1,1] handler=row
485Note	1105	DBUG:  [1,2] handler=row
486Note	1105	DBUG:  => handler=row
487Note	1105	DBUG:  ROW(3 args) level=1
488Note	1105	DBUG:   [0,0] handler=int
489Note	1105	DBUG:   [0,1] handler=geometry
490Note	1105	DBUG:   [0,2] handler=int
491Error	4078	Illegal parameter data types int and geometry for operation 'in'
492SET SESSION debug_dbug="-d,Predicant_to_list_comparator";
493SET SESSION debug_dbug="-d,Item_func_in";
494SET SESSION debug_dbug="-d,cmp_item";
495#
496# End of 10.4 tests
497#
498