Bug: vector index related bugs

[acquamarin]

Kuzu version

master

What operating system are you using?

macos

What happened?

Incorrect result:

1. The projected graph should filter out all books, so i expect an empty result.

CREATE NODE TABLE Book (
    ID SERIAL,
    title STRING,
    published_year INT64,
    title_embedding FLOAT[384],
    PRIMARY KEY (ID)
);

## Insert to Book table using the data shown on the doc page (https://github.com/kuzudb/kuzu-docs/blob/dev/src/content/docs/extensions/vector.mdx)

CALL CREATE_VECTOR_INDEX('Book', 'title_vec_index', 'title_embedding');
CALL CREATE_PROJECTED_GRAPH(
    'filtered_book',   // Name of the projected graph
    {'Book': {'filter': 'size(n.title_embedding) > 384'}},   // Projected node table Book with a filter on published_year. `n` is a place_holder here to reference the node table.
    []   // No relationship tables can be projected.
);
CALL QUERY_VECTOR_INDEX(
    'filtered_book', // Name of the projected graph
    'title_vec_index', // Name of the index
    [-0.09874727576971054, -0.019663318991661072, 0.026379680261015892, 0.03300049901008606, -0.08525621145963669, 0.03913292661309242, -0.008519773371517658, -0.10472023487091064, -0.07655946910381317, -0.02551322802901268, -0.008726594969630241, -0.004044667351990938, -0.034863777458667755, 0.019577588886022568, -0.053255144506692886, 0.06925362348556519, 0.005541415419429541, -0.007712417747825384, -0.04724293202161789, -0.07092397660017014, -0.00885140523314476, 0.057485658675432205, -0.01551036350429058, 0.007519498933106661, 0.08363034576177597, -0.011691797524690628, 0.07842060178518295, 0.0699118822813034, 0.03983190655708313, -0.04736096411943436, 0.05344963073730469, 0.018938563764095306, -0.007491335738450289, -0.06082497537136078, -0.0507962740957737, 0.04239414632320404, -0.018963998183608055, 0.007558973040431738, 0.042515095323324203, -0.026247873902320862, 0.04227885231375694, 0.031660303473472595, -0.04580925032496452, 0.030136926099658012, 0.06916909664869308, 0.1163673847913742, 0.08413344621658325, 0.00152504607103765, -0.024930620566010475, -0.10900826007127762, -0.055435676127672195, 0.034742217510938644, -0.0032851770520210266, 0.0435388945043087, 0.006796618457883596, -0.00048406978021375835, 0.07152412086725235, -0.01019048597663641, -0.03555936738848686, -0.06622810661792755, -0.025580912828445435, -0.09381087869405746, -0.09504663944244385, 0.02437695302069187, 0.134092777967453, 0.027306102216243744, -0.013635482639074326, 0.04523690044879913, -0.045877039432525635, -0.010559560731053352, -0.034854717552661896, -0.01888713240623474, -0.045843612402677536, 0.023764878511428833, 0.061249908059835434, -0.039338767528533936, 0.07242103666067123, 0.0527820959687233, 0.043525248765945435, -0.0003186847607139498, -0.02600417472422123, -0.10006128996610641, 0.016926968470215797, 0.008328817784786224, 0.09273956716060638, 0.019676057621836662, -0.08953194320201874, 0.006387700792402029, -0.081199049949646, -0.06670287251472473, -0.0417928621172905, -0.045379575341939926, -0.0008021353278309107, -0.09036444127559662, -0.029995467513799667, 0.029478128999471664, 0.026864662766456604, -0.06496299803256989, 0.012791202403604984, 0.09779316186904907, 0.03545205295085907, 0.04149294272065163, 0.019831914454698563, 0.002529511693865061, 0.0461372546851635, -0.008579960092902184, 0.026133403182029724, 0.01814635843038559, 0.07846872508525848, -0.09352493286132812, 0.022968290373682976, 0.01182691939175129, 0.012175423093140125, -0.004965497180819511, 7.896034367149696e-05, -0.021726293489336967, 0.036760929971933365, 0.08447402715682983, -0.046395111829042435, 0.05701972171664238, -0.050493594259023666, 6.76907438901253e-05, -0.002953510032966733, 0.0860934630036354, -0.02953658252954483, -0.03056415542960167, -0.12899217009544373, -2.064106550261511e-33, 0.015488152392208576, -0.03342021629214287, 0.015619009733200073, -0.010455731302499771, 0.05864442139863968, -0.02653684839606285, 0.07258284837007523, -0.08778553456068039, 0.018826346844434738, -0.016216641291975975, -0.007404595613479614, -0.03554968908429146, 0.008319997228682041, -0.02855130471289158, 0.03193259984254837, 0.018047798424959183, -0.06740124523639679, -0.007899004966020584, 0.03631879389286041, -0.02133457362651825, 0.04704872891306877, -0.05590340495109558, -0.045616090297698975, 0.021392134949564934, -0.07849449664354324, -0.023068571463227272, 0.11903978884220123, -0.0018944559851661325, -0.04567766189575195, 0.008722291328012943, 0.006837415508925915, 0.07824835181236267, -0.08694804459810257, -0.005149406846612692, 0.0592142678797245, 0.020647693425416946, 0.019302235916256905, 0.05669999122619629, 0.004759966395795345, -0.06363297998905182, -0.03863728791475296, -0.07707936316728592, 0.06844320148229599, -0.005478093400597572, -0.020625025033950806, 0.0005605336045846343, 0.02365974709391594, -0.0857347846031189, 0.0040472401306033134, -0.02703179605305195, 0.07371301203966141, -0.08515466749668121, -0.05958851799368858, -0.00036977347917854786, 0.045746318995952606, 0.037566229701042175, 0.037339646369218826, 0.01565920189023018, -0.029106922447681427, -0.026880435645580292, 0.02145109511911869, 0.020097855478525162, 0.004611643496900797, 0.05472870543599129, -0.016886215656995773, 0.06590874493122101, 0.013731150887906551, -0.018520070239901543, 0.003863745369017124, 0.09537586569786072, 0.006862230598926544, 0.04087948799133301, 0.048243604600429535, -0.07596695423126221, 0.08784883469343185, -0.04977760463953018, -0.01720358058810234, -0.04158437252044678, -0.007139154709875584, 0.005755842197686434, -0.005658647511154413, -0.03917710483074188, -0.047673579305410385, 0.022293440997600555, -0.02965836226940155, -0.1400938630104065, -0.06738895922899246, -0.06697329133749008, -0.016933375969529152, -0.0017664943588897586, -0.0932610034942627, -0.024097386747598648, 0.11550511419773102, 0.05578150972723961, -0.12074088305234909, 1.1273514286713838e-33, -0.11707723885774612, 0.07049695402383804, 0.03651612997055054, 0.06814820319414139, -0.021599706262350082, -0.01940377987921238, -0.02033681608736515, -0.011085398495197296, -0.00800390262156725, 0.05900853872299194, 0.05606481805443764, 0.07885222882032394, 0.08607453852891922, 0.05710339546203613, -0.04390961676836014, 0.09391780197620392, 0.022916318848729134, -0.01837819069623947, 0.06715855002403259, 0.012958995997905731, 0.0018168555106967688, 0.009906788356602192, 0.028201734647154808, -0.014642609283328056, 0.02585628256201744, 0.058014560490846634, 0.05878483131527901, 0.03323346748948097, 0.026972956955432892, -0.03851533681154251, 0.011257020756602287, -0.10183282196521759, -0.06838149577379227, 0.02577545866370201, -0.09795572608709335, 0.03309926018118858, 0.02638947032392025, 0.038076382130384445, 0.0023347269743680954, 0.025551890954375267, -0.034650497138500214, -0.01582970656454563, -0.08356215059757233, -0.009231070056557655, 0.004009858705103397, -0.036289189010858536, 0.003509229514747858, 0.011391056701540947, -0.061331845819950104, 0.01540123950690031, -0.0011264500208199024, 0.10097002238035202, -0.013182193972170353, 0.011979017406702042, -0.13199655711650848, 0.02036047913134098, -0.017511453479528427, 0.05499761179089546, 0.11070820689201355, 0.014930548146367073, -0.09360553324222565, -0.019297722727060318, 0.007204619701951742, 0.09441079944372177, -0.00927896611392498, -0.04180166870355606, -0.04578719288110733, 0.05872377008199692, 0.03292301297187805, -0.020148921757936478, -0.034446872770786285, 0.024236811324954033, 0.021329764276742935, -0.01295411866158247, 0.019372068345546722, -0.007271720562130213, -0.019697433337569237, -0.053335949778556824, -0.011210829950869083, -0.0036429560277611017, 0.018726753070950508, -0.01846127398312092, -0.026368536055088043, 0.06836844235658646, 0.03631875663995743, 0.04551452025771141, 0.09708166867494583, -0.0013076072791591287, 0.038096629083156586, -0.07843992859125137, 0.02037520334124565, 0.04456569254398346, 0.026434291154146194, -0.032406117767095566, -0.03527767211198807, -1.0356031587832604e-08, -0.017991339787840843, -0.038019757717847824, 0.046414148062467575, -0.04335968568921089, 0.13680949807167053, 0.01109931617975235, 0.004367447458207607, 0.018392788246273994, -0.07819430530071259, -0.05922280624508858, 0.02490466833114624, -0.024358082562685013, -0.06704910099506378, 0.02667614072561264, 0.03479555994272232, 0.027538081631064415, -0.02667420543730259, -0.010268918238580227, -0.004408948123455048, 0.01541890762746334, 0.09345494210720062, 0.03375879302620888, 0.0555303655564785, 0.02469305880367756, 0.009483843110501766, -0.057700056582689285, -0.03969407081604004, 0.0016294082161039114, 0.02770363539457321, 0.08777989447116852, -0.07391007244586945, 0.07368578761816025, 0.07130586355924606, 0.05937817692756653, -0.029533831402659416, -0.008655997924506664, -0.010082626715302467, -0.0797964483499527, -0.025537142530083656, 0.0783148780465126, -0.06385865062475204, 0.059156548231840134, -0.0749022364616394, 0.0023516560904681683, 0.0034361558500677347, 0.003786548040807247, 0.05568376183509827, -0.09200930595397949, 0.09327029436826706, 0.08218848705291748, 0.07302675396203995, 0.02313903532922268, 0.0677151307463646, -0.0498654730618, 0.0007056242320686579, 0.07477487623691559, 0.008759301155805588, -0.06420709192752838, -0.035795655101537704, 0.053932011127471924, 0.031011711806058884, 0.025613466277718544, -0.036662112921476364, -0.008528689853847027],
    2
)
RETURN nn.title ORDER BY _distance;

