-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 26/01/12 06:17, Dmitry Astapov wrote: > Comments in views could result in broken database dumps.
The underlying cause is as you said. When SQL text is stored in sqlite_master, trailing whitespace is removed. The text for tables, indices and triggers has trailing comments removed so this works out okay. But trailing comments for views are not removed. (Note all trailing comments are removed. ie if you have more than one, use -- or /* */ syntax, they all go.) > As far as I was able to tell, this is not a known bug. It isn't in the tracker so I added it: http://www.sqlite.org/src/info/c04a8b8a4f Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk8i6dQACgkQmOOfHg372QS/kACfea9+9yifI/G/4TY56dGYaGD4 cewAnRJ8X0Vdw8SzCJlTrkcu2mzmqDHF =rAp5 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
