Re: SQL Query over I-STAR

In <1993May27.101845.8010@pyra.co.uk> graeme@pyra.co.uk (Graeme Sargent) writes: >> Remote SQL Request: >> select x0.counter_id ,x0.timestamp ,x0.duration ,x0.shift ,x0.qu >> antity from printer_prod:"gap".rate x0 where ((x0.counter_id = 6 >> 1 ) AND (x0.timestamp > (? - ' 30' ) ) )>> >>Looks like maybe "CURRENT" isn't getting across the network? >It's the fact that the 30 gets sent as a character string rather than an >interval that looks highly suspicious to me. >I suspect that the remote engine is being asked to resolve >"datetime_column < (numeric_constant - character_string)" in which case >I am not surprised it is coughing. In fact, on further consideration, I think the optimiser should be sending either: where ((x0.counter_id = 61 ) AND (x0.timestamp > (? - ? ) ) ) or: where ((x0.counter_id = 61 ) AND (x0.timestamp > (? ) ) ) graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.