TM1 and MySQL Workbench

If you have chance to work with TM1 and MySQL, you probably will use MySQL workbench and it is really very handy. However, if you copy SQL directly from workbench into TI SQL window, you will have some problem, especially when you are on Windows platform. You will find that SQL in TI is truncated into some limitation automatically for some reason after you reboot the server.

See the following explanation,
How MySQL workbench add invisible char into the end of each line (only LF, which is Unix way)

After copying same SQL into Notepad++ and how Notepad++ display the end of each line (CR+LF, which is windows way)

And the SQL window in TI only recognize the common Windows way of displaying end of each line, which is CR+LF. If you copy SQL directly from workbench into TI window, at first, you won't see any problem and that SQL will be only displayed into one line. Once you reboot your server, TI would automatically truncate the whole SQL at the first place of LF. That caused the failure.

For anyone who is not familiar with CR or LF. Read this,

CR an LF are control characters, respectively coded 0x0D (13 decimal) and 0x0A (10 decimal).
They are used to mark a line break in text file. A you indicated, Windows uses two characters the CR LF sequence; Unix only uses LF and MacIntosh CR.
An apocryphal historical perspective
As indicated by Peter, CR = Carriage Return and LF = Line Feed, two expressions which have their roots in the old typewriters / TTY. LF moved the paper up (but kept the horizontal position identical) and CR brought back the "carriage" so that the next character typed would be at the leftmost position on the paper (but on the same line). CR+LF was doing both, i.e. preparing to type a new line. As time went by the physical semantics of the codes were not applicable, and as memory and floppy disk space was at a premium, some OS designers decided to only use one of the characters, they just didn't communicate very well with one another ;-)
Most modern text editors and text-oriented application offer options/settings etc. that allow the automatic detection of the file's end-of-line convention and to display it accordingly.