-
Notifications
You must be signed in to change notification settings - Fork 141
Home
Andreas Seltenreich edited this page Jul 10, 2026
·
115 revisions
* PostgreSQL
** Tips for bug hunting
- The =regression= database left behind by postgres' =make installcheck= is a good candidate to run against
- Use [[http://www.nongnu.org/failmalloc/][libfailmalloc]] to hunt out-of-memory bugs
- Starting the postmaster with =-T= makes it stop processes on a crash instead of doing a crash recovery
- Use [[https://github.com/credativ/sqlreduce][sqlreduce]] for automatic minimization of testcases
** Score list
When you find bugs using sqlsmith, don't hesitate to update the score list!
| finding/discussion | status | when |
|-----------------------------------------------------------------------------------------------------------------------+------------------------+------------|
| [[http://www.postgresql.org/message-id/87vbcyx36q.fsf@credativ.de][ERROR: cache lookup failed for index 2619]] | [[http://git.postgresql.org/pg/commitdiff/976b24fb477464907737d28cdf18e202fa3b1a5b][commit]] | 2015-07-02 |
| [[http://www.postgresql.org/message-id/87wpxfygg9.fsf@credativ.de][FailedAssertion("!(outer_rel->rows > 0)", File: "indxpath.c", Line: 1911)]] | [[http://git.postgresql.org/pg/commitdiff/358eaa01bf95935f9af968faf5b08d9914f6a445][commit]] | 2015-07-26 |
| [[http://www.postgresql.org/message-id/871tfv3wor.fsf@ex.ansel.ydns.eu][FailedAssertion("!(!bms_is_empty(phinfo->ph_eval_at))", File: "placeholder.c", Line: 109)]] | [[http://git.postgresql.org/pg/commitdiff/fca8e59c1c582030dd7a3c870e1c3c70e8a193aa][commit]] | 2015-07-26 |
| [[http://www.postgresql.org/message-id/871tfv3wor.fsf@ex.ansel.ydns.eu][FailedAssertion("!(key->sk_flags & 0x0080)", File: "brin_minmax.c", Line: 177)]] | [[http://git.postgresql.org/pg/commitdiff/c81276241b61d8759e024ed803e8f3f251d8e7c9][commit]] | 2015-07-26 |
| [[http://www.postgresql.org/message-id/87k2tm2l3i.fsf@ex.ansel.ydns.eu][FailedAssertion("!(join_clause_is_movable_into(rinfo, joinrel->relids, join_and_req))", File: "relnode.c", Line: 987)]] | [[http://git.postgresql.org/pg/commitdiff/95f4e59c3286671656aff7db45b322f14a7bb8cc][commit]] | 2015-07-27 |
| [[http://www.postgresql.org/message-id/BLU436-SMTP6793A5675100602B2012D6F28B0@phx.gbl][Division by zero in selfuncs.c:estimate_hash_bucketsize()]] | [[http://git.postgresql.org/pg/commitdiff/8693ebe37d65ec1bc1ebeab36f60b38f18fb25d6][commit]] | 2015-07-30 |
| [[http://www.postgresql.org/message-id/87wpxfygg9.fsf@credativ.de][FailedAssertion("!(!bms_overlap(joinrelids, sjinfo->min_lefthand))", File: "joinrels.c", Line: 500)]] | [[http://git.postgresql.org/pg/commitdiff/df3b0f47b9766ff14f50c3e381d8c00a9c2b7a4f][commit]] | 2015-08-01 |
| [[http://www.postgresql.org/message-id/87k2tevysn.fsf_-_@credativ.de][ERROR: plan should not reference subplan's variable]] | [[http://git.postgresql.org/pg/commitdiff/85e5e222b1dd02f135a8c3bf387d0d6d88e669bd][commit]] | 2015-08-01 |
| [[http://www.postgresql.org/message-id/87k2tevysn.fsf_-_@credativ.de][ERROR: failed to assign all NestLoopParams to plan nodes]] | [[http://git.postgresql.org/pg/commitdiff/85e5e222b1dd02f135a8c3bf387d0d6d88e669bd][commit]] | 2015-08-01 |
| [[http://www.postgresql.org/message-id/BLU436-SMTP121548815908D3CF56F631BF2880@phx.gbl][ERROR: could not find pathkey item to sort]] | [[http://git.postgresql.org/pg/commitdiff/cde35cf4ae968d3366ea5358d2a754641e4c06c8][commit]] | 2015-08-01 |
| [[http://www.postgresql.org/message-id/2086.1438444757@sss.pgh.pa.us][ERROR: could not determine which collation to use for string comparison]] | | 2015-08-01 |
| [[http://www.postgresql.org/message-id/BLU436-SMTP3324F13C3791725A65B862F2770@phx.gbl][ERROR: could not find RelOptInfo for given relids]] | [[http://git.postgresql.org/pg/commitdiff/6af9ee4c8c8f31cbf2e76166d1d9868876f60aea][commit]] | 2015-08-03 |
| [[http://www.postgresql.org/message-id/877fp8uwg5.fsf@credativ.de][FailedAssertion("!(!bms_is_empty(phinfo->ph_eval_at))", File: "analyzejoins.c", Line: 474)]] | [[http://git.postgresql.org/pg/commitdiff/de0227d8aef18c1013b26ab193e48a5122435154][commit]] | 2015-08-06 |
| [[http://www.postgresql.org/message-id/87oaijtu9b.fsf@credativ.de][ERROR: too late to create a new PlaceHolderInfo]] | [[http://git.postgresql.org/pg/commitdiff/89db83922a7f8ba223e233e262004b1745ece75d][commit]] | 2015-08-07 |
| [[http://www.postgresql.org/message-id/87bneit51e.fsf@ex.ansel.ydns.eu][ERROR: failed to build any %d-way joins]] | [[http://git.postgresql.org/pg/commitdiff/cfe30a72fa80528997357cb0780412736767e8c4][commit]] | 2015-08-08 |
| Crash in regexp compiler in memory-starved server | [[http://git.postgresql.org/pg/commitdiff/8a0258c31808c514755e3bba03cb052084c4887c][commit]] | 2015-08-10 |
| [[http://www.postgresql.org/message-id/87d1xdey0o.fsf@ex.ansel.ydns.eu][FailedAssertion("!(pointer != ((void *)0))", File: "mcxt.c", Line: 1002)]] | [[http://git.postgresql.org/pg/commitdiff/ba51774d87a2a0402628f7bd68295c0b2913cc25][commit]] | 2015-09-20 |
| [[http://www.postgresql.org/message-id/87fuzftqg5.fsf@ex.ansel.ydns.eu][Failed to generate plan on lateral subqueries]] | [[http://git.postgresql.org/pg/commitdiff/acfcd45cacb6df23edba4cb3753a2be594238a99][commit]] | 2015-12-06 |
| [[http://www.postgresql.org/message-id/87bn9nh2ny.fsf@credativ.de][Failing assertions in spgtextproc.c]] | [[http://git.postgresql.org/pg/commitdiff/7157fe80f42476db249e062b4f6eef6a3994b234][commit]] | 2015-12-18 |
| [[http://www.postgresql.org/message-id/87y4c6crt9.fsf@credativ.de][NULL-Pointer dereference in binary_upgrade_create_empty_extension]] | [[http://git.postgresql.org/pg/commitdiff/939d10cd8711fdeb7f0ff62c9c6b08e3eddbba3e][commit]] | 2016-01-03 |
| Out-of-bound array access in ruleutils.c | [[http://git.postgresql.org/pg/commitdiff/0daeba0][commit]] | 2016-01-07 |
| CVE-2016-3065: Missing superuser checks in contrib/pageinspect | [[http://git.postgresql.org/pg/commitdiff/3e1338475ffc2eac25de60a9de9ce689b763aced][commit]] | 2016-02-18 |
| [[http://www.postgresql.org/message-id/BLU436-SMTP18B0D0BA6E7F5EA5D1624BF2840@phx.gbl][Two division by 0 errors in optimizer/plan/planner.c and optimizer/path/costsize.c]] | [[http://git.postgresql.org/pg/commitdiff/76281aa9647e6a5dfc646514554d0f519e3b8a58][commit]] | 2016-03-26 |
| [[http://www.postgresql.org/message-id/BLU437-SMTP95EEBC8DD06F30A375ECDFF2840@phx.gbl][Clamp adjusted ndistinct to positive integer in estimate_hash_bucketsize().]] | [[http://git.postgresql.org/pg/commitdiff/fa09f8935156533584b4e215bdf70ec1ff968dad][commit]] | 2016-03-27 |
| [[http://www.postgresql.org/message-id/BLU437-SMTP67C2A4915E150388A48445F2850@phx.gbl][Guard against zero vardata.rel->tuples in estimate_hash_bucketsize().]] | [[http://git.postgresql.org/pg/commitdiff/d65b665d524a67273b075f468bf3d60ce31f4040][commit]] | 2016-03-27 |
| [[http://www.postgresql.org/message-id/871t5pgwdt.fsf@credativ.de][Crash in apply_projection_to_path]] | [[http://git.postgresql.org/pg/commitdiff/c45bf5751b6338488bd79ce777210285531da373][commit]] | 2016-04-28 |
| [[https://www.postgresql.org/message-id/20160430003645.vl66pksujc52cupq@alap3.anarazel.de][Failed assertions due to acl.c using text for syscache lookup]] ([[https://postgr.es/m/7d0809ee-6f25-c9d6-8e74-5b2967830d49@enterprisedb.com][another report]], [[https://postgr.es/m/17691.1482523168@sss.pgh.pa.us][discussion]]) | [[http://git.postgresql.org/pg/commitdiff/54386f3578][commit]] | 2016-04-29 |
| [[https://www.postgresql.org/message-id/8760use0hl.fsf@credativ.de][Failed assertion in parallel worker (ExecInitSubPlan)]] | [[http://git.postgresql.org/pg/commitdiff/b12fd41][commit]], [[http://git.postgresql.org/pg/commitdiff/54f5c51][commit]], [[http://git.postgresql.org/pg/commitdiff/598aa19][commit]] | 2016-05-05 |
| [[http://www.postgresql.org/message-id/87mvni77jh.fsf@elite.ansel.ydns.eu][PANIC: failed to add BRIN tuple]] | [[http://git.postgresql.org/pg/commitdiff/975ad4e602ff5793f2e57cfc883780dd5ff645a0][commit]] | 2016-05-22 |
| [[https://www.postgresql.org/message-id/87r3cu78qo.fsf@elite.ansel.ydns.eu][Failed assertions on parallel worker shutdown]] | [[http://git.postgresql.org/pg/commitdiff/44339b892a04e94bbb472235882dc6f7023bdc65][commit]] | 2016-05-22 |
| [[https://www.postgresql.org/message-id/87h9d7pwf4.fsf@credativ.de][Failed assertion in postgres_fdw/deparse.c:1116]] | [[http://git.postgresql.org/pg/commitdiff/131c7e70b4596027992a2f72bfd3765f0fff1b7c][commit]], [[http://git.postgresql.org/pg/commitdiff/332fdbef20b5b5f2588447793dbcc3bb9b88eb51][commit]] | 2016-06-05 |
| [[https://www.postgresql.org/message-id/87ziqno56m.fsf@credativ.de][ERRORs due to missing parallel unsafety tagging]] | [[http://git.postgresql.org/pg/commitdiff/c7a25c242ffa29810adc2b5320ec7542fe2928bd][commit]] | 2016-06-14 |
| [[https://www.postgresql.org/message-id/874m8nn0hv.fsf@elite.ansel.ydns.eu][OOM crash in plpgsql_extra_checks_check_hook]] | [[http://git.postgresql.org/pg/commitdiff/1fe1204e87c467221277d1789f1a530a27e15bd2][commit]] | 2016-06-20 |
| [[https://www.postgresql.org/message-id/874m89rw7x.fsf@credativ.de][Failed to generate CTE plan]] | [[http://git.postgresql.org/pg/commitdiff/7b67a0a49c19a566ee735f3b156677dab11bd902][commit]] | 2016-07-01 |
| [[https://www.postgresql.org/message-id/87r3bes70d.fsf@credativ.de][Crash in Hot Standby]] | [[http://git.postgresql.org/pg/commitdiff/4f9f495889d3d410195c9891b58228727b340189][commit]] | 2016-07-01 |
| [[https://www.postgresql.org/message-id/87d1md1xji.fsf@credativ.de][NULL-pointer dereference on close_ps(NaN)]] | [[http://git.postgresql.org/pg/commitdiff/278148907a971ec7fa4ffb24248103d8012155d2][commit]] | 2016-07-16 |
| [[https://www.postgresql.org/message-id/87mvktojme.fsf@credativ.de][FailedAssertion("!(XLogCtl->Insert.exclusiveBackup)", File: "xlog.c", Line: 10200)]] | [[http://git.postgresql.org/pg/commitdiff/974ece58bbb3c0ef185a9d44b1cedae51cd56b04][commit]] | 2016-08-03 |
| [[https://www.postgresql.org/message-id/87invhoj6e.fsf@credativ.de][FailedAssertion("!(k == indices_count)", File: "tsvector_op.c", Line: 511)]] | [[http://git.postgresql.org/pg/commitdiff/c50d192ce33c10fa06411306f8644b4f47ce9a06][commit]], [[http://git.postgresql.org/pg/commitdiff/f10eab73df2b94c860dea4a906c54e3c903f42e2][commit]] | 2016-08-03 |
| [[https://www.postgresql.org/message-id/87vazemeda.fsf@credativ.de][Crash in GetOldestSnapshot()]] | [[http://git.postgresql.org/pg/commitdiff/07a601eedab7c5fa4d62055fa3efacef2f38e446][commit]] | 2016-08-06 |
| [[https://www.postgresql.org/message-id/87y448l3ag.fsf@credativ.de][Crash in pg_get_viewdef_name_ext()]] | [[http://git.postgresql.org/pg/commitdiff/8a8c6b53810026641a1e12f60f873a7bd3cea5e3][commit]] | 2016-08-06 |
| [[https://www.postgresql.org/message-id/87oa45qfwq.fsf@credativ.de][Failed assertion in numeric aggregate]] | [[http://git.postgresql.org/pg/commitdiff/600dc4c0da3b8c094ccc1ae75b47c8320898c714][commit]] | 2016-09-04 |
| [[https://www.postgresql.org/message-id/87d1j2zqtz.fsf@credativ.de][Infinite recursion in bitshift]] | [[http://git.postgresql.org/pg/commitdiff/32fdf42cf546f613aab9ca98935c40a046187fa9][commit]] | 2016-10-15 |
| [[https://www.postgresql.org/message-id/8760oasf2y.fsf@credativ.de][Backend stuck in tsquery_rewrite]] | [[http://git.postgresql.org/pg/commitdiff/24ebc444c61306f50777f674544e8559e765ad81][commit]], [[http://git.postgresql.org/pg/commitdiff/5ec81aceec8cc5a0edcc4609ee8edbc43a47e878][commit]] | 2016-10-30 |
| [[https://www.postgresql.org/message-id/871sy78wno.fsf@credativ.de][Crash on GUC serialization]] | [[http://git.postgresql.org/pg/commitdiff/13671b4b22ae4bd345c62e7c0b41d717b8a2e19b][commit]] | 2016-11-19 |
| [[https://www.postgresql.org/message-id/878tse6yvf.fsf@credativ.de][Parallel worker crash on seqscan]] | [[http://git.postgresql.org/pg/commitdiff/4324ade9a6880113b08070305482ace2e8a2617c][commit]] | 2016-11-20 |
| [[https://www.postgresql.org/message-id/8737im6pmh.fsf@credativ.de][Failed assertion in parallel worker in ExecInitSubPlan]] | [[http://git.postgresql.org/pg/commitdiff/f24cf960d7ae3503e21fcb59dca652575619d9d4][commit]] | 2016-11-20 |
| [[https://www.postgresql.org/message-id/874m2w4k5d.fsf@ex.ansel.ydns.eu][Failed assertion in parallel worker in ExecInitSubPlan]] | [[http://git.postgresql.org/pg/commitdiff/ab77a5a4561fad847af4a101a29c922c66449870][commit]] | 2016-11-24 |
| [[https://www.postgresql.org/message-id/877f7i2hmf.fsf@credativ.de][Failed assertion in _hash_splitbucket_guts]] | [[http://git.postgresql.org/pg/commitdiff/2f4193c3509a822c55cc0eae77e7788806d9b022][commit]] | 2016-12-02 |
| [[https://www.postgresql.org/message-id/87k2be16n5.fsf@credativ.de][Crash in gather_readnext]] | [[http://git.postgresql.org/pg/commitdiff/06fa6670fb6bf430739cb1f69d28429a0e24851f][commit]] | 2016-12-05 |
| [[https://www.postgresql.org/message-id/8737i01dew.fsf@credativ.de][Crash in tsquery_rewrite/QTNBinary]] | [[http://git.postgresql.org/pg/commitdiff/89fcea1ace40bc025beea2758a80bcd56a319a6f][commit]] | 2016-12-07 |
| [[https://www.postgresql.org/message-id/877f6lw0gs.fsf@ansel.ydns.eu][Crash reading pg_stat_activity]] | [[http://git.postgresql.org/pg/commitdiff/175ff6598e014b2fe84c06fa443161294fc2eed0][commit]] | 2016-12-28 |
| [[https://www.postgresql.org/message-id/878tq6vja6.fsf@ansel.ydns.eu][Failed assertion in make_restrictinfo]] | [[http://git.postgresql.org/pg/commitdiff/d479e37e3d][commit]] | 2017-01-19 |
| [[https://www.postgresql.org/message-id/87o9wo8o0j.fsf@credativ.de][Failed assertion in _hash_kill_items/MarkBufferDirtyHint]] | [[http://git.postgresql.org/pg/commitdiff/93cd7684ee][commit]] | 2017-03-26 |
| [[https://www.postgresql.org/message-id/87h92g83t3.fsf@credativ.de][Unpinning error in parallel worker]] | [[http://git.postgresql.org/pg/commitdiff/fddf45b380][commit]] | 2017-03-26 |
| [[https://www.postgresql.org/message-id/87inmf5rdx.fsf@credativ.de][Planner crash on foreign table join]] | [[http://git.postgresql.org/pg/commitdiff/eef8c0069e4d5eea2e52965ce3eb018b5a594fd6][commit]] | 2017-04-08 |
| [[https://www.postgresql.org/message-id/87tw5x4vcu.fsf@credativ.de][ERROR: badly formatted node string "RESTRICTINFO...]] | [[http://git.postgresql.org/pg/commitdiff/88e902b769e180a232013e265ff9fd582dde125b][commit]] | 2017-04-09 |
| [[https://www.postgresql.org/message-id/877ey7bmun.fsf@ansel.ydns.eu][FailedAssertion("!(portal->cleanup == ((void *)0))", File: "portalmem.c", Line: 846)]] | [[http://git.postgresql.org/pg/commitdiff/5b6289c1e07dc45f09c3169a189e60d2fcaec2b3][commit]] | 2017-08-13 |
| [[https://www.postgresql.org/message-id/874ls2vrnx.fsf@ansel.ydns.eu][Failed assertion in initsplan.c]] | [[http://git.postgresql.org/pg/commitdiff/57eebca03a9eb61eb18f8ea9db94775653f797d1][commit]] | 2017-09-16 |
| [[https://www.postgresql.org/message-id/87h8vhtgj2.fsf@ansel.ydns.eu][stuck spinlock in pg_stat_get_wal_receiver after OOM]] | [[http://git.postgresql.org/pg/commitdiff/89e434b59caffeeeb7478653c74ad5d7a50d2e96][commit]] | 2017-10-02 |
| [[https://www.postgresql.org/message-id/87r2tvt9f1.fsf@ansel.ydns.eu][Failed assertion in adjust_appendrel_attrs_mutator]] | [[http://git.postgresql.org/pg/commitdiff/896eb5efbdcea5df12e7a464ae9c23dd1e25abd2][commit]] | 2017-10-22 |
| [[https://www.postgresql.org/message-id/878tfcsp1t.fsf@ansel.ydns.eu][pg_control_checkpoint() returning invalid tuples]] | [[http://git.postgresql.org/pg/commitdiff/2ede45c3a49e484edfa143850d55eb32dba296de][commit]] | 2017-11-11 |
| [[https://www.postgresql.org/message-id/871sl4sdrv.fsf@ansel.ydns.eu][insufficient argument checking in satisfies_hash_partition()]] | [[http://git.postgresql.org/pg/commitdiff/f3b0897a1213f46b4d3a99a7f8ef3a4b32e03572][commit]] | 2017-11-11 |
| [[https://www.postgresql.org/message-id/87mv2ju6zx.fsf@ansel.ydns.eu][Parallel worker executor crash on master]] | [[http://git.postgresql.org/pg/commitdiff/fd7c0fa732d97a4b4ebb58730e6244ea30d0a618][commit]] | 2017-12-15 |
| [[https://www.postgresql.org/message-id/87woxi24uw.fsf@ansel.ydns.eu][Segfault in expand_tuple]] | [[http://git.postgresql.org/pg/commitdiff/7c44c46deb495a2f3861f402d7f2109263e3d50a][commit]] | 2018-04-07 |
| [[https://www.postgresql.org/message-id/87po3a3n46.fsf@ansel.ydns.eu][Failed assertion in create_gather_path]] | [[http://git.postgresql.org/pg/commitdiff/dc1057fcd878d5c062c5c4c2b548af2be513b6ab][commit]] | 2018-04-07 |
| [[https://www.postgresql.org/message-id/87in923lyw.fsf@ansel.ydns.eu][Failed assertion on pfree() via perform_pruning_combine_step]] | [[http://git.postgresql.org/pg/commitdiff/7ba6ee815dc90d4fab7226d343bf72aa28c9aa5c][commit]] | 2018-04-07 |
| [[https://www.postgresql.org/message-id/CAJGNTeOkdk%3DUVuMugmKL7M%3Dowgt4nNr1wjxMg1F%2BmHsXyLCzFA@mail.gmail.com][FailedAssertion on partprune]] | [[http://git.postgresql.org/pg/commitdiff/59ef49d26d2f8724d0788fea0774f786a22ca63d][commit]] | 2018-07-24 |
| [[https://www.postgresql.org/message-id/87in4h98i0.fsf@ansel.ydns.eu][ERROR: partition missing from subplans]] | [[http://git.postgresql.org/pg/commitdiff/1eb9221585c25cad1a563bc3414f697dae3fbc8b][commit]] | 2018-08-11 |
| [[https://www.postgresql.org/message-id/87va8g7vq0.fsf@ansel.ydns.eu][ERROR: plan should not reference subplan's variable]] | [[http://git.postgresql.org/pg/commitdiff/0ff8f521d40f271c57f29f0ca773981e4465b35b][commit]] | 2018-08-11 |
| [[https://www.postgresql.org/message-id/CAJGNTeP=-6Gyqq5TN9OvYEydi7Fv1oGyYj650LGTnW44oAzYCg@mail.gmail.com][Assert failed in snprintf.c]] | [[http://git.postgresql.org/pg/commitdiff/3d0f68dd30612db8d8cf6529455a369ad121c521][commit]] | 2018-10-01 |
| [[https://www.postgresql.org/message-id/8736jdhbhc.fsf@ansel.ydns.eu][Planner crash in mcv_get_match_bitmap]] | [[http://git.postgresql.org/pg/commitdiff/e8b6ae2130e3a95bb776708a9a7c9cb21fe8ac87][commit]] | 2019-07-10 |
| [[https://www.postgresql.org/message-id/87y30r8sls.fsf@ansel.ydns.eu][FailedAssertion("!(rel->reloptkind == RELOPT_BASEREL)", File: "equivclass.c", Line: 764)]] | [[http://git.postgresql.org/pg/commitdiff/e1a0f6a983068675813074847e1d0d61bd37ac0e][commit]] | 2019-07-21 |
| CVE-2019-10209: Type confusion in hashed subplans | [[http://git.postgresql.org/pg/commitdiff/a034418cfc85fffa300d4d44792561c09e76f68b][commit]] | 2019-07-21 |
| [[https://www.postgresql.org/message-id/CAJGNTeMbhtsCUZgJJ8h8XxAJbK7U2ipsX8wkHRtZRz-NieT8RA@mail.gmail.com][Failed Assertion about PolymorphicType]] | [[http://git.postgresql.org/pg/commitdiff/07871d40c72e498b6e034eb674df5d8d206976bc][commit]] | 2020-04-04 |
| [[https://www.postgresql.org/message-id/CAJGNTeO93u-5APMga6WH41eTZ3Uee9f3s8dCpA-GSSqNs1b=Ug@mail.gmail.com][segmentation fault using currtid and partitioned tables]] | [[http://git.postgresql.org/pg/commitdiff/e786be5fcb257a09b05bd8e509c8d1b82e626352][commit]] | 2020-04-05 |
| [[https://www.postgresql.org/message-id/CAJGNTeNaxpXgBVcRhJX+2vSbq+F2kJqGBcvompmpvXb7pq+oFA@mail.gmail.com][enable_incremental_sort changes query behavior]] | | 2020-09-26 |
| [[https://www.postgresql.org/message-id/87sg8tqhsl.fsf@aurora.ydns.eu][Failed assertion during partition pruning]] | [[http://git.postgresql.org/pg/commitdiff/fb2d645dd53ff571572d830e830fc8c368063802][commit]] | 2020-11-28 |
| [[https://www.postgresql.org/message-id/87blfgqa4t.fsf@aurora.ydns.eu][Planner error on lateral joins]] | [[http://git.postgresql.org/pg/commitdiff/b1738ff6ab73203cbbc02d7fb82941dbc061d301][commit]] | 2020-11-29 |
| [[https://www.postgresql.org/message-id/87v9doorz7.fsf@aurora.ydns.eu][parallel worker errors "subplan ... was not initialized"]] | [[http://git.postgresql.org/pg/commitdiff/86b7cca72d4d0a4e043fac0a2cdd56218ff2f258][commit]] | 2020-11-29 |
| [[https://postgr.es/m/20210612023324.GT16435@telsasoft.com][pg_filenode_relation(0,0) elog]] | [[http://git.postgresql.org/pg/commitdiff/1250aad42520fd5a3db68d6381997b7e1f9bb4aa][commit]] | 2021-06-12 |
| [[https://www.postgresql.org/message-id/20210915230959.GB17635%40ahch-to][right join with partitioned table crash]] | [[http://git.postgresql.org/pg/commitdiff/a21049fd3f64518c8a7227cf07c56f2543241db2][commit]] | 2021-09-15 |
| [[https://www.postgresql.org/message-id/CAEP4nAz7Enq3+DEthGG7j27DpuwSRZnW0Nh6jtNh75yErQ_nbA@mail.gmail.com][Fix contrib/seg to be more wary of long input numbers.]] | [[https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=701c881f782b93ee29587112390bd3bfe035e78d][commit]] | 2022-12-21 |
| [[https://www.postgresql.org/message-id/flat/2518675.1675625252%40sss.pgh.pa.us#ddeda4830aa0540dbf901559a20d81ac][Multiple (6) Planner Asserts fixed]] | [[https://git.postgresql.org/gitweb/postgres.git?p=postgresql.git;a=commit;h=5840c2027264d5dfad743c50874e0ebf8b840f3f][commit]], [[https://git.postgresql.org/gitweb/postgres.git?p=postgresql.git;a=commit;h=8538519db107777a6b06b7277185e6605caf8d4c][commit]], [[https://git.postgresql.org/gitweb/postgres.git?p=postgresql.git;a=commit;h=9f452feeeb830534dc2ce743a2a14b109128326d][commit]], [[https://git.postgresql.org/gitweb/postgres.git?p=postgresql.git;a=commit;h=b2d0e13a0a4c31167d01e9871f907060c80b8fae][commit]], [[https://git.postgresql.org/gitweb/postgres.git?p=postgresql.git;a=commit;h=cad56920513e5b7ccdd3d41b0ea893eb3383f863][commit]], [[https://git.postgresql.org/gitweb/postgres.git?p=postgresql.git;a=commit;h=eae0e20deffb0a73f7cb0e94746f94a1347e71b1][commit]] | 2023-02-04 |
* Libraries and extensions
** Score list
| Extension/Library | finding/discussion | status | when |
|-------------------+-----------------------------------------------------+--------+------------|
| [[https://github.com/powa-team/pg_qualstats][pg_qualstats]] | [[https://github.com/powa-team/pg_qualstats/issues/5][Segfault when qual on view using expressions]] | [[https://github.com/powa-team/pg_qualstats/commit/e0ddf700f4e3f7e3da0320c62a7d89c2378798fb][commit]] | 2016-05-31 |
| [[https://github.com/ChristophBerg/postgresql-unit][unit]] | Crash when unit_reset() runs into an OOM error | [[https://github.com/ChristophBerg/postgresql-unit/commit/25d23803180c8d60dbf586329b6c57fb58d1e639][commit]] | 2017-06-13 |
| [[https://github.com/ChristophBerg/pg_dirtyread][pg_dirtyread]] | [[https://github.com/ChristophBerg/pg_dirtyread/issues/2][Failed assertion on hot standby]] | [[https://github.com/ChristophBerg/pg_dirtyread/commit/fdaa40dcd04d5325cfc5b7015d124603aa5caf2f][commit]] | 2017-08-05 |
| [[https://github.com/orafce/orafce][orafce]] | [[https://github.com/orafce/orafce/issues/59][Crashes due to insufficent argument checking]] | [[https://github.com/orafce/orafce/commit/6b89c07a00a92bd9c2f674b15797b3baba4482f7][commit]] | 2017-08-27 |
| [[https://github.com/powa-team/powa-archivist][powa]] | [[https://github.com/powa-team/powa-archivist/issues/10][Crash on pg_reload_conf()]] | [[https://github.com/powa-team/powa-archivist/commit/3e71401602dfa945ec4b513df507b84389fc2393][commit]] | 2017-09-10 |
| [[https://www.gnu.org/software/libc/][glibc]] | [[https://sourceware.org/bugzilla/show_bug.cgi?id=22238][NULL pointer dereference in dlopen on out-of-memory]] | [[https://sourceware.org/git/?p=glibc.git;a=commitdiff;h=3e3c904daef69b8bf7d5cc07f793c9f07c3553ef][commit]] | 2017-10-03 |
* SQLite3
** Score list
| finding/discussion | status | when |
|--------------------------------------------------------------------------------------------+--------+------------|
| whereLoopFindLesser: Assertion `p->rSetup>=pTemplate->rSetup' failed | [[https://www.sqlite.org/src/info/f81050859170c870][commit]] | 2016-06-23 |
| applyNumericAffinity: Assertion `(pRec->flags & (0x0002¦0x0004¦0x0008))==0x0002' failed | [[https://www.sqlite.org/src/info/507014e4c7a70cd0][commit]] | 2016-06-23 |
| sqlite3ExprCacheStore: Assertion `pParse->db->mallocFailed ¦¦ cacheIsValid(pParse)' failed | | 2016-06-24 |
* MonetDB (via [[https://github.com/tangloner/ssmonetdb][ssmonetdb]])
** Score list
| bugzilla | date |
|------------------------------------------------------------------------------------+------------|
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6075][6075: gdk_calc.c:13113: BATcalcifthenelse_intern: Assertion `col2 != NULL' failed.]] | 2016-12-21 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6076][6076: rel_optimizer.c:5426: rel_push_project_up: Assertion `e' failed.]] | 2016-12-21 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6077][6077: mserver5: rel_optimizer.c:5444: rel_push_project_up: Assertion `e' failed.]] | 2016-12-21 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6078][6078: rel_bin.c:2402: rel2bin_project: Assertion `0' failed.]] | 2016-12-21 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6080][6080: mserver5: rel_bin.c:2391: rel2bin_project: Assertion `0' failed.]] | 2017-03-03 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6081][6081: Segmentation fault (core dumped)]] | 2017-03-03 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6177][6177: Server crashes]] | 2017-03-03 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6213][6213: SQLsmith causes server to crash]] | 2017-03-03 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6215][6215: Bulk operators missing]] | 2017-02-16 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6216][6216: Assertion raised (sqlsmith)]] | 2017-03-15 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6217][6217: Segfault in rel_optimizer (sqlsmith)]] | 2017-03-03 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6219][6219: Crash in rel_optimizer (sqlsmith)]] | 2017-03-02 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6220][6220: Segfault in sql_ref_inc (sqlsmith)]] | 2017-03-15 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6242][6242: Crash on rel_reduce_groupby_exps (sqlsmith)]] | 2017-03-15 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6247][6247: Type analysis issue (sqlsmith)]] | 2017-03-22 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6249][6249: DEFAULT in row-values missing (sqlsmith)]] | 2017-03-22 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6300][6300: Protect against missing BATs (sqlsmith)]] | 2017-05-11 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6310][6310: Name resolution error (sqlsmith)]] | 2017-05-13 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6312][6312: Object not found in LIMIT clause (sqlsmith)]] | 2017-05-13 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6313][6313: Null type resolution in disjunction fails (sqlsmith)]] | 2017-05-13 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6314][6314: Lateral crash report (sqlsmith)]] | 2017-05-14 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6315][6315: Exist operator on type bigint missing (sqlsmith)]] | 2017-05-14 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6316][6316: Coalesc and limit error (sqlsmith)]] | 2017-05-14 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6319][6319: Server crash on LATERAL (sqlsmith)]] | 2017-05-31 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6322][6322: Crash on disjunction with LIMIT (sqlsmith)]] | 2017-06-07 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6344][6344: Spurious errors and assertions (SQLsmith)]] | 2017-07-12 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6352][6352: Scope resolution problem (sqlsmith)]] | 2017-07-28 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6417][6417: Segfault encountered (sqlsmith)]] | 2017-10-14 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6418][6418: Segfault in renaming (sqlsmith)]] | 2017-10-14 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6419][6419: segfault in rel_optimizer (sqlsmith)]] | 2017-10-14 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6420][6420: Assertion error in mergetable task (sqlsmith)]] | 2017-10-14 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6421][6421: Assertion error in sql_ref_dec (sqlsmith)]] | 2017-10-15 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6422][6422: Another assertion error in rel_or (sqlsmith)]] | 2017-10-15 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6423][6423: Dereference null pointer (sqlsmith)]] | 2017-10-15 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6424][6424: Assertion error in rel_rename_expr (sqlsmith)]] | 2017-10-16 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6425][6425: Assertion error in exp_bin (sqlsmith)]] | 2017-10-16 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6426][6426: Assertion error in rel_find_exp_ (sqlsmith)]] | 2017-10-16 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6427][6427: Assertion error in eq_typeswitchloop (sqlsmith)]] | 2017-10-17 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6430][6430: Assertion raised in another eq_typeswitch error (sqlsmith)]] | 2017-10-17 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6432][6432: Assertion error in exp_bin (sqlsmith)]] | 2017-10-18 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6449][6449: Assertion error in rel_dce_refs (sqlsmith)]] | 2017-10-29 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6450][6450: Assertion error in exp_bin (sqlsmith)]] | 2017-10-30 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6451][6451: Assertion error in sql_ref_dec (sqlsmith)]] | 2017-11-01 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6453][6453: Assertion error in rel_rename_exps (sqlsmith)]] | 2017-11-01 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6455][6455: Assertion error in rel_apply_rewrite (sqlsmith)]] | 2017-11-01 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6459][6459: Assertion error in exp_bin (sqlsmith)]] | 2017-11-08 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6472][6472: Assertion failure in rel_rename (Sqlsmith)]] | 2017-12-14 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6474][6474: Assertion error in exp_bin (sqlsmith)]] | 2017-11-22 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6477][6477: assertion eror rel_push_project_up (sqlsmith)]] | 2017-12-14 |
| [[http://www.monetdb.org/bugzilla/show_bug.cgi?id=6480][6480: Segfault in mvc_find_subexp (sqlsmith)]] | 2017-12-10 |
* TimescaleDB
[[https://github.com/timescale/timescaledb/search?q=SQLSmith&type=commits][https://github.com/timescale/timescaledb/search?q=SQLSmith&type=commits]]
** Score list
| finding | status | when |
|--------------------------------------------------------------------------------------------+--------+------------|
| Fix time_bucket comparison transformation | [[https://github.com/timescale/timescaledb/commit/1b4780df3127565991a7a6e7436f3743663c0a6d][commit]] | 2021-11-08 |
| Fix assertion failure in cursor_fetcher_rewind | [[https://github.com/timescale/timescaledb/commit/7591f7f1f3a03b25d69f96159244e7f8ce84574b][commit]] | 2021-12-13 |
* YugabyteDB (via [[https://github.com/def-/sqlsmith][def-/sqlsmith]])
[[https://github.com/yugabyte/yugabyte-db/issues?q=is%3Aissue+in%3Atitle+sqlsmith][https://github.com/yugabyte/yugabyte-db/issues?q=is%3Aissue+in%3Atitle+sqlsmith]]
** Score list
| github issue | date |
|------------------------------------------------------------------------------------+------------|
| [[https://github.com/yugabyte/yugabyte-db/issues/11066][DocDB SQLsmith ERROR: errstart was not called / Already marked as completed]] | 2022-01-26 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11220][YSQL SQLsmith Stuck query in ReplicationSlotAllocationLock, can't be cancelled]] | 2022-01-26 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11221][YSQL SQLsmith ERROR: Illegal state: Transaction for catalog table write operation 'sql_features' not found]] | 2022-01-26 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11222][YSQL SQLsmith ERROR: Remote error: Illegal state (yb/client/transaction.cc:678): Attempt to release transaction in the wrong state: kAborted]] | 2022-01-26 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11223][YSQL SQLsmith ERROR: unexpected duplicate for tablespace 0, relfilenode 0]] | 2022-01-26 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11224][YSQL SQLsmith ERROR: cache lookup failed for type 12227]] | 2022-01-26 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11225][YSQL SQLsmith ERROR: could not open relation with OID 1]] | 2022-01-26 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11226][YSQL SQLsmith ERROR: Operation failed. Try again: Operation failed. Try again (yb/tablet/transaction_participant.cc:296): Unknown transaction, could be recently aborted (pgsql error 40001)]] | 2022-01-26 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11229][YSQL SQLsmith Internal error (yb/common/ql_expr.cc:702): Unable to initialize catalog manager: Failed to initialize sys tables async: Failed log replay. Reason: Column unexpectedly not found in cache]] | 2022-01-26 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11233][YSQL SQLsmith TRAP: FailedAssertion("!(bms_is_subset(appendrel->lateral_relids, required_outer))", File: "../../../../../../../src/postgres/src/backend/optimizer/util/relnode.c", Line: 1543)]] | 2022-01-26 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11235][YSQL SQLsmith TRAP: FailedAssertion("!(!((allPgXactproc->pgprocno.xid) != ((TransactionId) 0)))", File: "../../../../../../../src/postgres/src/backend/storage/ipc/procarray.c", Line: 440)]] | 2022-01-26 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11237][DocDB SQLsmith ERROR: transaction ID is in the future]] | 2022-01-26 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11250][YSQL SQLsmith TRAP: BadArgument("!(((context) != ((void*)0) && (((((const Node*)((context)))->type) == T_AllocSetContext) ((((const Node*)((context)))->type) == T_SlabContext) ((((const Node*)((context)))->type) == T_GenerationContext))))", File:]] | 2022-01-26 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11251][YSQL SQLsmith TRAP: FailedAssertion("!(buflen - 1 == '\0')", File: "../../../../../src/postgres/src/common/psprintf.c", Line: 123)]] | 2022-01-26 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11253][YSQL SQLsmith TRAP: FailedAssertion("!(IsSearchNull(ybScan->keyi.sk_flags))", File: "../../../../../../../src/postgres/src/backend/access/yb_access/yb_scan.c", Line: 838)]] | 2022-01-26 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11259][YSQL SQLsmith AddressSanitizer: heap-use-after-free in yb::pggate::PgMemctx::Clear()]] | 2022-01-27 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11260][YSQL SQLsmith AddressSanitizer: SEGV on unknown address 0x000000000408 in yb::PgsqlResponsePB::SharedCtor()]] | 2022-01-27 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11300][YSQL SQLsmith TRAP: FailedAssertion("!(tuple != ((void*)0))", File: "../../../../../../src/postgres/src/backend/executor/execTuples.c", Line: 355)]] | 2022-02-01 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11301][YSQL SQLsmith ../../src/yb/rpc/outbound_call.cc:183 Check failed: IsFinished()]] | 2022-02-01 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11302][YSQL SQLsmith ../../src/yb/rpc/proxy.cc:112 Timeout to wait resolve to complete]] | 2022-02-01 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11303][YSQL SQLsmith Delete statement involving triggers fails assertion in debug build for invalid tupleid]] | 2022-02-01 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11308][YSQL SQLsmith ../../src/yb/client/meta_cache.cc:2159 Destructing LookupDataGroup(0x00000001236314f8), running_request_number: 7 with non empty lookups: 0x0000000123631520 -> deadline: partition_start:]] | 2022-02-01 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11348][YSQL SQLsmith AddressSanitizer: heap-use-after-free in yb::client::internal::Batcher::FlushAsync()]] | 2022-02-03 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11363][YSQL SQLsmith Segmentation fault in YbDatumToText()]] | 2022-02-04 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11365][YSQL SQLsmith Segmentation fault in YBCPgFlushBufferedOperations()]] | 2022-02-04 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11366][YSQL SQLsmith Segmentation fault in quickdie() after <signal handler>]] | 2022-02-04 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11370][YSQL PostGIS SQLsmith Segmentation fault in getPostgisConstants()]] | 2022-02-05 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11371][YSQL SQLsmith Segmentation fault in yb::pggate::YBCPgResetOperationsBuffering()]] | 2022-02-05 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11404][YSQL SQLsmith Segmentation fault after infinite loop in sigusr1_handler()]] | 2022-02-09 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11405][YSQL SQLsmith Segmentation fault in yb::rpc::Proxy::DoAsyncRequest() during ANALYZE]] | 2022-02-09 |
| [[https://github.com/yugabyte/yugabyte-db/issues/11213][DocDB SQLsmith util/uuid: ERROR: Corruption: Invalid length of binary data with TransactionId '': 0 (expected 16)]] | 2022-02-22 |
* Materialize (via [[https://github.com/def-/sqlsmith/tree/materialize][def-/sqlsmith/tree/materialize]])
[[https://github.com/MaterializeInc/materialize/issues?q=is%3Aissue+in%3Atitle+sqlsmith+label%3AC-bug+][https://github.com/MaterializeInc/materialize/issues?q=is%3Aissue+in%3Atitle+sqlsmith+label%3AC-bug+]]
** Score list
| github issue | date |
|------------------------------------------------------------------------------------+------------|
| [[https://github.com/MaterializeInc/materialize/issues/17616][thread 'coordinator' panicked at 'called Result::unwrap() on an Err value: Can't union types: Oid and String']] | 2023-02-10 |
| [[https://github.com/MaterializeInc/materialize/issues/17652][Cancellations not propagated to clusterd, can't run other queries on cluster until clusterd process killed]] | 2023-02-13 |
| [[https://github.com/MaterializeInc/materialize/issues/17762][mz_transform: Optimizer::optimize(): internal transform error: scalar types do not match]] | 2023-02-21 |
| [[https://github.com/MaterializeInc/materialize/issues/17775][mz_repr::row::encoding: protobuf decoding found Dummy datum]] | 2023-02-21 |
| [[https://github.com/MaterializeInc/materialize/issues/17807][ERROR: Evaluation error: internal error: invalid input type]] | 2023-02-23 |
| [[https://github.com/MaterializeInc/materialize/issues/17870][ERROR: cannot reference pseudo type pg_catalog.list]] | 2023-02-28 |
| [[https://github.com/MaterializeInc/materialize/issues/17871][ERROR: operator is not unique: "char" = character]] | 2023-02-28 |
| [[https://github.com/MaterializeInc/materialize/issues/17874][Invalid data in source, saw retractions]] | 2023-02-28 |
| [[https://github.com/MaterializeInc/materialize/issues/17897][ERROR: internal error: unimplemented join]] | 2023-03-02 |
| [[https://github.com/MaterializeInc/materialize/issues/17898][thread 'tokio:work-2' panicked at 'capacity overflow']] | 2023-03-02 |
| [[https://github.com/MaterializeInc/materialize/issues/17899][ERROR: coalesce could not convert type character to "char"]] | 2023-03-02 |
| [[https://github.com/MaterializeInc/materialize/issues/17978][thread 'coordinator' panicked at 'Datum::unwrap_int32 called on Int16(0)']] | 2023-03-07 |
| [[https://github.com/MaterializeInc/materialize/issues/17981][Evaluation error: unit '...' not recognized]] | 2023-03-07 |
| [[https://github.com/MaterializeInc/materialize/issues/17984][thread 'timely:work-0' panicked at 'can not convert float seconds to Duration: value is negative']] | 2023-03-07 |
| [[https://github.com/MaterializeInc/materialize/issues/17993][thread 'coordinator' panicked at 'Expression in join plan is not bound at time of use']] | 2023-03-07 |
| [[https://github.com/MaterializeInc/materialize/issues/18008][thread 'timely:work-0' panicked at 'internal error: invalid encoded state: couldn't decode batch at key ...: External format error: File out of specification: A parquet file must containt a header and footer with at least 12 bytes]] | 2023-03-08 |
| [[https://github.com/MaterializeInc/materialize/issues/18017][thread 'coordinator' panicked at 'internal error: entered unreachable code: Float8 is not a range element type']] | 2023-03-09 |
| [[https://github.com/MaterializeInc/materialize/issues/18023][ERROR: internal transform error: scalar types do not match:]] | 2023-03-09 |
| [[https://github.com/MaterializeInc/materialize/issues/18036][thread 'timely:work-0' panicked at 'Datum::unwrap_string called on Null']] | 2023-03-09 |
| [[https://github.com/MaterializeInc/materialize/issues/18038][thread 'timely:work-0' panicked at 'batch fetcher could not fetch batch part: unexpected missing blob: ... for shard: ...']] | 2023-03-10 |
| [[https://github.com/MaterializeInc/materialize/issues/18043][ERROR: WHERE clause error: sum(interval) not yet supported]] | 2023-03-10 |
| [[https://github.com/MaterializeInc/materialize/issues/18044][ERROR: array_agg on arrays not yet supported]] | 2023-03-10 |
| [[https://github.com/MaterializeInc/materialize/issues/18045][thread 'coordinator' panicked at 'assertion failed: !self.expressions.iter().any(e e.contains_temporal())']] | 2023-03-10 |
| [[https://github.com/MaterializeInc/materialize/issues/18048][ERROR: Unsupported temporal predicate. Note: mz_now() must be directly compared to a mz_timestamp-castable expression. Expression found: (mz_now() < mz_now())]] | 2023-03-10 |
| [[https://github.com/MaterializeInc/materialize/issues/18057][thread 'timely:work-0' panicked at 'Invalid argument to AggregateFunc::Any: Int64(43)']] | 2023-03-10 |
| [[https://github.com/MaterializeInc/materialize/issues/18144][thread 'coordinator' panicked at 'into_element called on collection with more than one element']] | 2023-03-15 |
| [[https://github.com/MaterializeInc/materialize/issues/18188][ERROR: unexpected ScalarExpr in uncorrelated plan]] | 2023-03-16 |
* pgrust
https://github.com/malisper/pgrust/issues?q=is%3Aissue%20sqlsmith
** Score list
| nr | issue | date |
|----+---------------------------------------------------------------------------------------------+------------|
| 28 | ERROR: subquery does not have attribute 3 | 2026-07-10 |
| 23 | Crash on SELECT numrange_subdiff(1,1) | 2026-07-09 |
| 22 | ERROR: hash fn: by-reference argument missing from the by-ref lane | 2026-07-09 |
| 21 | ERROR: plan should not reference subplan's variable | 2026-07-09 |
| 20 | ERROR: SubLink::clone: subselect is an embedded owned Query [...]) | 2026-07-09 |
| 19 | ERROR: AlternativeSubPlanExpr::clone: transient planner node, never present at execution | 2026-07-09 |
| 18 | ERROR: unexpected null/empty node string | 2026-07-09 |
| 17 | ERROR: could not find pathkey item to sort | 2026-07-09 |
| 16 | ERROR: SubPlanExpr::clone: SubPlan carries context-allocated children; clone the plan [...] | 2026-07-09 |