Re: Aliased table.

Michael Raskin <jhyiugjhvbjh234-JGs/[email protected]> Tue, 12 Oct 2010 00:18:04 +0400
Newsgroups gmane.lisp.clsql.general
Message-ID <[email protected]>
On 10/11/2010 11:30 PM, Michael Raskin wrote:
> 	What are the drawbacks of this patch?

Technically, it was incorrect because of lack of #\Space character in
the output. The corrected patch (tested and working nice):

# patch "sql/expressions.lisp"
#  from [7eae7583a0a34c3728ddcaf4e2e32f33ed33f0d4]
#    to [e5a988302a7d429da8a2a108f334e07a1a78bc68]
#
============================================================
--- sql/expressions.lisp        7eae7583a0a34c3728ddcaf4e2e32f33ed33f0d4
+++ sql/expressions.lisp        e5a988302a7d429da8a2a108f334e07a1a78bc68
@@ -200,7 +200,7 @@
       (symbol
        (write-string (sql-escape name) *sql-stream*)))
     (when alias
-      (format *sql-stream* " ~s" alias)))
+      (format *sql-stream* " ~a" (sql-escape alias))))
   t)

 (defmethod output-sql-hash-key ((expr sql-ident-table) database)