Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

Matthew King's latest activity

Saturday, September 01 2007
96 ambition: hard-coded MySQL syntax in WhereProcessor methods was updated in Plugins
  • Matthew King
    Matthew King commented at 5:12 PM

    I usually don't do the chatty things, but I can on weekdays. On weekends, my real boss requests that I keep computer work to a minimum.

Friday, August 31 2007
96 ambition: hard-coded MySQL syntax in WhereProcessor methods was updated in Plugins
  • Matthew King
    Matthew King commented at 10:06 AM

    I'm uploading a meaty patch (with tests!) that implements the idea in my last comment. I.e., it monkeypatches the Abstract, MySQL, and PostgreSQL adapters wit...

98 Regexp expressions ignored was updated in Plugins
  • Matthew King
    Matthew King commented at 7:45 AM

    postgres has different regexp operators for case sensitive and case insensitive. Perhaps the flags could be tracked for use in adapter-specific regexes.

    http...

Thursday, August 30 2007
96 ambition: hard-coded MySQL syntax in WhereProcessor methods was updated in Plugins
  • Matthew King
    Matthew King commented at 6:59 PM

    Re: database-specific translators for regexp

    How bad of an idea is this?

    Monkeypatch each ActiveRecord adapter with regexp-producing methods, then call them ...

  • Matthew King
    Matthew King commented at 11:27 AM

    Regarding REGEXP and SQL standards, I dunno. I haven't been using postgres long, and I have to look everything up anyway. Speaking of which, the PostgreSQL m...

  • Matthew King
    Matthew King commented at 10:59 AM

    Here's a patch that adds a quote_column_name facade for the ActiveRecord connection to Processor, which is then used in WhereProcessor#translate.

    The patch ha...

100 LIMIT clauses accumulate, anger PostgreSQL was updated in Plugins
  • Matthew King
    • Title changed from LIMIT clauses accumulate, anger PostgreSQL unbearably to LIMIT clauses accumulate, anger PostgreSQL
    by Matthew King at 6:38 PM
  • Matthew King
    Matthew King commented at 6:35 PM

    Here is a patch (with tests!) that substantially changes the way Ambition::Limit works.

    It solves the PostgreSQL problem by breaking out limit and offset into...

  • Matthew King
    Matthew King commented at 6:30 PM

    Attached is a patch with a test that demonstrates the accumulation problem. Easy to reproduce: just run Query#first with an argument more than once on the sa...

  • Matthew King
    Matthew King created the ticket at 6:26 PM

    Each time you kick a first or [] off of a query using a limit or offset, it accumulates a LimitProcessor in keyed_clauses[:limit].

    Additionally, PostgreSQL do...