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