4 Aug
2006
4 Aug
'06
11:08 p.m.
I am pulling that query right out of my mysql query log. This works
if I downgrade to an earlier version of mysql. Please reply.
again the query being run is...
SELECT gw.ip_addr, gw.port, gw.uri_scheme, gw.transport, gw.strip,
gw.prefix FROM gw, lcr WHERE ''<sip:15183024234@eastern.mynoc.net>''
LIKE lcr.from_uri AND '13143212222' LIKE CONCAT(lcr.prefix, '%') AND
lcr.grp_id = gw.grp_id ORDER BY CHAR_LENGTH(lcr.prefix), lcr.priority
DESC, RAND()
Would it have anything to do with the fact that the table type is
ndbcluster not myisam? I am willing to provide an account on that
box, but that is definitely the query being run.
On Aug 4, 2006, at 6:43 AM, Juha Heinanen wrote:
Brandon Price writes:
SELECT gw.ip_addr, gw.port, gw.uri_scheme,
gw.transport, gw.strip,
gw.prefix FROM gw, lcr WHERE
''<sip:12345678910@eastern.mynoc.net>''
LIKE lcr.from_uri AND '15184782222' LIKE CONCAT(lcr.prefix, '%') AND
lcr.grp_id = gw.grp_id ORDER BY CHAR_LENGTH(lcr.prefix), lcr.priority
DESC, RAND()
lcr module only adds a single single quote before and after from uri:
q_len = snprintf(query, MAX_QUERY_SIZE, "SELECT %.*s.%.*s, %.*s.%.*s,
%.*s.%.*s, %.*s.%.*s, %.*s.%.*s, %.*s.%.*s FROM %.*s, %.*s WHERE
'%.*s'
LIKE %.*s.%.*s AND '%.*s' LIKE CONCAT(%.*s.%.*s, '%%') AND %.*s.%.*s =
%.*s.%.*s ORDER BY CHAR_LENGTH(%.*s.%.*s), %.*s.%.*s DESC, RAND()",
-- juha