一个非常复杂的SQL语句是否会使实例崩溃？ [英] Should a very complex SQL statement crash the instance?
问题描述
SELECT栏目
FROM t1
加入t2
SELECT columns
FROM t1
JOIN t2
推荐答案
" Philip Sherman" ; < PS ****** @ ameritech.net>在消息中写道
news：gu *************** @ newssvr32.news.prodigy.com。 ..
"Philip Sherman" <ps******@ameritech.net> wrote in message
news:gu***************@newssvr32.news.prodigy.com. ..
SELECT栏目
FROM t1
加入t2
。
。
。
WHERE谓词
from / join包含5个表，其中一个表是从选择的
语句创建的。
列区包含35个选项，其中一些包含连接，引用了总共40个表。
UDB 8.1 Windows和Linux都崩溃了（完成实例关闭）
试图处理这个语句。 （是的，我有来自Linux的转储，可能会在下周进入Windows转储。）
请不要问我这是从哪里来的 - 我没有''写它并且只需要在接下来的两天内使它工作。
SELECT columns
FROM t1
JOIN t2
.
.
.
WHERE predicates
The from/join contains 5 tables, one of which is created from a select
statement.
The columns area contains 35 selects, some of them containing a join,
referencing a total of 40 tables.
UDB 8.1 Windows and Linux both hard crashed (complete instance shutdown)
trying to process this statement. (Yes, I have dumps from Linux and may
be able to get to the Windows dumps next week.)
Please don''t ask me where this came from - I didn''t write it and just
have to make it work within the next two days.
检查SQL Reference中的SQL限制，以获取
一个声明。如果你不在fixpak 5上，我现在就安装它。
我不在乎它来自哪里，但是那个人应该涂焦油
和羽毛。
Check the SQL limits in the SQL Reference for the most tables or joins in
one statement. If you are not on fixpak 5, I would install it now.
I don''t care where it came from, but the person who did it should be tarred
and feathered.
" Philip Sherman" < PS ****** @ ameritech.net>在消息中写道
news：gu *************** @ newssvr32.news.prodigy.com。 ..
"Philip Sherman" <ps******@ameritech.net> wrote in message
news:gu***************@newssvr32.news.prodigy.com. ..
SELECT栏目
FROM t1
加入t2
。
。
。
WHERE谓词
from / join包含5个表，其中一个表是从选择的
语句创建的。
列区包含35个选项，其中一些包含连接，引用了总共40个表。
UDB 8.1 Windows和Linux都崩溃了（完成实例关闭）
试图处理这个语句。 （是的，我有来自Linux的转储，可能会在下周进入Windows转储。）
请不要问我这是从哪里来的 - 我没有''写它并且只需要在接下来的两天内使它工作。
SELECT columns
FROM t1
JOIN t2
.
.
.
WHERE predicates
The from/join contains 5 tables, one of which is created from a select
statement.
The columns area contains 35 selects, some of them containing a join,
referencing a total of 40 tables.
UDB 8.1 Windows and Linux both hard crashed (complete instance shutdown)
trying to process this statement. (Yes, I have dumps from Linux and may
be able to get to the Windows dumps next week.)
Please don''t ask me where this came from - I didn''t write it and just
have to make it work within the next two days.
检查SQL Reference中的SQL限制，以获取
一个声明。如果你不在fixpak 5上，我现在就安装它。
我不在乎它来自哪里，但是那个人应该涂焦油
和羽毛。
Check the SQL limits in the SQL Reference for the most tables or joins in
one statement. If you are not on fixpak 5, I would install it now.
I don''t care where it came from, but the person who did it should be tarred
and feathered.
我们在FP5上。
我经历了SQL REF V1 3的限制部分时间并且无法获得特定限制。
也许年龄已经到了我的眼前。
Phil Sherman
Mark A写道：
We are on FP5.
I went through the limits section of SQL REF V1 3 times and couldn''t
find that particular limit. Maybe age is getting to my eyes.
Phil Sherman
Mark A wrote:
检查SQL Reference中的SQL限制，以获取一个语句中的大多数表或联接。如果你没有使用fixpak 5，我现在就安装它。
我不在乎它来自哪里，但做这件事的人应该涂焦油和羽毛。 br />
Check the SQL limits in the SQL Reference for the most tables or joins in
one statement. If you are not on fixpak 5, I would install it now.
I don''t care where it came from, but the person who did it should be tarred
and feathered.
这篇关于一个非常复杂的SQL语句是否会使实例崩溃？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
