Title: Query with #### or ---- · Issue #210 · FoolCode/SphinxQL-Query-Builder · GitHub
Open Graph Title: Query with #### or ---- · Issue #210 · FoolCode/SphinxQL-Query-Builder
X Title: Query with #### or ---- · Issue #210 · FoolCode/SphinxQL-Query-Builder
Description: Querying a "%%%%" or "----" $query = (new SphinxQL($cl)) ->select('id') ->from(['dindex']) ->match('body', $this->search_query) ->limit(10); generates an sql like this SELECT id FROM dindex WHERE MATCH('(@body %%%%)') SELECT id FROM dind...
Open Graph Description: Querying a "%%%%" or "----" $query = (new SphinxQL($cl)) ->select('id') ->from(['dindex']) ->match('body', $this->search_query) ->limit(10); generates an sql like this SELECT id FROM dindex WHERE M...
X Description: Querying a "%%%%" or "----" $query = (new SphinxQL($cl)) ->select('id') ->from(['dindex']) ->match('body', $this->search_query) ->limit(10...
Opengraph URL: https://github.com/FoolCode/SphinxQL-Query-Builder/issues/210
X: @github
Domain: patch-diff.githubusercontent.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Query with #### or ----","articleBody":"Querying a \"%%%%\" or \"----\"\r\n```\r\n $query = (new SphinxQL($cl))\r\n -\u003eselect('id')\r\n -\u003efrom(['dindex'])\r\n -\u003ematch('body', $this-\u003esearch_query)\r\n -\u003elimit(10);\r\n\r\n```\r\ngenerates an sql like this\r\n` SELECT id FROM dindex WHERE MATCH('(@body %%%%)')`\r\n`SELECT id FROM dindex WHERE MATCH('(@body \\\\\\\\-\\\\\\\\-\\\\\\\\-\\\\\\\\-)')`\r\n\r\nThrows SQL Error\r\nError SQL (1064): index dindex: syntax error, unexpected ')' near ' %%%%)'\r\n\r\nIs this ok?\r\n\r\n\r\n","author":{"url":"https://github.com/rabbitone","@type":"Person","name":"rabbitone"},"datePublished":"2023-07-09T02:20:50.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/210/SphinxQL-Query-Builder/issues/210"}
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:0cdb980c-e46a-5430-56d8-305461bd8f99 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | A614:2B91BA:3AC30B7:4C6CEBC:697D9910 |
| html-safe-nonce | 9dfe77129fbaec15101aae232ff2ac9bfabf48c90cf5c2d160fd794b53efdfdb |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBNjE0OjJCOTFCQTozQUMzMEI3OjRDNkNFQkM6Njk3RDk5MTAiLCJ2aXNpdG9yX2lkIjoiNTk3MzI2NDk3NzQzODI4NDA0OCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 782cdce873f1663ecafb0617a69dad00659c813d958ac9696cc848906e145802 |
| hovercard-subject-tag | issue:1795202627 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/FoolCode/SphinxQL-Query-Builder/210/issue_layout |
| twitter:image | https://opengraph.githubassets.com/560ac0799e75633cd71a6be9f8cf0f81b5842fb420688fb3efd35f551562360e/FoolCode/SphinxQL-Query-Builder/issues/210 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/560ac0799e75633cd71a6be9f8cf0f81b5842fb420688fb3efd35f551562360e/FoolCode/SphinxQL-Query-Builder/issues/210 |
| og:image:alt | Querying a "%%%%" or "----" $query = (new SphinxQL($cl)) ->select('id') ->from(['dindex']) ->match('body', $this->search_query) ->limit(10); generates an sql like this SELECT id FROM dindex WHERE M... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | rabbitone |
| hostname | github.com |
| expected-hostname | github.com |
| None | 60279d4097367e16897439d16d6bbe4180663db828c666eeed2656988ffe59f6 |
| turbo-cache-control | no-preview |
| go-import | github.com/FoolCode/SphinxQL-Query-Builder git https://github.com/FoolCode/SphinxQL-Query-Builder.git |
| octolytics-dimension-user_id | 915570 |
| octolytics-dimension-user_login | FoolCode |
| octolytics-dimension-repository_id | 5473481 |
| octolytics-dimension-repository_nwo | FoolCode/SphinxQL-Query-Builder |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 5473481 |
| octolytics-dimension-repository_network_root_nwo | FoolCode/SphinxQL-Query-Builder |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 7c85641c598ad130c74f7bcc27f58575cac69551 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width