@Test
	@SkipForDialects(
			value = {
					@SkipForDialect(value = Oracle8iDialect.class, jiraKey = "HHH-10161", comment = "Cannot convert untyped null (assumed to be BINARY type) to NUMBER"),
					@SkipForDialect(value = PostgreSQL9Dialect.class, jiraKey = "HHH-10312", comment = "Cannot convert untyped null (assumed to be bytea type) to bigint"),
					@SkipForDialect(value = PostgresPlusDialect.class, jiraKey = "HHH-10312", comment = "Cannot convert untyped null (assumed to be bytea type) to bigint")
			}
	)
	public void testNativeQueryWithSpecialChar() throws Exception {
		EntityManager em = getOrCreateEntityManager();
		em.getTransaction().begin();
		Item item = new Item( "Mouse", "Micro$oft mouse" );
		em.persist( item );
		// native queries don't seem to flush by default ?!?
		em.flush();
		Query q = em.createNativeQuery( "select coalesce(i.name, '--NONE--') as  from Item i where i.intVal=? " );
		q.setParameter( 1, 1 );
		List results = q.getResultList();
		// null != null
		assertEquals( 0, results.size() );
		em.getTransaction().rollback();
		em.close();
	}