Issue/1481 (Fulltext)/URI examples/direct db query

De Semantic MediaWiki - Sandbox
MariaDB [0210020150926]> SELECT DISTINCT
    ->   t5.smw_id AS id,t5.smw_title AS t,t5.smw_namespace AS ns,t5.smw_iw AS iw,t5.smw_subobject AS so,t5.smw_sortkey AS sortkey
    -> FROM
    ->   `02100_smw_object_ids` AS t5
    -> INNER JOIN
    ->   `02100_smw_fpt_inst` AS t1 ON t5.smw_id=t1.s_id
    -> INNER JOIN
    ->   `02100_smw_ft_search` AS t3 ON t1.s_id=t3.s_id
    -> WHERE
    ->   (t1.o_id='5003' AND ((MATCH(t3.o_text) AGAINST ('ccc*' IN BOOLEAN MODE) AND t3.p_id=85))) AND t5.smw_iw!=':smw' AND t5.smw_iw!=':smw-delete' AND t5.smw_iw!=':smw-redi'
    -> ORDER BY
    ->   t5.smw_sortkey ASC
    -> LIMIT
    ->   55
    -> OFFSET
    ->   0;
Empty set (0.00 sec)
MariaDB [0210020150926]> SELECT DISTINCT
    ->   t5.smw_id AS id,t5.smw_title AS t,t5.smw_namespace AS ns,t5.smw_iw AS iw,t5.smw_subobject AS so,t5.smw_sortkey AS sortkey
    -> FROM
    ->   `02100_smw_object_ids` AS t5
    -> INNER JOIN
    ->   `02100_smw_fpt_inst` AS t1 ON t5.smw_id=t1.s_id
    -> INNER JOIN
    ->   `02100_smw_ft_search` AS t3 ON t1.s_id=t3.s_id
    -> WHERE
    ->   (t1.o_id='5003' AND ((MATCH(t3.o_text) AGAINST ('ccc*' IN BOOLEAN MODE) AND t3.p_id='85'))) AND t5.smw_iw!=':smw' AND t5.smw_iw!=':smw-delete' AND t5.smw_iw!=':smw-redi'
    -> ORDER BY
    ->   t5.smw_sortkey ASC
    -> LIMIT
    ->   55
    -> OFFSET
    ->   0;
ERROR 1064 (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 '>   t5.smw_id AS id,t5.smw_title AS t,t5.smw_namespace AS ns,t5.smw_iw AS iw,t5.' at line 2
Les cookies nous aident à fournir nos services. En utilisant nos services, vous acceptez notre utilisation de cookies.