From: Luis Henrique Cassis Fagundes <lfagundes@ma...> - 2004-11-16 12:50:39
Flo Gleixner wrote:
> check my last commit on tikilib. It's easy to do that later when all
> results are combined in a php array. adodb offers a IsNull() to make the
> IS NULL call database independent, but unfortunately no IS NOT NULL
I just tested in mysql:
SELECT login FROM users_users WHERE NOT (login IS NULL);
maybe this is equivalent to IS NOT NULL in all dbs?
> You mean building that extra table in "background". Probably. But if it
> fails, then the permission system may fail too.
Not in background, before anything, maybe in tiki-setup.php. It must be designed in a way
that if it takes too long and time exceeds, next request it will be half done. This way,
it may hang first requests after software upgrade, then it's fine. Then it gets cached and
never checked again. In case cache is removed, it will take just one query to notice that
permissions are upgraded and cache it again.
> I'd say, it's a task for 1.10 and it looks like it will be a long way to
I wouldn't be dafraid to try it in 1.9, keeping both md5 an non-md5 ids redundant, but I
agree that this may not be prudent :-). The question is: are these issues critical for
1.9? There are some problems, but they've arisen in 1.9 features, I think we're not
getting less than 1.8 in anything with that.