建函数索引的时候报错:ORA-30553: The function is not deterministic, 这个函数是自定义的。 SQL>create index mobileIndex on mobile(getmobilearea (callerno)); Google 一下: 解决如下: 在创建基于自定义函数时, 指定deterministic参数,在创建函数索引,就没有问题了。 CREATE OR REPLACE FUNCTION ICD.getmobile...
建函数索引的时候报错:ORA-30553: The function is not deterministic,这个函数是自定义的。 SQL>createindexmobileIndexonmobile(getmobilearea(callerno)); Google 一下: 解决如下: 在创建基于自定义函数时,指定deterministic参数,在创建函数索引,就没有问题了。 CREATEORREPLACEFUNCTIONICD.getmobilearea(mobilenoVARCH...
SQL> create index idx_001 on a(func_ib(comoon)); create index idx_001 on a(func_ib(comoon)) * ERROR at line 1: ORA-30553: The function is not deterministic ---增加关键字deterministic create or replace function func_ib (v_comoon varchar2) return varchar2deterministicis v_var1 varchar...
运行MySQL时提示:[Err] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) 原因: 这是我们开启了bin-log, 我们就必须指定我们的函数是否是 ...
错误码[err] 1418表示在MySQL数据库中创建或修改函数时,该函数没有声明为确定性(deterministic)、不包含SQL语句(no sql)或声明为读取SQL数据(reads sql data),而在这种情况下,二进制日志记录(binary logging)是启用的。MySQL要求在进行二进制日志记录时,所有用户定义的函数都必须是确定性的,或者不包含修改数据的SQL...
我是在创建Mysql函数保存的时候报错:1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *m...
[Err] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creator【s 2018-08-13 11:00 − ... Quality...
indeterminate,undetermined- not precisely determined or established; not fixed or known in advance; "of indeterminate age"; "a zillion is a large indeterminate number"; "an indeterminate point of law"; "the influence of environment is indeterminate"; "an indeterminate future" ...
i vr deterministic pr i dont know what to d i e i m cooking i remember when you u i ve finished i ll just be in a sec i 93 i a glass of milk eve i a place nearby i accept ideas i accept your challen i accidentally got he i accompany you cry i actually had the we i admi...
其中在function里面,只有 DETERMINISTIC, NO SQL 和 READS SQL DATA 被支持。如果我们开启了 bin-log, 我们就必须为我们的function指定一个参数。 解决方案 在MySQL中创建函数时出现这种错误的解决方法有两种: 方案1(临时方案):先执行下面的SQL语句,在执行创建函数的语句即可,但是重启数据库就会失效,治标不治本。