Coluccio: R0ny, thats the “self” part of a self-join, you just cannot use the updated table in a subquery – explicit mysql limitation no idea what other systems allow
Cartaya: Feltenberger: hah, yes. it’s a custom accountancy package, and rather an unusual one. my accountant friend who has been helping me with the accountancy side of it doesn’t like it when i use such terms, nor does she like it when i use terms like ‘fiddle’ with the database lol
Zavalza: I did not want to have to develop this software, but it became necessary because we can’t afford to employ a proper book keeper, and our business model is such that most transactions can be automatically written into the general ledger anyway.
Bisconer: I’d rather trust a custom application than the ***uaries of manual entry by unqualified people
Varieur: StrixUK: use FLOAT for everything, to be sure.
Cuccinello: Because even if there is a bug like this one, it will be a bug that _consistently_ manifests itself, and so should be a lot easier to correct than mistakes made in manual entry
Gabor: Varieur: of course, that’s exactly what i’ve done, because floats are accurate and never suffer rounding errors /s lol
Tarango: In seriousness, all currency and quantity fields are DECIMAL14,2s
Adonis: Jkavalik: http://pastebin.ca/3155950 ,its giving me same eror ,i updated the query
Lopey: R0ny, you have the join, so remove the subquery
Keliipaakaua: Sure let me see,so do with out sub query
Lovin: R0ny, try to write it as select but with join only, so you can check it returns the same results
Brenagh: You just have to give the join conditions right so the t2 joins the exact row your subquery would return
Burkleo: Jkavalik: http://pastebin.ca/3155964 ,see the two queries,the first one returns results ,and the second one modified using join ,and with out sub query is returning no result,can you have alook?
Baros: R0ny, you join “on t1.id = t2.id”, but that is not anything the subquery has – the subquery case “***ociates” the two rows just by “t2.id = t1.parent_post”
Dantonio: And checks the accountid of those rows
Drewski: Anyway, there is nothing like having to write an accountancy package to really force you to understand accountancy practise
Bakalar: It’s been an interesting experience
Sessa: Jkavalik: can you rewrite that query for me
Milewski: R0ny, http://pastebin.ca/3155968 you were faster in hte end
Vanwye: Hello, I have a question regarding mysql replication.
Rippin: Given I have an mysql instance with multiple databases and I have one user, having access only to database X with rights for REPLICATION_SLAVE
Papa: How is the security handled for this?
Berentson: Replication slave is a global privilege, you can’t grant it on a particular database.
Finkle: As I understood, the binlog of MySQL will log everything from all databases to the log. How can I be safe, that the slave will only get those rows from the binlog, that he has access to those regarding database X
Stahlman: You can use binlog-do-db to only write statements which use your particular db as default to the binlog. However, it may not do exactly what you want.
Kalinger: Testerde_: it depends on how you configure mysql. you can tell it to replicate only certain DBs. by default, though, i think it replicates everything.
Olsten: If you have binlog-do-db=db1, then USE db1; INSERT INTO db2.table. still gets logged
Fenoff: Likewise, USE db2, INSERT INTO db1.table. does NOT get logged
Gerhauser: Testerde_: in any event, your replication user should probably be separate from application users
Santarpia: So in security thinking
Skeffington: Having one user that is able to replicate the DB, he will have access to everything inside the mysql master instance?
Grebe: Snoyes: ouch. didn’t know that. fortunately, i replicate everything except mysql.slow_log, which tends to break replication, so it doesn’t matter so much.