Re: Upgrading from 9.21 to 10 planning

> Can you give us an example that breaks it?

Yes, I can.

Here's the query:

SELECT tableX.* FROM tableX WHERE tableX.att1=?

It is run from Java app as a PreparedStatement.
tableX is in fact user's private synonym which points to a view w1 which is
defined as:

CREATE VIEW w1 AS
SELECT x.a1
, x.a2
, x.a3
FROM x
WHERE EXISTS (SELECT *
FROM y, z
WHERE x.a1 = y.a1
AND y.a2 = z.a1
AND z.a2 = USER);

If you run the query a few times IDS crashes with following trace from af
file:

0x0072e140 (oninit)afhandler(0xba1400, 0xa14000, 0x3f011668, 0x1, 0x601,
0x601)
0x0072d934 (oninit)afcrash_interface(0xb137cc, 0x48467b08, 0x3f011668,
0xb137e4, 0x1af, 0x0)
0x007322a8 (oninit)mt_ex_throw_sig(0xa12f58, 0xb108c8, 0xb9eb08, 0xb137a0,
0x44dcce18, 0x0)
0x006fdd7c (oninit)afsig_handler(0xb, 0x484680e0, 0x48467e28, 0x48467d48,
0xb8f4a8, 0xbab894)
0x001bd7f4 (oninit)sc_chkperm(0x40ba2470, 0x476457f8, 0x8000000, 0x2, 0x0,
0x418875c8)
0x001bae1c (oninit)ssc_link(0xbab800, 0x1, 0x1, 0xb8f4a8, 0x476ff310,
0x4761f020)
0x0035d594 (oninit)parsecmd(0xb8f400, 0xbab800, 0x0, 0x1, 0xb8f4a8,
0x40ba2558)
0x0035cdf4 (oninit)sqcmd (0xbab800, 0xbab894, 0x1, 0x4761b018, 0x0, 0x0)
0x0035ca68 (oninit)sq_cmnd (0xbab800, 0xb98aa4, 0x2, 0x2, 0x48468bd0, 0x0)
0x0035cab0 (oninit)sq_prepare(0xbab800, 0x1000, 0x0, 0x4761b018, 0xe, 0x1)
0x003da278 (oninit)sqmain (0x2, 0xbab800, 0xa11c00, 0x1004, 0xb98aa4,
0x1000)
0x00751708 (oninit)listen_verify(0xa45d58, 0xa, 0xa11e78, 0x0, 0x41aef8a0,
0xb16abc)
0x0070b7d8 (oninit)startup (0xba16d0, 0x7, 0x44dcce18, 0x3f0138e0,
0xffffffff, 0x3f0138a0)
0x00757f68 (oninit)net_wait_for_io(0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x00000000 (*nosymtab*)0x0

Designated IBM engineer said: "The issue in bug 158892 was with the checking
of permissions on every column every time the statement is executed.
Statement caching is having a problem with what you are doing."


.

Relevant Pages

  • Re: sp_spaceused reporting anomolies?
    ... when I ran the 'select * from TableX' ... query, it took ~ 5 seconds for the query to execute. ... so I'm wondering if there is some database corruption ...
    (microsoft.public.sqlserver.server)
  • Re: Qry not pulling bound column problem
    ... What are TableX and TableY? ... The UNION query will show ALL records in TableX and ALL records in TableY, ...
    (microsoft.public.access.queries)
  • Re: Starting Date of Week(Week Number Issue)
    ... from tablex s INNER JOIN tabley b on group by DAtenameorder ... by avg desc ... this is the query i had....which i formed with great difficulty, ...
    (microsoft.public.sqlserver.programming)
  • Re: query enhancement
    ... The query, as it now stands, tests for the presence of 'null' in one ... select countfrom tableX where columnX IS NULL; ... Presuming you have an index this may produce an index fast full scan ...
    (comp.databases.oracle.server)