Build from bazaar source on Mac 10.7 (Lion) fails

2011-09-02 Thread Derek Downey
Hello, I am trying to setup a development machine to start delving into some of the internal code of the MySQL DB. I'm off to a great start, since I can't even get it to build properly. I'm sure I'm missing an important step, but am following the instructions from http://dev.mysql.com/doc/ref

Re: select ... into local outfile ... ???

2011-09-02 Thread Tyler Poland
Dennis, The following closely simulates the default "INTO OUTFILE", you'll have to modify it slightly for your purposes: mysql --delimiter=comma -N < select_statement.sql \ | sed 's/\"/\\\"/g' \ | sed 's/\t/\",\"/g' \ | sed 's/$/\"/g' \ | sed 's/^/\"/g' \ | sed 's/\"NULL\"/\\N/g' \

select ... into local outfile ... ???

2011-09-02 Thread Dennis
hi, there, the following is my sql statement: SELECT   HIGH_PRIORITY   SQL_BIG_RESULT   SQL_NO_CACHE   tb.url_sign,  m_url,    m_title,   m_weight    INTO OUTFILE   '/tmp/a.csv'  FIELDS TERMINATED BY ','  ENCLOSED BY '\"'   LINES  TERMINATED BY '\n' STARTING BY '=' FROM d_lo

Re: Arrays

2011-09-02 Thread Hal�sz S�ndor
2011/09/02 06:09 -0700, javad bakhshi Hi, None of the above. :) .This is just an academic research on a benchmark. I just want to access my database with this function and return 4 Integer values. I separated the numbers with comma to process on it later as an string and split the resu

Re: locked non-existent row

2011-09-02 Thread Peter Brawley
On 9/2/2011 6:15 AM, Jochem van Dieten wrote: On Wed, Aug 31, 2011 at 4:10 AM, Peter Brawley wrote: While a transaction in one thread tries to update a non-existent InnoDB row with a given key value, an attempt to insert that value in another thread is locked out. Does anyone know where this beh

Re: locked non-existent row

2011-09-02 Thread Peter Brawley
On 9/1/2011 9:06 AM, Jerry Schwartz wrote: -Original Message- From: Peter Brawley [mailto:peter.braw...@earthlink.net] Sent: Wednesday, August 31, 2011 10:40 AM To: r...@grib.nl; mysql@lists.mysql.com Subject: Re: locked non-existent row On 8/31/2011 4:50 AM, Rik Wasmus wrote: While a t

Re: Arrays

2011-09-02 Thread javad bakhshi
Hi, None of the above. :) .This is just an academic research on a benchmark. I just want to access my database with this function and return 4 Integer values. I separated the numbers with comma to process on it later as an string and split the result using string functions which did work. I w

Re: Arrays

2011-09-02 Thread Shawn Green (MySQL)
Hello Javad, On 9/2/2011 05:51, javad bakhshi wrote: Hi again, Thanks for the tips. My problem is: I have a Function in Mysql that has some arguments in the signature as follows: CREATE FUNCTION Myfunction( type TINYINT, sec SMALLINT, vid INTEGER, way TINYINT, quid INTEGER, day TINYINT ) RETUR

Re: locked non-existent row

2011-09-02 Thread Jochem van Dieten
On Wed, Aug 31, 2011 at 4:10 AM, Peter Brawley wrote: > While a transaction in one thread tries to update a non-existent InnoDB row > with a given key value, an attempt to insert that value in another thread is > locked out. Does anyone know where this behaviour is documented? In the manual it is

Re: Arrays

2011-09-02 Thread javad bakhshi
Hi again, Thanks for the tips. My problem is: I have a Function in Mysql that has some arguments in the signature as follows:  CREATE FUNCTION Myfunction( type TINYINT, sec SMALLINT, vid INTEGER,   way TINYINT, quid INTEGER, day TINYINT ) RETURNS CHAR(50) BEGIN   DECLARE result CHAR(50); DECL