Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

View File Name : sp_gis.test

# GIS implementation is specific to myisam.
# Hence retaining the below inc file.
--source include/force_myisam_default.inc
--source include/have_myisam.inc
-- source include/have_geometry.inc

use test;

#
# BUG#21025: misleading error message when creating functions named 'x', or 'y'
#

--disable_warnings
drop function if exists a;
drop function if exists x;
drop function if exists y;
--enable_warnings

create function a() returns int
return 1;

create function x() returns int
return 2;

create function y() returns int
return 3;

select a();
--error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
select x();
--error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
select y();
select ST_x(ST_PointFromText("POINT(10 20)")), ST_y(ST_PointFromText("POINT(10 20)"));

# Non deterministic warnings from db_load_routine
--disable_warnings
select test.a(), test.x(), test.y();
--enable_warnings

drop function a;
drop function x;
drop function y;