Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error 1064 when installing on 5.6.8-rc with workbench #34

Open
GoogleCodeExporter opened this issue Jun 18, 2015 · 11 comments
Open

Error 1064 when installing on 5.6.8-rc with workbench #34

GoogleCodeExporter opened this issue Jun 18, 2015 · 11 comments

Comments

@GoogleCodeExporter
Copy link

Which version of common_schema are you using? (specify
revision+distribution)
1.2.2 r368

Which component is failing? (specify the view, function, etc.)

What is the expected output? What do you see instead?
11:33:43    INTO metadata (attribute_name, attribute_value) VALUES   ('author', 
'Shlomi Noach'),   ('author_url', 'http://code.openark.org/blog/shlomi-noach'), 
  ('install_success', false),   ('install_time', NOW()),   ('install_sql_mode', 
@@sql_mode),   ('install_mysql_version', VERSION()),   
('base_components_installed', false),   ('innodb_plugin_components_installed', 
false),   ('percona_server_components_installed', false),   ('license_type', 
'New BSD'),   ('license', ' Copyright (c) 2011 - 2012, Shlomi Noach All rights 
reserved.  Redistribution and use in source and binary forms, with or without 
modification, are permitted provided that the following conditions are met:     
 * Redistributions of source code must retain the above copyright notice, this 
list of conditions and the following disclaimer.     * Redistributions in 
binary form must reproduce the above copyright notice, this list of conditions 
and the following disclaimer in the documentation and/or other materials 
provided with the distribution.     * Neither the name of the organization nor 
the names of its contributors may be used to endorse or promote products 
derived from this software without specific prior written permission.  THIS 
SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY 
EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED 
WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE 
DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR 
ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES 
(INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; 
LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON 
ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT 
(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS 
SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.  '),   
('project_name', 'common_schema'),   ('project_home', 
'http://code.google.com/p/common-schema/'),   ('project_repository', 
'https://common-schema.googlecode.com/svn/trunk/'),   
('project_repository_type', 'svn'),   ('revision', '368'),   ('version', 
'1.2.2')    Error Code: 1064. You have an error in your SQL syntax; check the 
manual that corresponds to your MySQL server version for the right syntax to 
use near 'INTO metadata (attribute_name, attribute_value) VALUES   ('author', 
'Shlomi Noac' at line 1 0.000 sec


Can you provide with sample data?

(As of version 1.1), please provide output of
SELECT * FROM common_schema.status

Please provide any additional information below.

It seems like workbench does not like:
1. some statements which use multiple lines
2. "-- " comments do not work. "-- x" works



Original issue reported on code.google.com by [email protected] on 23 Nov 2012 at 10:50

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant