Rene Krenn a52443cc6d TT#147151 UDFs for fast usage count of billing profile&network ... mariadb does not support variable referals in correlated subqueries if the nesting depth is 2 or beyond. so in short: below works -> select (select count(*) from table1 where id = root.id ) as cnt from table2 as root; ... while this not unfortunately: select (select count(1) from (select 1 from table1 where id = root.id LIMIT 1001) as q ) as cnt_limited from table2 as root; this can be solved by declaring the topical subqueries in dedicated user-defined functions, so involved panel/api parts will load quickly even with millions of subscribers. Change-Id: If96603cb4115259d719297af46c5bc7c10aadf76 (cherry picked from commit 52b3341599) (cherry picked from commit d7b14a892e)		3 years ago
..
base	TT#108500 move 15660 to /diff folder	4 years ago
diff	TT#147151 UDFs for fast usage count of billing profile&network	3 years ago
init	MT#10699 remove ngcp.cfg_schema creation	11 years ago