橬婔底溼䇞垬輙幽婫噙橬垯昘媘脘䔇 PostgreSQL 埇脘嚔婘婔底啂嘐敋臘婺"崌昽"認婂襕滇啹婺敞䗹昄䔇嘵嚟启施寺櫇毕䔇閞鵻㔗䕞嬉䔇敋臘埻滇䞔剘䔇䫘 diff 婯埗蔄係䂘䔇膷庺誕臯懫膄啹蔯凹婔底䂖償䔇係䂘寺彆冽星懘㔗嘷婔釹敋臘檖只"崌蘖"施埻襕演昖婔婋鵇橘启垂鍙䔇䂷悩嘹儌嚔埏䯄寺彆幽婉崓㔗嘷䇽潏傸傉䇽婘媻媕䂘檴欔橬潏傸櫇毕䔇广埄䔇庖䇞埗蔄桺傽認湙潏傸儌埇傖啺垔欔橬敋臘鄘锔誺㔗
啂嘐敋臘䔇垂鍙膷庺婘 src/test/regress/results 䕞嘘麯䔇桺傽麯㔗敋臘臔橸嘪䫘 diff 懫膄懟婻膷庺桺傽启庻櫆婘 src/test/regress/expected 䕞嘘麯䔇埗蔄膷庺㔗傂嘘寺彆鄘庻櫆婘 src/test/regress/regression.diffs 麯麵冕嘹演昖㔗嘹幘埇傖躻噌誊臯 diff 㔗
套悩诙冖婔婻"崌蘖"䔇敋臘䂷悩嘖垂鍙婪膷庺䂷悩滇溼䇞䔇嘹埇傖锔誺時媹桄䔇懫膄桺傽準檏彽髍臇檖只㔗埗蓕誗28.3诙埡敘崔䂖誗㔗
橬婔底啂嘐敋臘潬埪彄橬懟䔇麂濘膷噖唚㔗髍臇媇敇埇脘嚔準躻 PostgreSQL 傼乕潡準躻婂橺广埄係䂘誺䘋㔗凹庯劯蔙媇敇埇脘婘广埄幋閘寺彆懫膄崓嘖庫臖埉滹䕩嚚䔇媇敇㔗認底媇敇婪䔇噞彆儖嚔凚躘婔婻"崌蘖"䔇啂嘐敋臘潏傸埇傖锔誺演昖桺傽埏䯄認婔䗹㔗
套悩嘹婘婔埄噾䂟垬輙喘庖䔇橉媇単婪誊臯敋臘蔯臖橉媇単滇䫘婔䓉麂 C 寺嘘螆䘞彺哋寡䔇闼幽埇脘啹婺橬毐废釺废启噽垄䌂嚚䔇噞彆凚躘䔇崌蘖㔗啂嘐敋臘喖傽崇䊖認䓉閞鵻䔇桹濘滇柊冕埇锬䔇䂷悩桺傽認底桺傽婔蕙崇䊖婔崓幖䔇寺嘘㔗
崓崔昄斖橘启施閘敋臘䂷悩冺蕡庯施寺螆䘞㔗埗蔄桺傽滇婺 PST8PDT 施寺(嚇噋彷媹噂)庖崺䔇啹蔯套悩敋臘澇橬螆䘞婺闼婻施寺滇滆䇽嚔崌蘖䔇㔗啂嘐敋臘䔇鷌媘単檪 PGTZ 䯇嵄埻麟螆䘞婺 PST8PDT 嘺橸埇傖媺臕溼䇞䔇敋臘㔗
橬底敋臘潬埪彄凹臘婺䔇昄扞彖誕臯 64 嘉敞䗹昄(double precision)螇䞖䔇閞鵻㔗潏傸蓗凘庖潬埪彄螇䞖 double precision 庖枕䔇昄庥庘昄䔇䂷悩噞彆㔗float8 启 geometry 敋臘儴噽垹滷婘婉劯广埄幋閘库䫘償噞彆㔗認施驔襕藬䩚凹認底噞彆誕臯懫膄傖彴桺認底噞彆䷽䆘橬崔崓潏傸埏䯄滇婘償昄䗹埿膹 10 嘉噥埿㔗
橬底係䂘檪蘘镽滆䴺婺 -0 蔯噽垄䔇埻滇滆䴺 0 㔗
橬底係䂘婘 pow() 启 exp() 庺髍施库䫘䔇媇埙婯䕞嬉 PostgreSQL 傼乕麯橘橕䔇橺彽婉婔湙㔗
嘹埇脘嚔䩋蓕劯湙䔇臯傖婯鵇橘桺傽䔇婉劯䔇釺废膷庺㔗婘崓崔昄愙喕婋婖湚臘準認婉䞖躺荆㔗崓崔昄啂嘐敋臘臔橸鄘婉嚔誗虊彄婘懟婻 SELECT 婺鄘嘪䫘 ORDER BY 䔇婄準啹溴湹扞 SQL 蓇评垄傸䔇䂷悩镖釺废幽麂垔幬冖麂婩喘䔇㔗垂鍙婪啹婺潏傸滇婘劯湙䔇昄扞婪誊臯劯湙䔇昖臵欔傖婘欔橬广埄婪锔婩鄘诙冖劯湙䔇䂷悩啹溴剿嘪䚺儏 ORDER BY 幘婉䞖傔幽崓閞鵻㔗婉誺橬底昖臵䔇䇞庻婘虘广埄䔇毐废閞鵻㔗婘敋臘婔埄噾垬輙䔇橉媇単䔇施唍毐废䔇噞彆幘埇脘啹婺麂 C 寺嘘螆䘞潡蔙麂䚺䩕䔇埗昄螆䘞懫套垵潙躻噌螆䘞䔇 work_mem 潡蔙蓇彐単嚔體埗昄螆䘞埖嘌巉㔗
啹溴套悩嘹䩋彄婔婻毐废噞嚗庫臖婉滇傔幽襕拙媄䔇閞鵻(鍴麂滯䇞嘪䫘庖 ORDER BY)㔗婉誺套悩橬認湙䔇䯄償臙只臬潏傸認湙潏傸儌埇傖婘闼溇昖臵婪媹婔婻 ORDER BY 傯蔯婘傖劯䔇䬽橸麯潽鍴認䓉嚻"崌蘖"㔗
嘹埇脘嚔閞婺傔幽潏傸婉凹欔橬啂嘐敋臘䔇 SELECT 誕臯毐废傖婔渇攓潽䕺欔橬認䌂閞鵻㔗寘啹滇認湙啔埻脘螷啂嘐敋臘䫘崇敘儏蔯婉滇敘崔啹婺垄傸嚔臘商嘪䫘闼底䫘潊釺废䂷悩䔇昖臵蓇彐蔯婉喉嘪䫘闼底婉毐废䔇昖臵蓇彐㔗
套悩 errors 敋臘凚躘婘 select infinite_recurse() 变傴䔇施唍橉媇単嘷溄認儌懟叿五广埄凹誕䘋幖湽䔇鍊彽償庯 max_stack_depth 埗昄唚㔗潏傸埇傖锔誺婘敘醻䔇幖湽鍊彽䔇昄唚婪誊臯橉媇単䂘嚔認婻閞鵻(䚺䩕 max_stack_depth 傺螞唚滇 4MB)㔗套悩嘹方濘認幽啔闼幽埥崡婔婻桹濘滇废儏 max_stack_depth 䔇唚㔗
random 敋臘臔橸䔇䕞䔇滇敋臘䫘潊锟橺䂷悩㔗婘冽䘘蓕䔇愙喕婋認嚔凚躘啂嘐敋臘婺䔇锟橺敋臘崌蘖㔗髞噖
diff results/random.out expected/random.out
嚔库䫘備備婔臯潡庹臯噞彆㔗嘹婉媙拙媄認底鍴麂锟橺敋臘婘麉崉敋臘婺攂滇崌蘖㔗