LEFT JOIN with "NOT LIKE"

[PriteshP23]

Query:

SELECT UMTS_napetude_cell.parent, UMTS_napetude_nodeb.idnap FROM 
UMTS_napetude_cell LEFT JOIN UMTS_napetude_nodeb
ON UMTS_napetude_cell.parent IS NOT LIKE CONCAT('%',UMTS_napetude_nodeb.idnap,'%')
WHERE UMTS_napetude_cell.parent IS NOT NULL

Error:

 

#1064 - You have an error in your SQL syntax near 'LIKE CONCAT('%', UMTS_napetude_nodeb.idnap,'%')
WHERE UMTS_napetude_cell.parent ' at line 3

 

 

Thanks in advanced.

[gvp16]

Drop the IS and should work.

[PriteshP23]

Drop the IS and should work.

 

Server is not working with this query. 

 

ON UMTS_napetude_cell.parent NOT LIKE CONCAT('%',UMTS_napetude_nodeb.idnap,'%')

[gvp16]

Whats the error message this time?

[PriteshP23]

 

Network Error (tcp_error)

 

- 503 error - A communication error occurred: ""

 

The Web Server may be down, too busy, or experiencing other problems preventing it from responding to requests. You may wish to try again at a later time.

 

[gvp16]

are you only getting then that when you remove the "IS" from the IS NOT ?  That error message sounds like a server or connection problem rather than an mysql issue.

[PriteshP23]

 That error message sounds like a server or connection problem rather than an mysql issue.

 

There is query error for sure.

 

There is no server/connection problem.

[gvp16]

ok, you still didn't answer the first part of the question, do you only get that message when removing the IS.

 

Is this a php based application, is error reporting on? or can you turn it on and do you get any errors?

 

the query could be returning null which is resulting the script to fail. This is all an assumption as I dont know anything about the application.

[PriteshP23]

BEFORE removing "IS", it gives error that i have posted inquestion and after you know.

 

Of course, it is php based application and i have used MySQL database.

[vinny42]

Connection errors usually indicate timeouts or resultsets that are too large to handle.

 

Using LIKE on a string that starts with an % sign is painfully slow. If the query takes too long to complete, the server or the connection might timeout.

 

How long does the query run before you get this error?

[PriteshP23]

It takes more than 2 minutes and than it gives error message.

 

I said this is not a problem because earlier i had other queries which takes around 5 minutes and gives the expected result.

[vinny42]

If timeouts aren't the problem then there are two options left; either the resultset is too big (try doing a count() without selecting any columns, and see how many rows the query expectes to return) or the query is causing the MySQL backend to crash, although I would expect an error like "server has gone away" when that happens. However, this is MySQL, nothing is ever what you expect it to be :-)