Re: [asterisk-users] Asterisk 10 'database show' CLI command
On 10/12/2011 07:24 PM, Barry Miller wrote: Up through 1.8, 'database show' returned results ordered by key. In 10, the output is unordered (or maybe chronological?). Is this intentional? It was not intentional, probably a side-effect of the switch to SQlite 3 from BDB. Unfortunately, that command was not documented to produce the database results ordered in any particular order, so this change isn't a bug, just a side-effect. -- Kevin P. Fleming Digium, Inc. | Director of Software Technologies Jabber: kflem...@digium.com | SIP: kpflem...@digium.com | Skype: kpfleming 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at www.digium.com www.asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Asterisk 10 'database show' CLI command
On Thu, Oct 13, 2011 at 10:13:49AM -0500, Kevin P. Fleming wrote: On 10/12/2011 07:24 PM, Barry Miller wrote: Up through 1.8, 'database show' returned results ordered by key. In 10, the output is unordered (or maybe chronological?). Is this intentional? It was not intentional, probably a side-effect of the switch to SQlite 3 from BDB. Unfortunately, that command was not documented to produce the database results ordered in any particular order, so this change isn't a bug, just a side-effect. Thanks. The only time it really matters to me is on my little test box, so I'll just keep running a patched db.c there. -- Barry -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Asterisk 10 'database show' CLI command
It was not intentional, probably a side-effect of the switch to SQlite 3 from BDB. Unfortunately, that command was not documented to produce the database results ordered in any particular order, so this change isn't a bug, just a side-effect. Thanks. The only time it really matters to me is on my little test box, so I'll just keep running a patched db.c there. It will be easy enough to change. No real reason for me not to add an 'ORDER BY key' to the get_tree_all SQL statement near the top of the file. -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Asterisk 10 'database show' CLI command
On Thu, Oct 13, 2011 at 02:52:58PM -0500, Terry Wilson wrote: It was not intentional, probably a side-effect of the switch to SQlite 3 from BDB. Unfortunately, that command was not documented to produce the database results ordered in any particular order, so this change isn't a bug, just a side-effect. Thanks. The only time it really matters to me is on my little test box, so I'll just keep running a patched db.c there. It will be easy enough to change. No real reason for me not to add an 'ORDER BY key' to the get_tree_all SQL statement near the top of the file. I also added the clause to gettree and showkey stmts, because wildcarding database show abc% database showkey 212% can return many results. But I'm not sure if anyone besides me cares :) -- Barry -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] Asterisk 10 'database show' CLI command
Up through 1.8, 'database show' returned results ordered by key. In 10, the output is unordered (or maybe chronological?). Is this intentional? (I know 'database query' will let me view the AstDB any way I want, but the output isn't formatted as nicely.) -- Barry -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users