Quelle information_schema_routines.result
Sprache: Lisp
set sql_mode="" ; set sql_mode="" ; 1 ==========; ; 64 ) NOT NULL,512 ) NOT NULL,64 ) NOT NULL,64 ) NOT NULL,13 ) NOT NULL,64 ) NOT NULL,21 ),21 ),21 ),21 ),21 ) unsigned,64 ),64 ),8 ) NOT NULL,64 ),64 ),8 ) NOT NULL,3 ) NOT NULL,64 ) NOT NULL,64 ),7 ) NOT NULL,NOT NULL,NOT NULL,8192 ) NOT NULL,NOT NULL,384 ) NOT NULL,32 ) NOT NULL,64 ) NOT NULL,64 ) NOT NULL'information_schema' AND table_name = 'routines' ; 1 64 192 64 )2 512 1536 512 )3 64 192 64 )4 64 192 64 )5 13 39 13 )6 64 192 64 )7 10 0 21 )8 10 0 21 )9 10 0 21 )10 10 0 21 )11 20 0 21 ) unsigned12 64 192 64 )13 64 192 64 )14 4294967295 4294967295 15 8 24 8 )16 4294967295 4294967295 17 64 192 64 )18 64 192 64 )19 8 24 8 )20 3 9 3 )21 64 192 64 )22 64 192 64 )23 7 21 7 )24 0 25 0 26 8192 24576 8192 )27 4294967295 4294967295 28 384 1152 384 )29 32 96 32 )30 64 192 64 )31 64 192 64 ); 64 ) NO NULL 512 ) NO NULL 64 ) NO NULL 64 ) NO NULL 13 ) NO NULL 64 ) NO NULL 21 ) YES NULL 21 ) YES NULL 21 ) YES NULL 21 ) YES NULL 21 ) unsigned YES NULL 64 ) YES NULL 64 ) YES NULL 8 ) NO NULL 64 ) YES NULL 64 ) YES NULL 8 ) NO NULL 3 ) NO NULL 64 ) NO NULL 64 ) YES NULL 7 ) NO NULL 8192 ) NO NULL 384 ) NO NULL 32 ) NO NULL 64 ) NO NULL 64 ) NO NULL 2 ==========IF EXISTS i_s_routines_test; ; ; 20 ) RETURNS CHAR(50 )RETURN CONCAT('Hello' , ,s,'!' ); ERROR 42000 : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'RETURNS CHAR(50) RETURN CONCAT('Hello' , ,s,'!' )' at line 1 'i_s_routines_test' AND ROUTINE_NAME = 'test_func1' ; CTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION3 ==========IF EXISTS i_s_routines_test; ; ; 20 )) RETURNS CHAR(50 )RETURN CONCAT('Hello, ' ,s,'!' ); 'i_s_routines_test' AND ROUTINE_NAME = 'test_func1' ; CTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION50 200 NULL NULL NULL utf8mb4 utf8mb4_uca1400_ai_ci char(50 ) SQL RETURN CONCAT('Hello, ' ,s,'!' ) NULL NULL SQL NO CONTAINS SQL NULL DEFINER <created> <modified> root@localhost latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci; 'i_s_routines_test' AND ROUTINE_NAME = 'test_func1' ; CTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION4 ==========IF EXISTS i_s_routines_test; ; ; 2 +2 as param1; ; 'i_s_routines_test' AND ROUTINE_NAME = 'testproc' ; CTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATIONBEGIN2 +2 as param1; swedish_ci utf8mb4_uca1400_ai_ci5 ==========IF EXISTS i_s_routines_test; ; ; 20 )) RETURNS CHAR(50 )RETURN CONCAT('Hello, ' ,s,'!' ); 'i_s_routines_test' AND ROUTINE_NAME = 'test_func1' ; CTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION50 200 NULL NULL NULL utf8mb4 utf8mb4_uca1400_ai_ci char(50 ) SQL RETURN CONCAT('Hello, ' ,s,'!' ) NULL NULL SQL NO CONTAINS SQL NULL DEFINER <created> <modified> root@localhost latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci6 ==========IF EXISTS i_s_routines_test; ; ; RETURN s*2 ; 'i_s_routines_test' AND ROUTINE_NAME = 'test_func2' ; CTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION10 0 NULL NULL NULL int(11 ) SQL RETURN s*2 NULL NULL SQL NO CONTAINS SQL NULL DEFINER <created> <modified> root@localhost latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci7 ==========IF EXISTS i_s_routines_test; ; ; RETURN CURRENT_TIMESTAMP; 'i_s_routines_test' AND ROUTINE_NAME = 'test_func5' ; CTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION0 NULL NULL timestamp SQL RETURN CURRENT_TIMESTAMP NULL NULL SQL NO CONTAINS SQL NULL DEFINER <created> <modified> root@localhost latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci8 ==========IF EXISTS i_s_routines_test; ; ; RETURN CURRENT_TIMESTAMP; 'i_s_routines_test' AND ROUTINE_NAME = 'test_func5' ; CTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION0 NULL NULL timestamp SQL RETURN CURRENT_TIMESTAMP NULL NULL SQL NO CONTAINS SQL NULL DEFINER <created> <modified> root@localhost latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci'new comment added' ; 'i_s_routines_test' AND ROUTINE_NAME = 'test_func5' ; CTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION0 NULL NULL timestamp SQL RETURN CURRENT_TIMESTAMP NULL NULL SQL NO CONTAINS SQL NULL DEFINER <created> <modified> new comment added root@localhost latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci9 ==========IF EXISTS i_s_routines_test; SET utf8; ; 20 )) RETURNS VARCHAR(30 )RETURN CONCAT('XYZ, ' ,s); 'i_s_routines_test' AND ROUTINE_NAME = 'test_func5' ; CTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION30 120 NULL NULL NULL utf8mb4 utf8mb4_uca1400_ai_ci varchar(30 ) SQL RETURN CONCAT('XYZ, ' ,s) NULL NULL SQL NO CONTAINS SQL NULL DEFINER <created> <modified> root@localhost latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci; 20609 Full table scan in INFORMATION_SCHEMA.PARAMETERS/ROUTINESIF EXISTS i_s_routines_test; ; ; 20 )) RETURNS VARCHAR(30 )RETURN CONCAT('XYZ, ' ,s); ; 'test_func5' ; 30 120 30 )RETURN CONCAT('XYZ, ' ,s)'handler_read%next' ; 2 and filtering by ROUTINE_NAMEnot work either since ROUTINE_NAME = 'not_existing_proc' . See; 'i_s_routines_test' AND ROUTINE_NAME = 'not_existing_proc' ; 'handler_read%next' ; 1 ; 'i_s_routines_test' AND ROUTINE_NAME = 'test_func5' ; 30 120 30 )RETURN CONCAT('XYZ, ' ,s)'handler_read%next' ; 1 2 ; 'i_s_routines_test' ; 30 120 30 )RETURN CONCAT('XYZ, ' ,s)'handler_read%next' ; 1 2 SET NAMES koi8r; ; ; 'i_s_routines_test' AND ROUTINE_NAME = 'процедурка' ; 'handler_read%next' ; 1 2 's impossible to use the index here 't check Handler_read counters, only the results correctness 'test_func5' ; 'test_%' ; '%func%' ; 'test' ; 'процедурка' ; '%оцедурка' ; '%оцедур%' ; 'такой_нет' ; ; ;
Messung V0.5 in Prozent C=93 H=100 G=96
¤ Dauer der Verarbeitung: 0.12 Sekunden
(vorverarbeitet am 2026-10-08)
¤ *© Formatika GbR, Deutschland
2026-10-10
Neuigkeiten Aktuelles Motto des Tages Open Source Software
Jenseits des Üblichen ....
Besucherstatistik
Statistik #Sources=1126864 #Domains=1897691
