Sticky Piston/Table

Block	Effect (Java Edition)	Effect (Bedrock Edition)
Barrier Beacon Bedrock Calibrated Sculk Sensor Command Block Creaking Heart Crying Obsidian Enchanting Table End Gateway End Portal End Portal Frame Ender Chest Grindstone Jigsaw Block Jukebox Light Block Lodestone Monster Spawner Moving Piston Nether Portal Obsidian Piston (extended) Piston Head Reinforced Deepslate Respawn Anchor Sculk Catalyst Sculk Sensor Sculk Shrieker Structure Block Trial Spawner Vault	Cannot be pulled.
Test Block Test Instance Block	Cannot be pulled.	N/A
Allow Deny Border	N/A	Cannot be pulled.
Compound Creator Element Element Constructor Hardened Glass Hardened Glass Pane Heat Block Lab Table Material Reducer Underwater TNT		Can be pulled.
Underwater Torch Colored Torches		Cannot be pulled.
Barrel Beehive Bee Nest Blast Furnace Brewing Stand Chest Chiseled Bookshelf Conduit Copper Chests Crafter Daylight Detector Dispenser Dropper Furnace Hopper Lectern Shelf Smoker Trapped Chest	Cannot be pulled, because these blocks hold block entities.	Can be pulled.
Large chest Large trapped chest Large copper chests		Can be pulled, but separates into two chests.
Banners Hanging Signs Signs		Breaks when unsupported, turning into drops when applicable. Cannot be pulled.
Campfire Soul Campfire		Cannot be pulled.
Structure Void	Cannot be pulled.
Heavy Core	Can be pulled.	Cannot be pulled.
Glazed Terracotta	Cannot be pulled.
^{[note 1]} Dead Coral Dead Coral Fans	Can be pulled, but breaks if unsupported, turning into drops when applicable.	Breaks when unsupported, turning into drops when applicable. Cannot be pulled.
^{[note 2]} Carpets (not moss) Rail Powered Rail Activator Rail Detector Rail	Can be pulled, but breaks if unsupported, turning into drops when applicable.
Bell Copper Lantern Lantern Soul Lantern	Cannot be pulled.	Can be pulled, but breaks if unsupported, turning into drops when applicable.
Candles	Cannot be pulled.	Can be pulled.
Air Amethyst Cluster Bamboo Beds Budding Amethyst Button Cactus Cake Carved Pumpkin Cave Vines Chorus Flower Chorus Plant Cobweb Cocoa Copper Golem Statue Copper Torch Dead Bush Decorated Pot Doors Fire Fern Flower Pot Flowers Frogspawn Glow Lichen Heads Item Frame^{[note 3]} ^{[note 4]} Jack o'Lantern Ladder Lava Leaves Lever Lily Pad Melon Melon Stem Moss Block Moss Carpet Mushrooms Nether Wart Painting^{[note 5]} Pale Hanging Moss Pale Moss Block Pale Moss Carpet Pink Petals Pointed Dripstone Pressure Plates Pumpkin Pumpkin Stem Redstone Comparator Redstone Dust Redstone Repeater Redstone Torch Resin Clump Saplings Sculk Vein Sea Pickle Short Grass Shulker Box Snow Soul Fire Sugar Cane Torch Torchflower Torchflower Crop Tripwire Tripwire Hook Turtle Egg Twisting Vines Vines Water Weeping Vines Weighted Pressure Plates Wheat	Cannot be pulled.
Anvil	Cannot be pulled.	Can be pulled, but falls if unsupported. Cannot be pulled when in a falling state.
Concrete Powder Gravel Red Sand Sand	Can be pulled, but falls if unsupported. Cannot be pulled when in a falling state.
Scaffolding Suspicious Gravel Suspicious Sand Dragon Egg	Cannot be pulled.

References

↑ Check the exceptions section
↑ Check the exceptions section
↑ In Java Edition, item frames are entities, not blocks. In Bedrock Edition, they are blocks.
↑ In Java Edition, if the "Fixed" NBT tag is set to "1", the item frame does not break when attempting to push it using a sticky piston, but it still does not push. If the "Invulnerable" NBT tag is set to "1", the item frame breaks when pushed.
↑ Paintings are technically entities, not blocks.

[1] Check the exceptions section

[2] Check the exceptions section

[3] In Java Edition, item frames are entities, not blocks. In Bedrock Edition, they are blocks.

[4] In Java Edition, if the "Fixed" NBT tag is set to "1", the item frame does not break when attempting to push it using a sticky piston, but it still does not push. If the "Invulnerable" NBT tag is set to "1", the item frame breaks when pushed.

[5] Paintings are technically entities, not blocks.

Sticky Piston/Table

References

Sources