From cfb109b87f5f930365681b0944e683652903749e Mon Sep 17 00:00:00 2001 From: Frédéric Buclin Date: Tue, 4 Sep 2012 12:58:21 +0200 Subject: Bug 787687: SQLite doesn't support CHAR_LENGTH natively r=wicked a=LpSolit --- Bugzilla/DB/Sqlite.pm | 1 + 1 file changed, 1 insertion(+) (limited to 'Bugzilla/DB') diff --git a/Bugzilla/DB/Sqlite.pm b/Bugzilla/DB/Sqlite.pm index 5564e21df..5810ab4d7 100644 --- a/Bugzilla/DB/Sqlite.pm +++ b/Bugzilla/DB/Sqlite.pm @@ -131,6 +131,7 @@ sub new { # so that's what we use, and I don't know of any way in SQLite to # alias the SQL "substr" function to be called "SUBSTRING". $self->sqlite_create_function('substring', 3, \&CORE::substr); + $self->sqlite_create_function('char_length', 1, sub { length($_[0]) }); $self->sqlite_create_function('mod', 2, \&_sqlite_mod); $self->sqlite_create_function('now', 0, \&_sqlite_now); $self->sqlite_create_function('localtimestamp', 1, \&_sqlite_now); -- cgit v1.2.3-24-g4f1b