Assertion failure in current cvs - Mailing list pgsql-bugs
From | Kris Jurka |
---|---|
Subject | Assertion failure in current cvs |
Date | |
Msg-id | Pine.LNX.4.33.0401121248380.22794-100000@leary.csoft.net Whole thread Raw |
Responses |
Re: Assertion failure in current cvs
|
List | pgsql-bugs |
When the JDBC driver tries to query the information schema running against cvs head, it gets an assertion failure. The query in question is the ugly: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname LIKE 'pg\\_%' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'testmetadat%' AND (false OR ( c.relkind = 'r' AND n.nspname NOT LIKE 'pg\\_%' AND n.nspname <> 'information_schema' ) ) ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME FailedAssertion("!(!and_clause((Node *) clause))", File: "restrictinfo.c", Line: 66) #0 0x40101561 in kill () from /lib/libc.so.6 #1 0x40101305 in raise () from /lib/libc.so.6 #2 0x40102828 in abort () from /lib/libc.so.6 #3 0x0820fd7c in ExceptionalCondition ( conditionName=0x6 <Address 0x6 out of bounds>, errorType=0x822bf31 "FailedAssertion", fileName=0x40207290 "\022", lineNumber=0) at assert.c:46 #4 0x0816cb13 in make_restrictinfo (clause=0x8392670, is_pushed_down=1 '\001', valid_everywhere=1 '\001') at restrictinfo.c:73 #5 0x08164c69 in distribute_qual_to_rels (root=0x8372b34, clause=0x8392670, is_pushed_down=1 '\001', isdeduced=0 '\0', outerjoin_nonnullable=0x0, qualscope=0x8393970) at initsplan.c:509 #6 0x08164a7b in distribute_quals_to_rels (root=0x8372b34, jtnode=0x838cbe0) at initsplan.c:226 #7 0x0816569e in query_planner (root=0x8372b34, tlist=0x0, tuple_fraction=0, cheapest_path=0xbffff100, sorted_path=0xbffff104) at planmain.c:136 #8 0x08166397 in grouping_planner (parse=0x8372b34, tuple_fraction=0) at planner.c:898 #9 0x08165bee in subquery_planner (parse=0x8372b34, tuple_fraction=0) at planner.c:315 #10 0x08165889 in planner (parse=0x8372b34, isCursor=0 '\0', cursorOptions=0) at planner.c:119 #11 0x081a0d2f in pg_plan_query (querytree=0x8372b34) at postgres.c:588 ---Type <return> to continue, or q <return> to quit--- #12 0x081a0dc7 in pg_plan_queries (querytrees=0x838cc34, needSnapshot=0 '\0') at postgres.c:655 #13 0x081a0fab in exec_simple_query ( query_string=0x836089c "SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname LIKE 'pg\\\\_%' OR n.nspname = 'information_schema' WHEN true THEN CASE \tWHEN n.nspname = 'pg_catalog' OR n."...) at postgres.c:813 #14 0x081a3360 in PostgresMain (argc=4, argv=0x82f9d88, username=0x82f9d50 "test") at postgres.c:2843 #15 0x081776e3 in BackendRun (port=0x8306d08) at postmaster.c:2622 #16 0x08176f53 in BackendStartup (port=0x8306d08) at postmaster.c:2267 #17 0x081753d8 in ServerLoop () at postmaster.c:1141 #18 0x08174cb5 in PostmasterMain (argc=3, argv=0x82f9ad8) at postmaster.c:904 #19 0x08142347 in main (argc=3, argv=0xbffffa94) at main.c:228
pgsql-bugs by date: