#mysql
22 October 2007
Total 24 pages. You are browsing page 4/24.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
06:06 <****> false. But NOT UNKNOWN is still UNKNOWN.
06:06 <****> DarienMB: It's all changed over the last couple of years. All my old IRC channels are foreign to me :(
06:07 <****> sweet
06:07 <****> I'm applying for a job at MySQL
06:07 <****> Xgc: why is select not null is null; false then?
06:07 <****> DarienMB: yeah? what job?
06:07 <****> err
06:07 <****> litheum: Course Developer
06:07 <****> isnt slave replcation servers supposed to replicate stored procedures as well ?
06:07 <****> chadmaynard: Because IS NOT is the operator.
06:08 <****> huh
06:08 <****> chadmaynard: That's much different than null IS (NOT NULL), which is invalid.
06:09 <****> chadmaynard: NOT is a boolean negation. IS NOT is something else.
06:09 <****> err anyone know why my slave server isnt replicating stored procedures inside a database .. if that database is part of the replication?
06:09 <****> Xgc: what is it?
06:09 <****> hehe
06:09 <****> select (not null) is null; seems to work though :)
06:09 <****> litheum: ah ha! that's that i want it to say
06:09 <****> litheum: Right. chadmaynard is asking why that would be correct.
06:10 <****> how do you select multiple rows to display, eg Select * from table where row = 1, 2, 3
06:10 <****> this dosnt work..
06:10 <****> anyone?
06:10 <****> chadmaynard: That's exactly what I said.
06:10 <****> !m Kupo24z in
06:10 <****> Kupo24z: (Comparison Functions and Operators) : http://dev.mysql.com/doc/mysql/en/comparison-operators.html
06:10 <****> NULL"
06:10 <****> Xgc: but in the order you had it in didn't work for some reason
06:11 <****> stuff
06:11 <****> can someone help me with a replication issue?
06:11 <****> chadmaynard: "is null" is an operator, "is (...)" means nothing
06:11 <****> i cant get my replication server to replicate any stored procedures created in the master
06:11 <****> litheum: ah that makes sense
06:12 <****> false.
06:13 <****> chadmaynard: select isnull(null) = isnull(not null);
06:13 <****> Xgc: I understand that
06:13 <****> chadmaynard: The ()'s do not change the result in that case. That's probably a precedence issue.
06:13 <****> chadmaynard: Just switch the ()'s to see the other meaning.
06:13 <****> I just didn't understand that not null was null
06:14 <****> chadmaynard: *nod*
06:14 <****> that explains why count(not null) returns 0
06:14 <****> NOT NULL being the same value as NULL suggests that also.
06:15 <****> because i've always said that count(expression) counts where expression is not null. that's not technically true because not null is null so how do i say it?
06:15 <****> anyone expecting something useful from count(not null) should be punched in the face
06:15 <****> litheum: I was playing
06:15 <****> chadmaynard: IS NOT null is the key.
06:15 <****> that's dangerous with mysql :)
06:16 <****> chadmaynard: Which is -not- == NOT NULL
06:16 <****> xgc: right but we don't usually talk that way
06:16 <****> chadmaynard: It's not easy to describe it in english without being ambiguous.
06:16 <****> litheum: i know doing silly stuff is the only way i've ever found bugs
06:16 <****> anyone here have any experience in replciation
06:17 <****> Xgc: so i should increase my ambiguity and I could always be correct.
06:17 <****> i cant for the likes of me figure out why my slave isnt replicating the stored procedures
06:17 <****> Assid: are you replicating the database they belong to?
06:18 <****> chadmaynard: It's sometimes easier to stick with SQL when dealing with NULL... or see the Clintonian dictionary on the word IS.
06:18 <****> how do i get the last row that i inserted?
06:18 <****> chadmaynard: yes
06:18 <****> heh Xgc joke.
06:18 <****> Xgc: ha...
06:18 <****> chadmaynard: data comes in fine.. stored procedure no.
06:18 <****> how do i get the last row that i inserted from a table?
06:19 <****> fitoria: are you using auto_increment?
06:19 <****> yes
06:19 <****> order by index number in reverse
06:19 <****> sort DESC
06:19 <****> fitoria: you can select last_insert_id(); if you keep the session alive
06:19 <****> ok
06:20 <****> be careful how you use that
06:20 <****> How can I find out the number of rows is going to be returned from a SELECT that uses HAVING?
06:20 <****> Assid: does the replication user correct privs?
06:20 <****> chadmaynard: i would guess so.. the data comes in fine
06:21 <****> has replication slave, replication client access
06:21 <****> Assid: that should be enough
06:22 <****> chadmaynard: yeah.. but it doesnt work
06:22 <****> could be the mysql bug in the older version
06:22 <****> anyone?
06:22 <****> chadmaynard: its running 5.0.27
06:22 <****> Assid: the slave is older?
06:22 <****> yes
06:22 <****> what version is the slave?
06:22 <****> 5.0.27 slave / 5.0.41 - master
06:23 <****> oh
06:23 <****> don't know then
06:23 <****> i would try giving the replication user all privs and see if they replicate then
06:24 <****> but I've never replicated functions or sp
06:24 <****> chadmaynard: do you see the appropriate statements in the binary and relay logs?
06:24 <****> oops
06:24 <****> Assid: do you see the appropriate statements in the binary and relay logs?
06:24 <****> Assid: have you read through all the caveats enumerated in the manual regarding binary logging of stored routines?
06:25 <****> trying to check the binlog
06:25 <****> i see it in the master that i dropped and then created it again
06:26 <****> chadmaynard: is this right http://paste.ubuntu-nl.org/41635/ ?
06:26 <****> it is not complete
06:26 <****> err.. i cant seem to see the binary log of the slave from phpmyadmin
06:27 <****> show binlog events doesnt seem to work
06:27 <****> fitoria: i dunno.... what are you doing?
06:27 <****> comparing 2 prices
06:28 <****> if one price is minor then an error ocurs
06:28 <****> litheum: is there a different way to read the binary logs of a slave?
06:29 <****> Assid: use the mysqlbinlog program
Total 24 pages. You are browsing page 4/24.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last