Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Building for iOS, Issue with 言葉 search #3

Open
yeyebbc opened this issue Jul 21, 2023 · 0 comments
Open

Building for iOS, Issue with 言葉 search #3

yeyebbc opened this issue Jul 21, 2023 · 0 comments

Comments

@yeyebbc
Copy link

yeyebbc commented Jul 21, 2023

漢字 search is fine.

Issue: 言葉 search returns no result.

Log:
Search keyword is “言葉”, tried other words but same log.

[logging] no such function: REGEXP in "SELECT entry.id as entry_id,
                  sense.id as sense_id, 
                  (
                    SELECT
                      GROUP_CONCAT(IFNULL(keb || ':', '') || reb)
                    FROM
                      r_ele r_ele_sub
                      LEFT JOIN r_ele_k_ele ON r_ele_k_ele.id_r_ele = r_ele_sub.id
                      LEFT JOIN k_ele k_ele_sub ON r_ele_k_ele.id_k_ele = k_ele_sub.id
                    WHERE
                      r_ele_sub.id_entry = entry.id
                  ) keb_reb_group,
                  GROUP_CONCAT(DISTINCT gloss.content) gloss_group,
                  GROUP_CONCAT(DISTINCT pos.description) pos_group,
                  GROUP_CONCAT(DISTINCT dial.name) dial_group,
                  GROUP_CONCAT(DISTINCT field.name) field_group,
                  GROUP_CONCAT(DISTINCT misc.name) misc_group
                  FROM entry
                  JOIN sense ON sense.id_entry = entry.id
                  JOIN gloss ON gloss.id_sense = sense.id
                  LEFT JOIN sense_pos on sense.id = sense_pos.id_sense 
                  LEFT JOIN pos on sense_pos.id_pos = pos.id
                  LEFT JOIN sense_dial on sense.id = sense_dial.id_sense 
                  LEFT JOIN dial on sense_dial.id_dial = dial.id
                  LEFT JOIN sense_field on sense.id = sense_field.id_sense 
                  LEFT JOIN field on sense_field.id_field = field.id
                  LEFT JOIN sense_misc on sense.id = sense_misc.id_sense
DB Error: 1 "no such function: REGEXP"
DB Query: SELECT entry.id as entry_id,
                  sense.id as sense_id, 
                  (
                    SELECT
                      GROUP_CONCAT(IFNULL(keb || ':', '') || reb)
                    FROM
                      r_ele r_ele_sub
                      LEFT JOIN r_ele_k_ele ON r_ele_k_ele.id_r_ele = r_ele_sub.id
                      LEFT JOIN k_ele k_ele_sub ON r_ele_k_ele.id_k_ele = k_ele_sub.id
                    WHERE
                      r_ele_sub.id_entry = entry.id
                  ) keb_reb_group,
                  GROUP_CONCAT(DISTINCT gloss.content) gloss_group,
                  GROUP_CONCAT(DISTINCT pos.description) pos_group,
                  GROUP_CONCAT(DISTINCT dial.name) dial_group,
                  GROUP_CONCAT(DISTINCT field.name) field_group,
                  GROUP_CONCAT(DISTINCT misc.name) misc_group
                  FROM entry
                  JOIN sense ON sense.id_entry = entry.id
                  JOIN gloss ON gloss.id_sense = sense.id
                  LEFT JOIN sense_pos on sense.id = sense_pos.id_sense 
                  LEFT JOIN pos on sense_pos.id_pos = pos.id
                  LEFT JOIN sense_dial on sense.id = sense_dial.id_sense 
                  LEFT JOIN dial on sense_dial.id_dial = dial.id
                  LEFT JOIN sense_field on sense.id = sense_field.id_sense 
                  LEFT JOIN field on sense_field.id_field = field.id
                  LEFT JOIN sense_misc on sense.id = sense_misc.id_sense 
                  LEFT JOIN misc on sense_misc.id_misc = misc.id
                  WHERE entry.id IN (SELECT DISTINCT  entry_sub.id FROM entry entry_sub JOIN sense sense_sub ON entry_sub.id = sense_sub.id_entry JOIN r_ele on entry_sub.id = r_ele.id_entry
         LEFT JOIN k_ele ON entry_sub.id = k_ele.id_entry WHERE (keb REGEXP '言葉' ) LIMIT 10 OFFSET 0)
                  GROUP BY sense.id
DB Path: /var/mobile/Containers/Data/Application/CF4DD936-8829-48ED-A6F1-3A825C4A2FB6/Documents/expression.db
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant