| Subject | Re: GROUP BY odd results - can someone explain please? |
|---|---|
| Author | |
| Post date | 2014-06-20T10:54:42Z |
Thanks for the replies.
- Same results with ISQL + CTE
- FB version 2.1.3.18185 SS on Windows 2008 Server R2 (on a VM)
- will validate the db when possible.
Database info
ODS Version 11.1
Page Size 8192
Pages 163560
Size on Disk 1.25GB
SQL Dialect 3
Default Character Set NONE
Settings
Page Buffers 10000
Sweep Interval 0
Forced Writes Y
Reserve Space Y
Read-Only N
Transaction info
Oldest transaction 63483321
Oldest active transaction 63483322
Oldest snapshot 63483322
Next transaction 63483378