<?php
declare(strict_types=1);require __DIR__.'/bootstrap.php';$f=json_decode(file_get_contents($runtime.'/fixture-journal.json'),true);$id=$f['owned']['store'];$char=$dm?'VARCHAR(128)':'CHAR(128)';$sql='SELECT SUM(total_pay_price) raw_money,SUM(total_num) raw_num,CAST(SUM(total_pay_price) AS '.$char.') text_money,CAST(SUM(total_num) AS '.$char.') text_num FROM yoshop_order_goods WHERE store_id=2147001111 AND order_id=? AND goods_id=?';$r=$read($sql,[$id['stat_order'],$id['goods']]);$wide=$read("SELECT CAST('1234567890123456.78' AS DECIMAL(18,2)) raw_wide,CAST(CAST('1234567890123456.78' AS DECIMAL(18,2)) AS ".$char.") text_wide FROM DUAL");$out=['lane'=>$lane,'scope'=>'own store synthetic aggregate only; wide scalar literal is not customer data','SQL_evidence_layer'=>'independent PDO readonly diagnostic, not HTTP/server trace','aggregate'=>$r,'wide_literal'=>$wide,'business_dml'=>0];$check($own()===$f['after'],'All23 rows diagnostic no effect');file_put_contents(__DIR__.'/aggregate-diagnostic-'.$lane.'.json',json_encode($out,JSON_PRETTY_PRINT|JSON_PRESERVE_ZERO_FRACTION|JSON_UNESCAPED_SLASHES));echo json_encode($out,JSON_PRESERVE_ZERO_FRACTION),"\n";
