search

Shooter7119 / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

SQL-99 standard queries fail to execute. #1658

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
1. Enable SQL-99, by setting the following:
    SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE;
    SET GLOBAL sql_mode = 'ANSI'
    or in my.cnf:
    [mysqld]
    sql_mode = ANSI
    transaction-isolation = SERIALIZABLE
2. Create a few tables in a db (in any way)
3. Export the DB/Table using Sequel Pro
4. Import using Sequel Pro

The import fails to succeed due to the SQL-99 standard compliant (double quote) 
delimiter.

What version of Sequel Pro are you using?  1.0.1
What version of OS X are you using?  10.8.2
What version of MySQL are you connecting to on the server? 5.6.10

I've also tried importing the Sequel Pro SQL dump by dropping it into the Query 
area.  This fails with the same error.

Original issue reported on code.google.com by devela...@gmail.com on 7 Mar 2013 at 3:48

GoogleCodeExporter commented 9 years ago

Original comment by stuart02 on 25 Oct 2013 at 1:57