now also support table/index scan as root node, i.e tree = [ scan ] ? [ lookup ] *
still with the limitations:
- a child may only be dependent on immediate parent
- still only left outer join.
i also completed the parameterized scan-filter inside tup but does not yet support this in spj or ndbapi.
currently working on
- the parameterized scan-filer in spj (and a tiny bit in the ndbapi).
- result set correlation
currently thinking on
- arena based allocator for spj-requests, (compare mysqld mem-root concept)
discussed with frazer what spj "really is", concluded that it probably is some kind of "data-flow-engine"...should probably find some hip acronym/term for it...
current mental capacity is limiting spj to only one scan in a tree.
this limitation can of course be lifted...but not now, or my brain will fry.
wonder how i should make people giving me votes on planetmysql??
MySQL 8.0: ひらがなカタカナを判別する日本語用Collation - 以前の記事では、MySQL 8.0.1で導入された新しい 日本語のutf8bm4のCollation(文字照合順)について ご紹介しました。このcollation (utf8mb4_ja_0900_as_cs) は、CLDR 30で定義されたアクセント記号(清音濁音半濁音)ならびに大文字小文字(拗音促音など)...
4 hours ago