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.