Error on Informix Online
Posted in 1996
Hi, I hope you apoligize my english. I have a HP900 with HPUX 9.04 and Infomix Online 7. When i execute this select SELECT bas_doctes.*, ana_enaz.*, bas_tipdoc.*, bas_lineac.*, smc_iart.*, ana_copa.*, ana_agba.*, bas_tiplis.*, ana_aliq.*, bas_agente.*, bas_bolfis.*, ana_enan.*, ven_regfat.* FROM bas_doctes, outer (ana_enaz, ana_enan), bas_tipdoc, outer bas_lineac, outer (smc_iart, ven_regfat), ana_copa, outer ana_agba, bas_tiplis, outer ana_aliq, outer bas_agente, outer bas_bolfis WHERE ana_enaz.enaz_enan = ana_enan.enan_enan AND smc_iart.iart_reiv = ven_regfat.regfat_reiv AND bas_doctes.doctes_enaz = ana_enaz.enaz_enaz AND bas_doctes.doctes_tipdoc = bas_tipdoc.tipdoc_tipdoc AND bas_doctes.doctes_lineac = bas_lineac.lineac_lineac AND bas_doctes.doctes_iart = smc_iart.iart_iart AND bas_doctes.doctes_copa = ana_copa.copa_copa AND bas_doctes.doctes_agba = ana_agba.agba_agba AND bas_doctes.doctes_tiplis = bas_tiplis.tiplis_tiplis AND bas_doctes.doctes_aliq = ana_aliq.aliq_aliq AND bas_doctes.doctes_agente = bas_agente.agente_agente AND bas_doctes.doctes_bolfis = bas_bolfis.bolfis_bolfis AND bas_doctes.doctes_azie = '2' AND 1=1 AND 1=1 AND bas_doctes.doctes_dtadoc >= '08-07-1996' AND bas_doctes.doctes_dtadoc <= '19-07-1996' AND 1=1 ORDER BY doctes_azie, doctes_dtadoc, doctes_numdoc, doctes_doctes i recive this error PID 10763 received a SIGSEGV for stack growth failure. Possible causes insufficient memory o swap space, or stack size exceeded maxssiz. If i remove the order by statement the select work ok. Please, H H EEEEE L PPPPP H H E L P P HHHHH EEE L PPPPP H H E L P H H EEEEE LLLLL P Bye |/ Bye |\\ino