search

tushargoyal1309 / common-schema

Automatically exported from code.google.com/p/common-schema
0 stars 0 forks source link

Errors when trying to install script via SQLYog #74

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Hi,
I am trying to install your common-schema-2.2 via SQLYog.
MySQL server version is 5.6.17.
OS is Windows 8.1 64bit.

When try to install it give me two errors.
-----
1. It sense that "" is function and it try to execute it.
-----
"A block statement ({...}) is not terminated by a delimiter. There is no way to
change the delimiter. In particular, QueryScript does not recognize the
DELIMITER statement."

changed to (Notice the . in DELIMITER)

"A block statement ({...}) is not terminated by a delimiter. There is no way to
change the delimiter. In particular, QueryScript does not recognize the
DELI.MITER statement."

-----
2. A document line is showing error.
-----

"This function splits the input text txt into tokens, according to given
delimiter_text. It returns a single token, indicated by the 1-based token_index.
The function is a shortcut to the common pattern of using two SUBSTRING_INDEX() 
invocations."

Changed to 
"This function splits the input text txt into tokens."

Both errors are resolved by altering text (Add . in between text) and removing 
the specific line.

Original issue reported on code.google.com by myi...@gmail.com on 19 Jan 2015 at 6:06

GoogleCodeExporter commented 8 years ago 
Thank you -- 
DELIMITER cannot be recognized by QueryScript as it is unrecognized by prepared 
statements, on which QS relies.
I've encountered multiple issues with loading common_schema (and QueryScript in 
particular) from GUI tools.
I cannot support GUI tools. I suggest that they should support anything that 
loads correctly from command line or via SOURCE, which I do support -- so in 
this case I would suggest opening a bug report for SQLYog.

Original comment by shlomi.n...@gmail.com on 19 Jan 2015 at 8:12