Subquery limits

Found this on the MySQL crashme page, http://www.tcx.se/crash-me.html:

                                                Join methods
                                     MySQL         EMPRESS       mSQL      Oracle   PostgreSQL    SOLID
 cross join (same as from
 a,b)                         [yes]              [no]        [no]        [no]       [no]      [yes]
 full outer join              [no]               [no]        [no]        [no]       [no]      [yes]
 tables in join               32                 63          +64         +64        30        23
 left outer join              [yes]              [no]        [no]        [no]       [no]      [yes]
 left outer join using        [yes]              [no]        [no]        [no]       [no]      [no]
 natural join                 [no]               [no]        [no]        [no]       [no]      [no]
 natural left outer join      [yes]              [no]        [no]        [no]       [no]      [no]
 left outer join odbc style   [yes]              [no]        [no]        [no]       [no]      [yes]
 recursive subqueries                            49                      +64        226       14
 ^^^^^^^^^^^^^^^^^^^^

 right outer join             [no]               [no]        [no]        [no]       [no]      [yes]
 ANSI SQL simple joins        [yes]              [yes]       [yes]                  [yes]     [yes]
 subqueries                   [no]               [yes]       [no]        [yes]      [yes]     [yes]
 ^^^^^^^^^^

So he did updated it to be accurate.  Interesting we support 226 levels
of recursive subqueries.  That sounds like a lot.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)