Result:

┌───────────────────┐
│ nn.title          │
│ STRING            │
├───────────────────┤
│ The Quantum World │
│ Learning Machines │
└───────────────────┘

Error handling:

1. Negative number of nearest neighbors to return causes undefined behaviour:

CALL QUERY_VECTOR_INDEX(
    'Book', 
    'title_vec_index', 
    [-0.09874727576971054, -0.019663318991661072, 0.026379680261015892, 0.03300049901008606, -0.08525621145963669, 0.03913292661309242, -0.008519773371517658, -0.10472023487091064, -0.07655946910381317, -0.02551322802901268, -0.008726594969630241, -0.004044667351990938, -0.034863777458667755, 0.019577588886022568, -0.053255144506692886, 0.06925362348556519, 0.005541415419429541, -0.007712417747825384, -0.04724293202161789, -0.07092397660017014, -0.00885140523314476, 0.057485658675432205, -0.01551036350429058, 0.007519498933106661, 0.08363034576177597, -0.011691797524690628, 0.07842060178518295, 0.0699118822813034, 0.03983190655708313, -0.04736096411943436, 0.05344963073730469, 0.018938563764095306, -0.007491335738450289, -0.06082497537136078, -0.0507962740957737, 0.04239414632320404, -0.018963998183608055, 0.007558973040431738, 0.042515095323324203, -0.026247873902320862, 0.04227885231375694, 0.031660303473472595, -0.04580925032496452, 0.030136926099658012, 0.06916909664869308, 0.1163673847913742, 0.08413344621658325, 0.00152504607103765, -0.024930620566010475, -0.10900826007127762, -0.055435676127672195, 0.034742217510938644, -0.0032851770520210266, 0.0435388945043087, 0.006796618457883596, -0.00048406978021375835, 0.07152412086725235, -0.01019048597663641, -0.03555936738848686, -0.06622810661792755, -0.025580912828445435, -0.09381087869405746, -0.09504663944244385, 0.02437695302069187, 0.134092777967453, 0.027306102216243744, -0.013635482639074326, 0.04523690044879913, -0.045877039432525635, -0.010559560731053352, -0.034854717552661896, -0.01888713240623474, -0.045843612402677536, 0.023764878511428833, 0.061249908059835434, -0.039338767528533936, 0.07242103666067123, 0.0527820959687233, 0.043525248765945435, -0.0003186847607139498, -0.02600417472422123, -0.10006128996610641, 0.016926968470215797, 0.008328817784786224, 0.09273956716060638, 0.019676057621836662, -0.08953194320201874, 0.006387700792402029, -0.081199049949646, -0.06670287251472473, -0.0417928621172905, -0.045379575341939926, -0.0008021353278309107, -0.09036444127559662, -0.029995467513799667, 0.029478128999471664, 0.026864662766456604, -0.06496299803256989, 0.012791202403604984, 0.09779316186904907, 0.03545205295085907, 0.04149294272065163, 0.019831914454698563, 0.002529511693865061, 0.0461372546851635, -0.008579960092902184, 0.026133403182029724, 0.01814635843038559, 0.07846872508525848, -0.09352493286132812, 0.022968290373682976, 0.01182691939175129, 0.012175423093140125, -0.004965497180819511, 7.896034367149696e-05, -0.021726293489336967, 0.036760929971933365, 0.08447402715682983, -0.046395111829042435, 0.05701972171664238, -0.050493594259023666, 6.76907438901253e-05, -0.002953510032966733, 0.0860934630036354, -0.02953658252954483, -0.03056415542960167, -0.12899217009544373, -2.064106550261511e-33, 0.015488152392208576, -0.03342021629214287, 0.015619009733200073, -0.010455731302499771, 0.05864442139863968, -0.02653684839606285, 0.07258284837007523, -0.08778553456068039, 0.018826346844434738, -0.016216641291975975, -0.007404595613479614, -0.03554968908429146, 0.008319997228682041, -0.02855130471289158, 0.03193259984254837, 0.018047798424959183, -0.06740124523639679, -0.007899004966020584, 0.03631879389286041, -0.02133457362651825, 0.04704872891306877, -0.05590340495109558, -0.045616090297698975, 0.021392134949564934, -0.07849449664354324, -0.023068571463227272, 0.11903978884220123, -0.0018944559851661325, -0.04567766189575195, 0.008722291328012943, 0.006837415508925915, 0.07824835181236267, -0.08694804459810257, -0.005149406846612692, 0.0592142678797245, 0.020647693425416946, 0.019302235916256905, 0.05669999122619629, 0.004759966395795345, -0.06363297998905182, -0.03863728791475296, -0.07707936316728592, 0.06844320148229599, -0.005478093400597572, -0.020625025033950806, 0.0005605336045846343, 0.02365974709391594, -0.0857347846031189, 0.0040472401306033134, -0.02703179605305195, 0.07371301203966141, -0.08515466749668121, -0.05958851799368858, -0.00036977347917854786, 0.045746318995952606, 0.037566229701042175, 0.037339646369218826, 0.01565920189023018, -0.029106922447681427, -0.026880435645580292, 0.02145109511911869, 0.020097855478525162, 0.004611643496900797, 0.05472870543599129, -0.016886215656995773, 0.06590874493122101, 0.013731150887906551, -0.018520070239901543, 0.003863745369017124, 0.09537586569786072, 0.006862230598926544, 0.04087948799133301, 0.048243604600429535, -0.07596695423126221, 0.08784883469343185, -0.04977760463953018, -0.01720358058810234, -0.04158437252044678, -0.007139154709875584, 0.005755842197686434, -0.005658647511154413, -0.03917710483074188, -0.047673579305410385, 0.022293440997600555, -0.02965836226940155, -0.1400938630104065, -0.06738895922899246, -0.06697329133749008, -0.016933375969529152, -0.0017664943588897586, -0.0932610034942627, -0.024097386747598648, 0.11550511419773102, 0.05578150972723961, -0.12074088305234909, 1.1273514286713838e-33, -0.11707723885774612, 0.07049695402383804, 0.03651612997055054, 0.06814820319414139, -0.021599706262350082, -0.01940377987921238, -0.02033681608736515, -0.011085398495197296, -0.00800390262156725, 0.05900853872299194, 0.05606481805443764, 0.07885222882032394, 0.08607453852891922, 0.05710339546203613, -0.04390961676836014, 0.09391780197620392, 0.022916318848729134, -0.01837819069623947, 0.06715855002403259, 0.012958995997905731, 0.0018168555106967688, 0.009906788356602192, 0.028201734647154808, -0.014642609283328056, 0.02585628256201744, 0.058014560490846634, 0.05878483131527901, 0.03323346748948097, 0.026972956955432892, -0.03851533681154251, 0.011257020756602287, -0.10183282196521759, -0.06838149577379227, 0.02577545866370201, -0.09795572608709335, 0.03309926018118858, 0.02638947032392025, 0.038076382130384445, 0.0023347269743680954, 0.025551890954375267, -0.034650497138500214, -0.01582970656454563, -0.08356215059757233, -0.009231070056557655, 0.004009858705103397, -0.036289189010858536, 0.003509229514747858, 0.011391056701540947, -0.061331845819950104, 0.01540123950690031, -0.0011264500208199024, 0.10097002238035202, -0.013182193972170353, 0.011979017406702042, -0.13199655711650848, 0.02036047913134098, -0.017511453479528427, 0.05499761179089546, 0.11070820689201355, 0.014930548146367073, -0.09360553324222565, -0.019297722727060318, 0.007204619701951742, 0.09441079944372177, -0.00927896611392498, -0.04180166870355606, -0.04578719288110733, 0.05872377008199692, 0.03292301297187805, -0.020148921757936478, -0.034446872770786285, 0.024236811324954033, 0.021329764276742935, -0.01295411866158247, 0.019372068345546722, -0.007271720562130213, -0.019697433337569237, -0.053335949778556824, -0.011210829950869083, -0.0036429560277611017, 0.018726753070950508, -0.01846127398312092, -0.026368536055088043, 0.06836844235658646, 0.03631875663995743, 0.04551452025771141, 0.09708166867494583, -0.0013076072791591287, 0.038096629083156586, -0.07843992859125137, 0.02037520334124565, 0.04456569254398346, 0.026434291154146194, -0.032406117767095566, -0.03527767211198807, -1.0356031587832604e-08, -0.017991339787840843, -0.038019757717847824, 0.046414148062467575, -0.04335968568921089, 0.13680949807167053, 0.01109931617975235, 0.004367447458207607, 0.018392788246273994, -0.07819430530071259, -0.05922280624508858, 0.02490466833114624, -0.024358082562685013, -0.06704910099506378, 0.02667614072561264, 0.03479555994272232, 0.027538081631064415, -0.02667420543730259, -0.010268918238580227, -0.004408948123455048, 0.01541890762746334, 0.09345494210720062, 0.03375879302620888, 0.0555303655564785, 0.02469305880367756, 0.009483843110501766, -0.057700056582689285, -0.03969407081604004, 0.0016294082161039114, 0.02770363539457321, 0.08777989447116852, -0.07391007244586945, 0.07368578761816025, 0.07130586355924606, 0.05937817692756653, -0.029533831402659416, -0.008655997924506664, -0.010082626715302467, -0.0797964483499527, -0.025537142530083656, 0.0783148780465126, -0.06385865062475204, 0.059156548231840134, -0.0749022364616394, 0.0023516560904681683, 0.0034361558500677347, 0.003786548040807247, 0.05568376183509827, -0.09200930595397949, 0.09327029436826706, 0.08218848705291748, 0.07302675396203995, 0.02313903532922268, 0.0677151307463646, -0.0498654730618, 0.0007056242320686579, 0.07477487623691559, 0.008759301155805588, -0.06420709192752838, -0.035795655101537704, 0.053932011127471924, 0.031011711806058884, 0.025613466277718544, -0.036662112921476364, -0.008528689853847027], 
    -1
)
RETURN nn.title ORDER BY _distance;

