You've already forked mariadb-columnstore-engine
							
							
				mirror of
				https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
				synced 2025-10-31 18:30:33 +03:00 
			
		
		
		
	* Restructured test suites and added autopilot and extended suites * Updated autopilot with correct branch - develop * Moved setup test case to a 'setup' directory, for consistency * Fixed a path issue * Updated some tests cases to keep up with development Co-authored-by: root <root@rocky8.localdomain>
		
			
				
	
	
		
			20 lines
		
	
	
		
			644 B
		
	
	
	
		
			Plaintext
		
	
	
	
	
	
			
		
		
	
	
			20 lines
		
	
	
		
			644 B
		
	
	
	
		
			Plaintext
		
	
	
	
	
	
| # -------------------------------------------------------------- #
 | |
| # Test case migrated from regression test suite: bug4703.sql
 | |
| #
 | |
| # Author: Daniel Lee, daniel.lee@mariadb.com
 | |
| # -------------------------------------------------------------- #
 | |
| #
 | |
| --source ../include/have_columnstore.inc
 | |
| #
 | |
| USE tpch1;
 | |
| #
 | |
| select cast(cdatetime as signed) from datatypetestm;
 | |
| select (cdatetime << 8) from datatypetestm;
 | |
| select (cdatetime & 0xff0000000000) from datatypetestm;
 | |
| select (cdatetime >> 12) from datatypetestm;
 | |
| select (cdatetime | 0xffffff) from datatypetestm;
 | |
| select (cdatetime ^ 337) from datatypetestm;
 | |
| select bit_count(cdatetime) from datatypetestm;
 | |
| #
 | |
| 
 |