OpenEuphoria

Re: edbi on 64 bit machines?

• Posted by Jerome Apr 26, 2012
• 3964 views

To add another data point, I downloaded edbi on my 64 bit Ubuntu and did the following:

cd ~/Code/Euphoria/edbi/drivers/mysql 
euc -so edbi_mysql.e 
sudo mv edbi_mysql.so /usr/local/lib/. 
sudo ldconfig 

As a quick fix, I changed edbi.e around line 330 to this:

--sequence dll_name3 = sprintf("edbi_%s.%s", { driver, SHARED_LIB_EXT }) 
sequence dll_name3 = "/usr/local/lib/edbi_mysql.so" 

I was able to succesfully run the t_myslq.e in unittest after putting in my mysql information, but had several failures. All of these tests pass on my 32bit system.

eutest -verbose -all t_mysql.e 
interpreting t_mysql.e: 
CMD 'eui   -d UNITTEST -batch t_mysql.e  -all' 
  passed: Open database 
  passed: Drop table TestNum 
  passed: Create table TestNum 
  passed: Insert values into TestNum 
  passed: Checking INTEGER data types with Query Rows... 
  failed: Checking DOUBLE data types with Query Rows..., expected: 76.4 but got: 0 
  failed: Checking REAL data types with Query Rows..., expected: 3.14159 but got: 76.4 
  passed: Checking INTEGER data types with Query... 
  failed: Checking DOUBLE data types with Query..., expected: 76.4 but got: 0 
  failed: Checking REAL data types with Query..., expected: 3.14159 but got: 76.4 
  passed: Open database 
  passed: Drop table TestString 
  passed: Create table TestString 
  passed: Insert values into string table 
  failed: Checking TEXT data types with Query Rows..., expected: "A Tale of Two Cities" but got: 0 
  failed: Checking VARCHAR(30) data types with Query Rows..., expected: "Charles Dickens" but got: "" 
  failed: Checking BLOB data types with Query Rows..., expected: "English" but got: 0 
  failed: Checking DATETIME data types with Query Rows..., expected: {1859,1,1,23,59,0} but got: 0 
  failed: Checking DATE data types with Query Rows..., expected: {2000,10,13,0,0,0} but got: 0 
  failed: Checking TEXT data types with Query..., expected: "A Tale of Two Cities" but got: 0 
  failed: Checking VARCHAR(30) data types with Query..., expected: "Charles Dickens" but got: "" 
  failed: Checking BLOB data types with Query..., expected: "English" but got: 0 
  failed: Checking DATETIME data types with Query..., expected: {1859,1,1,23,59,0} but got: 0 
  failed: Checking DATE data types with Query..., expected: {2000,10,13,0,0,0} but got: 0 
  24 tests run, 10 passed, 14 failed, 42% success 
... 

And for reference:

eui --version 
   Euphoria Interpreter v4.1.0 development 
   64-bit Linux, Using System Memory 
   Revision Date: 2012-04-25 09:43:17, Id: 5545:6b3fc2c6be44 

ls -alt libmysqlclient.so 
   lrwxrwxrwx 1 root root 20 2012-03-28 15:46 libmysqlclient.so -> libmysqlclient.so.16 

Hope this helps!

- Ira