Demauro: Only solution i found is doing a where for each customer and adding them by UNION
Noser: Can you explain a bit more, Decoux?
Rumery: Do you have some criteria which 60 results you want? newest/oldest/by some rank etc
Wiater: The latest, so i want ORDER BY DESC
Blazer: Http://pastie.org/10423522 that’s my current query which logically gives me ALL results from last_update
Newmyer: Can ORDER BY clause change somehow selected value ?
Rumery: But depends on what you mean
Quoss: I have strange behavior. When I insert ORDER BY . It changes my values
Stawasz: I have set of AVG, STD in my SELECT clause
Pippin: And if I sort result by one column value of another changes
Killough: Seems like only value with column type = time.
Rumery: Silas, can you pastebin some example and the query?
Byone: Anyway Im trying to make a minimal working example
Kenderdine: Rumery: I will. If I wont produce minimal working example
Rumery: Silas, ok, and if you manage the working example, try sqlfiddle.com
Hoban: If I make temporary table with the same set of data as my joins produces, it’s OK. But if I use original query with joins and sub queries, bug appears
Aimone: KSeems I need spent an evening to
Rumery: Silas, “explain extended . ; show warnings;” – there might be some optimization be used in the wrong case which might contain a bug, it happens sometimes – if you identify some possible suspect, you can try disabling it to see if results change
Pfeiff: I have one warning with code 1003
Panfilov: Ohhh. seems Im pretty experienced to write complex queries, but not yet as experienced to inspect situations like this one
Clyatt: Silas: With MySQL it is the full error message that matters. 1003 tells almost nothing
Dontas: Ok. No prob. I need to dig and produce working example. This way I will learn, otherwise everything is magic
Mcconaghy: Hmm, so I have a unique index on two fields l_id,r_id . but actually I need to be able to enter both 1,2 and 2,1
Goodridge: How would I ensure that for each pair of l_id,r_id I can have both but no duplicates?
Truner: I guess I could add a field invert to the key and set it to 1 when l r and 0 when r l?
Skeeters: Unique keyl, r allows 1,2 and 2,1
Rossotto: After hours of googling, and no concrete answers, is it possible to LOAD DATA INFILE multiple times concurrently into an InnoDB table? I have hundreds of files all to be imported into the same single table. Looks like they queue and timeout when I run multiple jobs to do it.
Kofman: Probably depends on what indexes exist
Congrove: A few, single and compound, but is that actually going to dictate whether multiple inserts can happen or not?
Roderman: In a later run i’m going to trial setting unique_checks to 0 for it
Chiasson: Robscow: yes, row locking could cause one to have to wait for another
Feemster: Is mysql cluster direct alternative to vertica ?
Pritchet: Or am i totally wrong ?
Clyatt: Robscow: If you want mutiple concurrent LOAD DATA into same table better make sure all the text files contain non-conflicting rows
Clyatt: Kahoun: What the heck is vertica?
Clyatt: Robscow: That means no two files contain rows with same Primary Key nor Unique key values
Yournet: Salle, i’m confident they are all unique
Clyatt: Kahoun: What the heck is HP vertica?
Bachinski: Is that the company that just announced plans to lay of 30,000 employees? yeas, sure, go with that one :-
Saffo: Kahoun: it’s not column oriented.
Dorsay: But they’re still queuing
Boulais: Kahoun: NDB it is an in-memory distributed database. Vertica is a column oriented database.