Result in shell:

Error: vector

Usability:

1. Give a more meaningful message when the user tries to drop a table with vector index

kuzu> drop table Book;
Error: Binder exception: Cannot delete node table Book because it is referenced by relationship table _bookidx_UPPER.

The relationship table: _bookidx_UPPER. might be confusing?

2. Disable dropping properties which a projected graph depends on:

CALL CREATE_PROJECTED_GRAPH(
    'filtered_book',   // Name of the projected graph
    {'Book': {'filter': 'n.published_year > 2010'}},   // Projected node table Book with a filter on published_year. `n` is a place_holder here to reference the node table.
    []   // No relationship tables can be projected.
);

ALTER TABLE BOOK DROP published_year;

CALL QUERY_VECTOR_INDEX(
    'filtered_book', // Name of the projected graph
    'title_vec_index', // Name of the index
    [-0.09874727576971054, -0.019663318991661072, 0.026379680261015892, 0.03300049901008606, -0.08525621145963669, 0.03913292661309242, -0.008519773371517658, -0.10472023487091064, -0.07655946910381317, -0.02551322802901268, -0.008726594969630241, -0.004044667351990938, -0.034863777458667755, 0.019577588886022568, -0.053255144506692886, 0.06925362348556519, 0.005541415419429541, -0.007712417747825384, -0.04724293202161789, -0.07092397660017014, -0.00885140523314476, 0.057485658675432205, -0.01551036350429058, 0.007519498933106661, 0.08363034576177597, -0.011691797524690628, 0.07842060178518295, 0.0699118822813034, 0.03983190655708313, -0.04736096411943436, 0.05344963073730469, 0.018938563764095306, -0.007491335738450289, -0.06082497537136078, -0.0507962740957737, 0.04239414632320404, -0.018963998183608055, 0.007558973040431738, 0.042515095323324203, -0.026247873902320862, 0.04227885231375694, 0.031660303473472595, -0.04580925032496452, 0.030136926099658012, 0.06916909664869308, 0.1163673847913742, 0.08413344621658325, 0.00152504607103765, -0.024930620566010475, -0.10900826007127762, -0.055435676127672195, 0.034742217510938644, -0.0032851770520210266, 0.0435388945043087, 0.006796618457883596, -0.00048406978021375835, 0.07152412086725235, -0.01019048597663641, -0.03555936738848686, -0.06622810661792755, -0.025580912828445435, -0.09381087869405746, -0.09504663944244385, 0.02437695302069187, 0.134092777967453, 0.027306102216243744, -0.013635482639074326, 0.04523690044879913, -0.045877039432525635, -0.010559560731053352, -0.034854717552661896, -0.01888713240623474, -0.045843612402677536, 0.023764878511428833, 0.061249908059835434, -0.039338767528533936, 0.07242103666067123, 0.0527820959687233, 0.043525248765945435, -0.0003186847607139498, -0.02600417472422123, -0.10006128996610641, 0.016926968470215797, 0.008328817784786224, 0.09273956716060638, 0.019676057621836662, -0.08953194320201874, 0.006387700792402029, -0.081199049949646, -0.06670287251472473, -0.0417928621172905, -0.045379575341939926, -0.0008021353278309107, -0.09036444127559662, -0.029995467513799667, 0.029478128999471664, 0.026864662766456604, -0.06496299803256989, 0.012791202403604984, 0.09779316186904907, 0.03545205295085907, 0.04149294272065163, 0.019831914454698563, 0.002529511693865061, 0.0461372546851635, -0.008579960092902184, 0.026133403182029724, 0.01814635843038559, 0.07846872508525848, -0.09352493286132812, 0.022968290373682976, 0.01182691939175129, 0.012175423093140125, -0.004965497180819511, 7.896034367149696e-05, -0.021726293489336967, 0.036760929971933365, 0.08447402715682983, -0.046395111829042435, 0.05701972171664238, -0.050493594259023666, 6.76907438901253e-05, -0.002953510032966733, 0.0860934630036354, -0.02953658252954483, -0.03056415542960167, -0.12899217009544373, -2.064106550261511e-33, 0.015488152392208576, -0.03342021629214287, 0.015619009733200073, -0.010455731302499771, 0.05864442139863968, -0.02653684839606285, 0.07258284837007523, -0.08778553456068039, 0.018826346844434738, -0.016216641291975975, -0.007404595613479614, -0.03554968908429146, 0.008319997228682041, -0.02855130471289158, 0.03193259984254837, 0.018047798424959183, -0.06740124523639679, -0.007899004966020584, 0.03631879389286041, -0.02133457362651825, 0.04704872891306877, -0.05590340495109558, -0.045616090297698975, 0.021392134949564934, -0.07849449664354324, -0.023068571463227272, 0.11903978884220123, -0.0018944559851661325, -0.04567766189575195, 0.008722291328012943, 0.006837415508925915, 0.07824835181236267, -0.08694804459810257, -0.005149406846612692, 0.0592142678797245, 0.020647693425416946, 0.019302235916256905, 0.05669999122619629, 0.004759966395795345, -0.06363297998905182, -0.03863728791475296, -0.07707936316728592, 0.06844320148229599, -0.005478093400597572, -0.020625025033950806, 0.0005605336045846343, 0.02365974709391594, -0.0857347846031189, 0.0040472401306033134, -0.02703179605305195, 0.07371301203966141, -0.08515466749668121, -0.05958851799368858, -0.00036977347917854786, 0.045746318995952606, 0.037566229701042175, 0.037339646369218826, 0.01565920189023018, -0.029106922447681427, -0.026880435645580292, 0.02145109511911869, 0.020097855478525162, 0.004611643496900797, 0.05472870543599129, -0.016886215656995773, 0.06590874493122101, 0.013731150887906551, -0.018520070239901543, 0.003863745369017124, 0.09537586569786072, 0.006862230598926544, 0.04087948799133301, 0.048243604600429535, -0.07596695423126221, 0.08784883469343185, -0.04977760463953018, -0.01720358058810234, -0.04158437252044678, -0.007139154709875584, 0.005755842197686434, -0.005658647511154413, -0.03917710483074188, -0.047673579305410385, 0.022293440997600555, -0.02965836226940155, -0.1400938630104065, -0.06738895922899246, -0.06697329133749008, -0.016933375969529152, -0.0017664943588897586, -0.0932610034942627, -0.024097386747598648, 0.11550511419773102, 0.05578150972723961, -0.12074088305234909, 1.1273514286713838e-33, -0.11707723885774612, 0.07049695402383804, 0.03651612997055054, 0.06814820319414139, -0.021599706262350082, -0.01940377987921238, -0.02033681608736515, -0.011085398495197296, -0.00800390262156725, 0.05900853872299194, 0.05606481805443764, 0.07885222882032394, 0.08607453852891922, 0.05710339546203613, -0.04390961676836014, 0.09391780197620392, 0.022916318848729134, -0.01837819069623947, 0.06715855002403259, 0.012958995997905731, 0.0018168555106967688, 0.009906788356602192, 0.028201734647154808, -0.014642609283328056, 0.02585628256201744, 0.058014560490846634, 0.05878483131527901, 0.03323346748948097, 0.026972956955432892, -0.03851533681154251, 0.011257020756602287, -0.10183282196521759, -0.06838149577379227, 0.02577545866370201, -0.09795572608709335, 0.03309926018118858, 0.02638947032392025, 0.038076382130384445, 0.0023347269743680954, 0.025551890954375267, -0.034650497138500214, -0.01582970656454563, -0.08356215059757233, -0.009231070056557655, 0.004009858705103397, -0.036289189010858536, 0.003509229514747858, 0.011391056701540947, -0.061331845819950104, 0.01540123950690031, -0.0011264500208199024, 0.10097002238035202, -0.013182193972170353, 0.011979017406702042, -0.13199655711650848, 0.02036047913134098, -0.017511453479528427, 0.05499761179089546, 0.11070820689201355, 0.014930548146367073, -0.09360553324222565, -0.019297722727060318, 0.007204619701951742, 0.09441079944372177, -0.00927896611392498, -0.04180166870355606, -0.04578719288110733, 0.05872377008199692, 0.03292301297187805, -0.020148921757936478, -0.034446872770786285, 0.024236811324954033, 0.021329764276742935, -0.01295411866158247, 0.019372068345546722, -0.007271720562130213, -0.019697433337569237, -0.053335949778556824, -0.011210829950869083, -0.0036429560277611017, 0.018726753070950508, -0.01846127398312092, -0.026368536055088043, 0.06836844235658646, 0.03631875663995743, 0.04551452025771141, 0.09708166867494583, -0.0013076072791591287, 0.038096629083156586, -0.07843992859125137, 0.02037520334124565, 0.04456569254398346, 0.026434291154146194, -0.032406117767095566, -0.03527767211198807, -1.0356031587832604e-08, -0.017991339787840843, -0.038019757717847824, 0.046414148062467575, -0.04335968568921089, 0.13680949807167053, 0.01109931617975235, 0.004367447458207607, 0.018392788246273994, -0.07819430530071259, -0.05922280624508858, 0.02490466833114624, -0.024358082562685013, -0.06704910099506378, 0.02667614072561264, 0.03479555994272232, 0.027538081631064415, -0.02667420543730259, -0.010268918238580227, -0.004408948123455048, 0.01541890762746334, 0.09345494210720062, 0.03375879302620888, 0.0555303655564785, 0.02469305880367756, 0.009483843110501766, -0.057700056582689285, -0.03969407081604004, 0.0016294082161039114, 0.02770363539457321, 0.08777989447116852, -0.07391007244586945, 0.07368578761816025, 0.07130586355924606, 0.05937817692756653, -0.029533831402659416, -0.008655997924506664, -0.010082626715302467, -0.0797964483499527, -0.025537142530083656, 0.0783148780465126, -0.06385865062475204, 0.059156548231840134, -0.0749022364616394, 0.0023516560904681683, 0.0034361558500677347, 0.003786548040807247, 0.05568376183509827, -0.09200930595397949, 0.09327029436826706, 0.08218848705291748, 0.07302675396203995, 0.02313903532922268, 0.0677151307463646, -0.0498654730618, 0.0007056242320686579, 0.07477487623691559, 0.008759301155805588, -0.06420709192752838, -0.035795655101537704, 0.053932011127471924, 0.031011711806058884, 0.025613466277718544, -0.036662112921476364, -0.008528689853847027],
    2
)
RETURN nn.title ORDER BY _distance;

