Hey Inge, let me thank you for your very detailed email about the AS numbers & MySQL issue which has allowed me to quickly work on the code.
There isn't any specific reason behind the choice of unquoted AS numbers; it is definitely the right behaviour for PostgreSQL in "typed" data mode but wrong for MySQL, SQLite and PostgreSQL in "unified" data mode. I've made a patch for the new upcoming release 0.9.6 which: -- solves the AS numbers issue by quoting them while in one of the above mentioned SQL configurations. -- adds a minor cosmetic behaviour: if (i) no 'sql_optimize_clauses' is specified and (ii) either src_as or dst_as is specified, the unused primitives is filled with '0' instead of '0.0.0.0'. The fresh archive (which is the final 0.9.5 plus the above patch) is available at the following URL: http://www.ba.cnr.it/~paolo/pmacct/pmacct-0.9.6-20051208.tar.gz Anyone interested into it, is invited to test it and let me know wheter it works as expected. Inge, thank you again for your active cooperation; of course, you will be credited in the ChangeLog for the solution of this issue. Cheers, Paolo
