Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- test=# SELECT * FROM test_text WHERE i>='abc' ORDER BY i;
- i
- -----
- abc
- axy
- xyz
- (3 rows)
- test=# SELECT * FROM test_text WHERE i>'abc' ORDER BY i;
- Program received signal SIGSEGV, Segmentation fault.
- __memmove_avx_unaligned_erms () at ../sysdeps/x86_64/multiarch/memmove-vec-unaligned-erms.S:420
- 420 ../sysdeps/x86_64/multiarch/memmove-vec-unaligned-erms.S: No such file or directory.
- #0 __memmove_avx_unaligned_erms () at ../sysdeps/x86_64/multiarch/memmove-vec-unaligned-erms.S:420
- #1 0x000056134abf0369 in varstr_cmp (arg1=0x56134c82d0c4 "\023V", len1=320805950,
- arg2=0x7fbb5ee5f021 "abc", len2=3, collid=100) at varlena.c:1534
- #2 0x000056134abf06a1 in text_cmp (arg1=0x56134c82d0c0, arg2=0x7fbb5ee5f020, collid=100)
- at varlena.c:1630
- #3 0x000056134abf0ba7 in bttextcmp (fcinfo=0x7fffb25e5450) at varlena.c:1772
- #4 0x000056134ac2daa3 in FunctionCall2Coll (flinfo=0x56134c81e900, collation=100, arg1=94640888008896,
- arg2=140442727739424) at fmgr.c:1059
- #5 0x000056134a670593 in ginCompareEntries (ginstate=0x56134c81e7e8, attnum=1, a=94640888008896,
- categorya=0 '\000', b=140442727739424, categoryb=0 '\000') at ginutil.c:396
- #6 0x000056134a670608 in ginCompareAttEntries (ginstate=0x56134c81e7e8, attnuma=1, a=94640888008896,
- categorya=0 '\000', attnumb=1, b=140442727739424, categoryb=0 '\000') at ginutil.c:413
- #7 0x000056134a67699b in entryLocateLeafEntry (btree=0x7fffb25e5950, stack=0x56134c821238)
- at ginentrypage.c:385
- #8 0x000056134a68281e in startScanEntry (ginstate=0x56134c81e7e8, entry=0x56134c82d1b8,
- snapshot=0x56134c81bc28) at ginget.c:341
- #9 0x000056134a6831d0 in startScan (scan=0x56134c8194b0) at ginget.c:543
- #10 0x000056134a686316 in gingetbitmap (scan=0x56134c8194b0, tbm=0x56134c8197f8) at ginget.c:1829
- #11 0x000056134a6e0477 in index_getbitmap (scan=0x56134c8194b0, bitmap=0x56134c8197f8) at indexam.c:726
- #12 0x000056134a8e9945 in MultiExecBitmapIndexScan (node=0x56134c8192a8) at nodeBitmapIndexscan.c:104
- #13 0x000056134a8d513c in MultiExecProcNode (node=0x56134c8192a8) at execProcnode.c:490
- #14 0x000056134a8e7d59 in BitmapHeapNext (node=0x56134c817ee8) at nodeBitmapHeapscan.c:117
- #15 0x000056134a8d6cd8 in ExecScanFetch (node=0x56134c817ee8,
- accessMtd=0x56134a8e7c7e <BitmapHeapNext>, recheckMtd=0x56134a8e8e54 <BitmapHeapRecheck>)
- at execScan.c:95
- #16 0x000056134a8d6d47 in ExecScan (node=0x56134c817ee8, accessMtd=0x56134a8e7c7e <BitmapHeapNext>,
- recheckMtd=0x56134a8e8e54 <BitmapHeapRecheck>) at execScan.c:143
- #17 0x000056134a8e8ee3 in ExecBitmapHeapScan (pstate=0x56134c817ee8) at nodeBitmapHeapscan.c:673
- #18 0x000056134a8d504e in ExecProcNodeFirst (node=0x56134c817ee8) at execProcnode.c:430
- #19 0x000056134a902e63 in ExecProcNode (node=0x56134c817ee8)
- at ../../../src/include/executor/executor.h:251
- #20 0x000056134a902fa1 in ExecSort (pstate=0x56134c817c18) at nodeSort.c:107
- #21 0x000056134a8d504e in ExecProcNodeFirst (node=0x56134c817c18) at execProcnode.c:430
- #22 0x000056134a8ccf69 in ExecProcNode (node=0x56134c817c18)
- at ../../../src/include/executor/executor.h:251
- #23 0x000056134a8cf937 in ExecutePlan (estate=0x56134c817a00, planstate=0x56134c817c18,
- use_parallel_mode=0 '\000', operation=CMD_SELECT, sendTuples=1 '\001', numberTuples=0,
- direction=ForwardScanDirection, dest=0x56134c8143a8, execute_once=1 '\001') at execMain.c:1720
- #24 0x000056134a8cd56f in standard_ExecutorRun (queryDesc=0x56134c8175f0,
- direction=ForwardScanDirection, count=0, execute_once=1 '\001') at execMain.c:363
- #25 0x000056134a8cd389 in ExecutorRun (queryDesc=0x56134c8175f0, direction=ForwardScanDirection,
- count=0, execute_once=1 '\001') at execMain.c:306
- #26 0x000056134aaac7ae in PortalRunSelect (portal=0x56134c7f64e0, forward=1 '\001', count=0,
- dest=0x56134c8143a8) at pquery.c:932
- #27 0x000056134aaac3cd in PortalRun (portal=0x56134c7f64e0, count=9223372036854775807,
- isTopLevel=1 '\001', run_once=1 '\001', dest=0x56134c8143a8, altdest=0x56134c8143a8,
- completionTag=0x7fffb25e6090 "") at pquery.c:773
- #28 0x000056134aaa5c38 in exec_simple_query (
- query_string=0x56134c7c55c0 "SELECT * FROM test_text WHERE i>'abc' ORDER BY i;") at postgres.c:1109
- #29 0x000056134aaaa4b5 in PostgresMain (argc=1, argv=0x56134c76ee28, dbname=0x56134c76ecb8 "test",
- username=0x56134c76ec98 "mark") at postgres.c:4103
- #30 0x000056134aa02807 in BackendRun (port=0x56134c768060) at postmaster.c:4357
- #31 0x000056134aa01eaa in BackendStartup (port=0x56134c768060) at postmaster.c:4029
- #32 0x000056134a9fe21c in ServerLoop () at postmaster.c:1753
- #33 0x000056134a9fd709 in PostmasterMain (argc=3, argv=0x56134c740300) at postmaster.c:1361
- #34 0x000056134a932512 in main (argc=3, argv=0x56134c740300) at main.c:228
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement