回答編集履歴
1
DETERMINISTICが抜けてました
answer
CHANGED
|
@@ -44,7 +44,7 @@
|
|
|
44
44
|
例えば
|
|
45
45
|
|
|
46
46
|
```sql
|
|
47
|
-
CREATE FUNCTION like_ci(x TEXT,y TEXT) RETURNS BOOLEAN
|
|
47
|
+
CREATE FUNCTION like_ci(x TEXT,y TEXT) RETURNS BOOLEAN DETERMINISTIC
|
|
48
48
|
RETURN x LIKE y COLLATE utf8mb4_unicode_ci;
|
|
49
49
|
```
|
|
50
50
|
|