Raises:

Error: Binder exception: Cannot find property published_year for n.

3. Create projected graph gives a not meaningful error message:

kuzu> CALL CREATE_PROJECTED_GRAPH(
          'filtered_test',   // Name of the projected graph
          [{'Book': {'filter': 'n.published_year > 2010'}},   // Projected node table Book with a filter on published_year. `n` is a place_holder here to reference the node table.
          {'test': {'filter': 'n.id > 2010'}}],
          []   // No relationship tables can be projected.
      );
Error: Catalog exception:  does not exist in catalog.

[ray6080]

For incorrect result 1. "The projected graph should filter out all books, so i expect an empty result." I think you put wrong filter in the projected graph.
The filter size(n.title_embedding) > 384 is not filtering anything out. Change it to size(n.title_embedding) > 3840 will give you empty result.

kuzu> match (b:Book) return size(b.title_embedding);
┌───────────────────────────────────────┐
│ SIZE(CAST(b.title_embedding, STRING)) │
│ INT64                                 │
├───────────────────────────────────────┤
│ 3648                                  │
│ 3643                                  │
│ 3641                                  │
│ 3652                                  │
│ 3645                                  │
└───────────────────────────────────────┘

[ray6080]

For "Disable dropping properties which a projected graph depends on". This is currently the expected behaviour, we choose to not error while users drop the table/property. Instead error at runtime when the projected graph is evaluated.
This is what we put in the docs in the projected graph part.

We use lazy evaluation to evaluate the predicate. The predicate is only evaluated when the projected graph is queried. As a result, the project graph operation always runs instantly.

Perhaps we can make this more clear in the docs. @andyfengHKU what do you think?